Support Board
Date/Time: Tue, 26 Nov 2024 09:39:26 +0000
Aggregating Data
View Count: 180
| [2023-12-15 16:35:09] |
| User585993 - Posts: 83 |
|
I currently have a formula that generates signals when absorption occurs. As I analyze the data, one key aspect is the delta observed when these signals are generated. I'm seeking guidance on how to aggregate the positive deltas associated with all the signals only and, conversely, the negative deltas This is the formula I use to get the signals: =AND(C[0] > C[-1], ID1.SG1[0] < 0, ABS(ID1.SG1) > 500 |
| [2023-12-15 17:33:28] |
| John - SC Support - Posts: 36286 |
|
In the end, you would need to create an IF() statement that gives you the "delta" value when your condition is true. You could then accumulate the deltas by using the "Cumulative Sum of Study". You would need to either use the Spreadsheet Study or the Spreadsheet Formula study to do this. We are not sure where the delta is coming from, but your formula would look like the following: =IF(AND(C[0] > C[-1], ID1.SG1[0] < 0, ABS(ID1.SG1) > 500), ID2.SG1, 0) Where ID2.SG1 is the delta value you want to capture. Refer to the following for the "Cumulative Sum of Study". Cumulative Sum of Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: