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

Linux CENTOS 7 / various Windows OS'es and servers
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
Stock / Option Traders - anyone-weeklys.jpg  
My System SpecsSystem Spec

Thread Tools

Similar help and support threads
Thread Forum
How to Replace Stock CPU Fan
Hi, I am building a PC and I would like to upgrade my CPU fan from the stock one. I want to keep the stock heatsink to save some money if possible. My idea is that I can remove the fan from the stock cpu heatsink, and then replace it with a CoolerMaster Sickleflow or Rosewill fan. The processor...
PC Custom Builds and Overclocking
Stock SLI GTX 680 Idle 50C
I have looked into overclocking and how realised that my graphics card runs way too hot. Idle temps at stock are around 45-50C and under 99% load it reaches up to 80-90C. The 2 card's are the reference NVIDIA card and the Galaxy 2gb GC. I have 8 fans in my case; Intake: (1x bottom, 4x side, 1x...
Graphic Cards
cpu usage stock at 100%
can any one help me??? my cpu usage is stock at 100% for several days now, and it's really starting to slow my pc. I'm kinda a noob in this kind of things ... what should i do???
Performance & Maintenance
Any "Day" or other Traders Here - Read This
Hi all I'm unterested in the PSYCHOLOGY of trading as well as dabbling a little bit myself. I don't always work on computers. Understanding and watching people trading a highly volatile market is a rewarding exercise BTW - but don't get in their way whilst they are actively trading. I...
Chillout Room
Day Traders anyone --- Do you use MACD or other trading system
Hi guys -- often when I'm sitting at a computer I meddle around with dabbling on the movement of the British FTSE index, the Dow Jones (30) DJIA index and the Nasdaq index (QQQQ) Yahoo epic codes ^FTSE , ^DJIA, and ^QQQQ I find using the MACD where the lines cross are good Buy / sell...
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 21:50.
Twitter Facebook Google+