Stock / Option Traders - anyone - Windows 7 Help Forums
Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Stock / Option Traders - anyone

18 Apr 2011   #1

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
Stock / Option Traders - anyone

Hi all
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

(enc screenshot)

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.




Attached Thumbnails
My System SpecsSystem Spec

Thread Tools

Similar help and support threads for2: Stock / Option Traders - anyone
Thread Forum
iPad stock photos Chillout Room
OC althon ii 640 x4 stock 3.0ghz PC Custom Builds and Overclocking
cpu usage stock at 100% Performance & Maintenance
Any "Day" or other Traders Here - Read This Chillout Room
Day Traders anyone --- Do you use MACD or other trading system Chillout Room

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 19:19.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App