Support Board
Date/Time: Sun, 12 Jan 2025 09:26:04 +0000
Spreadsheets: Easiest way to get e.g. the low price of 3 days ago and 10-day ATR
View Count: 917
| [2017-02-13 19:45:30] |
| 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] |
| |
|
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? 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] |
| 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] |
| |
|
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] |
| 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: