Support Board
Date/Time: Sun, 06 Jul 2025 14:53:46 +0000
Using Spreadsheet System for Trading Study
View Count: 1166
| [2019-03-21 11:36:14] |
| User94606 - Posts: 327 |
|
Is there a way to get the slope value (positive or negative) of the ADX study in the spreadsheet provided by "Spreadsheet System for Trading" Study (Spreadsheet Systems, Alerts and Automated Trading: Troubleshooting). Currently, the ADX study can be configured on the Study Settings -> Settings and Inputs -> Subgraphs based on the slope. I am trying to see if the slope value can also be available in the spreadsheet. Currently, I am only getting the ADX value in the spreadsheet. |
Attachment Deleted.  ADX Slope.jpg / V - Attached On 2019-03-21 11:35:53 UTC - Size: 117.36 KB - 337 views |
| [2019-03-21 17:40:10] |
| |
|
The slope is not directly available, but you can easily calculate it in the spreadsheet. Keep in mind that slope is just rise/run between two points on the line. With regards to how the colors are determined from the slope, it is just comparing the current bar against the one before it and and if the value of the current bar is higher than the previous bar then it uses the Primary Color, otherwise it uses the Secondary Color. If this is what you really want, then it is an even easier calculation. 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 |
| [2019-03-21 18:44:48] |
| User94606 - Posts: 327 |
|
Can you provide formula to calculate the rise/run between two points of the ADX value? Would this calculation be using the ADX actual value for each timeframe (e.g., 1 min chart)?
|
| [2019-03-22 08:57:03] |
| |
|
Have a look at using the Study Angle study to determine this: Study Angle 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: