Stock Return Custom Dates
Calculates the total percentage return for a stock between two specific dates.
Syntax
=StockReturnCustomDates(Symbol, StartDate, EndDate)Parameters
symbolstringRequired
Stock ticker symbol
startDatedateRequired
Start date (YYYY-MM-DD)
endDatedateRequired
End date (YYYY-MM-DD)
Returns
number
Stock return between two dates as percentage
Examples
=StockReturnCustomDates("AAPL", DATE(2022,1,1), DATE(2023,1,1))=StockReturnCustomDates("MSFT", A1, B1)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.
Excel Templates Using Stock Return Between Two Dates In Past
These ready-made MarketXLS templates call StockReturnCustomDates() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?