Login Page - Create Account

Support Board


Date/Time: Sun, 26 May 2024 16:13:27 +0000



Post From: Cummulative Sum of a cell in spreadsheet

[2023-01-31 21:16:12]
Sawtooth - Posts: 4010
If you only need the most current sum, and don't need any historical sums, you could add a 1 second chart to the chartbook, with the same-named spreadsheet study.
This will show as its own Sheet#, and you can reference its row 3.

Use a formula like this on the 1 second sheet:
=SUM(AA3:OFFSET(AA3,3,0))
This will sum 4 rows, rows 3 to 6, inclusive. (The OFFSET function starts its count in the row below, hence 3 instead of 4.)

Since there are 180 seconds in 3 min, the rows won't align row to row between sheets, so referencing a row other than row 3 will give you erroneous values.

SC recommends using the Study/Price Overlay study instead of a direct reference between sheets.
But since you are only using the latest current sum, using the overlay study will likely not provide an advantage.

If you want to sum all 180 1-sec bars, you would have some alignment between sheets, and using the overlay study would be recommended.

So the question is: Can you get the same values on the 1 sec chart that appear intrabar on the 3 min chart.
This is where a workaround like this might be problematic, or not work at all in a way that is useful.