Skip to main content

SPY's Expected Loss During Market Downturn

This article is about risk analysis of SPY. First, I will build an app that will randomly generate investment start date and end date given an investment span. The user has the freedom to set a tax rate on dividends.

With this app, I am looking for given an investment span, what is the chance that SPY's return is negative, and if it is, what is the expected loss. This will help me decide how much cash or its equivalent I need to keep when retired.

The data range is from 2007-04-11 to 2022-07-22 and  each year is assumed to have 252 trading days.

APP

Truncated Data:
Start Date:
End Date:
Tax Rate on Dividends: %
Investment Span: days.
Investing in SPY for 252 days:

Total Distribution

TImes when Lost are greater than 5%

Start Date End Date Span Return(%)
Labels:

Comments

Post a Comment

Popular posts from this blog

Which is better? BND or AGG?

The US 10-year treasury yield has reached at 2007-2008 years level, which is about 16 years ago. From a technical point of view, it is a buy. Then there are 2 bond ETFs that I am interested in. There are BND and AGG. They are very similar in nature. US 10 year Treasury Bond, chart, prices - FT.com Expense Ratio BND: 0.03% AGG: 0.03% The same. Turnover Rate BND: 40.00% AGG: 104.0% BNG seems better. Historical Performance Comparison Investment duration: 5 years with no tax on dividends BND wins a little with winning rate of 57.5%, but AGG wins 0.012% in return. Investment duration: 5 years with 30% tax on dividends AGG wins a little with winning rate of 65% and a 0.079% difference on average. Investment duration: 10 years with no tax on dividends AGG wins a little with winning rate of 67% and a 0.024% difference on average. Investment duration: 10 years with 30%  tax on dividends AGG wins a little with winning rate of 99% and a 0.095% difference on average. C...
Post a Comment
Read more