Stock Return Custom Dates

Calculates the total percentage return for a stock between two specific dates.

Syntax

=StockReturnCustomDates(Symbol, StartDate, EndDate)
Excel Desktop (Windows)

Examples

=StockReturnCustomDates("AAPL", DATE(2022,1,1), DATE(2023,1,1))
=StockReturnCustomDates("MSFT", A1, B1)
Dates from cells

When to Use

  • Custom period analysis
  • Event-based return calculation

When NOT to Use

Scenario Use Instead
Need standard period StockReturnTwoYears(), etc.

Common Issues & FAQ

What date format to use?

Use Excel DATE() function: DATE(2023,1,15) for Jan 15, 2023.

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 Between Two Dates In Past and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions