Login Page - Create Account

Support Board


Date/Time: Mon, 21 Apr 2025 13:05:43 +0000



Spreadsheet update data

View Count: 138

[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: 39362
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: 39362
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
imageScreenshot 2025-04-16 154528 Spreadsheet.png / V - Attached On 2025-04-16 19:50:47 UTC - Size: 445.46 KB - 11 views
Attachment Deleted.
imageScreenshot 2025-04-16 154528 Spreadsheet.png / V - Attached On 2025-04-16 19:51:26 UTC - Size: 445.46 KB - 8 views
[2025-04-16 21:07:00]
John - SC Support - Posts: 39362
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: 39362
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.
imageScreenshot 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: 39362
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: 39362
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account