As tax time is rapidly approaching, and I have a bunch of cap gains/losses to declare, I am trying to figure out the best way of doing this in or out of gnucash. (I have data since 1999!)
I have been looking at g2 cvs and lots, but 'view' lots doesn't seem at this point (i know this is a work in progress) to provide the necessary info or be incorporated into a report.
In a transaction report of my Sold securities I am able to produce the following:
>From 2005-01-01 To 2005-12-31
Date Num Description Account Shares Price Amount
2005-02-23 ALA Buy 70.00 10.18 ALA 70 ALA
2005-06-29 ALA Buy 40.00 11.18 ALA 40 ALA
2005-09-19 ALA Sell -30.00 12.96 ALA -30 ALA
I could export this and import into calc, but will also require some massaging. I can't get the account field to show, the 'amount', and price fields are appended with the stock ticker. And most importantly the commission paid would have to be done on a second report and then merged or something.