Stock Return Two Years

Calculates the total percentage return for a stock over the past 2 years.

Examples

=StockReturnTwoYears("AAPL")

Apple 2-year return

=StockReturnTwoYears("MSFT")

Microsoft 2-year return

=StockReturnTwoYears(A1)

Symbol from cell

When to Use

Long-term performance analysis
Multi-year return comparison

When NOT to Use

Scenario	Use Instead
Need 1-year return	`StockReturnOneYear()`
Need 3-year return	`StockReturnThreeYears()`
Need custom dates	`StockReturnCustomDates()`

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

Get started today

MarketXLS Excel Add-in Tutorial - How to Use Stock Return Two Years and Other Financial Formulas

▶

How does MarketXLS work?

Related Functions