Q: Hi Peter, Ryan, and Team,
I understand the rationale for different weighting of sectors among the three portfolios. You've stated in the past that we should look at our entire portfolio to "determine where we stand", and I've done this for my RRIF, my wife's RRSP, both of our TFSA's and our joint Margin Account. I use Google Sheets to track this entire portfolio. My question is this: In a 'composite" portfolio, how can one determine the appropriate sector weighting, or is it purely a personal choice? For example, Technology is 21.38% of the Balanced Equity Portfolio, 32.05% of the Growth Portfolio, and 7.26% of the Income Portfolio. In our 'composite' portfolio, Technology has a weighting of 10.83% of the portfolio's equity portion. So I suppose my question would be "How do I know that my weightings are appropriate, and once weightings are chosen, do I stick with them? Or should they vary for different points in the economic cycle?"
I have another question that I'm hoping can be answered by one of our computer-savvy members: As mentioned, I use Google Sheets to track our portfolio which can "capture" the stock price for popular indexes like the TSX. However, there's a "new kid on the block", namely the Aequitas Neo index, and I haven't been able to "capture" prices to be inserted into Google Sheets automatically. As an example, a Canadian Money Saver top-rated ETF, (CLU) is no longer listed on the TSX, but is now listed on the Aequitas Neo index. Do any 5i members know how to accomplish this "price capturing"?
Given that there are several questions in this long-winded question, please deduct as many question credits as you deem necessary. Thanks for all your help! Now I'm going to watch Peter on BNN which I PVR'd earlier!
I understand the rationale for different weighting of sectors among the three portfolios. You've stated in the past that we should look at our entire portfolio to "determine where we stand", and I've done this for my RRIF, my wife's RRSP, both of our TFSA's and our joint Margin Account. I use Google Sheets to track this entire portfolio. My question is this: In a 'composite" portfolio, how can one determine the appropriate sector weighting, or is it purely a personal choice? For example, Technology is 21.38% of the Balanced Equity Portfolio, 32.05% of the Growth Portfolio, and 7.26% of the Income Portfolio. In our 'composite' portfolio, Technology has a weighting of 10.83% of the portfolio's equity portion. So I suppose my question would be "How do I know that my weightings are appropriate, and once weightings are chosen, do I stick with them? Or should they vary for different points in the economic cycle?"
I have another question that I'm hoping can be answered by one of our computer-savvy members: As mentioned, I use Google Sheets to track our portfolio which can "capture" the stock price for popular indexes like the TSX. However, there's a "new kid on the block", namely the Aequitas Neo index, and I haven't been able to "capture" prices to be inserted into Google Sheets automatically. As an example, a Canadian Money Saver top-rated ETF, (CLU) is no longer listed on the TSX, but is now listed on the Aequitas Neo index. Do any 5i members know how to accomplish this "price capturing"?
Given that there are several questions in this long-winded question, please deduct as many question credits as you deem necessary. Thanks for all your help! Now I'm going to watch Peter on BNN which I PVR'd earlier!