RE:RE:RE:DF unit nav to March 28 = approx; $15.29 before dist.I have a very old program Apache open office , so many of the other excel spreadsheets wont jive with it. It is a lot of work keeping these, as you have t take into account USD/CAD in some of the Split funds and also have to add in dividends collected on ex divvy date. When Quadravest does the full update, you have to adjust for cash, and changes in weightings. AND THOSE you have to guess at the % .
So after you have guessed at the % of the UNIT NAV in the spreadsheet, you calculate the value of the holding in $. Multiply the % of the holding x the UNIT NAV after cash is deducted.
Update it whenever you want to give your estimate. I do these almost every day. Mine is not automatic.