Support Board
Date/Time: Fri, 31 Jan 2025 03:02:49 +0000
Same spreadheet with 2 chartbooks
View Count: 742
| [2019-04-10 12:28:09] |
| ILIM KIRGIZ - Posts: 187 |
|
I have two chartbooks. One is writing some study data into a spreadsheet file via spreadsheet study and calculate some formulas in K L M N columns. The other chartbook is reading from it these columns (K L M N). I made all settings according to documentation and both charts have the same days to load setting in the chart settings menu. My problem is column A which shows date and time value is always changing. How can I fix this? I made a small video of the situation. Thanks. |
Private File |
| [2019-04-11 05:08:32] |
| |
|
Do you have more than one Spreadsheet Study using the same Sheet within the same named Spreadsheet? You can control this through this input: Spreadsheet Study Inputs: Chart Data Output Sheet Number 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 Date Time Of Last Edit: 2019-04-11 05:08:51
|
| [2019-04-11 07:54:40] |
| ILIM KIRGIZ - Posts: 187 |
|
Yes, I have. But I only need to read the data in formula columns via the second chart calculated based on the first chart's studies. I do not want to write back to it. But It looks like this is not possible. So I am creating the second sheet and copy data from the first sheet to the second one. How can I be sure to have the exact bar start date time for both charts? (You can view the difference in the video file). both charts have the same days to load setting in the chart settings menu. and the same number of rows setting in spreadsheet study settings. Thanks. Date Time Of Last Edit: 2019-04-11 09:16:09
|
| [2019-04-14 06:48:58] |
| |
|
You cannot output data to the same Sheet from different charts. You are going to have problems with this. So that has to be solved first but it sounds like you may have done that. To maintain exact synchronization between charts requires that the Chart Settings are identical for those charts and you may also need to enable the Include Columns With No Data option in Chart Settings. However, there still can be short periods of time where there are differences when a new bar is added to one of the charts. Also really it is hard for us to comprehend that video unless we can see the entire set up. But that is just getting too involved for us. 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 Date Time Of Last Edit: 2019-04-14 06:50:12
|
To post a message in this thread, you need to log in with your Sierra Chart account: