Capital gains calculation question (stocks, 104 holding, etc)

adrian.idar

Hello.


Wondering if anyone aware of a program/site that could calculate the capital gain given a set of trades at some moments in time.


Use case is: about 140 trades in various stocks over 10 year period. Would need for tax purposes to calculate the PnL every year at determined dates. Say for Oct 2009 to Oct 2010 the output would say the capital gain is £4,234 and the cash holdings £123,100.



The could be done manually, but although it doesn't look rocket science, to be done properly one has to look at attribution rules, 'bed and breakfasting', etc.


Is there a program/Excel sheet that would take the set of trades in .csv format and do the job?


If not, how are you guys who trade frequently do this activity when the tax return needs preparing?


Help much appreciated.


Adrian

cloud_dog

I trade mostly within S&S ISA accounts, therefore no headaches.

I run MS Money and this it is not something I have needed to check out / verify, but I think MS Money would be able to do what you are looking for.

grey_gym_sock

http://www.cgtcalculator.com/ and http://www.stonebanks.co.uk/ are 2 online capital gains tax calculators, which take a CSV file (of your transactions) and spit out a CGT calculation.

(i haven't actually used them. i don't have large numbers of transactions.)

adrian.idar

Thank you grey gym sock, both look good at first view, exactly what I was looking for! Will give them a go this weekend.


I wondered for a while what professionals (e.g. tax advisers) use, as such calcs should be the bread and butter for them, daily routine. Maybe one of these 2 sites .



Have a nice day all!



Adrian