I wanted to have all the data of this stock screener extracted into an excel sheet:
[login to view URL]
I need it in the following collums:
Ticker --(the ticker seperate) --Ticker is the hyperlinked stuff after the brackets in the company collum,
Select showdate All.
I only need Calls that are Buy & Sell. Both please in two sepearate Tabs on the spreadsheet.
(Buy Calls should be 4758entries & Sell 935 Entries)
the main challange with this is that the data is spread over several years. however, the years are not listed. in the dropdown menu (date) they are ordered in order by date. if the data simply gets extracted there will be multiple entries of a stock on the same date that is actually in two different years (without being able to tell a difference)
If you scroll down the date drop down menu to try to access 2017 data you will see that yes, thechnically they are in order. but if extraced into a database its imposible to tell if a call was 2016,2017 or 2018 on that date...
Please write me if you are able of doing this job
Thank you for your time and a wonderful evening