Data
EMA
Live15.80
It is a technical indicator that gives more importance to recent data points used to generate buy and sell signals based on historical average crossovers
How calculated | EMA(today) = Value(today)*(Smoothing/(1+days)) + EMA(yesterday)*(1-(Smoothing/(1+days))
where Smoothing is generally kept 2 |
Example usage | =ExponentialMovingAverage("MSFT") - Returns ExponentialMovingAverage value for 30 day period =ExponentialMovingAverage("MSFT",20) - Returns ExponentialMovingAverage value for 20 day period =ExponentialMovingAverage("MSFT",20,"9/1/2021") - Returns ExponentialMovingAverage value for 20 day period with start date 1 September 2021 |
Notes | EMA is more reactive to recent price changes and hence the results are more timely and preferred more than SMA by many traders |
Assets | Stocks ETFs Mutual Funds Currencies Cryptocurrencies |
| Stock | EMA |
|---|---|
PCG | 15.80 |
EIX | 67.80 |
POR | 47.27 |
XEL | 65.39 |
D | 54.53 |
SRE | 145.47 |
AVA | 41.13 |
CMS | 60.06 |
HE | 37.77 |
WEC | 92.10 |
NWE | 56.03 |
Pacific Gas & Electric Co.
PCG
NYE
Sector: Utilities
Industry: Utilities - Regulated Electric
15.74
USD
-0.01
(-0.06%)
Optionable: Yes Market Cap: 36,387 M 90-day average vol: 14,112,088
Previous close: 15.75 Open: 15.78 Bid: 15.99 Ask: 15.99
52 week range
9.64 16.83
Last updated: Wednesday 29th March 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
Are you?
Call: 1-877-778-8358
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Get started today