Login Page - Create Account

Support Board


Date/Time: Wed, 22 Jan 2025 16:52:00 +0000



Store previous bars

View Count: 595

[2018-10-05 11:05:22]
User345323 - Posts: 18
Dear all,

I'm looking to store previous bars on spreadsheet.
On Sheet1 I know I already have previous bars but problem to me appears when I make a rollover on new contract.
New conract history is obviously not long enought for my study so I want to make a mix of old contract bars and continue with new ones.
I think is not possible to automatically realize this request with only spreadsheet feature, so I think acsil code is required but I'm not a programmer and I don't know how to code it.


My idea is: on Sheet2 from row 5 to below rows I have previous data. I need that if row 5 of Sheet1 is different from row 5 of Sheet2 new line will be added to Sheet2 shifting down previous bars.

Any help to code it or any idea to how to solve it with only spreadsheet feature?
Thanks everybody
[2018-10-05 18:24:38]
Sierra Chart Engineering - Posts: 104368
You just need to use the Continuous Futures Contract feature:
Continuous Futures Contract Charts
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account