Stock Return One Year
Returns the stock's past 1 year (366 days) return. By default, this function returns total return using adjusted prices where available. You can optionally pass a second argument to request price return instead.
What is Calculated
The calculation measures return over the past 1 year (366 days) using the nearest available trading dates for the start and end observations.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| TypeOfReturn | No | Optional. Use total (default) for dividend-adjusted total return, or price for price return. Also accepts return, change, and changepercent. |
Notes
- Returns are expressed as decimals (0.20 = 20% gain)
- Default behavior is total return
- Use
pricewhen you want return based only on unadjusted closing prices - Trading-day availability may shift the exact start/end observation dates slightly
Syntax
=StockReturnOneYear(Symbol, [TypeOfReturn])Examples
=StockReturnOneYear("AAPL")=StockReturnOneYear("AAPL","total")=StockReturnOneYear("AAPL","price")=StockReturnOneYear("AAPL") * 100When to Use
- Annual performance analysis
- Long-term trend assessment
- Year-over-year comparisons
- Portfolio annual reviews
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need a different preset horizon | Use the corresponding StockReturn...() function for that horizon |
| Need custom dates | StockReturnCustomDates() |
| Need dollar change instead of return | Use the corresponding Change...() function where available |
Common Issues & FAQ
What is the difference between total and price?
total uses adjusted prices and includes dividends where available. price uses unadjusted close prices and excludes dividend adjustments.
Why might the exact dates differ from the dates I expect?
If the requested anchor date is a weekend or market holiday, the calculation uses the nearest available trading date.
Why am I getting NA?
Check that the symbol is valid and that sufficient historical pricing data is available for the requested period.
Excel Templates Using Stock Return One Year
These ready-made MarketXLS templates call StockReturnOneYear() 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:
- Stock Return Quarter To Date
- Stock Return Seventy Five Days
- Stock Return Sixty Days
- Stock Return Ten Days
- Stock Return Three Years
- Stock Return Twenty Days
- Stock Return Two Years
- Stock Return Week To Date
See StockReturnOneYear used in a complete workbook: Obesity Drug Stocks Dashboard Excel: GLP-1 Leader and Pipeline Tracker (2026)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today