Query HL..Download transaction history CSV

C_Mababejive

Hi

I notice HL allow you to download a spreadsheet in csv format but only in three month blocks.

Is there any way of obtaining a CSV sheet for entire history and if not, if i download in three month blocks,can openoffice be made to assemble the individual blocks into one sheet which can be arranged by date ?

Could this be done in MS money?

Thanks

psychic_teabag

A CSV file is just a text file, using Commas to Separate the Values.

It's one line per entry, so you ought to be able to just concatenate all the csv files before importing into your spreadsheet.

You might need to edit out header lines first, using a text editor. Or you can probably delete those from the spreadsheet once it's imported.

jimjames

If you can get all the files downloaded, put them in a single folder and run this code it will copy them all to a single file called aggregate.txt

You need to use command prompt and change to the folder that contains the files. The original files remain intact.

copy /a *.csv aggregate.txt

MS Money won't load these in but you could use them in a spreadsheet to review performance. If you are using MS Money you could also use the facility to auto download prices using the features of that.

Porcupine

I looked at writing a bit of code to automate the process of downloading the CSVs. It didn't look too hard, but the difficult bit was doing the security dance (17th letter of your password etc) before you got to ask for the data. So I never got around to it.

There might be some kind of browser plugin you can use to automate it. The download link looks like this:

https://online.hl.co.uk/my-accounts/investment_history_csv/account/22/view/CB/page/1/func/download/startDate/2012-10-30/endDate/2013-01-30

So if you change the dates and put those URLs into a browser download manager that goes and fetches a list of URLs you can download them all. But you can't use an external download manager because you need to have logged into the website with your browser first.

In the worst case, make an HTML file on your hard drive like this:

<a href="https://online.hl.co.uk/my-accounts/investment_history_csv/account/22/view/CB/page/1/func/download/startDate/2012-10-30/endDate/2013-01-30">1</a&gt;
<a href="https://online.hl.co.uk/my-accounts/investment_history_csv/account/22/view/CB/page/1/func/download/startDate/2012-07-30/endDate/2012-10-30">2</a&gt;

open it in your browser and and click on all the links.