How to import a .asp url table into Matlab

2 views (last 30 days)
Edson
Edson on 19 Aug 2016
Answered: Edson on 19 Aug 2016
Hi. I need to get into Matlab a table that appears in: http://www.sbs.gob.pe/app/stats/TC-Contable.asp. The web page lets you choose which date you want the data; but I must do it by clicking in the calendar icon. Is there a way to import the table (foreign exchange rates) and specify the date? So far I only found ways to import the raw data but no success in specifying the date. Thanks in advance!

Answers (1)

Edson
Edson on 19 Aug 2016
[UPDATE / CLARIFICATION], if you click on http://www.sbs.gob.pe/app/stats/tipodecambiocontablexls.asp?fec=18/08/2016, it will generate an excel file with the data as of 18/08/2016. I tried to use the matlab function webread without success:
url = 'http://www.sbs.gob.pe/app/stats/tipodecambiocontablexls.asp?fec=06/05/2016'; options = weboptions('ContentType','text','ArrayFormat','csv'); x=webread(url,options);

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!