PC-SPAN - Options on Futures | futures io social day trading
futures io futures trading


PC-SPAN
Updated: Views / Replies:55,243 / 483
Created: by ron99 Attachments:118

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 118  
 
Thread Tools Search this Thread
 

PC-SPAN

  #221 (permalink)
Trading for Fun
Brisbane, Queensland, Australia
 
Futures Experience: Intermediate
Platform: OX, Z360, Excel
Broker/Data: DeCarley
Favorite Futures: Futures and Future Options
 
Posts: 121 since Aug 2013
Thanks: 75 given, 96 received


CafeGrande View Post
Just out of curiosity, is all of the data on the chart derived from the SPAN files, i.e. have you collected several months of history and your application calculates HVs based on the futures settlement price found in the SPAN file?

Yes all data is derived from the SPAN files. Generates chart in a few clicks based on your selected date range. It does not calculate HV. HV and IV are the fields named as such in the SPAN spreadsheet.

I have introduced functions for greeks that are calculated based on SPAN data but have not progressed it further...

...do you have a suggestion...


Last edited by BlueRoo; June 4th, 2014 at 03:21 PM.
Reply With Quote
 
  #222 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 196 since Jan 2014
Thanks: 117 given, 191 received

I was mostly wondering if you've had difficulty retrieving so many consecutive days of data. Currently, I don't store any history, but if it's a reliable source and it downloads fairly quickly, I might try storing a few contracts worth of individual option data to build a skew time series, either by delta or moneyness (percent out of the money)

As for suggestions, two minor ones:

- Since it appears the HV field is actually the ATM IV for CME products, you'll probably want to rename the label.

- I don't know how experienced you are with options, but I'd put a "real" HV calculation lower on development list. It's nice to have, but it's readily available in virtually all charting programs and if you're like most, you'll probably spend more time with ATM IV and option-specific IV than the underlying's HV.

Reply With Quote
 
  #223 (permalink)
Trading for Fun
Brisbane, Queensland, Australia
 
Futures Experience: Intermediate
Platform: OX, Z360, Excel
Broker/Data: DeCarley
Favorite Futures: Futures and Future Options
 
Posts: 121 since Aug 2013
Thanks: 75 given, 96 received



CafeGrande View Post
I was mostly wondering if you've had difficulty retrieving so many consecutive days of data. Currently, I don't store any history, but if it's a reliable source and it downloads fairly quickly, I might try storing a few contracts worth of individual option data to build a skew time series, either by delta or moneyness (percent out of the money)

As for suggestions, two minor ones:

- Since it appears the HV field is actually the ATM IV for CME products, you'll probably want to rename the label.

- I don't know how experienced you are with options, but I'd put a "real" HV calculation lower on development list. It's nice to have, but it's readily available in virtually all charting programs and if you're like most, you'll probably spend more time with ATM IV and option-specific IV than the underlying's HV.

The EOD files decompressed for me are about 66mb. Therefore a years worth of data would be 250 x 66 = 16,500mb. So you do need some storage capacity.

Once the files are downloaded...it takes about 3 minutes to build a year to date historical record for a select strike. Once you have this the vol and history charts I have posted are generated in a second.

Yes, following you and Dudetooth in my be better titled base vol...so if the BV is higher than the IV option premium is cheap and if lower expensive...anyway the way I use it currently is as a measure of comparison...tending to look for assets with above average IV...

Reply With Quote
The following user says Thank You to BlueRoo for this post:
 
  #224 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 196 since Jan 2014
Thanks: 117 given, 191 received

DudeTooth -

If you're thinking about updating the SPAN tool some day, and if the data elements already exist in the risk arrays (I think that's the term for the big files from the CME and ICE), could you add a column for Gamma and Theta? I'd suggest making the columns easy to hide because I know they wouldn't be useful to everyone.

Currently, I sum the number of option contracts, the option value and the delta by product. If Gamma and Theta could be summed, the application, in addition to it's scanning abilities, would become an even better portfolio management and reporting tool.


Thanks!

Reply With Quote
 
  #225 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 216 since Sep 2012
Thanks: 26 given, 243 received


CafeGrande View Post
DudeTooth -

If you're thinking about updating the SPAN tool some day, and if the data elements already exist in the risk arrays (I think that's the term for the big files from the CME and ICE), could you add a column for Gamma and Theta? I'd suggest making the columns easy to hide because I know they wouldn't be useful to everyone.

Currently, I sum the number of option contracts, the option value and the delta by product. If Gamma and Theta could be summed, the application, in addition to it's scanning abilities, would become an even better portfolio management and reporting tool.


Thanks!

CafeGrande,

Actually, I've been working with BlueRoo on some new ideas. Unfortunately, the pa2 files do not contain the Gamma or Theta (at least not that I have seen), but the idea of adding some Greeks has been tossed around and is definitely doable. We have even worked out a way to show only the columns of data that you want to see.

One area I have wanted to build up was the portfolio management. I kind of have an idea of what you are asking about, but if you don't mind elaborating, can you give me an example of how you are using the Gamma and Theta for your portfolio management?

