Support Board
Date/Time: Tue, 26 Nov 2024 11:48:47 +0000
Post From: Aggregating Data
| [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 |