The Web Query Table data in excel not the same as displayed online at the website.

Not as far as I can tell:

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
1
NoNameCodeREMLast DoneLACPCHG%CHGVol ('00)BUY Vol ('00)BUYSELLSELL Vol ('00)HIGHLOWstock_id
2
1​
3A
[td=bgcolor:#E2EFDA]0012[/td][td=bgcolor:#E2EFDA]s[/td][td=bgcolor:#E2EFDA]
0.74​
[/td][td=bgcolor:#E2EFDA]
0.745​
[/td][td=bgcolor:#E2EFDA]-0.005[/td][td=bgcolor:#E2EFDA]-0.67[/td][td=bgcolor:#E2EFDA]2,258[/td][td=bgcolor:#E2EFDA]308[/td][td=bgcolor:#E2EFDA]0.740[/td][td=bgcolor:#E2EFDA]0.750[/td][td=bgcolor:#E2EFDA]951[/td][td=bgcolor:#E2EFDA]
0.75​
[/td][td=bgcolor:#E2EFDA]
0.74​
[/td][td=bgcolor:#E2EFDA]0012[/td]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
3
[/td][td]
2​
[/td][td]AASIA [/td][td]7054[/td][td]s[/td][td]
0.155​
[/td][td]
0.165​
[/td][td]-0.010[/td][td]-6.06[/td][td]31,274[/td][td]85[/td][td]0.155[/td][td]0.160[/td][td]4,302[/td][td]
0.17​
[/td][td]
0.155​
[/td][td]7054[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
4
[/td][td=bgcolor:#E2EFDA]
3​
[/td][td=bgcolor:#E2EFDA]AAX [/td][td=bgcolor:#E2EFDA]5238[/td][td=bgcolor:#E2EFDA]s[/td][td=bgcolor:#E2EFDA]
0.15​
[/td][td=bgcolor:#E2EFDA]
0.155​
[/td][td=bgcolor:#E2EFDA]-0.005[/td][td=bgcolor:#E2EFDA]-3.23[/td][td=bgcolor:#E2EFDA]20,495[/td][td=bgcolor:#E2EFDA]114,187[/td][td=bgcolor:#E2EFDA]0.150[/td][td=bgcolor:#E2EFDA]0.155[/td][td=bgcolor:#E2EFDA]64,063[/td][td=bgcolor:#E2EFDA]
0.155​
[/td][td=bgcolor:#E2EFDA]
0.15​
[/td][td=bgcolor:#E2EFDA]5238[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
5
[/td][td]
4​
[/td][td]AAX-WA [/td][td]5238WA[/td][td]s[/td][td]
0.005​
[/td][td]
0.005​
[/td][td]-[/td][td]-[/td][td]3,058[/td][td]15,689[/td][td]0.005[/td][td]0.010[/td][td]204,277[/td][td]
0.01​
[/td][td]
0.005​
[/td][td]5238WA[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
6
[/td][td=bgcolor:#E2EFDA]
5​
[/td][td=bgcolor:#E2EFDA]ABLEGRP [/td][td=bgcolor:#E2EFDA]7086[/td][td=bgcolor:#E2EFDA]s[/td][td=bgcolor:#E2EFDA]
0.075​
[/td][td=bgcolor:#E2EFDA]
0.075​
[/td][td=bgcolor:#E2EFDA]-[/td][td=bgcolor:#E2EFDA]-[/td][td=bgcolor:#E2EFDA]-[/td][td=bgcolor:#E2EFDA]1,250[/td][td=bgcolor:#E2EFDA]0.075[/td][td=bgcolor:#E2EFDA]0.080[/td][td=bgcolor:#E2EFDA]5,703[/td][td=bgcolor:#E2EFDA]
0.075​
[/td][td=bgcolor:#E2EFDA]
0.075​
[/td][td=bgcolor:#E2EFDA]7086[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
7
[/td][td]
6​
[/td][td]ABMB[/td][td]2488[/td][td][x] s[/td][td]
2.62​
[/td][td]
2.6​
[/td][td]+0.020[/td][td]+0.77[/td][td]19,958[/td][td]1,000[/td][td]2.610[/td][td]2.620[/td][td]5[/td][td]
2.62​
[/td][td]
2.58​
[/td][td]2488[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
8
[/td][td=bgcolor:#E2EFDA]
7​
[/td][td=bgcolor:#E2EFDA]ACME [/td][td=bgcolor:#E2EFDA]7131[/td][td=bgcolor:#E2EFDA]s[/td][td=bgcolor:#E2EFDA]
0.32​
[/td][td=bgcolor:#E2EFDA]
0.315​
[/td][td=bgcolor:#E2EFDA]+0.005[/td][td=bgcolor:#E2EFDA]+1.59[/td][td=bgcolor:#E2EFDA]666[/td][td=bgcolor:#E2EFDA]217[/td][td=bgcolor:#E2EFDA]0.310[/td][td=bgcolor:#E2EFDA]0.320[/td][td=bgcolor:#E2EFDA]89[/td][td=bgcolor:#E2EFDA]
0.32​
[/td][td=bgcolor:#E2EFDA]
0.31​
[/td][td=bgcolor:#E2EFDA]7131[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
9
[/td][td]
8​
[/td][td]ACME-WA [/td][td]7131WA[/td][td]s[/td][td]
0.07​
[/td][td]
0.07​
[/td][td]-[/td][td]-[/td][td]-[/td][td]900[/td][td]0.070[/td][td]0.120[/td][td]200[/td][td]
0.07​
[/td][td]
0.07​
[/td][td]7131WA[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
10
[/td][td=bgcolor:#E2EFDA]
9​
[/td][td=bgcolor:#E2EFDA]ACOSTEC [/td][td=bgcolor:#E2EFDA]7120[/td][td=bgcolor:#E2EFDA]s[/td][td=bgcolor:#E2EFDA]
0.36​
[/td][td=bgcolor:#E2EFDA]
0.345​
[/td][td=bgcolor:#E2EFDA]+0.015[/td][td=bgcolor:#E2EFDA]+4.35[/td][td=bgcolor:#E2EFDA]289[/td][td=bgcolor:#E2EFDA]1[/td][td=bgcolor:#E2EFDA]0.350[/td][td=bgcolor:#E2EFDA]0.360[/td][td=bgcolor:#E2EFDA]260[/td][td=bgcolor:#E2EFDA]
0.36​
[/td][td=bgcolor:#E2EFDA]
0.335​
[/td][td=bgcolor:#E2EFDA]7120[/td][/tr]
Sheet: Sheet2
 
I see you got - the data in your worksheet is right - same as what we would see online at Bursa Malaysia. How did you put the data-table in your reply. I like to put my data-table for you to see - maybe I did not do it right.
 
I did the excel web-query again but using 10 entries/page and got the same result as yours in your reply. Can you do it with 50 entries/page and see. My result for 50 entries/page is different.
 
No - you need to attach your file so that we can troubleshoot it. Use the Go Advanced button bottom right.

My screenshot is just the top 10 rows - I have all 50 in the workbook (see attached).
 

Attachments

  • PQ Web Scrape AliGW.xlsx
    23.5 KB · Views: 9
I re-do the excel web query in 10 entries/page, 20 entries/page and 50 entries/page. I get the same result as you in 10 entries/page and 20 entries/page. BUT the result I get with 50 entries/page is different.
 

Attachments

  • 50E.xlsx
    21.6 KB · Views: 7
I attach my 10 entries/page and 20 entries/page results for your view.
 

Attachments

  • 20E.xlsx
    18.6 KB · Views: 6
  • 10E.xlsx
    17.5 KB · Views: 3
I re-do the excel web query in 10 entries/page, 20 entries/page and 50 entries/page. I get the same result as you in 10 entries/page and 20 entries/page. BUT the result I get with 50 entries/page is different.

SPECIFICALLY, what differences do you see? Highlight the cells where you think there are anomalies. I am not going to go through the table and check every entry, sorry.
 
Just pick any one row in my 50 entries/page and compare to your attached file (same row) and you see they are not the same. This only happens in my 50 entries/page attached file. The 10 entries/page and 20 entries/page has no problem. I thinks the problem could be the EXCEL2016 software in my laptop. Somehow if I do the web query for 50 entries/page the data is not right.
Anyway many thanks for your help. Appreciate it very much.
 
I cannot see any difference. You are the one asking for help: all I have asked is that you provide a version with a few specific anomalies highlighted so that I can cross-check them quickly and easily. If you do this, I'll take a look. As I said before, I am not going to go hunting for them - sorry.
 
Your attached file (PQ Web Scrape AliGW.xlsx) No:1 Code: 0012 Name: 3A Last Done: 0.74 Vol ('00): 2258
My attached file (50E.xlsx) No:1 Code: 0012 Name: 3A Last Done: 0.745 Vol ('00): 314
see the data of the columns Last Done: and the Vol ('00): is different.
Look at specifically the Last Done: and Vol ('00): columns for other table-rows you see the difference.
 
Last edited:
That's because you haven't refreshed the query. I have opened both our workbooks and refreshed the queries. Mine now shows:

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
1
NoNameCodeREMLast DoneLACPCHG%CHGVol ('00)BUY Vol ('00)BUYSELLSELL Vol ('00)HIGHLOWstock_id
2
1​
3A

[TD="bgcolor: #E2EFDA"]0012[/TD]
[TD="bgcolor: #E2EFDA"]s[/TD]
[TD="bgcolor: #E2EFDA"]
0.74​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.745​
[/TD]
[TD="bgcolor: #E2EFDA"]-0.005[/TD]
[TD="bgcolor: #E2EFDA"]-0.67[/TD]
[TD="bgcolor: #E2EFDA"]2,258[/TD]
[TD="bgcolor: #E2EFDA"]308[/TD]
[TD="bgcolor: #E2EFDA"]0.740[/TD]
[TD="bgcolor: #E2EFDA"]0.750[/TD]
[TD="bgcolor: #E2EFDA"]951[/TD]
[TD="bgcolor: #E2EFDA"]
0.75​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.74​
[/TD]
[TD="bgcolor: #E2EFDA"]0012[/TD]

[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
3
[/TD]
[TD]
2​
[/TD]
[TD]AASIA [/TD]
[TD]7054[/TD]
[TD]s[/TD]
[TD]
0.155​
[/TD]
[TD]
0.165​
[/TD]
[TD]-0.010[/TD]
[TD]-6.06[/TD]
[TD]31,274[/TD]
[TD]85[/TD]
[TD]0.155[/TD]
[TD]0.160[/TD]
[TD]4,302[/TD]
[TD]
0.17​
[/TD]
[TD]
0.155​
[/TD]
[TD]7054[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
4
[/TD]
[TD="bgcolor: #E2EFDA"]
3​
[/TD]
[TD="bgcolor: #E2EFDA"]AAX [/TD]
[TD="bgcolor: #E2EFDA"]5238[/TD]
[TD="bgcolor: #E2EFDA"]s[/TD]
[TD="bgcolor: #E2EFDA"]
0.15​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.155​
[/TD]
[TD="bgcolor: #E2EFDA"]-0.005[/TD]
[TD="bgcolor: #E2EFDA"]-3.23[/TD]
[TD="bgcolor: #E2EFDA"]20,495[/TD]
[TD="bgcolor: #E2EFDA"]114,187[/TD]
[TD="bgcolor: #E2EFDA"]0.150[/TD]
[TD="bgcolor: #E2EFDA"]0.155[/TD]
[TD="bgcolor: #E2EFDA"]64,063[/TD]
[TD="bgcolor: #E2EFDA"]
0.155​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.15​
[/TD]
[TD="bgcolor: #E2EFDA"]5238[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
5
[/TD]
[TD]
4​
[/TD]
[TD]AAX-WA [/TD]
[TD]5238WA[/TD]
[TD]s[/TD]
[TD]
0.005​
[/TD]
[TD]
0.005​
[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]3,058[/TD]
[TD]15,689[/TD]
[TD]0.005[/TD]
[TD]0.010[/TD]
[TD]204,277[/TD]
[TD]
0.01​
[/TD]
[TD]
0.005​
[/TD]
[TD]5238WA[/TD]
[/TR]

Sheet: Sheet2

and yours shows:

Excel 2016 (Windows) 32 bit
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
3
NoNameCodeREMLast DoneLACPCHG%CHGVol ('00)BUY Vol ('00)BUYSELLSELL Vol ('00)HIGHLOWstock_id
4
1​
3A

[TD="bgcolor: #E2EFDA"]0012[/TD]
[TD="bgcolor: #E2EFDA"]s[/TD]
[TD="bgcolor: #E2EFDA"]
0.74​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.745​
[/TD]
[TD="bgcolor: #E2EFDA"]-0.005[/TD]
[TD="bgcolor: #E2EFDA"]-0.67[/TD]
[TD="bgcolor: #E2EFDA"]2,258[/TD]
[TD="bgcolor: #E2EFDA"]308[/TD]
[TD="bgcolor: #E2EFDA"]0.740[/TD]
[TD="bgcolor: #E2EFDA"]0.750[/TD]
[TD="bgcolor: #E2EFDA"]951[/TD]
[TD="bgcolor: #E2EFDA"]
0.75​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.74​
[/TD]
[TD="bgcolor: #E2EFDA"]0012[/TD]

[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
5
[/TD]
[TD]
2​
[/TD]
[TD]AASIA [/TD]
[TD]7054[/TD]
[TD]s[/TD]
[TD]
0.155​
[/TD]
[TD]
0.165​
[/TD]
[TD]-0.010[/TD]
[TD]-6.06[/TD]
[TD]31,274[/TD]
[TD]85[/TD]
[TD]0.155[/TD]
[TD]0.160[/TD]
[TD]4,302[/TD]
[TD]
0.17​
[/TD]
[TD]
0.155​
[/TD]
[TD]7054[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
6
[/TD]
[TD="bgcolor: #E2EFDA"]
3​
[/TD]
[TD="bgcolor: #E2EFDA"]AAX [/TD]
[TD="bgcolor: #E2EFDA"]5238[/TD]
[TD="bgcolor: #E2EFDA"]s[/TD]
[TD="bgcolor: #E2EFDA"]
0.15​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.155​
[/TD]
[TD="bgcolor: #E2EFDA"]-0.005[/TD]
[TD="bgcolor: #E2EFDA"]-3.23[/TD]
[TD="bgcolor: #E2EFDA"]20,495[/TD]
[TD="bgcolor: #E2EFDA"]114,187[/TD]
[TD="bgcolor: #E2EFDA"]0.150[/TD]
[TD="bgcolor: #E2EFDA"]0.155[/TD]
[TD="bgcolor: #E2EFDA"]64,063[/TD]
[TD="bgcolor: #E2EFDA"]
0.155​
[/TD]
[TD="bgcolor: #E2EFDA"]
0.15​
[/TD]
[TD="bgcolor: #E2EFDA"]5238[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
7
[/TD]
[TD]
4​
[/TD]
[TD]AAX-WA [/TD]
[TD]5238WA[/TD]
[TD]s[/TD]
[TD]
0.005​
[/TD]
[TD]
0.005​
[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]3,058[/TD]
[TD]15,689[/TD]
[TD]0.005[/TD]
[TD]0.010[/TD]
[TD]204,277[/TD]
[TD]
0.01​
[/TD]
[TD]
0.005​
[/TD]
[TD]5238WA[/TD]
[/TR]

Sheet: Sheet1

You can set your query to refresh when you open the workbook, if you wish. It seems you don't really understand how PowerQuery works.
 
Yes you are right. I just started this week to use PowerQuery thru articles in the internet here and there. Anyway thanks for your help. I know next to nothing about PowerQuery but learning...I am not tech-savvy.
 
Last edited:
OK - so you need to refresh queries! Either do this manually (Data ribbon - Refresh (All)), or right-click your query in the query bar on the right (Data ribbon - Queries & Connections - right-click - Properties - Refresh query when opening file).

I asked you several posts back if you had refreshed the query - it would have been sensible to ask what I meant if you weren't sure - it would have saved a lot of time! I've been learning PQ now for a few years. ;)
 
Before I wrote in for help, I have done REFRESH query and compare the EXCEL table to the online Bursa WEB page. They don't match. Previously I used to copy the online BURSA WEB (998 entries) in one page and paste it into EXCEL. But recently BURSA made changes (limit 50 entries per page) which make my old way of copying and paste not practical. That's why I embark to use PowerQuery.
 
That's impossible if you did the refresh correctly, I'm afraid, so it comes down to novice user error, one way or the other. Either way, you have learned something today, and that's all that matters. :)
 
Tomorrow(6 pm my time) I'll REFRESH my 50E.xlsx and compare to online BURSA WEB to see if they match. Thank you for your help. Funny for my 20E.xlsx and 10E.xlsx web queries the data matches - no refresh no problem.
 
Last edited:
I did the REFRESH for the 50E.xlsx today. The data don't match with online BURSA WEB page. I did a new workbook with all 3 queries (10, 20 & 50 entries/page) in one worksheet (Sheet 1) - REFRESHed ALL at same time. Also did a copy & paste into another worksheet (Sheet 2) the data from online BURSA WEB page. They ALL don't match.

Maybe I did not do them right. I attach the files for your reference.
 

Attachments

  • 50E.xlsx
    21.4 KB · Views: 7
  • ONEforALL.xlsx
    35.2 KB · Views: 3
Back
Top