Support Board
Date/Time: Sat, 08 Feb 2025 20:00:10 +0000
Chart ADX vs ADX.13.scss discrepancies
View Count: 683
| [2020-07-14 00:40:54] |
| PeaceFrog - Posts: 105 |
|
Hello, Using the formulas in the “IntermediateCalculations” tab of "ADX.13.scss" (ADX) and data from a 1 minute F.US.CA6H20 chart, I calculated DI(+), DI(-) and ADX. All the DI(+), DI(-), and ADX results did not match the 1 minute chart data, the majority are off by at least 0.40, which is significant and material, given the results in columns H and I of the “Test” tab. Please see the attached spreadsheet that demonstrates the discrepancies over 4 steps in 4 progressing spreadsheets. I am now wondering which set of data is correct and if the chart data is correct, then why the formulas in the spreadsheet are not producing those results. Thank you very much for your help. |
Private File |
| [2020-07-14 01:42:22] |
| |
|
We will look this over as soon as we can.
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 |
| [2020-07-14 20:30:41] |
| PeaceFrog - Posts: 105 |
|
Thank you very much. I look forward to your reply.
|
| [2020-07-15 23:07:10] |
| SC Support Tom - Posts: 450 |
|
I am in the process of going through your spreadsheet. I am the one who created the Sierra Chart spreadsheet and wrote the documentation.
|
| [2020-07-15 23:14:41] |
| PeaceFrog - Posts: 105 |
|
Thank you. If you have any questions or if I can be of any assistance, please let me know. I'm very keen on being able to make this calculation work.
|
| [2020-07-16 20:33:38] |
| SC Support Tom - Posts: 450 |
|
Hi again. You need to re-check your Intermediate Calculations in the fourth tab of your spreadsheet. You did not copy and paste the data over correctly. I re-did the copy/paste job and found the ADX calculations to agree with those of Sierra Chart. You can see the calculations in the attached Excel file. I did find one small error in the file ADX.13.scss, and this error carried over into your spreadsheet. The error was in Column P of the Intermediate Calculations. In Cell P17, the formula should have been as follows. P16 - P16/14 + O17 This formula should be copied down to the bottom of the column. I corrected this error in both the attached Excel file and in ADX.13.scss. However, this error had no significant impact on the calculations. The discrepancy that you found is almost completely accounted for by the copy/paste error in your Intermediate Calculations. Date Time Of Last Edit: 2020-07-16 22:47:42
|
 ADX_Test.xlsx - Attached On 2020-07-16 20:33:35 UTC - Size: 27.31 KB - 307 views Attachment Deleted. |
To post a message in this thread, you need to log in with your Sierra Chart account: