new thread, page-74

"or have you/ could you do this:

XJO 31 Mar = 5995
XJO 27-29 Apr = 6151

= up 3%

NTA AUI = 8.77 at 31/3
so now 8.77*1.03 = 9.00

(I KNOW however what AUI holds in not a represention of XJO which is I gather the ASX200? But ?? close enough?)"


You will be very close.
However to be strictly correct you must use the S&P/ASX200 TR (Accumulation) Index (can be found on the Standard & Poors Web Site) not the S&P/ASX200, for the obvious reasons.
The only other adjustments you must be mindful of are the Capital Management events eg if they go ex-dividend, simply subtract the DPS amount, if they issue new shares (DRP, SPP, Rights, Buybacks etc) add the cash raised/spent and divided buy the new number of shares.
This method will get you a 99% answer and you will be well ahead of most bast*ards out there.


However, I do it in more detail. It doesnt improve the accuracy much from the method above but I have my spreadsheet set up to account for (eliminate) LIC cross-holdings and arrive at net-net NTA's.
Briefly my method involves (partly answering the question from your previous post) setting up the *entire* holdings of all the LICs I follow in a spreadsheet (these holdings appear in all LIC Annual Reports). Thereafter, I update the holdings from whatever updates are available, sometimes top 10,20,25 sometimes monthly or at Half Year ... depends on the LIC.
I have all the LIC holdings set up as a portfolio in Yahoo Finance which I can download into a spreadsheet as frequently as I wish. This updates portfolio values automatically using Excel Lookup.
I also project their Income Statement (dividends, interest, expenses etc) and Balance sheet.
I account for all the Capital Events and finally eliminate the cross-holdings.
Its all obvious but it needs some serious work to set-it up thereafter its easy to update.
Lets put it this way, there aint anyone in this country who has more accurate and timely information than I (not even the LICs themselves).