How to get data from web?

Question

Adriano 2017-5-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339624-how-to-get-data-from-web

评论： Adriano 2017-5-11

采纳的回答： Ned Gulley

Hello! I need to donwload the table and the datas in this url:

http://www.morningstar.es/es/tools/categoryoverview.aspx?filterId=-1&lang=es-ES

I tried with "webread", "urlfilter" and "getTableDataScript" but I didn't fix the problem. Anyone can help me?

2 个评论
显示无隐藏无

Jan 2017-5-10

Please post your code and explain, which problems you have. It is easier to suggest a solution than to guess a problem.

Adriano 2017-5-10

编辑：Adriano 2017-5-10

在 MATLAB Online 中打开

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!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ned Gulley 2017-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339624-how-to-get-data-from-web#answer_266625

在 MATLAB Online 中打开

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