Support Board
Date/Time: Sat, 08 Feb 2025 19:44:56 +0000
Post From: Chart ADX vs ADX.13.scss discrepancies
| [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 - 306 views Attachment Deleted. |