Reply With Quote
 
  #226 (permalink)
Trading for Fun
Brisbane, Queensland, Australia
 
Futures Experience: Intermediate
Platform: OX, Z360, Excel
Broker/Data: DeCarley
Favorite Futures: Futures and Future Options
 
Posts: 121 since Aug 2013
Thanks: 75 given, 96 received


CafeGrande View Post
DudeTooth -

If you're thinking about updating the SPAN tool some day, and if the data elements already exist in the risk arrays (I think that's the term for the big files from the CME and ICE), could you add a column for Gamma and Theta? I'd suggest making the columns easy to hide because I know they wouldn't be useful to everyone.

Currently, I sum the number of option contracts, the option value and the delta by product. If Gamma and Theta could be summed, the application, in addition to it's scanning abilities, would become an even better portfolio management and reporting tool.


Thanks!

I have all the greeks in a version of the span file that can be easily added from the option trading workbook that is available free on the net it has all the greek functions and can be easily added with little vba skill

one idea has been finding low delta high theta options...i like your ideas and ask if you could email me so we can work together closer on them? it would help me better understand your thinking process better

Reply With Quote
 
  #227 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 196 since Jan 2014
Thanks: 117 given, 191 received


Dudetooth View Post
CafeGrande,

Actually, I've been working with BlueRoo on some new ideas. Unfortunately, the pa2 files do not contain the Gamma or Theta (at least not that I have seen), but the idea of adding some Greeks has been tossed around and is definitely doable. We have even worked out a way to show only the columns of data that you want to see.

One area I have wanted to build up was the portfolio management. I kind of have an idea of what you are asking about, but if you don't mind elaborating, can you give me an example of how you are using the Gamma and Theta for your portfolio management?

I'm trying to get the basics on one spreadsheet so I can see my cumulative positions across brokerages. Here's a snip of the Risk Navigator tool from Interactive Brokers. https://www.interactivebrokers.com/en/?f=%2Fen%2Fsoftware%2Fpdfhighlights%2FPDF-riskNavigator.php. There are a lot of features and data columns not shown, but what I'm trying to do (in Excel) is get a product-level view (where you see the "+" sign in the snip; I'm not aiming for drill down capability).

The IB tool is very useful but because of their margin policy on FOPs I'm slowly moving some money out of there. If the SPAN tool included the additive Greeks, I could have a simple dashboard in Excel and if I wanted to get fancy, I could do other things like link the SPAN tool to real-time underlying prices and re-calculate the Greeks as often as I wished, break out my risk by time period (probably DTEs in 2 week buckets or something like that).

I don't pay very close attention to Theta but I do watch Gamma closely, especially if the short options are near the money and near expiration. Gamma is probably not a big issue if someone is selling way OTM options (5 Delta or less) because they've likely closed their position once they're close to the money. Sometimes, though, I sell a 10 or 20 Delta option because I *want* to be that close to the money.

Edit: Please don't spend time on this on my account. I can calculate the missing Greeks in Excel by using the Hoadley add-in tools. I just thought that if they're already in the arrays, maybe they could be displayed in a future update of PC-SPAN.


Last edited by CafeGrande; June 25th, 2014 at 09:46 PM.
Reply With Quote
 
  #228 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 196 since Jan 2014
Thanks: 117 given, 191 received

BlueRoo,

I think I have the workbook you're referring to. FWIW, another resource from a well-known author is the "DerivaGem" software that accompanies John Hull's book(s).

DerivaGem Software

Reply With Quote
 
  #229 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 216 since Sep 2012
Thanks: 26 given, 243 received


CafeGrande View Post
Here's a snip of the Risk Navigator tool from Interactive Brokers.

Thanks ... that's some good food for thought. I had already been looking at the idea of summing all of the risk/option value by product to get close to portfolio margin (minus the intra/inter-commodity spread adjustments). Now I'm intrigued to see the Greeks summed by product as well.

Reply With Quote
 
  #230 (permalink)
Trading Apprentice
Los Angeles, CA
 
Futures Experience: Intermediate
Platform: TOS
Favorite Futures: NG
 
Posts: 5 since Jun 2014
Thanks: 7 given, 1 received


Man, this looks cool, but I've spent a couple hours and I just cant get it to work.

After pressing "Download Risk Arrays" i'm just not getting anything in my destination folder.

Any ideas?

Reply With Quote

Reply



futures io > > > > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

Dec 7

Linda Bradford Raschke: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Current PC Specs tderrick Tech Support 45 October 28th, 2012 04:40 PM
Any PC Gamers in here? forrestang Off-Topic 61 October 10th, 2012 03:37 PM
Virtual PC setup how? boze man Tech Support 5 September 8th, 2012 04:59 PM
I need PC help Boomer34 Tech Support 5 January 22nd, 2012 03:28 PM
PC Question NMTrader Off-Topic 0 July 12th, 2009 11:56 PM


All times are GMT -4. The time now is 09:08 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-11-22 in 0.18 seconds with 20 queries on phoenix via your IP 54.198.246.116