Support Board
Date/Time: Fri, 24 Jan 2025 11:17:17 +0000
Spreadsheet for Trading not updating
View Count: 1630
| [2018-05-09 20:09:00] |
| User104854 - Posts: 457 |
|
I'm using spreadsheets for trading and I keep running into situations on replay and live where the cells are not updating properly. Either each row will have a value of 0 or each row will have #VALUE!. I've gone through my studies to graph list and have everything in order by CalcOrder. I'm only using 10 rows on the spreadsheet. I've deleted all of the other sheets. I can't figure out what to do. The column for which I notice it is just a simple '=ID123.SG1@3' where the study graph referenced is a Spreadsheet Formula study. Any ideas on what I might do to fix this. When it happens I have to click on 'recalculate all formulas' under the spreadsheets tab in order to get it back on track? Thank you. Date Time Of Last Edit: 2018-05-09 20:09:58
|
| [2018-05-09 21:04:03] |
| |
|
There is little doubt this has to do with calculation order. You have to consider what dependencies the Spreadsheet Formula study has itself and all of those must be calculated before the Spreadsheet Formula study and then after that the Spreadsheet System for Trading study needs to be calculated. 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 |
| [2019-01-12 19:32:28] |
| User871277 - Posts: 34 |
|
Same Problem here, easy fix. Starting replay not all Indicators have data. Figured VWMA with period 20 doesn't get updated (in replay), unless I go into spreadsheet and "confirm" the formula, guess it pulls then actual data. Easy fix, was to set the option "Reset alert condition on new bar" in the spreadsheet configuration page. |
| [2019-01-12 20:46:52] |
| |
|
Figured VWMA with period 20 doesn't get updated (in replay), unless I go into spreadsheet and "confirm" the formula, guess it pulls then actual data. Chart Studies: Study Calculation Precedence And Related Issues 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: