I'm interested in trading the new(ish) weekly options -- there are about 60 or so stocks where you can now trade WEEKLY options (called "Weeklys" - no typo that's what they are called).
The list of "optionable" stocks that can be traded as "weeklys"are available from the CBOE
(CBOE - Micro Site
I've pulled this into a spreadsheet but what I need to do now is to be able to get an "updateable" spreadsheet with the prices in it.
For example the WEEKLY option for QQQ (Nasdaq index which can be traded as a "share" or a "stock" ) is around 56 USD per "share".
The "weekly" option chain for the W4 April expiry looks roughly as follows - before market open on 18 Apr
What I want is to be able to get the base share price and the option chain table into a spread sheet without having to create a query each time.
I'm only interested in the "Calls and Puts" say within 2 dollars either side of "At the Money" -- that means if the share price is currently trading at 56 USD then "At the Money" means the "Strike price" (the price you "sell or Buy" your option") is 56 USD so I'd be interested in a "Strike price" 2 USD either side -- in this cse between 54 and 58 USD.)
I'm sure some of you VBA gurus out there could import the table into EXCEL and strip off the entries I'm not interested in -- you don't have to understand "Trading" for this.
Any ideas anyone.