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

ESGR

NGS
Enstar Group Limited
Financial ServicesInsurance - Diversified
Watchlists:
Last updated: Wednesday 2nd July 2025
337.91
+1.55 (0.46%)
Prev Close:336.36
Open:336.36
Bid:336.97
Ask:338.0
52 Week Range
315.94
348.48
Volume:110,651
Mkt Cap:5,015 M
Price Target
$388.60
+15.0%

Stock Return One Year

Live
Returns the stock return over one year based on closing prices. Updated daily around 5PM EST. Can retrieve total or price return.

How calculated

(Previous Closing Price/Closing price on the given past x day )-1

Example usage

=StockReturnOneYear("MSFT") - Returns the total stock return for MSFT for the given period
=StockReturnOneYear("MSFT","total") - Returns the total stock return for MSFT for the given period
=StockReturnOneYear("MSFT","price) - Returns the price return for MSFT for the given period

Assets

Stocks, ETFs ,Mutual Funds, Cryptocurrencies