Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 21:59:22 +0000



Spreadsheet / Datasaving

View Count: 612

[2022-04-26 18:17:04]
User793920 - Posts: 10
Hello Support,

I hope my message finds you well.

I would like to know how can I get the spreadsheet to memorize the market data for the past bars? For example using the basic Spreadsheet study i get the Open/High/Low/Last/Volume and # of trades and have them saved. When I use "Depth of Market Data" study I see that the information is stored in the end of the row but it's in real time and it doesn't store the values when the bar closes. How can I make the spreadsheet to save the current values of the last 5 levels of the market depth when the period of the current bar ends?

Many thanks.

With best regards,
M. Petkov
[2022-04-27 13:23:41]
John - SC Support - Posts: 38621
There really is not a way to do this using the Spreadsheet or any of the built-in studies. You would have to create a custom study using ACSIL in order to take a snapshot of the data at any particular time. Refer to the following for the start of the information on ACSIL:
Advanced Custom Study Interface and Language (ACSIL)
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-10 12:35:57]
User793920 - Posts: 10
Hello Support,
I hope my message finds you well.
Could you please advice how can I get:
* real time data for LIFFE to get real time access to UK100 (FTSE 100 futures)
* tick by tick history and real time data for UK100 (FTSE 100 futures)
* Depth of Market and Top of Book for UK100 (FTSE 100 futures)
I have found under EUREX access ZM22 futures, but not in real time data as last quotes was yesterday.
Many thanks in advance.
With best regards,
Miro
[2022-05-10 16:46:11]
John - SC Support - Posts: 38621
We do not have real-time data for LIFFE. You can check with IQFeed to see if they have the data - refer to the following:
DTN IQ Feed Data Service
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-31 10:02:54]
Sierra Chart Engineering - Posts: 104368
Eurex data is supported through the Denali data feed:
Denali Exchange Data Feed

However, this is not a Eurex symbol:
ZM22
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:

Login

Login Page - Create Account