download data from a web page

Hello,

I want to write a code downloading an Excel file from a web page automatically or by my command. I have two different ideas.

1. Download an excel file and replace it with new file

2. Just download new data within an excel file and add it to yesterday's data set(preferable)

Either ways I could not download the file itself. Would you please help me to solve this case?

Thanks,

Answer 1

[George]

Use webread

Answer 2

[KidJolly]

I need a matlab code to download data from the website. The code should have the option to select the releases, all countries, Gross Domestic product, all the date range and save the excel files

If you select manually the options for the website --- http://www.imf.org/external/ns/cs.aspx?id=28 At the end you will see a table and at the bottom of that you will find an excel file. I need to download that file. These are the steps that the matlab code should execute

[Cedric]

You should open a new thread for this if you really want to do it this way.

Yet, if you look at these pages, you well see some regularity but that Excel files are not stored in a regular fashion, sometimes a data set released in April is stored under month 01, sometimes under month 02. So there may be some HTML parsing to accomplish (or just brute force try/catch 12 months per year).

If all you need is 36 Excel files, just do it by hand, it will take 5-10 minutes and you'll be done.