www.stonebanks.co.uk

stonebanks2CGTcalc - changes data format

I AM NOT QUALIFIED OR AUTHORISED TO GIVE INVESTMENT ADVICE

This program changes source format from that reqd for my CGT program to that for www.CGTcalculator.com

My format - company-code (EPIC), company name
then deals: date, b/s, qty, share_price (p), total price £.p

My prog at stonebanks.co.uk does not need the company EPIC share code but it is required at CGTcalculator so this translation prog will extract that if company line is formatted as
EPIC, company name

CGTcalculator format:
B/S date dd/mm/yyyy company qty share_price charges(commission) tax


Copy and paste source data (in my format) into the upper (input) text box. Click on process then you can copy and paste from the lower (output) text box.

Sample data:

EXT, Exeter Selective Assets Ord
13-10-04, b, 13000, 30.5, 3999.82
01-09-05, s, 13000, 44.61, 5784.31

FRNI, Framlington Inc & Cap Tst Inc
18-04-02, b, 5000, 45, 2283.75
03-10-05, s, 5000, 42.01, 2085.51

JSS, Jupiter Second Split Trust Geared Growth
15-07-05, b, 8919, 39.4, 3546.65
25-07-05, b, 11771, 39.6, 4699.62
19-10-05, s, 20690, 42.5, 8778.26

Let me know if you have problems - send an email to david@stonebanks.co.uk

I AM NOT QUALIFIED OR AUTHORISED TO GIVE INVESTMENT ADVICE