Excel Power Query (Web Query) for website without tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2877828%22%20slang%3D%22de-DE%22%3EExcel%20Power%20Query%20(Web%20Query)%20for%20website%20without%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877828%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20struggling%20with%20the%20excel%20web%20query.%20I%20have%20been%20using%20them%20successfully%2C%20but%20not%20yet%20for%20tables%20where%20the%20data%20is%20generated%20by%20Java%20Script%20(and%20is%20not%20in%20a%20%3CTABLE%3E...%3CTABLE%3E.%3C%2FTABLE%3E%20Hence%20my%20web%20query%20does%20not%20recognize%20it%20%3B(%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20extract%20the%20table%20under%20%22ZM%20Earnings%20Price%20Changes%22%20on%20this%20website%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.tipranks.com%2Fstocks%2Fzm%2Fearnings-calendar%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tipranks.com%2Fstocks%2Fzm%2Fearnings-calendar%3C%2FA%3E%20where%20XX%20is%20the%20symbol%20(in%20my%20example%20link%20zm%20)%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20ideal%20functionality%20would%20look%20like%20this%3A%3C%2FP%3E%3CP%3EInput%3A%20zm%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3Enavigate%20to%20this%20link%3A%20https%3A%2F%2Fwww.tipranks.com%2Fstocks%2F%22Input%20goes%20here%22%2Fearnings-calendar%20where%20zm%20was%20filled%20in%2C%20the%20output%20should%20look%20like%20this%3A%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%3EAug%2030%2C%202021%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24340.81.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24289.50.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E-15.06%25%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%3EJun%2001%2C%202021.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24331.53.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24327.1.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E-1.33%25%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%3EMar%2001%2C%202021.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24373.61.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24372.79.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E-0.22%25%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%3ENov%2030%2C%202020.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24471.61.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24406.31.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E-13.85%25%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3ECould%20anyone%20help%20me%20with%20this%20by%20any%20chance%3F%20I%20am%20using%20windows%20of%20course%20with%20the%20latest%20version%20of%20excel..%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2877828%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FTABLE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

 

0 Replies