1) Click My Portfolio 2) Click Confirmations 3) Click Download (Next to Sort by Contract Number) 4) Open file in Microsoft Excel 5) Delete all transactions that were not in current Financial Year 6) Sort all Transactions into Buy/Sell Column (B/S)by using sort function in excel 7) Isolate all of the Buy orders and the Sell orders 8) Match the Buy orders with the sell orders by cutting and pasting the Sell line next to the corresponding buy line. I dont change any format or delete any columns (ie Contract # Field) 9) Use a simple formula to calculate net loss or gain (Involving Net Proceeds ... You may want to manually check a Capital Gains Transaction to see if your formula is right) 10) Total all Gains and Losses using Autosum.
