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


PC-SPAN
Updated: Views / Replies:55,130 / 483
Created: by ron99 Attachments:118

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

Reply
 118  
 
Thread Tools Search this Thread
 

PC-SPAN

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


TFOpts View Post
A review of the compatibilty with XLS-SPAN is still ongoing. One thing Ron found was that by changing the name from ccl to cme he was able to scan in the data into XLS-SPAN but was not able to use the tracking functionality of the tool.

Small code fix from what I can tell in order to get Track to work with the older PA2 files.

1) Go to Class Modules COption

2) Find:

Public Property Let OptContract(Value As String)
pOptContract = Value
If pCSVPA2 = "CSV" Then
pType8Opt = pOptContract & pOptType & pStrike '"50,201" & Right(pOptContract, 1) & conv2num(Mid(pOptContract, Len(pOptContract) - 1, 1)) & "00," & pOptType & "," & pStrike
Else
pType8Opt = pType8O & pOptType & "201" & Right(pFutContract, 1) & conv2num(Mid(pFutContract, Len(pFutContract) - 1, 1)) _
& " 201" & Right(pOptContract, 1) & conv2num(Mid(pOptContract, Len(pOptContract) - 1, 1)) & " " & pStrike
End If
End Property


3) And replace with:

Public Property Let OptContract(Value As String)
pOptContract = Value
Dim tempdate As String
If pCSVPA2 = "CSV" Then
pType8Opt = pOptContract & pOptType & pStrike '"50,201" & Right(pOptContract, 1) & conv2num(Mid(pOptContract, Len(pOptContract) - 1, 1)) & "00," & pOptType & "," & pStrike
Else
If Left(pDatePA2, 3) & Right(pFutContract, 1) >= Left(pDatePA2, 4) Then
tempdate = Left(pDatePA2, 3) & Right(pFutContract, 1)
Else
tempdate = Left(pDatePA2, 2) & Mid(pDatePA2, 3, 1) + 1 & Right(pFutContract, 1)
End If
pType8Opt = pType8O & pOptType & tempdate & conv2num(Mid(pFutContract, Len(pFutContract) - 1, 1)) _
& " " & tempdate & conv2num(Mid(pOptContract, Len(pOptContract) - 1, 1)) & " " & pStrike
End If
End Property


I'll continue to troubleshoot any other issues that come from these older PA2 files.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #462 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,717 since Jul 2011
Thanks: 792 given, 4,759 received
Forum Reputation: Legendary

How will XLS-SPAN know the difference between ESH8 for 2008 and 2018?

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



ron99 View Post
How will XLS-SPAN know the difference between ESH8 for 2008 and 2018?

I looks at the year of the PA2 file. With the 20080501.s.pa2 it takes the digit for the decade (0) and combines it with the single digit for the year of the contract (8). That year (08) should be >= the year of the PA2 file or it adds to the decade. That should work when we get 2009 PA2 files with 2010 contract data.

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

@Dudetooth when I make the change above, Track quits working for me even for 2017 contracts. When I change it back to the way it was before the change, it works again for 2017 contracts but not 2008 contracts.

I copied from the post above and pasted it on top of old part. Do I need to compile VBS project? Or just save changes? Are the indents necessary?

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

@ron99,

You should just have to hit save, in either the VBA editor or in Excel itself.

I did a quick check with 20170524's PA2 and it was working for me.

I'm not sure if something gets messed up when copying and pasting the code to the forum, but I uploaded it just to be safe and so you could compare.

Attached Files
Register to download File Type: zip XLS-SPAN (05b).zip (290.0 KB, 13 views)
Reply With Quote
The following 2 users say Thank You to Dudetooth for this post:
 
  #466 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,717 since Jul 2011
Thanks: 792 given, 4,759 received
Forum Reputation: Legendary


Dudetooth View Post
@ron99,

You should just have to hit save, in either the VBA editor or in Excel itself.

I did a quick check with 20170524's PA2 and it was working for me.

I'm not sure if something gets messed up when copying and pasting the code to the forum, but I uploaded it just to be safe and so you could compare.

I downloaded this version and then copied and pasted the macro and everything works OK.

I found the problem. When copy and pasting to forum it lost some spaces between quotes.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Your post with macro changes was missing the spaces.

Reply With Quote
The following 2 users say Thank You to ron99 for this post:
 
  #467 (permalink)
Trading for Fun
Los Angeles, CA
 
Futures Experience: Beginner
Platform: Zaner360
Broker/Data: DeCarley
Favorite Futures: Options on Futures
 
Posts: 64 since May 2017
Thanks: 48 given, 116 received

@Dudetooth,

Do you know if the SPAN files include margin requirements on the underlying futures (instead of just on options)? If yes, would it required extensive modifications to XLS-SPAN to extract this information?

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


TFOpts View Post
@Dudetooth,

Do you know if the SPAN files include margin requirements on the underlying futures (instead of just on options)? If yes, would it required extensive modifications to XLS-SPAN to extract this information?

XLS-SPAN does give margin for futures. Just put a "F" in the C/P column and nothing in strike column.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Reply With Quote
The following 2 users say Thank You to ron99 for this post:
 
  #469 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 216 since Sep 2012
Thanks: 26 given, 243 received


TFOpts View Post
@Dudetooth,

Do you know if the SPAN files include margin requirements on the underlying futures (instead of just on options)? If yes, would it required extensive modifications to XLS-SPAN to extract this information?

Just to add to ron99's comment, the futures contact have the same 16 risk scenarios that the options do, so futures can be added to a spread with options to calculate margin.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #470 (permalink)
Trading for Fun
Riga Latvia
 
Futures Experience: Intermediate
Platform: Zaner 360
Favorite Futures: commodyties
 
Posts: 99 since Jan 2013
Thanks: 366 given, 70 received

Futures


@Dudetooth
Sorry, I forgot how to get simple futures price, f.e. CLQ7

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)

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

Dec 7

Linda Bradford Raschke: TBA

Elite only

Ran Aroussi: 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 07:24 PM.

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-11-18 in 0.08 seconds with 19 queries on phoenix via your IP 54.198.108.19