Forum Discussion

Hawkridge91's avatar
Hawkridge91
Copper Contributor
Oct 23, 2021

Excel Power Query (Web Query) for website without tables

Hello, 

 

I am currently struggling with the excel web query. I have been using them successfully, but not yet for tables where the data is generated by Java Script (and is not in a <table>...<table/>. Hence my web query does not recognize it ;( 

 

I am trying to extract the table under "ZM Earnings Price Changes" on this website: https://www.tipranks.com/stocks/zm/earnings-calendar where XX is the symbol (in my example link zm ) .

 

The ideal functionality would look like this: 

Input: zm

navigate to this link: https://www.tipranks.com/stocks/"Input goes here"/earnings-calendar   where zm was filled in, the output should look like this: 

Aug 30, 2021 $340.81. $289.50. -15.06%
Jun 01, 2021. $331.53. $327.1.  -1.33%
Mar 01, 2021. $373.61. $372.79. -0.22%
Nov 30, 2020. $471.61. $406.31. -13.85%
 
Could anyone help me with this by any chance? I am using windows of course with the latest version of excel.. 
 

 

Excel for web

2 Replies

  • Papibi's avatar
    Papibi
    Copper Contributor
    Nov 01, 2022
    Hi! to both of you

    I have the same problem and cannot find a solution
    see https://stackoverflow.com/questions/74129360/excel-2019-2021-version-2208-2209-2210-import-data-from-web-no-tables-showin

    Did you find a solution/work around ?
  • jan_tothemoon's avatar
    jan_tothemoon
    Copper Contributor
    Apr 28, 2022

    Hawkridge91 Hi Hawkridge91, did you find out how to solve ths problem? I'm struggling with the exact same situation. Also I'd like to build something with stock analysis as you're doing.

Resources