Downloading entire TD Direct Investing transactions?

Kaitlyn · Jun 2, 2014

I've got 4 accounts in TD Waterhouse/WebBroker/TD Direct Investing and called in last night wondering if there is ANY way to get my entire transaction history. He said no and the Activity only keeps the previous 60 days then they are basically discarded, and statements is how you get them.

I've got monthly statements since 2010 as a result - some without any transactions in them. Anyone have ANY idea how I might be able to get a full transaction log? At best I thought about opening them all, COPY+PASTE the "transaction table" and process it later, although it seems to not copy cleanly (i.e. tab-delimited) and so it's very difficult to handle some of the multiline items or determining if it is a credit or debit.

Manually entering them all is not only annoying but prone to error - then I'd have to go back and figure out IF and WHERE that error even exists.

Hoping some of you guys might be a little creative in solving the problem!

Spudd · Jun 3, 2014

For the previous year, you can get a .csv file under the "tax documents" tab. For the current year, I have no suggestions.

Kaitlyn · Jun 3, 2014

Oooh! It looks like "Investment Income - Summary" (dividends) and "Investment Income - Trading Summary" (buy/sells) should cover 99% of the work if I'm not mistaken. MIGHT have to account for a split separately - any other transactions or events I might be missing?

This should at least help me get them more easily since everything is a lot more organized in these documents. However, they are in PDF only it seems - where do you see a CSV option?

Edit: Not the END of the world I guess, but it also looks like all it has for my RRSP is the contribution receipt... no trading summary, since it doesn't matter for tax reasons! Same for my TFSA.... hmmm, so it actually is somewhat limited :S

PoolAndRapid said:
This should be easy to do programmatically. What are your source and target file formats?

Sources are PDF - output is whatever, probably convert it to a CSV format for bringing it into Excel or database

PoolAndRapid · Jun 3, 2014

MoreMiles · Jun 3, 2014

You should switch to BMO IL. For those using it, you know you can export all sorts of transactions into csv text and into a spreadsheet. You have like 2 years of info, more than enough time for tax prep. You want to list all the cash deposit and transfer, no problem, its power filter allows you to export the type of info on what you really need.

Also, any 5 star customer gets a free capital gain / loss report free of charge... No need for you to calculate.

Eclectic12 · Jun 3, 2014

MoreMiles said:
You should switch to BMO IL.
For those using it, you know you can export all sorts of transactions into csv text and into a spreadsheet. You have like 2 years of info, more than enough time for tax prep.

I'll let the OP decide if it's worth switching ... however I will note that since the OP wants to reconcile their registered accounts as well, I don't believe this is about tax prep so much as tracking the investments/gains.

MoreMiles said:
... Also, any 5 star customer gets a free capital gain / loss report free of charge... No need for you to calculate.

Knowing and seeing errors from the broker ... I personally prefer to calculate this on my own and compare where I can. Two sets of calculations that are in agreement have a much higher confidence of accuracy.

Does BMO IL provide the capital gain/loss for registered accounts as well?

Cheers

PoolAndRapid · Jun 3, 2014

Spudd · Jun 3, 2014

For me the csv is just one of the files in the list:
Investment Income - Trading Summary (csv)

But yeah, nothing for TFSA or RRSP, only for the cash account.

Personally I just keep track of each transaction as I go along throughout the year.

Cal · Jun 6, 2014

I normally print each accounts transactions every February-ish for the entire preceeding year. Maybe you can watch for that option, as it may be only available around tax time, not sure....maybe another TD rep could be more helpful.

Kaitlyn · Jun 7, 2014

Weird - I don't ever recall seeing any option like that

AltaRed · Jun 7, 2014

Generally called the Annual Trading Summary for trades. Most, if not all, brokerages have it. Example: http://www.tdwaterhouse.ca/services/annualtrading.jsp

Also the Income and Expenses Statement for things like dividends and distributions.

Kaitlyn · Jun 7, 2014

Ah, yes - that... nothing exists for TFSA or RSP accounts, though

AltaRed · Jun 7, 2014

Maybe not directly in PDF form, but every brokerage I am familiar with does provide transaction history in html format which can then be printed out in PDF form using 'Print to PDF' utility software.

Downloading entire TD Direct Investing transactions?

Top Contributors this Month

Recommended Communities