Support Board
Date/Time: Sun, 24 Nov 2024 17:05:55 +0000
EMA Calculation Method in Spreadsheet study
View Count: 2611
| [2013-11-10 22:08:24] |
| 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 - 565 views |
| [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
|
| [2013-11-10 22:40:13] |
| 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] |
| Sawtooth - Posts: 4119 |
|
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: