Excel Dynamic Web Query (Simple Problem!)

Asked Jan 08 '19 at 19:23

Active Jan 08 '19 at 22:43

Viewed 139 times

I'm trying to import a simple HTML table from a website into EXCEL on an iMac

I wrote a text file saved as .iqy

WEB
1
https://english.mubasher.info/countries/kw/stock-prices

Selection=1
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

What I get is this:

Stock   Price   Change %    Change  Turnover    Volume  Open    High    Low

{{row.name | limitTo : 20}} {{row.value}}   {{row.changePercentage}}    {{row.change}}  {{row.turnover}}    {{row.volume}}  {{row.open}}    {{row.high}}    {{row.low}}

How do I get it to fetch the actual data? (entire table)

edited Jan 08 '19 at 22:43

pushkin

9,575
15
51
95

asked Jan 08 '19 at 19:23

nowifi6952

Why you just copy paste it? – Chris P Jan 08 '19 at 22:45
Supposedly this is a dynamic web query meaning it changes the values automatically as the website updates. – nowifi6952 Jan 09 '19 at 15:59
Ok, now understand. I don't have knowledge about. But i will search. – Chris P Jan 11 '19 at 11:32
Hello, have you found any solution? – Chris P Apr 11 '19 at 16:29

Excel Dynamic Web Query (Simple Problem!)

0 Answers0