Support Board
Date/Time: Tue, 26 Nov 2024 20:19:28 +0000
Relative Moving Average study
View Count: 246
| [2023-10-30 05:29:26] |
| Presar - Posts: 5 |
|
Is there any study that can display a Relative Moving Average? The MA study doesn't include it and I'm not sure if it goes under any other name. I understand it's not a very common moving average but was hoping one may exist already before having to code it. Thank you! |
| [2023-10-30 15:20:59] |
| John - SC Support - Posts: 36307 |
|
First, refer to the following and see if it is what you are looking for: Relative Volume If the above is not it, then we need more information on what you are looking for in terms of a "Relative Moving Average", as we do not know what exactly this is. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-10-30 16:39:27] |
| Presar - Posts: 5 |
|
A relative moving average is like an exponential moving average but has different smoothing as it places less importance on the last price. The smoothing is calculated as "1/length" in an RMA while it's "2/(1+length)" in an EMA. Using the spreadsheet examples for EMA, I think I can easily code this with a minor change to the EMA formula. Cell $H$2 has the length value, E3 is closing price, and the formula would be in P3. EMA: =(E3 - P4) * (2 / (1 + $H$2)) + P4 RMA: =(E3 - P4) * (1 / $H$2) + P4 |
| [2023-10-30 16:43:06] |
| John - SC Support - Posts: 36307 |
|
There are quite a few Moving Average studies we have and all of them have documentation on how they are calculated. Be sure you look through them all to see if one of them may already have what you are looking for.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: