Hello
I need a tool that will scrape for me in excel (final destination) list of atm (at the money) options (call and put) from BarChart
[login to view URL]
So expiration date should be closes to 5 days ..but not less
If Instrument / ticker...has no 5 days option than choose first next expiration ..7 or 14 or 21 ..which ever is offered for particular ticker
ATM ( meaning at the money options ) ..if price is 127.39 USD atm options are 127 CALL and 127 PUT ( out of the money would be 128 CALL and 128 PUT)..I need ATM!
So in case from the link I need next information ..sorted in excel in columns like this
CHECK THIS EXAMPLE:
Ticker DTE ( days till expiration ) CALL (ask price) PUT ask price Strike price Stock price
AAPL 7 1.98 1.54 127 127.45
F 7 0.45 0.11 11.50 11.84
And so on....( Scraper should read ticker symbols from my list of tickers. Which I am going to change occasionally. There will be 1000-2000 tickers. Maybe even more...)
Links of this two examples :
[login to view URL]
[login to view URL]
So always first check that closes expiration
Budget is 35 USD
End product is EXCEL with all those information sorted in columns as presented in this description!
P.S.
List of tickers1 excel is there for you to test the tool
Choose for example Sheet named Sp100a..there are around 100 ticker If I am right
Scrape those for a test
Hi there
I'm expert in web scraping, web automation and data mining projects. I have done many similar tasks.
I'm ready to do it now. Please contact me and lets discuss more details. I'm waiting to hear from you.
Many thanks!!!