Importing from online brokers/banks to personal finance software

Banking and Saving strategies, maximizing interest rates, budgeting, GICs, HISAs.
Post Reply
Hogwild
Silver Ring
Silver Ring
Posts: 150
Joined: 18 Aug 2015 21:46

Importing from online brokers/banks to personal finance software

Post by Hogwild » 13 Mar 2017 23:32

Hi everyone:

After reading yet another informative thread here, I'm considering whether it would be worth it for me to get all my financial data into some sort of personal finance software. I'm leaning towards KMyMoney. Now, I read in one thread that you cannot download all your historical transactions from TD Direct Investing website. They don't have that feature (which I complained about in an email). Do CIBC IE allow you to do that? I tried it with BMO Investorline, but it only allowed me to download about a year or 18-months worth. What about CIBC?

Does anyone else feel like harrassing TD to try to get them to implement that feature?

User avatar
AltaRed
Diamond Ring
Diamond Ring
Posts: 18378
Joined: 05 Mar 2005 20:04
Location: Ogopogo Land

Re: Importing from online brokers/banks to personal finance software

Post by AltaRed » 14 Mar 2017 00:14

Why do you need to download all historical data going back several years? The starting point is not really all that relevant. It is what you do with the data from point A forward in time. Having a year's worth of historical data seems perfectly good to me.

Example: I started with digital data in 1995 via Quicken and kept records through an early 2008 divorce. I then started 'anew' with a new data set and obviously didn't miss any of that earlier data one bit since I never went back to look at any of it.
Imagefiniki, the Canadian financial wiki The go-to place to bolster your financial freedom

Hogwild
Silver Ring
Silver Ring
Posts: 150
Joined: 18 Aug 2015 21:46

Re: Importing from online brokers/banks to personal finance software

Post by Hogwild » 14 Mar 2017 01:11

Well, okay. How do you decide how far back to go? And I take it there is no way to go back even a year to get TDDI transaction records? How about CIBC?

OnlyMyOpinion
Silver Ring
Silver Ring
Posts: 661
Joined: 24 Jan 2014 23:17

Re: Importing from online brokers/banks to personal finance software

Post by OnlyMyOpinion » 14 Mar 2017 09:54

From TDDI, I can download monthly statements as pdf's from the past 6 years (to Feb 2010) - ten at a time :(. These show monthly activity and holdings.
As a collated pdf file you can easily search for a company name to strip out its transactions (for buys, sells, drips, acb calcs...). If you need earlier, then you're stuck with the paper you've saved. I 'grew up' having to go through the paper manualy, so pdf's are a vast improvement.
You are correct that downloading TDDI activity as a csv-type file appears limited to the year-to-date activity. It's not something I've had occasion to have to use routinely.
I agree with AltaRed - unless you are trying to capture historical activity related to your acb, it is not reallly necessary.
For posterity I just keep the old Royal Trust passbook showing the first $2000 we deposited into a RRSP.

Hogwild
Silver Ring
Silver Ring
Posts: 150
Joined: 18 Aug 2015 21:46

Re: Importing from online brokers/banks to personal finance software

Post by Hogwild » 14 Mar 2017 11:09

OnlyMyOpinion:

What do you mean by a "collated PDF file". I've never heard of that.

pmj
Gold Ring
Gold Ring
Posts: 2411
Joined: 27 Feb 2005 18:15
Location: Ottawa

Re: Importing from online brokers/banks to personal finance software

Post by pmj » 14 Mar 2017 11:13

OnlyMyOpinion wrote:From TDDI, I can download monthly statements as pdf's from the past 6 years (to Feb 2010) - ten at a time :(.
Recently(?) upgraded to allow 12 at a time :-).
Peter

Patrick Hutber: Improvement means deterioration

OnlyMyOpinion
Silver Ring
Silver Ring
Posts: 661
Joined: 24 Jan 2014 23:17

Re: Importing from online brokers/banks to personal finance software

Post by OnlyMyOpinion » 14 Mar 2017 17:49

PMJ,
You're right, up to 12 monthly statements can can be checked off and downladed at once. It is the confirmation slips that are limited to 10 for some reason - I'd like to be able to check off and download the full year's worth of confirmation slips, not just 10.
Note that you must check off each monthly statement in the correct order (from Jan>Dec), not just randomly check them all off, otherwise the pdf will not be saved in order from Jan>Dec.

Hogwild,
By collated, I just meant that you can have a full year's monthly statements saved together in one searchable pdf file. I save a pdf file of each account for each year for my records.

Hogwild
Silver Ring
Silver Ring
Posts: 150
Joined: 18 Aug 2015 21:46

Re: Importing from online brokers/banks to personal finance software

Post by Hogwild » 14 Mar 2017 22:42

OnlyMyOpinion:

Yeah, I hear you. I'm just not sure how helpful that is in terms of getting data into KMyMoney or other personal finance software. The column names are different and often in a different order for each broker. It would just be sOOOOOOO much easier if we could download this stuff. From an IT point of view, that would be easy to implement-just a simple database query, and the formatting of the data for that query. I can't unerstand why they don't let us do it.

Anyways, back to the grindstone.

Post Reply