Home >> Support Board

Support Board

Date/Time: Sat, 04 May 2024 16:49:02 +0000

How to Post a Message for Support

Spreadsheet study help

View Count: 81

[2024-04-10 18:12:35] #1 [Go To First Post]
User411320 - Posts: 265
Hello, I'm using a formula in the spreadsheet study but after every new bar the study shifts. attached are 2 pics. I have 3 orange circles with vertical lines and after a few bars you can see how the study shifted.


Attachment Deleted. Screenshot 2024-04-10 140346.png / V - Attached On 2024-04-10 18:12:22 UTC - Size: 50.04 KB - 19 views Screenshot 2024-04-10 140847.png / V - Attached On 2024-04-10 18:12:29 UTC - Size: 55.09 KB - 17 views

[2024-04-10 18:13:03] #2 [Go To First Post]
User411320 - Posts: 265
im just using the STANDARIZE function

[2024-04-10 20:08:31] #3 [Go To First Post]
John - SC Support - Posts: 31362
How are you displaying the data in the two regions as you are? Do you have multiple copies of the Spreadsheet Study, or are you using a "Study Subgraph Reference"? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-10 20:38:16] #4 [Go To First Post]
User411320 - Posts: 265
Hello John, I have multiple copies (circled in orange ), please see attached picture. I don't need both though, just the bottom purple one. So if I have to delete one that's fine


Screenshot 2024-04-10 163616.png / V - Attached On 2024-04-10 20:38:10 UTC - Size: 46.22 KB - 15 views

[2024-04-10 20:47:55] #5 [Go To First Post]
John - SC Support - Posts: 31362
You can have multiple copies of the Spreadsheet Study, but you can not use the same Spreadsheet Name and Sheet Number. This is probably at the heart of the issue you are having, as there is a conflict with it updating the data. Please remove one of the Spreadsheet Studies and select "Edit >> Reload and Recalculate" and then see if you continue to have an issue. For the most reliable, advanced, and zero cost futures order routing, use 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: