Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

SMA

Live
It is a technical indicator that gives equal importance to all data points used to generate buy and sell signals based on historical average crossovers

How calculated

Sum of prices for a given number of days divided by the number of days

Example usage

=SimpleMovingAverage("MSFT") - Returns SimpleMovingAverage value for 30 day period
=SimpleMovingAverage("MSFT",20) - Returns SimpleMovingAverage value for 20 day period
=SimpleMovingAverage("MSFT",20,"9/1/2021") - Returns SimpleMovingAverage value for 20 day period with start date 1 September 2021

Notes

It is a tool to quickly identify if a security is in an uptrend or downtrend

Assets

Stocks ETFs Mutual Funds Currencies Cryptocurrencies