How is the Simple Moving Average (SMA) calculated if some days have no trades?
How is the Simple Moving Average (SMA) calculated if some days have no trades?
Loading saved threads...
Flux · External communityPost link
External question — Personal Finance Stack Exchange
Author: Flux
Original post: https://money.stackexchange.com/questions/153053
License: CC BY-SA 4.0 — https://creativecommons.org/licenses/by-sa/4.0/
Adaptation: HTML converted to plain text; contact email addresses removed.
I want to calculate the 10-day SMA of a stock. However, there are some trading days when no trades took place for the stock (i.e. volume is zero). For the days that have zero volume, what is the stock price that should be used to calculate the SMA? Is it the closing price of the previous day that had a trade? Or is it $0?
Quote
Report
D Stanley · External communityPost link
External answer — Personal Finance Stack Exchange
Author: D Stanley
Original post: https://money.stackexchange.com/a/153055
License: CC BY-SA 4.0 — https://creativecommons.org/licenses/by-sa/4.0/
Adaptation: HTML converted to plain text; contact email addresses removed.
It might depend on what you're using the SMA for, but I certainly wouldn't use zero.
I can see two viable options - the most intuitive to me is to use the prior closing price for the days on which there are no trades. That would cause the SMA to converge to the last price over 10 days.
Another option might be to use the prices for the past 10 days on which there were trades. That would cause the the SMA to be "flat" until the day after a trade).
Quote
Report
Bob Baerker · External communityPost link
External answer — Personal Finance Stack Exchange
Author: Bob Baerker
Original post: https://money.stackexchange.com/a/153059
License: CC BY-SA 4.0 — https://creativecommons.org/licenses/by-sa/4.0/
Adaptation: HTML converted to plain text; contact email addresses removed.
A 10 "period' moving average involves the data for the last 10 periods of trading. It could be for any period of time (minute, hour, day, etc.).
A market day when there is no trading is the same as a weekend or a holiday. It is ignored, as is any shorter intraday time frame.
Quote
Report
Post Reply
Quoted from Forex.com.bd-Editorial External answer — Personal Finance Stack Exchange Author: Bob Baerker Source score (net votes, not local likes): 1 Original post: https://money.stackexchange.com/a/153059 License: CC BY-SA 4.0 — https://creativecommons.org/licenses/by-sa/4.0/ Adaptation: HTML converted to plain text; contact email addresses removed. A 10 "period' moving average involves the data for the last 10 periods of trading. It could be for any period of time (minute, hour, day, etc.). A market day when there is no trading is the same as a weekend or a holiday. It is ignored, as is any shorter intraday time frame.
Checking account access…