RE:RE:RE:RE:RE:My spreadsheetWell therein lies the discrepency. Since CIX is in the top 15, I have assigned a significantly higher weighting to it than Loblaw, which has had a terrible week.
In any case, we're all forced to make assumptions so it's never going to be an exact science. I'm satisfied so long as we're within a couple of cents of the true value.
mouserman wrote: On my spreadsheet the only holding showing a positive move since JUNE 30th was CIX. If you attach a lower % to CIX and higher to the losers above, the NAV would not be higher.
I recently adjusted the spreadsheet to make the UNIT NAV make sense to my spreadsheet. The trend in many portfolios is to give a higher weighting to renewable energy like TA....and less to oil plays like SUNCOR. Dont know if i agree with that... but it is what is happening. And i noted DGS for instance has very high weightings to stocks like Dolarama, QSR, and Loblaws... so I upped Loblaws weighting in DFN as well.