Forum Discussion
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..
- 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 ? 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.
