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

BFC

NSC
Bank First Corporation
Financial Services•Banks - Regional - US
Watchlists:
Last updated: Thursday 17th July 2025
121.22
+1.55 (1.30%)
Prev Close:119.67
Open:120.53
Bid:115.88
Ask:128.0
52 Week Range
82.50
125.27
Volume:105,398
Mkt Cap:1,187 M
72
MarketXLS Rank ®
Buy
How are these ranks calculated?
Price Target
$139.40
+15.0%
overviewOptionfinancialsvaluequalitytechnicalestimatespeersnewsTrend Analysis & Forecastdata

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