Custom Historical Report

[elimb]

Hi Mark,
I am looking to produce a custom report for historical trades, so that the following columns are displayed:
Name/Symbol, # Shares, Entry date, Entry price, Exit date, Exit Price, %P/L

Is this possible?
Thank you
Eli

[Mark]

Hi Eli,

The Custom report doesn't list by "transaction". The lowest level you can list by is an investment. If you want to see transaction specific details, see one of these 3 reports:

Open Lots
Capital Gains
Investment Transactions

It sounds like you're mostly looking for the "Open Lots" and "Capital Gains" reports.

[elimb]

The open lots report is the closest to the format I am looking for.
It has the open date, open price, current price, % gain -- which is great.
The only problem is I want to see the historical trades in this format as well. (With 'closing price' instead of 'current price').
Is there any way to do this? Or get close to it?

I understand the custom report cannot report by "transaction." Can it produce the above fields by investment or date? That may work for me as well.

Thank you!

[Mark]

Hi elimb,

By "closing price", do you mean the price you sold the lot for? If so, that wouldn't be in an open lots report, as that report only reports on un-sold lots. You can get value based numbers for sold lots in a Capital Gains report.

In the Custom report there are fields that show this information summed for all transactions within an investment. For example, see all the fields beginning with "Tax basis". In addition to tax basis, Fund Manager calculates an "Out Of Pocket (OOP)" basis. It is similar to tax basis, but differs due to distributions. It is meant to show your overall break even point. When an investment pays a dividend, that doesn't change your tax basis, but it does lower your OOP basis.