PC-SPAN - Options on Futures | futures io social trading
futures io futures trading


PC-SPAN
Updated: Views / Replies:48,636 / 465
Created: by ron99 Attachments:108

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
 108  
 
Thread Tools Search this Thread
 

PC-SPAN

  #101 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 207 since Sep 2012
Thanks: 26 given, 221 received


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
Register to download File Type: docx SPAN Process Edit.docx (20.2 KB, 60 views)

Last edited by Dudetooth; December 4th, 2013 at 01:19 PM.
Reply With Quote
The following 4 users say Thank You to Dudetooth for this post:
 
  #102 (permalink)
Elite Member
Dallas, TX
 
Futures Experience: Advanced
Platform: T4, Zaner360, TOS
Broker/Data: DeCarley Trading
Favorite Futures: Options
 
Posts: 104 since Sep 2013
Thanks: 133 given, 50 received


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: http://www.cmegroup.com/confluence/display/pubspan/Type+8+-+Expanded

Reply With Quote
 
  #103 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,572 since Jul 2011
Thanks: 739 given, 4,407 received
Forum Reputation: Legendary


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.

Reply With Quote
 
  #104 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 207 since Sep 2012
Thanks: 26 given, 221 received


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: http://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
The following user says Thank You to Dudetooth for this post:
 
  #105 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 207 since Sep 2012
Thanks: 26 given, 221 received


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)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,572 since Jul 2011
Thanks: 739 given, 4,407 received
Forum Reputation: Legendary


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

Reply With Quote
 
  #107 (permalink)
Market Wizard
Houston TX
 
Futures Experience: Advanced
Platform: XTrader
Broker/Data: Advantage Futures
Favorite Futures: Energy
 
Posts: 1,862 since Dec 2013
Thanks: 1,585 given, 2,805 received
Forum Reputation: Legendary


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)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,572 since Jul 2011
Thanks: 739 given, 4,407 received
Forum Reputation: Legendary


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

Reply With Quote
 
  #109 (permalink)
Trading Apprentice
Moscow Russia
 
Futures Experience: Intermediate
Platform: OX, OEC
Favorite Futures: Futures Options
 
Posts: 7 since Oct 2012
Thanks: 110 given, 0 received

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)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 207 since Sep 2012
Thanks: 26 given, 221 received



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

Reply



futures io > > > > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

FIO Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

May

An overview of volumetric analytical tools w/Sergey Sokolov @ PTMC

Elite only

John Hoagland (TBA)

Elite only

FuturesTrader71 Extended Ask Me Anything (AMA)

Elite only

Pete @ Jigsaw Trading (TBA)

Elite only

John @ No BS Day Trading (TBA)

Elite only

An Afternoon with FIO member Softsoap (being rescheduled)

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Current PC Specs tderrick Tech Support 45 October 28th, 2012 03:40 PM
Any PC Gamers in here? forrestang Off-Topic 61 October 10th, 2012 02:37 PM
Virtual PC setup how? boze man Tech Support 5 September 8th, 2012 03:59 PM
I need PC help Boomer34 Tech Support 5 January 22nd, 2012 02:28 PM
PC Question NMTrader Off-Topic 0 July 12th, 2009 10:56 PM


All times are GMT -4. The time now is 02:01 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@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 2017-05-29 in 0.12 seconds with 20 queries on phoenix via your IP 54.158.248.219