Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I am trying to replicate the cumulative sum study @Big Mike used to use on his Sierra Chart setup to get Cumulative TICK for the week. I have asked him he said he no longer uses Sierra Chart so asking here. Was also told to tag @aslan
I know to get ctick / cumulative tick on a daily basis I use the Cumulative Sum of Study and set the option to Reset at Start of Trading Day to "Yes". All good.
I can't seem to find anything that would "Reset at Start of Trading Week" so it starts summing from 0 every Sunday night or whenever the week opens. I know it is possible as @Big Mike had cum tick starting at zero on his chart every start of week. It would sum till end of week then start at 0 again at the new week.
Anyone that can guide me much appreciated (I have asked Sierra but going round in circles a bit there).
Have a great week!
Can you help answer these questions from other members on NexusFi?
Best Threads (Most Thanked) in the last 7 days on NexusFi
You could do it with the Spreadsheet Formula study, with a formula like this in its Formula field:
=IF(AND(WEEKDAY(BARDATE)=1,HOUR(BARTIME)=18),ID1.SG1,ID1.SG1+ID9.SG1[-1])
where ID1.SG1 is the study and subgraph to cumulatively sum, and ID9 is this Spreadsheet Formula study.
This will begin the cumulative summation every Sunday at 18:00.