json - Google Sheets’ ImportHTML( ) function fails to pull data from a large table

Question

I want to retrieve a table from the URL of https://iboard.ssi.com.vn/bang-gia-ssi/hose (It is actually a stock price board and prices fluctuate all the time during transaction hours. The url allow viewing in English)

I applied the syntax written in the guidelines, namely IMPORTHTML(url, query, index) but failed to import the above mentioned table.

I wonder whether or not Googlesheets’ importhtml() or Importxml() function is able to import such a large table. Could anyone help me with the coding?

Last time, Mr. Tanaike helped me to retrieve a table (IMPORTHTML() doesn't work in this webpage structure)

but this time, the task seems much harder and more complicated, I am not sure if importhtml() function can handle or not

The table that I want to import looks like:

Symbol  Ceil    Floor   Ref Bid                     Matched             Asked                       High
                P3  Vol3    P2  Vol2    P1  Vol1    Price   Vol #ERROR! #ERROR! P1  Vol1    P2  Vol2    P3  Vol3    
AAA 15.7    13.7    14.7    14.35   38,300  14.4    106,600 14.45   30,800  14.45   76,500  -0.25   -1.70%  14.5    10,000  14.55   17,200  14.6    28,700  14.8
AAM 12.3    10.7    11.5    11  1,500   11.1    1,000   11.2    1,000                   11.5    200 11.7    1,000   11.75   3,600   

I look forward to your kind support and would like to thank you for your expertise and valuable instructions Cao Doremi

question from:https://stackoverflow.com/questions/65845161/google-sheets-importhtml-function-fails-to-pull-data-from-a-large-table

Answer 1

Waitting for answers