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 190,372 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

  #351 (permalink)
mdavis
St. Petersburg FL
 
Posts: 1 since Mar 2015
Thanks Given: 1
Thanks Received: 0

Anyone know where the CME documents the release times for the various intraday Span files or the differences between the files other than time-of-day?

I need use the most current file and thought a specific version was released only once per day. But now I notice that today's *.a.pa2 file was updated at least once this morning after I downloaded it earlier so I'm no longer using the current version of *.a.pa2.

Also, *.BE.pa2 files started showing up recently. Anyone know what those are?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
How to apply profiles
Traders Hideout
Better Renko Gaps
The Elite Circle
Increase in trading performance by 75%
The Elite Circle
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
34 thanks
Tao te Trade: way of the WLD
24 thanks
GFIs1 1 DAX trade per day journal
16 thanks
Vinny E-Mini & Algobox Review TRADE ROOM
13 thanks
My NQ Trading Journal
12 thanks
  #352 (permalink)
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


mdavis View Post
Anyone know where the CME documents the release times for the various intraday Span files or the differences between the files other than time-of-day?

I need use the most current file and thought a specific version was released only once per day. But now I notice that today's *.a.pa2 file was updated at least once this morning after I downloaded it earlier so I'm no longer using the current version of *.a.pa2.

Also, *.BE.pa2 files started showing up recently. Anyone know what those are?

I don't think the CME keeps to a strict schedule as far as time.

Here is their description of the files.



https://www.cmegroup.com/clearing/files/Loading_a_Risk_Array_File.pdf

Started this thread Reply With Quote
Thanked by:
  #353 (permalink)
uwevoelker
Hamburg, Germany
 
Posts: 15 since May 2014
Thanks Given: 14
Thanks Received: 4


Is the format documented somewhere?

Let's look at the E-Mini January 2016 1575 Put (data files are from October 16th):

81CMEEW ES OOFP201603 201601 000157500414-00234+00306-00248+00541-00213+00213-00258+00689-00000000000570N

82CMEEW ES OOFP201603 201601 000157500184+00134-00265+00859-00143+00084+00508-00422-002802650000570++00426-C

How can I calculate the IM out of this?


PS: I'm using a Mac, unfortunately the Excel file is not working with "Excel for Mac".

Reply With Quote
  #354 (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


uwevoelker View Post
Is the format documented somewhere?

@uwevoelker

CME describes the information that is in record type within the pa2 file (what you posted was the Type 81 and Type 82 records):
https://www.cmegroup.com/confluence/display/pubspan/Risk+Parameter+File+Layouts+for+the+Positional+Formats

And they have a brief description of the methodology, but it's a little bare:
https://www.cmegroup.com/clearing/span-methodology.html

I can break it down for you in a little more detail, but unfortunately it's not as simple as finding the two lines for an option. You'll need several more lines from the pa2 file to be able to calculate the initial margin.

Are you looking to code this on a Mac?

Reply With Quote
  #355 (permalink)
uwevoelker
Hamburg, Germany
 
Posts: 15 since May 2014
Thanks Given: 14
Thanks Received: 4

Thanks @Dudetooth, I will have a look into the documentation.

If you don't mind, I would appreciate if you could break it down in a little more detail, perhaps with an example.

Yes, I'm looking into coding this. Depending on complexity maybe not all parts, but I consider correct IM for simple short options as the minimum. I'm coding in Go, so the code will not be Mac specific. Ideally I would like to offer a web service, so that also others can us it. But I assume CME does not allow this. Open sourcing the library code would be another option.

Reply With Quote
  #356 (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


uwevoelker View Post
I would appreciate if you could break it down in a little more detail, perhaps with an example.

@uwevoelker

I added a simplistic explanation of the SPAN process as a PDF (I don't think I would have been able to figure out how to format it properly as a normal post). Let me know if you have any questions.


uwevoelker View Post
Ideally I would like to offer a web service, so that also others can us it. But I assume CME does not allow this. Open sourcing the library code would be another option.

If you haven't already seen CME's Quickstrike, you may want to check out if you want a web-based method for calculating margin.

Hope this helps.

Attached Thumbnails
PC-SPAN-span-process.pdf  
Reply With Quote
  #357 (permalink)
yihanxu
Singapore
 
Posts: 1 since Oct 2015
Thanks Given: 3
Thanks Received: 0

Hello Dudetooth,

I came across your SPAN process document and that was a great help for me!

I am having issue with the Type 3 "Combined Commodity Code". It looks like the exchange and product code are joint together? However, when I am trying to find the ES S&P Emini in the file, I can't seem to find the logic behind and was not sure which line should be correct.

If there is any information on website etc that I can refer to, please share with me as I have many exchanges to handle.

Thank you very much!


Dudetooth View Post
enderqa,

Here's my attempt to break down the SPAN process. Hope it helps.

***Edit: A few minor edits ... I guess I should have read through the CME material a little more closely before I posted this. I think I have everything correct now.


Reply With Quote
  #358 (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


yihanxu View Post
Hello Dudetooth,

I came across your SPAN process document and that was a great help for me!

I am having issue with the Type 3 "Combined Commodity Code". It looks like the exchange and product code are joint together? However, when I am trying to find the ES S&P Emini in the file, I can't seem to find the logic behind and was not sure which line should be correct.

If there is any information on website etc that I can refer to, please share with me as I have many exchanges to handle.

Thank you very much!

CME's website has some info on the process (I think ICE has a better description of the process), but not a lot of details about the actual codes used within the pa2 file.

For ES this is what the beginning of the line will look like for the following Record Types:
Type P: "P CMEES OOF"
Type 3: "3 SP 1001"
Type 4: "4 SP "
Type B: "B CMEES "
Type 8 for the futures contract: "82CMEES ES FUT"
Type 8 for the option contract: "82CMEES ES OOF"

***Note: the number of spaces does not show up properly in the post, for example between the "3" and "SP" there is 1 space, between the "SP" and "1001" there are 4 spaces.

If you are looking at several exchanges you will need to find the appropriate product codes for all the commodities you are looking to track.

Reply With Quote
Thanked by:
  #359 (permalink)
uwevoelker
Hamburg, Germany
 
Posts: 15 since May 2014
Thanks Given: 14
Thanks Received: 4

I noticed the same (ES missing). Apparently you have to use SP. Is this somewhere encoded in the data?

Reply With Quote
  #360 (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



uwevoelker View Post
I noticed the same (ES missing). Apparently you have to use SP. Is this somewhere encoded in the data?

It looks like the Type 2 Record in the pa2 lists family of products, though I have never actually broke this record down before.
https://www.cmegroup.com/confluence/display/pubspan/Type+2+-+Expanded

There is an order to the records, so the Type 1 that is the exchange will show up first, then multiple Type 2s under that Type 1 for every family of products within that exchange.

Here's SP's Type 2 Records:
"2 CME SP 0USD$PN SP FUT SP OOF YP OOF EV OOF XP OOF YP1 OOF"
"2 CME SP 0USD$PN EV1 OOF EV2 OOF EV4 OOF EV5 OOF ES FUT ES OOF"
"2 CME SP 0USD$PN 7S OOF EW OOF EW1 OOF EW2 OOF EW4 OOF EW5 OOF"

"ES FUT" for the ES futures contracts, "ES OOF" for the ES option contracts.

Type 3 & type 4 Records relate to the family of products, hence "3 SP" rather than "3 ES". You still will need to know the product codes within the family of products to track down the options.

I suppose it could be programmed to extract the data, but it doesn't look that easy.

Reply With Quote
Thanked by:




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