Support Board
Date/Time: Sun, 29 Dec 2024 15:32:28 +0000
Data extracting via spreadsheet and formula question
View Count: 703
| [2016-05-16 02:28:46] |
| User713273 - Posts: 409 |
|
Hi, is it possible to get the formulas or calculation methods for EMA, Study Angle & RSI? http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s27 http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s231 http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s38 Also is it possible to extract the data points from a 1 minute chart and layer these over a 1 second spreadsheet? We would want every data point that occurs within a 1 second timeframe. I ask because we want to start analyzing specific values and to do this we would need every 1 second tick rather that the data point that a 1 minute chart produces on the close of each bar. Thanks Adam |
| [2016-05-16 09:47:16] |
| |
|
You can look at the source code for all three of those studies. Refer to this page for instructions: https://www.sierrachart.com/index.php?page=doc/doc_BuildCustomStudiesDLL.html#SearchingSourceCodeBuiltIn Also is it possible to extract the data points from a 1 minute chart and layer these over a 1 second spreadsheet? We would want every data point that occurs within a 1 second timeframe.
The only way to do this is to use a chart with the chart bars set to 1 Number of Trades per Bar or 1 Second. Otherwise there is no way to access each data point within the bar.
I ask because we want to start analyzing specific values and to do this we would need every 1 second tick rather that the data point that a 1 minute chart produces on the close of each bar. 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: 2016-05-16 09:48:05
|
| [2016-05-16 17:57:56] |
| User713273 - Posts: 409 |
|
The only way to do this is to use a chart with the chart bars set to 1 Number of Trades per Bar or 1 Second. Otherwise there is no way to access each data point within the bar.
I believe this would work for us, if we would be using the same input values for say RSI & MACD on the 1 minute chart and 1 second chart and then layered those data points onto a spreadsheet. Would the same values be portrayed in both time frames? Say the 06:55:55 timeframe? |
| [2016-05-16 18:02:11] |
| |
|
You have to do your own testing. We cannot answer this question.
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: