How to get data from web?
24 views (last 30 days)
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?
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