Apply it to your data 4
Joseph Frates
2025-09-16
1 | Import stock prices of your choice
2 | Convert prices to quarterly returns
3 | Make plot
4 | Interpretation of the plot and summary table
| symbol | Avg_Quarterly_Return | Annualized_Return |
|---|---|---|
| AAPL | 3.5% | 14.7% |
| MSFT | 6.6% | 28.9% |
| TSLA | 7.7% | 34.5% |
| ^GSPC | 3.8% | 16.1% |
Interpretation:
From the summary table and the plot:
- Stocks with higher average quarterly and annualized
returns than the S&P 500 (^GSPC) have
beaten the market so far in 2025.
- Stocks with lower returns have underperformed.
- Observing both visuals and numbers provides insight into risk and
consistency of returns—
for example, a high average but volatile quarterly trend may indicate
more speculative behavior (like TSLA often shows),
while steadier gains suggest more stable growth (such as MSFT or
AAPL).