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

UI

NYE
Ubiquiti Inc.
Communication EquipmentTechnology
Watchlists:
Last updated: Friday 18th July 2025
446.93
+24.96 (5.92%)
Prev Close:421.97
Open:424.0
Bid:408.0
Ask:478.0
52 Week Range
156.94
469.98
Volume:104,217
Mkt Cap:24,838 M
Price Target
$513.97
+15.0%

Stock Return Seven Days

Live
The return is calculated on the closing prices for the given calendar days. The value gets updated everyday at around 5PM EST. Can be used to retrieve total return or price return.

How calculated

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

Example usage

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

Assets

Stocks, ETFs ,Mutual Funds, Cryptocurrencies