Sum of prices for a given number of days divided by the number of days
=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
It is a tool to quickly identify if a security is in an uptrend or downtrend
|Stocks ETFs Mutual Funds Currencies Cryptocurrencies|
Sector: Professional, Scientific, and Technical Services
Industry: Research and Development in the Physical, Engineering, and Life Sciences (except Biotechnology)
Ingles Markets Incorporated Class A Common Stock
Fidus Investment Corporation
Republic Services Inc.
Donaldson Company Inc.
BWX Technologies Inc.
New Residential Investment Corp.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Stand with Ukraine
As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.
For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to firstname.lastname@example.org to avail the extention
From all of us at MarketXLS, thank you!