Hi there
I have a spreadsheet with a stock ticker in A2. Let’s say for example "GRMN" which is Garmin's stock ticker.
I want some code which will go to the webpage www.optionslam.com/earnings/stocks/”STOCKTICKER”. So in my example this would be: https://www.optionslam.com/earnings/stocks/GRMN
And then I would like to extract from this page the EVR ("2.7") to B2, the expiry date of implied weekly move ("Feb 23, 2018") to C2 and the last two Earnings Events (“Nov 1, 2017” and "Aug 2, 2017") to D2 respectively E2.
I have played around with Data Web Query, however I can’t get anything to work.
Thanks,
Roman
I have a spreadsheet with a stock ticker in A2. Let’s say for example "GRMN" which is Garmin's stock ticker.
I want some code which will go to the webpage www.optionslam.com/earnings/stocks/”STOCKTICKER”. So in my example this would be: https://www.optionslam.com/earnings/stocks/GRMN
And then I would like to extract from this page the EVR ("2.7") to B2, the expiry date of implied weekly move ("Feb 23, 2018") to C2 and the last two Earnings Events (“Nov 1, 2017” and "Aug 2, 2017") to D2 respectively E2.
I have played around with Data Web Query, however I can’t get anything to work.
Thanks,
Roman