PC-SPAN (Page 11) - 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,527 / 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 December 4th, 2013, 08:43 AM   #101 (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


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, 56 views)

Last edited by Dudetooth; December 4th, 2013 at 02:19 PM.
Reply With Quote
     
The following 4 users say Thank You to Dudetooth for this post:
     

Old December 4th, 2013, 12:18 PM   #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
     

Old December 4th, 2013, 12:45 PM   #103 (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


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
     

Old December 4th, 2013, 02:23 PM   #104 (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


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:
     

Old December 4th, 2013, 02:29 PM   #105 (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

Futures Edge on FIO

Are you a NinjaTrader user?

 

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
     

Old December 4th, 2013, 02:40 PM   #106 (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
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
     

Old December 8th, 2013, 10:21 AM   #107 (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


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
     

Old December 8th, 2013, 09:53 PM   #108 (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


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
     

Old December 11th, 2013, 09:32 AM   #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
     

Old December 11th, 2013, 09:45 AM   #110 (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



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

NinjaTrader 8: Features and Enhancements, Tips and Tricks

Dec 6
 

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

Elite only
 

Trading Technologies: Algo Design Lab hands-on

Dec 13
     

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 08:03 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-07 in 0.12 seconds with 20 queries on phoenix via your IP 50.16.17.16