Support Board
Date/Time: Sun, 24 Nov 2024 16:31:00 +0000
Post From: EMA Calculation Method in Spreadsheet study
| [2013-11-10 22:21:38] |
| Sawtooth - Posts: 4119 |
|
This is the Excel formula for an EMA: =(B3-D4)*(2/(1+$D$1))+D4 where the formula is in cell D3, and the length is in cell D1, and B3 is the closed/last price. It assumes the formula will advance the references that are not absolute in rows below. IOW, cell D4 would look like this: =(B4-D5)*(2/(1+$D$1))+D5 Date Time Of Last Edit: 2013-11-10 22:22:38
|