Skip to main content

Evaluate Mean and Standard Deviation for Asseet Allocation of SPY and Cash

Assume cash has a mean return of 0, return standard deviation of 0 and has no corration with SPY, in theroy, with x percent of cash ans 1-x percent of y, the portfolio mean return is (1-x) times SPY mean return and standard devation of (1-x) times SPY standard deviation. Mathematical proof is in this blog post.

SPY has a daily mean return of 0.046% and daily return standard deviation of 1.179%. Derivation is in this blog post.

Then, for example, a portfolio of 50% cash and 50% SPY will have a daily mean return of 0.046%/2= 0.023% and daily return standard deviation of 1.179%*/2 = 0.5895%.

I want to test the above statistial theory by runing simulation.

Simulator

SPY and Cash have the above mentioned daily mean return and daily return standard deviation. This simulator will generate SPY pirces base on geometric Brownian Motion that stock prices follow. Then it calculate portfolio value and its daily rerun data. Finally, the porfolio daily returns will be transformed into the mean and the standard deviation for comparing with the theoretical mean and standard deviation.

Portfolio Initail Value: $1000
SPY ratio: %
Cash ratio: %
  • Theoretical Mean: 0.0230%
  • Theoretical Standard Deviation: 0.5895%
  • Simulated Mean: %
  • Simulated Standard Deviation: %
Labels:

Comments

Post a Comment

Popular posts from this blog

Which Asset Class Had the Best Performance During the 2008 Financial Crisis?

In this article, I want to explore which asset, ETFs, MFs, Stocks, did best during the 2008 financial crisis. I will compare the investment results against the result of SPY, since it represents the overall market. The scenario is investing right at the highest point of S&P 500 index right before it crashed during the crisis. The date is Oct 9, 2007  when the index reached 1,565.15. I will compare the returns of each asset against SPY in the following order: Investing until the bottom of the crisis at 676.53 on Mar 09, 2009 in order to simulate downside risk. Investing until the S&P 500 index closed above the previous high at 1,568.61 on Apr 09, 2013 in order to simulate recover ability. Investing until the bottom of the Covid crisis at 2,304.92 on Mar 20, 2020 in order to simulate a series of market crashes. Performance By Ranks Oct 9, 2007 to Mar 09, 2009 SHY  return is 8.848% AGG  return is 7.390% LQD  return is -6.793% HYG  return i...
Post a Comment
Read more