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: