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|
Atlantic Capital Bancshares Inc.
Sector: Financial Services
Industry: Banks - Regional - US
Optionable: No Market Cap: 647 M 90-day average vol: 0
Previous close: 32.37 Open: 31.23 Bid: Ask:
52 week range
Last updated: Monday 26th 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