Last Monday, I took a huge contract; making the trade calculations for each ETF trading with a moving average of 200 days. I thought it was easy… man, this was a lot of trades! Before I jump with the actual calculation, I’ll share a few points to consider first:

#1 There are some trades that I have ignored

In order to list the trades according to the moving average, I have used Google Finance. Since there were moments where the closing price and the moving average were getting crossed every 2 days, I have skipped a few trades. So keep in mind that while it wouldn’t affect much the overall return of each ETF, but it would affect it if you trade with a small amount due to trading fees.

#2 Trading dates might now be completely exact

Since I had to cover 10 years of trade for each, I have decided to use the graphs from Google Finance as I have previously mentioned. However, this doesn’t give all the dates and trade prices (you skip a few days from one point to another on the graph). Nevertheless, the main point of this strategy is still respected; avoid most of the downfall and capture most of the uptrend.

#3 Trading calculations don’t take trading fees into account

I have not taken trading fees into consideration since they do not necessarily play a huge role in yield calculation. As you will see in the trading tables, there are several trades done for each ETF. Therefore, if you want to use the Ivy portfolio strategy, I strongly suggest you use it with a large amount. If you start your portfolio with $10,000, you may end-up eat a lot of your investment return in trading fees.

#4 I have “sold” all ETF on March 7^th 2011

In order to have a “final yield”, I have virtually sold all ETF on March 7^th 2011 even they were not meant to be sold according to the moving average. This exercise was to give you an idea of what works and what doesn’t with the Ivy Portfolio.

I leave you today with the table and I’ll return on next Monday with my final conclusion on the Ivy Portfolio and the ETF asset allocation model.

BOND ETF; SHY (Starting on August 2^nd 2002) (total yield:4.80% vs 3.21%)

REITS ETF: IYR (Starting on March 2^nd 2001) (total yield: 114.29% vs 64.15%)

US Stock Market: SPY (Starting on March 2^nd 2001) (total yield:27.12% vs 6.55%)

International Stock Market: EFA (Starting on August 24^th 2001) (total yield 89.91% vs 46.58%)

Canadian Stock Market: EWC (Starting on March 2^nd 2001) (total yield: 102.69% vs 185.82%)

Emerging Stock Market: EWZ (Starting on March 2^nd 2001) (total yield: 311.24% vs 343.4%)

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss

***************************************************