PC-SPAN (Page 32) - 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,560 / 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 August 5th, 2015, 11:33 AM   #311 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


Quoting 
ICUS originally announced it would provide the legacy SPAN arrays for up to two weeks after the implementation date of August 20. To aid the clearing members with their transition to the new SP6 formatted array files, ICUS will extend the timeframe for the availability of the legacy SPAN array files until September 11, 2015. Please keep in mind that effective with the business of August 21, 2015, ICUS will margin the GCM files submitted by the clearing members using ICE SPAN and the SP6 formatted array files.

https://www.theice.com/publicdocs/clear_us/notices/15-063_Production_of_Legacy_SPAN_Array_Files.pdf

Reply With Quote
     
The following 2 users say Thank You to ron99 for this post:
     

Old August 5th, 2015, 12:40 PM   #312 (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

ICE SP6

Has anyone taken a look at a SP6 file?

I was hoping to find a way to get XLS-SPAN to be able to use SP6 SPAN files. I've peeked at a couple and it looks like most of the information needed is in there.

The one issue I'm seeing is the expiration date. All dates in ICE's SP6 have just the year and month with the day as 0s (i.e. 20150900). Without the correct expiration date from the SP6, DTE would have to be calculated by rules (i.e. finding the first Friday of the month preceding the contract month). Of course, each commodity in ICE seems to have different rules for the last trade date.

I'd rather not go down the road of calculating DTE based on rules, but that might be the only course. That is, unless I'm missing something ... and I hope I am.

Reply With Quote
     

Old August 13th, 2015, 12:57 PM   #313 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,586 since Dec 2013
Thanks: 1,395 given, 2,362 received
Forum Reputation: Legendary


August 12, 2015
NOTICE 15-065
Release 7.9 – Use of ICE Span and Legacy SPAN Array Files in PC-SPAN1


On August 20, 2015, effective for the business of August 21, 2015, ICE Clear US (ICUS) will implement a system release (Version 7.9). The primary impact of this release is the replacement of CME SPAN with ICE SPAN. Refer to CM Notice # 15-063. Anyone who will be processing the newly formatted SP6 array files in CME PC SPAN must download an updated version of the CME SPAN organizational master.

The updated PC-SPAN organizational master is available for download through the CME Group's web site or can be accessed directly by clicking here. The file should be downloaded to the C:/Span4/Master directory on the computer running PC-SPAN. If you have questions or need assistance with downloading the updated PC-SPAN organizational master, please contact Bruce Domash, Risk Director at 312-836-5709, or Mark Duce at 312-836-6713.
FOR MORE INFORMATION
ICE Clear US
ICEClearUS@theice.com
(212) 748-4001
(312) 836-6777


https://www.theice.com/publicdocs/clear_us/notices/15-065_Release_7.9_Use_of_ICE_Span_and_Legacy_Span_Array_Files.pdf?

Reply With Quote
     
The following 2 users say Thank You to SMCJB for this post:
     

Old August 20th, 2015, 02:19 PM   #314 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,586 since Dec 2013
Thanks: 1,395 given, 2,362 received
Forum Reputation: Legendary

https://www.theice.com/publicdocs/clear_us/notices/15-069_Release_7.9_SPAN_Margining.pdf


August 19, 2015
NOTICE 15/069
Release 7.9 SPAN Margining
On August 20, 2015, effective for the business of August 21, 2015, ICE Clear US (ICUS) will implement a system release (Version 7.9). The primary impact of this release is the replacement
of CME SPAN1 with ICE SPAN. Refer to CM Notice # 15-063.
Clearing members should be aware of the following:
• The rounding routine of the new system will result in minor changes to the margin requirements of several soft agricultural commodities and FX inter-commodity spread credits. Butterfly spreads and inter-exchange spreads will no longer be available in ICE SPAN.
• The format of the ICE Clear US array files will change to match the SP6 format currently produced for ICE Clear Europe products. All margin parameter information will be available in a Comma Separated Value (CSV) format. SPAN margin parameters for ICE Clear US products will be contained in the following four files:
1. Scanning Ranges and Tiering
2. Inter-Month Spread Charge Rates
3. Strategy Spread Charge Rates
4. Inter-Commodity Spread Credit Rates
• To process the newly formatted SP6 array files in CME PC SPAN, the updated version of the CME SPAN organizational master must be download. The updated PC-SPAN organizational master is available through the CME Group's web site or can be accessed directly by clicking here. The file should be downloaded to the C:/Span4/Master directory on the computer running PC-SPAN.
• Clearing firms may continue to use the legacy version of the array files after implementation on August 20, 2015, however, effective with the business of August 21, 2015, ICE Clear US will margin the GCM files submitted by the clearing members using ICE SPAN and the SP6 formatted array files. The SPAN arrays in the legacy format will continue to be produced until September 11, 2015. The separate array file that includes inter-exchange spreads is being eliminated.

Listed below are sources of both legacy PA2 and SP6 SPAN array files effective August 21, 2015.
Legacy Array Files
The legacy PA2 version of the array files will be available at:
• CME FTP site ftp://ftp.cmegroup.com/span/data/nyb/ using the same naming convention: nyb.yyyymmdd.x(e or s).pa2.zip
• The production version of MFT in the pub/span folder using the same naming convention as the CME FTP site.
• ICE Clear US website: https://www.theice.com/clear-us/risk-management
SP6 Formatted Array Files
The SP6 version of the array files will be available at:
• The production version of MFT in the pub/span folder using the following naming convention: NYBmmddF(or E).SP6 (or csv).zip.
• CME FTP site ftp://ftp.cmegroup.com/span/data/nyb/ using the same naming convention as production MFT.
• ICE Clear US website: https://www.theice.com/clear-us/risk-management

