Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
ITCI logo

ITCI

NGS
Intra-Cellular Therapies Inc.
HealthcareBiotechnology
Watchlists:
Last updated: Wednesday 2nd April 2025
131.87
-0.05 (-0.04%)
Prev Close:131.92
Open:131.9
Bid:131.88
Ask:131.91
52 Week Range
64.09
131.98
Volume:3,192,892
Mkt Cap:14,003 M
Price Target
$151.65
+15.0%

SMA

Live
Returns the Simple Moving Average (SMA) 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/2022") - Returns SimpleMovingAverage value for 20 day period with start date 1 September 2022

Notes

It is a tool to quickly identify if a security is in an uptrend or downtrend

Assets

Stocks, ETFs, Mutual Funds, Currencies, Cryptocurrencies