Support Board

Date/Time: Tue, 07 May 2024 09:44:34 +0000

Post From: EMA Calculation Method in Spreadsheet study

[2013-11-10 22:21:38] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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