Ivy Portfolio April Update

Note: Spreadsheets are currently not importing data or importing intermittently. If you have extensive experience working with Google Sheets and would be willing to assist, please contact me.

The Ivy Portfolio spreadsheet track the 10 month moving average signals for two portfolios listed in Mebane Faber’s book The Ivy Portfolio: How to Invest Like the Top Endowments and Avoid Bear Markets. Faber discusses 5, 10, and 20 security portfolios that have trading signals based on long-term moving averages.

The Ivy Portfolio spreadsheet on Scott’s Investments tracks both the 5 and 10 ETF Portfolios listed in Faber’s book. When a security is trading below its 10 month simple moving average, the position is listed as “Cash”. When the security is trading above its 10 month simple moving average the positions is listed as “Invested”.

The spreadsheet’s signals update once daily (typically in the late evening) using dividend/split adjusted closing price from Yahoo Finance. The 10 month simple moving average is based on the most recent 10 months including the current month’s most recent daily closing price.  Even though the signals update daily, it is not an endorsement to check signals daily or trade based on daily updates. It simply gives the spreadsheet more versatility for users to check at his or her convenience.

The page also displays the percentage each ETF within the Ivy 10 and Ivy 5 Portfolio is above or below the current 10 month simple moving average, using both adjusted and unadjusted data. If an ETF has paid a dividend or split within the past 10 months, then when comparing the adjusted/unadjusted data you will see differences in the percent an ETF is above/below the 10 month SMA. This could also potentially impact whether an ETF is above or below its 10 month SMA. Regardless of whether you prefer the adjusted or unadjusted data, it is important to remain consistent in your approach. My preference is to use adjusted data when evaluating signals.

Bring Your Portfolio Into The 21st Century
Free Access – INO.com Special Report

The current signals based on March 31st’s adjusted closing prices are below.    This month (DBC) (GSG) (VEU) and (VB) are below their moving average and the balance of the ETFs are above their 10 month moving average.

The spreadsheet also provides quarterly, half year, and yearly return data courtesy of Finviz. The return data is useful for those interested in overlaying a momentum strategy with the 10 month SMA strategy:

Ivy