Support Board
Date/Time: Wed, 15 Jan 2025 17:58:15 +0000
Spreadsheet data that updates with different time frame data.
View Count: 1100
| [2017-08-18 02:21:58] |
| EZForex - Posts: 3 |
|
I am trying to put data on a spreadsheet that is different time frame than the main price graph. When I put an overlay on the main price graph the source chart changes time frames to match the destination chart. Can I stop that? I tried putting the spreadsheet I am working with on the other charts but that just creates the spreadsheet in the pull down menu, sheet4, sheet5, etc. Then if I reference that spreadsheet on the one I want to work with, the price does not update in the cell that I used reference formula, =Sheet5!AX3. I have tried reading the documentation but can't seem to find the way. So is there a way to get data on a spreadsheet that updates from different time frames? |
| [2017-08-18 05:38:45] |
| |
|
What you want to do is documented here: Referencing Other Charts in Spreadsheet Study Formulas You will need to use the Study/Price Overlay study. Then if I reference that spreadsheet on the one I want to work with, the price does not update in the cell that I used reference formula, =Sheet5!AX3. We tested this, and we do see updating of the cell referencing a cell on another Sheet which is changing.
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: 2017-08-18 05:39:01
|
To post a message in this thread, you need to log in with your Sierra Chart account: