Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 17:41:21 +0000



[Programming Help] - sumproduct issue and depend bartime

View Count: 276

[2023-11-17 10:22:16]
User278398 - Posts: 291
hello,
im trying to sum the last 60 last bars and which start from bartime=1
for exa:
if the value for all bars are "1"
so:
at 9:30:00 the value will be: 1
at 9:30:01 the value will be: 2
at 9:30:59 the value will be: 60

at 9:31:00 the value will be: 1
at 9:31:01 the value will be: 2
///
maybe for an ideas:
im using sumproduct formula
and second(bartime)>0,second(bartime)<60
but i didnt get the right values :(

...

what is the solution by formula?
thank you
[2023-11-20 06:56:00]
User278398 - Posts: 291
some one ?

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account