Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 08:57:59 +0000



Post From: Spreadsheet formula problem

[2022-08-18 13:21:27]
Sawtooth - Posts: 3980
How can I create from this data 5 bar (X interval) running sum of bid volume and ask volume ?
Try this in row 3 of a Formula Column:
=SUM(OFFSET(ID1.SG1@3,0,0,$H$2,1))
where ID1 is the Bid Volume study, and H2 is the x interval