[Uglyowl]

I have created a spreadsheet with beginning balance, deposits, withdrawals, commissions, dividends, ending balance for each month (everything can be from the statement) and set a formula for the difference to calculate gains and losses.

For % gains for the year, I take the average end balance each month. This isn't exact, but close enough.