FOR MORE INFORMATION
ICE Clear US
ICEClearUS@theice.com
(212) 748-4001
(312) 836-6777

1 SPAN® is a registered trademark of Chicago Mercantile Exchange Inc., used herein under license. Chicago
Mercantile Exchange Inc. assumes no liability in connection with the use of SPAN by any person or entity.

Reply With Quote
     
The following 2 users say Thank You to SMCJB for this post:
     

Old August 29th, 2015, 11:08 AM   #315 (permalink)
Trading Apprentice
Hyderabad
 
Futures Experience: Intermediate
Platform: Amibroker
Favorite Futures: NIFTY
 
Posts: 3 since Jan 2015
Thanks: 2 given, 0 received

Futures Edge on FIO
Hi,

I am sure this question would have been answered somewhere in this thread, but couldnt figure it out.

It is pretty simple question actually, but have burned enough hours on it

How do I know margin for a particular future contract.

I have PC SPAN, I have spn file.

I do not have position file.

Any help is appreciated.

Regards
D'jay

Reply With Quote
     

Old August 29th, 2015, 11:26 AM   #316 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received

When you say PC SPAN is that the CME program or the spreadsheet from this thread?

I don't think you can get futures margin from this spreadsheet.

Here are margins at CME.

http://www.cmegroup.com/clearing/margins/outright-vol-scans.html

Multiply Maintenance times 1.1 to get Initial Margin.

Here are ICE margins

https://www.theice.com/publicdocs/futures_us_reports/all/Futures_US_Margin_Requirements.pdf

Reply With Quote
     

Old August 29th, 2015, 02:41 PM   #317 (permalink)
Trading Apprentice
Hyderabad
 
Futures Experience: Intermediate
Platform: Amibroker
Favorite Futures: NIFTY
 
Posts: 3 since Jan 2015
Thanks: 2 given, 0 received

Hi,

PC-SPAN I am talking abt is the CME application.

I actually trade in India on NSE. The Exchange does provide the span file, but there is no authentic source for margin amount. What broker says you pay.

So I am trying to decode the span file using PC-SPAN but it doesnt show me the margin amount

Attached Thumbnails
PC-SPAN-pcspan.png  

Last edited by djay; August 29th, 2015 at 02:55 PM.
Reply With Quote
     

Old August 31st, 2015, 02:19 PM   #318 (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

XLS-SPAN v.04c

Updated 8/31/2015: Historic Tracking now accomplished through Tracking Tab.

For Historic Tracking of positions, including spreads, enter your positions in columns A-E on the Tracking Tab. All options in a specific spread should have the same number in column F.

Cell G1 has current/start date ... H1 has the end date. When you click Track Historic the data is calculated for each day and saved over to the HistData Tab. To view the results check out the HistPivot Tab.

Attached Files
Register to download File Type: xls XLS-SPAN (04c).xls (567.5 KB, 12 views)

Last edited by Dudetooth; August 31st, 2015 at 04:17 PM. Reason: Updated Attachment
Reply With Quote
     
The following 4 users say Thank You to Dudetooth for this post:
     

Old August 31st, 2015, 02:48 PM   #319 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


Dudetooth View Post
Updated 8/31/2015: Historic Tracking now accomplished through Tracking Tab.

For Historic Tracking of positions, including spreads, enter your positions in columns A-E on the Tracking Tab. All options in a specific spread should have the same number in column F.

Cell G1 has current/start date ... H1 has the end date. When you click Track Historic the data is calculated for each day and saved over to the HistData Tab. To view the results check out the HistPivot Tab.

Thank you so much!

I do see one problem. The result on HistPivot for the first line for Average Position IM is half of what it should be. The rest are OK.

EDIT I notice that there is a zero price in AC3 on the HistData tab. That is what is throwing off the first line for Average Position IM.

Reply With Quote
     

Old August 31st, 2015, 03:53 PM   #320 (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



ron99 View Post
Thank you so much!

I do see one problem. The result on HistPivot for the first line for Average Position IM is half of what it should be. The rest are OK.

EDIT I notice that there is a zero price in AC3 on the HistData tab. That is what is throwing off the first line for Average Position IM.

This should take care of those issues:
1. Go to the HistPivot Tab
2. Click cell A1 ... you should see the PivotTable Fields window open on the right side of the tab (if not click Analyze under the PivotTable Tools tab at the very top right of the Excel window ... click Field List on the far right)
3. In the bottom right of the PivotTable Fields under values, click on Average of Pos Net Value and select Value Field Settings
4. In the new window select Sum and click OK
5. Repeat for Pos IM and Current Pos P/L

The 0 you saw at AC3 is normal. When calculating a spread only one line should have Pos Net Value, Pos IM and Current Pos P/L values ... they are the combined values for the spread and are only populated on one line. For some reason the code adds 0 for some of those on the first day of the Historical Tracking, but then blank afterwards.

I hope this makes sense.

Reply With Quote
     
The following user says Thank You to Dudetooth for this post:
     

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)
 

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

Elite only
 

Trading Technologies: ADL hands-on

Dec 13

Normal webinar schedule resumes after the holidays

January

Ernie Chan: Risk Management

Elite only

Dedicated Trading Servers: Advantages/Disadvantages w/sam028

Elite only

An Afternoon with FIO member Massive I

Elite only

Leo Murphy: 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 11:49 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-08 in 0.17 seconds with 20 queries on phoenix via your IP 54.197.66.254