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
-15.11%
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

ALRS

-15.11%

FFWM

-58.06%

HTLF

-42.82%

OFG

109.92%

SSBI

33.38%
Alerus Financial Corp logo

Alerus Financial Corp

Sector: Financial Services   

Industry: Banks - Regional - US

18.00
 
USD
  
-0.10
  
(-0.55%)
Optionable: No  Market Cap: 356 M  90-day average vol: 31,000

Previous close: 18.1  Open: 18.23  Bid: 15.57  Ask: 18.83
52 week range    
13.11   
   24.16
Peers   
FFWM / 
HTLF / 
OFG / 
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