Support Board

Date/Time: Tue, 21 May 2024 05:55:14 +0000

Post From: Chart ADX vs ADX.13.scss discrepancies

[2020-07-16 20:33:38] Link To Thread - Link To Post [Go To First Post]
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 - 254 views Attachment Deleted.