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
jimbo45

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.

Thanks

cheers

jimbo


Attached Thumbnails
-weeklys.jpg  
My System SpecsSystem Spec
Reply

Thread Tools



Similar help and support threads
Thread Forum
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
Factory Overclocked or Stock
This is the question which bothers me the most, is it more reliable to get a factory overclocked or stock graphic card? Will it lower the lifespan of the card getting a factory overclocked? The card which I ordered is GTX 650 Ti from ASUS: ASUS - - ASUS GTX650TI-O-1GD5 The other 2 are the same...
Graphic Cards
OC althon ii 640 x4 stock 3.0ghz
Yeah I been thinking and want to oc to atleast 3.4. I was reading on the net that my processor can oc to 3.8 but anything after that it's unstable. Been reading on about oc and what it effects and ways to test if it is stable(more info on this is appreciated if you want to share with me :) )...
PC Custom Builds and Overclocking
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 13:13.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App