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
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|
Agilent Technologies Inc.
Industry: Diagnostics & Research
Optionable: Yes Market Cap: 36,001 M 90-day average vol: 1,415,703
Previous close: 121.61 Open: 122.77 Bid: 125.05 Ask: 125.05
52 week range
Last updated: Thursday 29th September 2022
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today