Support Board
Date/Time: Mon, 25 Nov 2024 13:34:39 +0000
Post From: standardize spreadsheet
| [2024-03-05 21:13:08] |
| John - SC Support - Posts: 36238 |
|
Thank you for the clarifications. so I used the spreadsheet function (LN) on the 1 bar change of the EMA, my understanding is that 0.00 is when price on the chart is at the EMA but it's not doing that as shown in the previous pic.
This will not be the case, as you are taking the ratio of the current bar's EMA divided by the previous bar's EMA, therefore the only time the natural log of this will be 0 is if the EMA is the same at both bars, giving you a ratio of 1.00 (LN(1) = 0). We do not know how you setup the EMA (i.e. what Length you are using), but even if it is set to 1, then you would need to have the same price at both bars for the chosen bar value to get natural log to be 0. We are not really sure how you are using the "STANDARDIZE" function as we do not know what you have in M3 and N3, but it looks like the best this would be is a smoothing function to the natural log data. What exactly are you wanting to accomplish from this? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |