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


PC-SPAN
Updated: Views / Replies:50,145 / 475
Created: by ron99 Attachments:111

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

PC-SPAN

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


ron99 View Post
Looks like it needed the full path for spanit.

That'll do it. If no path is given it will default to the folder the batch file is in. I went back through my batch files and placed the full path in all of them just to be safe.

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


spj77 View Post
But i am hoping to get just the straight margin for each as if it were traded independently of anything else, like if it was the only position in the portfolio.t

Another route you could look at would be to use the RiskReported.exe as mentioned in post #12.

It'll give you a CSV file that looks like the attached pic (activeValue= last value of position; scanContr= margin for that position) :
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Last edited by Dudetooth; November 18th, 2013 at 06:05 PM. Reason: added text
Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #33 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,616 since Jul 2011
Thanks: 756 given, 4,492 received
Forum Reputation: Legendary



Dudetooth View Post
Another route you could look at would be to use the RiskReported.exe as mentioned in post #12.

It'll give you a CSV file that looks like the attached pic (activeValue= last value of position; scanContr= margin for that position) :
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

I don't understand. I get $61 IM for each OG contract.

Reply With Quote
The following user says Thank You to ron99 for this post:
 
  #34 (permalink)
Elite Member
Qld, Australia
 
Futures Experience: Beginner
Platform: Excel/Hoadley/PC-SPAN
Broker/Data: OX
Favorite Futures: Options
 
Posts: 28 since Mar 2012
Thanks: 6 given, 39 received

Wish the CME would hurry up and send me a user id and password so i can download SpanPosCov.exe...So frustrating, want to try the ideas you guys have given!

Reply With Quote
 
  #35 (permalink)
Elite Member
Qld, Australia
 
Futures Experience: Beginner
Platform: Excel/Hoadley/PC-SPAN
Broker/Data: OX
Favorite Futures: Options
 
Posts: 28 since Mar 2012
Thanks: 6 given, 39 received

Hi Ron,
So if in PCSPAN each option is its own portfolio, would you use the risk reporter tool to extract them all out into one excel/csv file, or do you have another method?
Cheers
Scott



ron99 View Post
Scott, if you put the symbol in the firm name then you will get the margin for each. That is what I do. See post #14.

SPAN will group the results by firm name with the same acct ID. So everything on the spreadsheet will the same firm name and acct ID will be calculated together to give you margin for all lines of the spreadsheet with that firm name and acct ID.

If you want margin for each contract then put your symbol in the firm name and anything in acct ID.

If you want margin for a spread, Put the same firm name and acct ID for each leg. SPAN will then combine them.

Tip: The spreadsheet must be closed in order to run the SPANPosConv batch. Also blank lines in spreadsheet are ignored.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


This is how it would look if you put them into the SPAN program.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


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


ron99 View Post
I get $61 IM for each OG contract.

I did misspeak (thanks for catching that) ... it is the scan risk contribution that is listed, not the margin. The main thing is that it does not add in the Short Option Minimum (SOM). I loaded it up in PC-SPAN with 1 GCZ3 C1660 I get $61 for risk and $71 for IM. Digging through PC-SPAN results it looks like the SOM for GC added $55 to the $7 risk array (rounded to $61), plus the option value of $10 for the $71 total.

Unfortunately, the ScanRiskContr report doesn't reflect the SOM. That is done in the PBReq report, but in there the SOM is grouped by commodity so it won't be too helpful for multiple positions in the same market. Your method of using the spanit.exe with the position name in the firm column may be the best solution for calculating individual position margin that will include the SOM. Thanks for the idea.

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


spj77 View Post
Wish the CME would hurry up and send me a user id and password so i can download SpanPosCov.exe...So frustrating, want to try the ideas you guys have given!

CME give good customer service?

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

The procedure would be to create the CSV spreasheet like post #12 with your contracts.

Run SPAN Position Converter Utility to create the .pos file.

Run the SPAN Script batch (spanit) created in post #6.

The output of SPAN Script would be a spreadsheet that looks like this (Column M is the IM)

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Or if you run my FormatSPANMargins sub it would look like this (Column L is the IM) I delete column A and do a Text to Column procedure on the resulting Column A to extract the symbols from the rest of the info.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Column H is the current option value in dollar form. You just multiply this by -1 to get a positive number.
Column J is the MM.


Last edited by ron99; November 18th, 2013 at 08:25 PM.
Reply With Quote
The following user says Thank You to ron99 for this post:
 
  #39 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,616 since Jul 2011
Thanks: 756 given, 4,492 received
Forum Reputation: Legendary


Dudetooth View Post
I did misspeak (thanks for catching that) ... it is the scan risk contribution that is listed, not the margin. The main thing is that it does not add in the Short Option Minimum (SOM). I loaded it up in PC-SPAN with 1 GCZ3 C1660 I get $61 for risk and $71 for IM. Digging through PC-SPAN results it looks like the SOM for GC added $55 to the $7 risk array (rounded to $61), plus the option value of $10 for the $71 total.

Unfortunately, the ScanRiskContr report doesn't reflect the SOM. That is done in the PBReq report, but in there the SOM is grouped by commodity so it won't be too helpful for multiple positions in the same market. Your method of using the spanit.exe with the position name in the firm column may be the best solution for calculating individual position margin that will include the SOM. Thanks for the idea.

The SPAN Risk under Initial Requirements is the IM. $61 in this case. That matches statements I get from the firms I trade at.

The Risk Initial amount on the statements is what I am looking to match. The Initial Margin number on some statements includes the value of the option. But that number is not used to determine margin calls and we don't use that to determine ROI.

The $55 is the MM.


Last edited by ron99; November 19th, 2013 at 03:13 PM. Reason: More info
Reply With Quote
 
  #40 (permalink)
Elite Member
Qld, Australia
 
Futures Experience: Beginner
Platform: Excel/Hoadley/PC-SPAN
Broker/Data: OX
Favorite Futures: Options
 
Posts: 28 since Mar 2012
Thanks: 6 given, 39 received


Hi,

I finally received the login credentials from the CME and have started to try and automate the PC-SPAN experience like you guys.

But i am hitting the second hurdle. I have copied your guys coding from earlier posts and the 'DownloadRiskArrayFiles" sub works fine; places the unzipped data files in the 'span4\data' folder ready for loading into SPAN. All good there.

I created a "SpanScriptLoadRiskArrayFiles.txt" file and saved it in Span4\Bin folder. It contains two lines:
Load C:\Span4\Data\cme.s.pa2
Load C:\Span4\Data\nyb.s.pa2

I created a "LoadRiskArrayFiles.bat" file and saved it in Span4\Bin folder. It contains:
C:\Span4\Bin\spanit.exe C:\Span4\Bin\SpanScriptLoadRiskArrayFiles.txt


When i run the macro, it opens up a dos window which contains "Batch Interface for PC-SPAN" and then says it is loading the files. The window then closes. The problem is when i then open PC-SPAN to see if files have been loaded it is empty in there.......... The data files themselves are fine as i loaded them manually in PC-SPAN and they populate as you would expect (and then exited without saving).

Any ideas what i am missing / doing wrong? I can't find any setting in the program where i need to enable batch processing...


My Code is attached:
-------------------------------------------------

Sub DownloadRiskArrayFiles()

On Error GoTo GetOut
Dim RetVal
Dim batchfile As String
Dim path As String
dateit = Range("SpanMacro!B2").Value 'Date in YYYYMMDD format
namecme = "cme." & dateit & ".s.pa2.zip"
namenyb = "nyb." & dateit & ".s.pa2.zip"
path = "C:\Span4\Data"

SaveWebFile "ftp://ftp.cmegroup.com/pub/span/data/cme/" & namecme, path & "\" & namecme
SaveWebFile "ftp://ftp.cmegroup.com/pub/span/data/nyb/" & namenyb, path & "\" & namenyb

Call UnZip(path & "\", path & "\" & namecme)
Call UnZip(path & "\", path & "\" & namenyb)

Kill path & "\" & namecme
Kill path & "\" & namenyb

Kill path & "\cme.s.pa2"
Kill path & "\nyb.s.pa2"
Name path & "\" & "cme." & dateit & ".s.pa2" As path & "\cme.s.pa2"
Name path & "\" & "nyb." & dateit & ".s.pa2" As path & "\nyb.s.pa2"

GetOut:
End Sub

-----------------------------------------------

Sub LoadRiskArrayFiles()

batchfile = "C:\Span4\Bin\LoadRiskArrayFiles.bat"
RetVal = Shell(batchfile, 1)

End Sub

-----------------------------------------------


Cheers
Scott

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)

July Journal Challenge w/$1100 in prizes from TopstepTrader

July

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 03:09 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-06-28 in 0.08 seconds with 19 queries on phoenix via your IP 54.158.253.14