Support Board
Date/Time: Mon, 25 Nov 2024 17:27:13 +0000
Spreadsheet study not loading OHLC on row 4 for Add Additional Symbols
View Count: 427
| [2024-02-16 12:38:17] |
| Poblano Trading Capital - Posts: 15 |
|
Hello Sierra Chart team, I have been using spreadsheets for a while and the following issue occurred to me this week and I can't fix it. I have a chart of QQQ with the Add Additional Symbol studies for all the symbols in the QQQ, the I use a spreadsheet study to calculate simple math calculations, for the past few days ONLY row 4 for all 101 additional symbols show a random OHLC price and volume Zero. I have tried to use all download historical data, delete download historical data, reload historical data and reload and recalculate historical data in the Edit menu of the chart but random values remain the same. Thank you for your feedback. |
 Screenshot 2024-02-16 052819.png / V - Attached On 2024-02-16 12:37:22 UTC - Size: 138.12 KB - 55 views Attachment Deleted. |
| [2024-02-19 23:37:55] |
| Sierra_Chart Engineering - Posts: 17174 |
|
Refer to the information here regarding this: 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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-22 13:09:10] |
| Poblano Trading Capital - Posts: 15 |
|
Thank you for your link and information. I made sure calculation precedence and order are respected, but the most remarkable of my issue is that the OHLC data doesn't update ONLY for yesterday's data ( row 4 ) for all Add Additional Symbol studies, but for the rest of the days is perfectly fine. So the issue is not that is not updating ( row 3 and 5 to end are ok ), is just the OHLC data on row 4 the one that has the issue. There must be something else that I can check, why the row OHCL data for line 4 is not updating for all Add Additional Symbol studies? Thanks for your support. |
| 2024-02-22.png / V - Attached On 2024-02-22 12:59:01 UTC - Size: 149.47 KB - 45 views |
| [2024-02-22 17:49:34] |
| John - SC Support - Posts: 36253 |
|
Please try adding a new Spreadsheet Study and see if you have the same issue.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-22 18:50:36] |
| Poblano Trading Capital - Posts: 15 |
|
Thanks for your reply. I closed all Chartbooks. Open and new Daily chart of XLY. (Daily #1) Used 5 times Add Additional Symbol Study in (Daily #1) Then created Spreadsheet Study in (Daily #1) And as you can see I have the same issue, "row 4" doesn't update OHLC data, even in the chart there is no candle. * See 2024-02-22 attachment Trying to find the solution for this issue, I found that ONLY when I manually go to Find Symbol, and Open Historical Chart of any of those 5 symbols, at the moment it finishes downloading the Historical chart (blue message), then the data is overwritten on row 4 in the Spreadsheet Study. *See 2024-02-22 2 attachment Is like when I manually load the historical chart is pushing to update row 4. Thanks for your feedback. |
Attachment Deleted. 2024-02-22.png / V - Attached On 2024-02-22 18:48:50 UTC - Size: 295.15 KB - 51 views 2024-02-22 (2).png / V - Attached On 2024-02-22 18:48:56 UTC - Size: 365.19 KB - 41 views |
| [2024-02-22 19:04:10] |
| John - SC Support - Posts: 36253 |
|
We are not able to reproduce this. The Volume information shows properly for row 4 for the Add Additional Symbol in the Spreadsheet. When you open a new Spreadsheet Study it uses a name of "DefaultSpreadsheetStudy". It's possible that you have a saved copy of this spreadsheet on your system that somehow has an issue with displaying that data. If you are not using that particular name for any spreadsheets that you have, then please exit from Sierra Chart and go into your "Data" folder under your main Sierra Chart installation folder, and if you have a file named 'DefaultSpreadsheetStudy.scss' then remove it from your system. Then restart Sierra Chart and do not open a chartbook, rather open a new chart for any symbol, and add an "Add Additional Symbol" study and then add the "Spreadsheet Study" to that chart and see if the numbers are showing properly. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-22 19:44:57] |
| Poblano Trading Capital - Posts: 15 |
|
Thanks for your reply again. I think we can bring the issue one step before, see the attachment, even without the spreadsheet I have the issue. When I add the Add Additional Symbol Study, OHLC data is missing ONLY for yesterday, and it just repeats the Close Price of the day before yesterday into yesterdays OHLC. So, What can I do to solve the "Add Additional Symbol Study" not loading yesterday's OHLCV data? Thank you. |
| 2024-02-22 (3).png / V - Attached On 2024-02-22 19:39:48 UTC - Size: 123.79 KB - 54 views |
| [2024-02-23 15:17:53] |
| John - SC Support - Posts: 36253 |
|
Please get us the chart that shows this issue for us to take a look. Follow the instructions at the following link to get us your chartbook: Support Board Posting Information: Providing Chartbook with Only a Single Chart 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: