Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Data

Stock Return Five Years

Live
242.83%
Returns the stock return over five years 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

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

Assets

Stocks ETFs Mutual Funds Cryptocurrencies
Stock Return Five Years
StockStock Return Five Years

BRG

242.83%

EQR

5.13%

AGNC

-13.12%

GEO

-57.29%

RPT

-0.35%
Bluerock Residential Growth REIT Inc. Class A logo

Bluerock Residential Growth REIT Inc. Class A

Sector: Real Estate   

Industry: REIT - Residential

26.60
 
USD
  
-0.32
  
(-1.19%)
Optionable: Yes  Market Cap: 823 M  90-day average vol: 0

Previous close: 26.92  Open: 26.88  Bid:   Ask:
52 week range    
26.57   
   27.03
Peers   
EQR / 
AGNC / 
GEO / 
Last updated: Friday 29th September 2023

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today