PC-SPAN (Page 23) - Options on Futures | futures.io
futures.io futures trading
 

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Traders Hideout > Options on Futures


PC-SPAN
Started:October 23rd, 2013 (09:36 AM) by ron99 Views / Replies:41,492 / 403
Last Reply:November 19th, 2016 (08:49 AM) Attachments:100

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • 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, and we will never resell your private information.

-- Big Mike
     

Reply
 100  
 
Thread Tools Search this Thread

PC-SPAN

Old June 4th, 2014, 03:11 PM   #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
     

Old June 4th, 2014, 05:05 PM   #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: 189 since Jan 2014
Thanks: 108 given, 171 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
     

Old June 4th, 2014, 09:14 PM   #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:
     

Old June 25th, 2014, 04:53 PM   #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: 189 since Jan 2014
Thanks: 108 given, 171 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
     

Old June 25th, 2014, 06:16 PM   #225 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 received

Futures Edge on FIO

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
     

Old June 25th, 2014, 06:20 PM   #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
     

Old June 25th, 2014, 09:29 PM   #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: 189 since Jan 2014
Thanks: 108 given, 171 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
     

Old June 25th, 2014, 09:58 PM   #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: 189 since Jan 2014
Thanks: 108 given, 171 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
     

Old June 25th, 2014, 10:03 PM   #229 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 179 since Sep 2012
Thanks: 24 given, 198 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
     

Old June 28th, 2014, 10:30 PM   #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 > Futures Trading, News, Charts and Platforms > Traders Hideout > Options on Futures > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

NinjaTrader 8: Features and Enhancements, Tips and Tricks

Dec 6
 

Al Brooks: Stop Losing when a Good Trade goes Bad, Correcting Mistakes

Elite only
 

Trading Technologies: Algo Design Lab hands-on

Dec 13
     

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 05:53 PM.

Copyright © 2016 by 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 2016-12-06 in 0.15 seconds with 20 queries on phoenix via your IP 54.163.92.62