NexusFi: Find Your Edge


Home Menu

 





PC-SPAN


Discussion in Options

Updated
      Top Posters
    1. looks_one Dudetooth with 218 posts (213 thanks)
    2. looks_two ron99 with 116 posts (55 thanks)
    3. looks_3 CafeGrande with 30 posts (4 thanks)
    4. looks_4 BlueRoo with 24 posts (5 thanks)
      Best Posters
    1. looks_one Dudetooth with 1 thanks per post
    2. looks_two SMCJB with 1 thanks per post
    3. looks_3 ron99 with 0.5 thanks per post
    4. looks_4 BlueRoo with 0.2 thanks per post
    1. trending_up 188,781 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
Search this Thread

PC-SPAN

  #221 (permalink)
BlueRoo
Brisbane, Queensland, Australia
 
Posts: 121 since Aug 2013
Thanks Given: 75
Thanks Received: 97


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...

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Futures True Range Report
The Elite Circle
Deepmoney LLM
Elite Quantitative GenAI/LLM
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #222 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207

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)
BlueRoo
Brisbane, Queensland, Australia
 
Posts: 121 since Aug 2013
Thanks Given: 75
Thanks Received: 97



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
Thanked by:
  #224 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207

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)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


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)
BlueRoo
Brisbane, Queensland, Australia
 
Posts: 121 since Aug 2013
Thanks Given: 75
Thanks Received: 97


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)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207


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.

Reply With Quote
  #228 (permalink)
CafeGrande
St Paul, MN, USA
 
Posts: 200 since Jan 2014
Thanks Given: 131
Thanks Received: 207

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)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


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)
Griffith
Los Angeles, CA
 
Posts: 5 since Jun 2014
Thanks Given: 7
Thanks Received: 1


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




Last Updated on September 23, 2021


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts