Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 17:30:23 +0000

How to Post a Message for Support

Spreadsheets: Easiest way to get e.g. the low price of 3 days ago and 10-day ATR

View Count: 839

[2017-02-13 19:45:30] #1 [Go To First Post]
User985778 - Posts: 16
Hi, can someone please help me out. I just dont get it to work. Maybe I am overcomplicating things. What is the easiest way to accomplish the following: 1) Get e.g. the low price of an instrument of 3 days ago etc? 2) How to get an value from an indicator: e.g. 10 day ATR of a stock or future? I dont need any charts so just some simple calculations in the spreadsheets. So it would be great if I would not need to open a chart at the same time... Thanks for your help and best regards, Chris

[2017-02-13 22:41:52] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
1) Get e.g. the low price of an instrument of 3 days ago etc? 2) How to get an value from an indicator: e.g. 10 day ATR of a stock or future? Really the easiest way of doing this is to have a separate Historical Daily chart open for the symbol. Add the Average True Range study to that chart. And then use the Study/Price Overlay study to overlay the data from that chart to the chart you are using with the Spreadsheet study: Study/Price Overlay Study 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 Date Time Of Last Edit: 2017-02-14 17:46:34

[2017-02-14 09:05:57] #3 [Go To First Post]
User985778 - Posts: 16
Thanks for your quick reply! I opened a chart and added the ATR and then the Spreadsheet Study and it gives the same result or am I overseeing anything here? Or did you mean the spreadsheet study?

[2017-02-14 17:48:24] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We originally misunderstood what you want to do. If you want to get data from a chart into a Spreadsheet, you need to use the Spreadsheet Study. And you will need to add that to the chart we described in post #2. Here is the relevant documentation: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudy.html No need to use the Study/Price Overlay study mentioned. That was based upon a misunderstanding. 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 Date Time Of Last Edit: 2017-02-14 17:48:35

[2017-02-15 12:06:40] #5 [Go To First Post]
User985778 - Posts: 16
I understand, thanks a lot!

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