|
Posted by Jerry Boyle on July 13, 2008, 2:25 pm
Please log in for more thread options
> I've been needing this over and over on many occasions in which I am
> trying to understand where something went wrong.
>
> That would be a report of the register of a single investment in a
> single account (which might have other investments in it), showing all
> transactions and a running total of shares balance and investment
> value.
>
> Actually a cash balance isn't as critical, but if included would
> probably be ACCOUNT cash balance...not cash balance due to that
> particular investment.
>
> Does anyone know how I can generate such a report in Quicken? If you
> do, and you share it, I'd really appreciate it!
No such report that I know of. But you may be able to use Portfolio
(Investing -> Portfolio or Ctrl-U) to find when your share balance went
wrong.
The following method (known as binary convergence) works quite well if you
have brokerage statements that go back to the date or dates where the
error(s) occurred.
Set Show:Holdings and Group by:Accounts and As of:<date of interest> to see
your share balance, cost basis, etc. on that date. You can customize this
report to add or remove columns.
Then find a date G where the balance was good, a date B where it is bad and
a date M about midway between G and B.
If the balance on M is bad the error is between G and M, so divide that
interval in half and repeat the process. If the balance on M is good divide
the interval between M and B. Keep dividing until you find the date where
the error occurred.
|