Stock Return Five Years

Live
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