Support Board
Date/Time: Mon, 25 Nov 2024 13:45:29 +0000
Post From: standardize spreadsheet
| [2024-03-07 16:08:31] |
| John - SC Support - Posts: 36238 |
|
You are taking the natural log of the EMA from the current bar divided by the EMA of the previous bar, and then using that to determine the Slope and Intercept for an input into the Z-Score. The formula we use in our Z-Score study is the following Z(index) = ((X(index) - SMA(X)) / SD(X) Where X is the Input Data, SMA is the Simple Moving Average of the data, and SD is the Standard Deviation of the data. Therefore, for what you are doing in a spreadsheet, your formula would be the following = (ID0.SG4@3 - ID1.SG1) / $N$3 Where ID0.SG4 is the Close, ID1 is the EMA study with SG1 being the EMA subgraph, N3 is the cell that holds the Standard Deviation of the EMA (not the LN(EMA/EMA(-1)). For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |