Support Board
Date/Time: Wed, 22 Jan 2025 17:03:35 +0000
Post From: Store previous bars
| [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 |