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

  #361 (permalink)
uuu1965
Riga Latvia
 
Posts: 107 since Jan 2013
Thanks Given: 441
Thanks Received: 72

@Dudetooth

Hi,
I use XLS-SPAN for such position:
HEJ6 C66 -3
HEG6 C60 +3
HEG6 C61 -3
HEG6 C66 +3

and get 1752$.
But CME's PC-SPAN (and Zaner platform) shows 2439$.

Would you help?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Futures True Range Report
The Elite Circle
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
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
  #362 (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


uuu1965 View Post
@Dudetooth

Hi,
I use XLS-SPAN for such position:
HEJ6 C66 -3
HEG6 C60 +3
HEG6 C61 -3
HEG6 C66 +3

and get 1752$.
But CME's PC-SPAN (and Zaner platform) shows 2439$.

Would you help?

@uuu1965,

I'll need a little more information in order to see if I can help.

What version of the spreadsheet are you using?

What day did you calculate for?

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



Dudetooth View Post
@uuu1965,

I'll need a little more information in order to see if I can help.

What version of the spreadsheet are you using?

What day did you calculate for?

He's probably in bed now but I got the same result 1752 using 1/07/16 files and using XLS-SPAN 04d. I tried using both the reduced version of the CME file and the full file. Same result.


Started this thread Reply With Quote
Thanked by:
  #364 (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


ron99 View Post
He's probably in bed now but I got the same result 1752 using 1/07/16 files and using XLS-SPAN 04d. I tried using both the reduced version of the CME file and the full file. Same result.


@uuu1965 & @ron99

I found the issue. For certain markets there are additional charges assessed for intra-commodity spreads. I've found that this is true for at least meats and grains ... other markets like ES do not get these additional charges.

In the spread mentioned earlier the worst risk scenario was $1593 * 1.1 = $1752 for IM as seen in the spreadsheet. My spreadsheet unfortunately does not handle the intra-commodity spread charges. In this scenario those charges were $624, so ($1593 + $624) * 1.1 = $2439.

I haven't even looked at trying to figure out how to code the intra-commodity spread charges. Sorry, but my spreadsheet won't be of much use in these markets.

Reply With Quote
Thanked by:
  #365 (permalink)
uuu1965
Riga Latvia
 
Posts: 107 since Jan 2013
Thanks Given: 441
Thanks Received: 72


Dudetooth View Post
@uuu1965 & @ron99

I found the issue. For certain markets there are additional charges assessed for intra-commodity spreads. I've found that this is true for at least meats and grains ... other markets like ES do not get these additional charges.

In the spread mentioned earlier the worst risk scenario was $1593 * 1.1 = $1752 for IM as seen in the spreadsheet. My spreadsheet unfortunately does not handle the intra-commodity spread charges. In this scenario those charges were $624, so ($1593 + $624) * 1.1 = $2439.

I haven't even looked at trying to figure out how to code the intra-commodity spread charges. Sorry, but my spreadsheet won't be of much use in these markets.

Lesson for me: always check the various source (and first: your broker)! Anyway your spreadsheet is excellent!
I would ask about "... the worst risk scenario...": does it mean that IM have preset values (f.e., if I have short ESH6 P 1950 and ES close at 1932 on 01/07, IM is 4236$ and if ES close at 1911 on 01/08 the same position IM is 4326$)? In others words: can I in advance to know IM of my positions at certain levels of commodity?

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


uuu1965 View Post
Lesson for me: always check the various source (and first: your broker)! Anyway your spreadsheet is excellent!
I would ask about "... the worst risk scenario...": does it mean that IM have preset values (f.e., if I have short ESH6 P 1950 and ES close at 1932 on 01/07, IM is 4236$ and if ES close at 1911 on 01/08 the same position IM is 4326$)? In others words: can I in advance to know IM of my positions at certain levels of commodity?

When SPAN is calculated there are 16 different scenarios that they run for risk assessments that include changes in prices and/or volatility. It is a best guess according to the exchanges of how far a position can go against you in the next trading day based on the recent past price action.

Check out CME's SPAN Methodology for more detail https://www.cmegroup.com/clearing/files/span-methodology.pdf

Reply With Quote
Thanked by:
  #367 (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

Looks like no more ICE (nyb) array files as of March 1st. @Dudetooth, any ideas?

https://www.ice.com/publicdocs/clear_us/notices/16-005_Legacy_SPAN_File_to_be_Eliminated_Feb_29.pdf

Location of new files

https://www.ice.com/clear-us/risk-management

I'm assuming the SP6 files can't be used like we used the PA2 files.

Started this thread Reply With Quote
Thanked by:
  #368 (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


ron99 View Post
Looks like no more ICE (nyb) array files as of March 1st. @Dudetooth, any ideas?

https://www.ice.com/publicdocs/clear_us/notices/16-005_Legacy_SPAN_File_to_be_Eliminated_Feb_29.pdf

Location of new files

https://www.ice.com/clear-us/risk-management

I'm assuming the SP6 files can't be used like we used the PA2 files.

That is correct ... the files types are quite different. I did take a look at cracking the SP6 files last year when they first started mentioning the switch. I'll see what I can do.

Reply With Quote
Thanked by:
  #369 (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

If anyone is still interested in an XLS-SPAN fix for ICE's new SP6 format, I have some good news and some bad news.

Good news: I think I have a solution. ICE publishes the SPAN files as SP6 and CSV files. The CSV files are a lot easier to extract data from, but there are some down sides. For example, they no longer give an expiration date, so one has to be calculated in order to get DTE.

Bad news: Over the last year I have been working with a new spreadsheet and rewrote almost all of the main code addressing issues like calculating IM for portfolios/multi-legged spreads and futures. I worked through my solution for ICE's new risk files on the new spreadsheet. I looked, but it would be extremely difficult to rework the solution into the existing XLS-SPAN because the processes and layout are so different. I'm not sure I can commit the time and effort required into reinventing the wheel, especially when I've already reinvented it (so to speak).

More bad news: The new spreadsheet was a cooperative project with another individual. He is not inclined to share the spreadsheet publically.

Possible solution: I am willing to share the code I worked on (main calculations and functions). If there is interest, I can see about pulling out my portions of the code and put them in a bare-bones spreadsheet.

Reply With Quote
Thanked by:
  #370 (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


With ICE starting to charge too much for real time data ($110/month) on April 1st, I am inclined to tell you not to do the work to make this available to us because I suspect not many will be trading ICE products after April 1st.

I might be but not right away.

Are any other posters going to be trading ICE products after April 1st?

Thank you for all you have done so far Dudetooth! I use your spreadsheet every day.

Started this thread 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