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)
KEN logo

KEN

NYE
Kenon Holdings Ltd.
UtilitiesUtilities - Regulated Electric
Watchlists:
Last updated: Sunday 20th July 2025
47.22
+0.29 (0.62%)
Prev Close:46.93
Open:46.96
Bid:45.95
Ask:52.25
52 Week Range
23.31
47.30
Volume:20,899
Mkt Cap:2,336 M
Price Target
$54.30
+15.0%

Average True Range

Live
Returns the Average True Range, measuring volatility by decomposing the range of asset price.

How calculated

Moving average of true range

Example usage

=AverageTrueRange("MSFT") - Returns ATR value for 14 day period
=AverageTrueRange("MSFT",30) - Returns ATR value for 30 day period
=AverageTrueRange("MSFT",30,"9/1/2022") - Returns ATR value for 30 day period with start date 1 September 2022

Notes

A stock with a high level of volatility has a higher ATR, and a low volatility stock has a lower ATR.

Assets

Stocks, ETFs, Mutual Funds, Currencies, Cryptocurrencies