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

  #101 (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


enderqa View Post
@Dudetooth, Maybe we can start small.

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.

Attached Files
Elite Membership required to download: SPAN Process Edit.docx
Reply With Quote
Thanked by:

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
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Futures True Range Report
The Elite Circle
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
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
  #102 (permalink)
 mu2pilot 
Dallas, TX
 
Experience: Advanced
Platform: T4, Zaner360, TOS
Broker: DeCarley Trading
Trading: Options
Posts: 104 since Sep 2013
Thanks Given: 134
Thanks Received: 52


Dudetooth View Post
I read through some of their material when I was researching the script language, but I somehow missed this part. With everything spelled out like this, I think you could eventually get Excel to do everything that PC-SPAN does.

You mention the standard record layout, but as I pointed out to Ron, this is not the correct file structure. The correct structure is the "expanded" record layout. Note the length of the Commodity (Product) Code. In the standard format, the Commodity Code has a length of 2, but the expanded format shows the Commodity Code having a length of 10.

The expanded "layout guide" matches what we see in the .pa2 files.

Here is a link to that page: https://www.cmegroup.com/confluence/display/pubspan/Type+8+-+Expanded

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


Wow. I inadvertently had a wrong thing in columns A-D. Program locked up. Got it out of that and it still wouldn't work.

Found out that the Temp sheet had over 5,000 lines from the data array in it. Copied a correct Temp sheet over the incorrect one and that fixed it.

Started this thread Reply With Quote
  #104 (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


mu2pilot View Post
You mention the standard record layout, but as I pointed out to Ron, this is not the correct file structure. The correct structure is the "expanded" record layout. Note the length of the Commodity (Product) Code. In the standard format, the Commodity Code has a length of 2, but the expanded format shows the Commodity Code having a length of 10.

The expanded "layout guide" matches what we see in the .pa2 files.

Here is a link to that page: https://www.cmegroup.com/confluence/display/pubspan/Type+8+-+Expanded

Sorry, you are correct. The general point was just that I was unaware that CME had such a detailed description of the risk arrays and armed with that info it could be possible to have Excel do everything PC-SPAN does (though it would take a lot of time and effort to do it all).

Reply With Quote
Thanked by:
  #105 (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
Wow. I inadvertently had a wrong thing in columns A-D. Program locked up. Got it out of that and it still wouldn't work.

Found out that the Temp sheet had over 5,000 lines from the data array in it. Copied a correct Temp sheet over the incorrect one and that fixed it.

I had that happen when I was testing (multiple lines in the risk array that match the search criteria). I tried to put some code in to prevent it from writing more than one line for each chunk of data that it was searching for, but I guess there are still holes. Do you remember what the values in columns A-E were?

Reply With Quote
  #106 (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
I had that happen when I was testing (multiple lines in the risk array that match the search criteria). I tried to put some code in to prevent it from writing more than one line for each chunk of data that it was searching for, but I guess there are still holes. Do you remember what the values in columns A-E were?

I had inadvertently copied the header (rows 1-3) down into cells below row 3.

Rows 1 & 2 of the header were blank. Row 3 had the headers (text) plus the popup for column E (Net).

Started this thread Reply With Quote
  #107 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,041 since Dec 2013
Thanks Given: 4,375
Thanks Received: 10,192


datahogg View Post
I noticed there is a $10.00 charge to download the PC Span. Are there any other charges for the data used
for calculating span??

WOW. When I bought mine (2009) it cost $500 and if you wanted a hard copy it cost an extra $35!

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


SMCJB View Post
WOW. When I bought mine (2009) it cost $500 and if you wanted a hard copy it cost an extra $35!

Same here. And you would think that a multi-billion dollar company would rewrite 25 year old code when charging $500!!!

Started this thread Reply With Quote
  #109 (permalink)
vp62
Moscow Russia
 
Posts: 7 since Oct 2012
Thanks Given: 113
Thanks Received: 0

Dudetooth,

I tried both versions of your software. When I enter a date and click the 'Download Risk Arrays' button it downloads, unzips and saves the risk arrays. But when I enter position data and click the Portfolio or Single Position buttons, nothing happens, just blank gray field in the Main Tab and almost all Zeroes in the Temp Tab. Am I doing something wrong?

Thank you in advance.

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



vp62 View Post
But when I enter position data and click the Portfolio or Single Position buttons, nothing happens, just blank gray field in the Main Tab and almost all Zeroes in the Temp Tab.

Can you show me what are you entering in columns A:E? It may be an issue with the contract or strike (the spreadsheet is a little finicky).

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