Login Page - Create Account

Support Board


Date/Time: Mon, 23 Dec 2024 16:37:53 +0000



Quote Spreadsheet question

View Count: 797

[2015-10-09 22:01:27]
User941434 - Posts: 39
Is there any way to capture the information on a single symbol's quote line on row 2 in a Quote Spreadsheet and record or paste the lines quote values each second on rows 3 and below to build a quote database for the day.

Essentially this would be creating a custom quote chart with last know quote information for the end of a specified time period(1 second in this example)?

...Or is SC only set up to to get this data (bid price and ask price) based on the last tick/trade information in a typical SC main price graph or study?

Thanks in advance for fielding this question, I could not find the anwer on the forum or in the SC documentation.
[2015-10-10 18:56:45]
Sierra Chart Engineering - Posts: 104368
This not supported exactly like this. However, it is supported a different way.

Open a chart and set the chart bars to be 1 second per bar.

At the Spreadsheet Study to the chart.

At the Bid & Ask Prices study to the chart:
http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s355

The study data will be outputted beginning at column AA.
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