Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 16:26:38 +0000

How to Post a Message for Support

EMA Calculation Method in Spreadsheet study

View Count: 2385

[2013-11-10 22:08:24] #1 [Go To First Post]
Sascha Haas - Posts: 10
Hi SC Team! :) I've been trying for hours to reproduce the EMA values calculated in the attached spreadsheet study. Or more exactly, I am unable to reproduce only the "first value" of the study. Would you be so kind and have a short look at the attached spreadsheet and advice me how the value in Cell E40 has been calculated by sierra ? I am able to continue the calculation from that point on, but I stuck with the first value. Thanks a million in advance! Sascha


SC_EMA200.xls - Attached On 2013-11-10 22:04:10 UTC - Size: 121.5 KB - 474 views

[2013-11-10 22:21:38] #2 [Go To First Post]
Sawtooth - Posts: 3976
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

[2013-11-10 22:40:13] #3 [Go To First Post]
Sascha Haas - Posts: 10
Hi tomgilb, thanks for your fast reply. :) I got your point and I fully understand your formula. But I still don't know how sierra calculates "the first value -> i.o.w the "oldest value". Please have a look at the attached spreadsheet at my first post above. Can you say how the value in Cell E40 (->81.698196) has been calculated by sierra? Thanks! Sascha

[2013-11-10 22:53:10] #4 [Go To First Post]
Sawtooth - Posts: 3976
I believe the usual starting value for an EMA is the SMA to that point, but this might not be how Sierra it. The formula I gave does not start with an SMA value; it just takes the length in bars to 'catch up'. Not very sophisticated, but with a short length, it doesn't matter too much. This is my reference: http://stockcharts.com/school/doku.php?id=chart_school:technical_indicators:moving_averages

To post a message in this thread, you need to log in with your Sierra Chart account: