Support Board
Date/Time: Mon, 21 Apr 2025 14:47:43 +0000
Spreadsheet update data
View Count: 147
| [2025-04-15 21:48:35] |
| AndreQuant - Posts: 9 |
|
I created a Spreadsheet and a QuoteBoard Spreadsheet from scratch and I added equities and Futures data per row. In both instances, the data stopped updating at market close on the day of creation and never again updated. Who can help me with that? I'd like to keep the data updating continuously on each row.
|
| [2025-04-15 22:10:17] |
| John - SC Support - Posts: 39372 |
|
If the market is closed, then there will not be any additional updates until the market opens again. Are you having an issue when the market opens? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-16 00:45:54] |
| AndreQuant - Posts: 9 |
|
Yes, I'm having an issue when the market opens. The spreadsheet doesn't update any of the data. I want the spreadsheet to restart calculating at market open each day and continue calculating rate of change. Kind of the QuoteBoard. Can you help? Thx
|
| [2025-04-16 17:15:18] |
| John - SC Support - Posts: 39372 |
|
There is no reason for the Spreadsheet to stop updating. It should be updating as soon as the market is open again. Can you please get us an image of the spreadsheet by following these instructions: Support Board Posting Information: Attaching or Posting a Screenshot/Image (Optional) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-16 19:52:01] |
| AndreQuant - Posts: 9 |
|
Thanks for your help. Right now can't figure out a way to follow the path you gave me. I have a screenshot which I can send. I'm also trying to recreate the Quote spreadsheet so I can send to you as a file, but now it isn't working. In short, prices aren't updating. I have a screenshot from last week when it only worked that day and haven't updated a number after. Check if the file uploaded |
 Screenshot 2025-04-16 154528 Spreadsheet.png / V - Attached On 2025-04-16 19:50:47 UTC - Size: 445.46 KB - 12 views Attachment Deleted. Screenshot 2025-04-16 154528 Spreadsheet.png / V - Attached On 2025-04-16 19:51:26 UTC - Size: 445.46 KB - 9 views |
| [2025-04-16 21:07:00] |
| John - SC Support - Posts: 39372 |
|
We wonder if somehow that spreadsheet got into a mode where it does not know that it is specifically a "Quote Spreadsheet", as the "Quote Spreadsheet" is a special item. We do not know how this would have occurred. If you open a new Quote Spreadsheet and enter a few symbols, does it work properly for you? Be sure to save the Quote Spreadsheet with the Chartbook. You will be prompted to name the spreadsheet, and it does not matter what you call it. Just make sure to keep it as part of the chartbook and not open/close it separately. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-16 21:33:58] |
| AndreQuant - Posts: 9 |
|
I created a new spreadsheet today. Let's see what happens tomorrow at market open. Interesting enough, at first it wasn't working. For instance, when I added the equities it did nothing. I created a few and it worked on the 4th try. So far it's updating even though market closed 90 minutes ago.
|
| [2025-04-16 21:38:22] |
| John - SC Support - Posts: 39372 |
|
U.S. Equities, with extended trading hours, trade from 04:00 to 20:00 Eastern US Time. So the fact that you are still seeing updates at this time (~17:30 Eastern US Time), is correct.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-16 21:40:24] |
| AndreQuant - Posts: 9 |
|
Yes, agree. Let's see what happens tomorrow. My goal is to track changes from Open same as a Quote Board but in a spreadsheet. Thank YOU
|
| [2025-04-17 13:15:47] |
| AndreQuant - Posts: 9 |
|
It's happening again. As you can see from the screenshot, it stopped updating yesterday at 17:05 ET. I even added ESM25 this morning and nothing happened. I'd love for this quote spreadsheet to continuously update itself and start calculating against equities open each RTH.
|
| Screenshot 2025-04-17 091211.png / V - Attached On 2025-04-17 13:15:31 UTC - Size: 49.98 KB - 4 views |
| [2025-04-17 14:36:44] |
| John - SC Support - Posts: 39372 |
|
We will try to see if we can reproduce this. We have setup a quote spreadsheet similar to what you have. But we will not know for sure until tomorrow morning. In the meantime, can you use the regular Quote Board and see if you have an issue there as well? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-17 18:55:30] |
| AndreQuant - Posts: 9 |
|
Appreciate your attention to this. Yes, I setup a regular Quote Board early today with aapl and amzn and so far so good. Never had issues with those.
|
| [2025-04-18 17:35:19] |
| John - SC Support - Posts: 39372 |
|
Of course we can not test this today, as the markets are closed. We will check on Monday.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-04-21 13:26:18] |
| John - SC Support - Posts: 39372 |
|
We opened the spreadsheet this morning and everything is updating as it should. Are you still having an issue with your Quote Spreadsheet? 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: