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

SMA

Live
Returns the Simple Moving Average (SMA) 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/2022") - Returns SimpleMovingAverage value for 20 day period with start date 1 September 2022

Notes

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

Assets

Stocks, ETFs, Mutual Funds, Currencies, Cryptocurrencies