MATLAB Answers

How to get data from web?

205 views (last 30 days)
Adriano
Adriano on 10 May 2017
Commented: Adriano on 11 May 2017
Hello! I need to donwload the table and the datas in this url:
I tried with "webread", "urlfilter" and "getTableDataScript" but I didn't fix the problem. Anyone can help me?

  2 Comments

Jan
Jan on 10 May 2017
Please post your code and explain, which problems you have. It is easier to suggest a solution than to guess a problem.
Adriano
Adriano on 10 May 2017
I don't have a code. With webread I get an html that is very confused. What I need is a table in which in first column I have the names of the categories and in the second column the YTD Return%. For example:
RV China - A Shares 0.65
RV India 18.94
RV Dinamarca 14.09
and so on. How Can I do it? Thanks!

Sign in to comment.

Accepted Answer

Ned Gulley
Ned Gulley on 11 May 2017
URLREAD expects US-style usage of commas and stops in numbers. So in a number like 150,228.17 it will ignore the comma and return 150228.17. We should re-write URLFILTER so that it can read numbers that use commas as the decimal point, but in the meantime there is a workaround.
For financial numbers, if you are certain there will be exactly 2 digits reported after the decimal point (which appears to be the case on www.morningstar.es/), then just take the output of URLFILTER and divide by 100.
url = 'http://www.morningstar.es/es/tools/categoryoverview.aspx?filterId=-1&lang=es-ES';
name = 'RV India';
raw_price = urlfilter(url,name)
actual_price = raw_price/100
raw_price =
1974
actual_price =
19.7400

  1 Comment

Adriano
Adriano on 11 May 2017
Many thanks Ned!!!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!