Stock Return Six Months
Returns the percentage price return for a stock over the past 6 months (181 days). This is calculated from 181 days ago to yesterday's close.
What is Calculated
The function calculates:
- Start: Close price from 181 days ago
- End: Close price from yesterday
- Return: (End - Start) / Start
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
Notes
- Returns are expressed as decimals (0.10 = 10% gain)
- Negative values indicate a decline
- Useful for semi-annual performance reviews
Examples
=StockReturnSixMonths("AAPL")=StockReturnSixMonths("MSFT")=StockReturnSixMonths("IWM")=StockReturnSixMonths(A1)=StockReturnSixMonths("AAPL") * 100When to Use
- Semi-annual performance analysis
- Medium-term trend assessment
- Half-year portfolio reviews
- Comparing 6-month price movements
- Momentum screening
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need 3-month return | StockReturnThreeMonths() |
| Need 9-month return | StockReturnNineMonths() |
| Need 1-year return | StockReturnOneYear() |
| Need 30-day return | StockReturnThirtyDays() |
| Need custom dates | StockReturn() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is valid
- The stock has been trading for at least 181 days
- Market data is available for the period
Q: How do I convert to percentage?
A: Multiply by 100:
=StockReturnSixMonths("AAPL") * 100
Q: What time period exactly is used? A: The return is calculated from Today-181 days to Today-1 day (yesterday's close).
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?