Investment performance showing incomplete data

Chris Sowerby

Tom Young

Jim_Harman

Dividend reinvestments where the dividend and the purchase were in the same day do not have a separate entry in the investing performance report because the return and the new investment are the same amount. They affect the performance correctly because you have more shares at the end of the period.

Jim_Harman

Chris Sowerby

Chris Sowerby

Jim_Harman

If you had no buys or sells, only reinvested dividends during the analysis period and you sort by account, it is showing you account level performance and the security will not appear in the report.

Chris Sowerby

Nope, the missing transactions are all buys, sells or cash dividends.  As I mentioned in an earlier comment, everything appears correctly when sorted by security but some data gets suppressed when sorted by account or a time criterion.

q_lurker

Chris Sowerby said:

Nope, the missing transactions are all buys, sells or cash dividends.  As I mentioned in an earlier comment, everything appears correctly when sorted by security but some data gets suppressed when sorted by account or a time criterion.

You keep saying that transactions and/or securities are missing from the report. Yet the report does not list securities and does not intend to list all transactions.  Something seems amiss in your description. 

I will also point to a character of the IPR - that is, an applicable transaction is listed as a return if it is a removal from that sub-total.  So when subtotaled by security, a Dividend transaction will be listed in the IPR under that security.  For the same transaction when the IPR is subtotaled by Account, the dividend will not be listed. 

That is not saying that the transaction is missed when subtotaled by Account.  For that subtotal, the dividend is a change in form - from value as part of the security to value as cash.  Since the cash is still part of the account, the dividend payment does not represent 'return' at the account level.  The positive nature of the dividend is still felt since the overall ending value of the account is increased by the dividend (even though the security value might have dropped similarly).  

Perhaps it is then obvious that DivX and similar that remove the paid dividend from the account would be listed as transactions when subtotaled by account.  

That characteristic would not seem to apply within the time-criterion setting where the 'investment' / 'return' consideration would still be at the upper level.  

I am not seeing you basis for missing transactions and securities.  I think there is some other discrepancy in your data.

Chris Sowerby

Thanks for the insight provided in replies to my original post.  I have taken a closer look at the types of transactions included with the different sorting criteria, and realized that everything is being taken into account correctly.  I discovered that certain transaction types such as buys, sells, interest and cash dividend income are not itemized when the report is sorted by account.  Adds, removes and return of capital always appear regardless how the report is sorted. This now makes sense - unless cash or securities are transferred in or out of the account as part of a transaction, the IRR doesn't change at the account level because the timing of those transactions is not significant for IRR calculation and the value just remains in the account ending total amount regardless what form it is in.  However those transactions do appear when summarized by security because they have to be considered in IRR at the individual security level.  The reason that some securities were disappearing from my report when it was sorted by account is that those securities only had buy, sell and/or dividend transactions.  It's a confusing situation and I am feeling greatly relieved now that it's resolved!

Jim_Harman

Chris Sowerby said:

Thanks for the insight provided in replies to my original post.  I have taken a closer look at the types of transactions included with the different sorting criteria, and realized that everything is being taken into account correctly.  I discovered that certain transaction types such as buys, sells, interest and cash dividend income are not itemized when the report is sorted by account.  Adds, removes and return of capital always appear regardless how the report is sorted. This now makes sense - unless cash or securities are transferred in or out of the account as part of a transaction, the IRR doesn't change at the account level because the timing of those transactions is not significant for IRR calculation and the value just remains in the account ending total amount regardless what form it is in.  However those transactions do appear when summarized by security because they have to be considered in IRR at the individual security level.  The reason that some securities were disappearing from my report when it was sorted by account is that those securities only had buy, sell and/or dividend transactions.  It's a confusing situation and I am feeling greatly relieved now that it's resolved!

Right. You can think of subtotaling as drawing a circle around each subtotaled item. Only transactions that cross that boundary will appear in the report.