Open lots report

[gerard]

I like the standard open lots report. I know you can customize this report via Report preferences Open lots. But I want to customize this report further, by adding some own created variables as you can do with: reports --> custom. But i was wondering if you can get an open lot's type overview when creating your own custom report ?
Investment Shares Open date Open price etc.

I could not find the right variables.

[Mark]

Hi gerard,

The Open Lots report lists by lot (transaction), where the Custom report lists by investment (among other things, but not transaction). So, for example if you have an investment that you've bought on two different occasions, the Open Lot report will have 2 lines, one for each time you purchased it. The Custom report listed by investment will only have a single line summarizing the whole investment, which would include both purchase transactions. There are fields to get the equivalent numbers, but they will consolidate all purchases together. For instance, see the 2 fields:

Date acquired, end (ending)
Date acquired, start (ending)

These two fields will show you the beginning and ending dates of all your purchases for all open lots in that investment as of the ending report date. There are other equivalent fields for shares/price, like:

Average out of pocket purchase price (current)
Tax basis per share (assigned)
OOP basis per share (current)
Shares (ending)

[gerard]

Thanks Mark for the explanation.

So, I concluded that it is not realy possible to reproduce open lots report with a custom report.

Regards

Gerard

[Mark]

Hi Gerard,

Yes, that is correct. You can't exactly replicate the Open Lots report as a Custom report.