Parses annual activity statement in .csv from IBKR, automatically calculates correct ACB for Schedule 3.

For use with https://github.com/Bizzaro/cad-capital-gains.

T5008 is inaccurate even using a single broker. Fractional shares are not included in calculations, exchange rates are also not BoC rates. This is common knowledge amongst CPAs and also the CRA itself.

1. Download a new csv from client portal.

Performance & Reports > Statements > Activity > Period: Annual > Download the CSV

2. Place it in ./source
3. Update the year in launch.sh and run it!
4. Look for a new file called schedule3-XXXX.csv to import

Options trades are excluded from this csv and need to be entered manually.

1. Sign in to client portal, then go:

Performance & Reports > Statements > Activity > Period: Annual > Download the CSV

1. Create virtual env

python3 -m venv virtual-env 
source virtual-env/bin/activate

2. This installs my cad-capital-gain fork

pip3 install -r requirements.txt

3. Drop all your .csv's from every year into the ./source folder.

4. Generate a compatible cad-capital-gains compatible .csv

python3 ibkr.py

5. Run the capgains (cad-capital-gains) tool

capgains calc master.csv 2022

YOU (THE USER OF THIS SCRIPT) ARE RESPONSIBLE FOR THE NUMBERS PRODUCED BY THIS TOOL. IT HAS NOT BEEN AUDITED OR VERIFIED BY A THIRD PARTY. THIS IS NOT TAX ADVICE OR CERTIFIED TAX SOFTWARE. DOING RANDOM SPOT CHECKS OF CALCULATIONS IS RECOMMENDED. CONSULT A CPA FOR ALL YOUR TAX INQUIRIES.