Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 23

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

  1. #1
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I used the DATA>NEW QUERY>FROM OTHER SOURCES>FROM WEB

    URL: https://www.bursamalaysia.com/market...=1&per_page=50

    to load the data in the sheet. But the data shown in excel in different when I compare it with what is displayed online at the URL.

    Please help.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,337
    Articles
    0
    Excel Version
    Office 365 Subscription
    Different in what way? Have you refreshed our query?
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016
    The data such as Last Done price and Vol('00), end-of-day stock-prices, displayed in excel worksheet web query table from the url below is different from what you will see online at the URL below.
    https://www.bursamalaysia.com/market...=1&per_page=50.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,337
    Articles
    0
    Excel Version
    Office 365 Subscription
    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
    No Name Code REM Last Done LACP CHG %CHG Vol ('00) BUY Vol ('00) BUY SELL SELL Vol ('00) HIGH LOW stock_id
    2
    1
    3A [S] 0012 s
    0.74
    0.745
    -0.005 -0.67 2,258 308 0.740 0.750 951
    0.75
    0.74
    0012
    3
    2
    AASIA [S] 7054 s
    0.155
    0.165
    -0.010 -6.06 31,274 85 0.155 0.160 4,302
    0.17
    0.155
    7054
    4
    3
    AAX [S] 5238 s
    0.15
    0.155
    -0.005 -3.23 20,495 114,187 0.150 0.155 64,063
    0.155
    0.15
    5238
    5
    4
    AAX-WA [S] 5238WA s
    0.005
    0.005
    - - 3,058 15,689 0.005 0.010 204,277
    0.01
    0.005
    5238WA
    6
    5
    ABLEGRP [S] 7086 s
    0.075
    0.075
    - - - 1,250 0.075 0.080 5,703
    0.075
    0.075
    7086
    7
    6
    ABMB 2488 [x] s
    2.62
    2.6
    +0.020 +0.77 19,958 1,000 2.610 2.620 5
    2.62
    2.58
    2488
    8
    7
    ACME [S] 7131 s
    0.32
    0.315
    +0.005 +1.59 666 217 0.310 0.320 89
    0.32
    0.31
    7131
    9
    8
    ACME-WA [S] 7131WA s
    0.07
    0.07
    - - - 900 0.070 0.120 200
    0.07
    0.07
    7131WA
    10
    9
    ACOSTEC [S] 7120 s
    0.36
    0.345
    +0.015 +4.35 289 1 0.350 0.360 260
    0.36
    0.335
    7120
    Sheet: Sheet2
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016
    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.

  6. #6
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016
    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.

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,337
    Articles
    0
    Excel Version
    Office 365 Subscription
    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).
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016
    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.
    Attached Files Attached Files

  9. #9
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    13
    Articles
    0
    Excel Version
    2016
    I attach my 10 entries/page and 20 entries/page results for your view.
    Attached Files Attached Files

  10. #10
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,337
    Articles
    0
    Excel Version
    Office 365 Subscription
    Quote Originally Posted by guanstan View Post
    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.
    Ali
    Enthusiastic self-taught user of MS Excel!

Page 1 of 3 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •