Support Board
Date/Time: Tue, 24 Jun 2025 13:23:11 +0000
Post From: I want to know a formula
| [2025-06-22 11:58:54] |
| JabDouks25 - Posts: 21 |
|
Hello, i come back to you, because i suceefully with your help putting alert messages when the volume are increasing tremendsouly when compared with the average of volume since the open. I come with a problem when it comes with the delta since the open us. I am trying to calculate the averages of posive deltas since the open and compare it with the current delta in order to highlight a signicant increase of it. here what i achieved so far: ID1.SG1 : Delta use spreedsheet formula: with that condition: =IF(AND(ID1.SG1 > 0, BARTIME > TIME(15,30,00)), ID1.SG1, 0) -> Result: ID31.SG1. then I use study subgraphs average : ref: ID31.SG1 -> result: ID39.SG1. Then i create a signal with color bar based with: =AND(ID1.SG1 > ID39.SG1 * 1.2, BARTIME > TIME(15,30,00)) what would be the best study to get what I need, which is to highlight a significant increase of the delta (Positive: agression of the buyers), and negative (agression of the sellers) I am not really having much of a progress here. thank you for your help |