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..
