Support Board
Date/Time: Tue, 26 Nov 2024 20:19:28 +0000
Post From: Relative Moving Average study
| [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 |