Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Data

SMA

Live
129.16
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
SMA
StockSMA

A

129.16

TMO

538.51

PKI

128.78

DHR

274.92

TER

81.81

NATI

39.48

ILMN

197.75

AME

119.00

BRKR

52.79

GE

67.68
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

123.72
 
USD
  
2.11
  
(1.74%)
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    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Thursday 29th September 2022
58
MarketXLS Rank marketxls
70
Value marketxls
23
Technical marketxls
81
Quality marketxls

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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