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


PC-SPAN
Updated: Views / Replies:50,153 / 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

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

Because of the CME's screwy idea of putting the files for December 31st in the following year's folder for 2014 & 2015 (2013 is OK), XLS-SPAN will not download those files.

Reply With Quote
 
  #402 (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
Because of the CME's screwy idea of putting the files for December 31st in the following year's folder for 2014 & 2015 (2013 is OK), XLS-SPAN will not download those files.

Try this:

Go into the Download module and find the Sub downloadRiskFile(targetDate)
Look down until you see the section 'download risk inside that sub

Replace:
Else:
If SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & namecme, path & "\" & namecme) = True Or _
SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & Left(dateit, 4) & "/" & namecme, path & "\" & namecme) = True Or _
SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & Left(dateit, 4) & "/" & Left(dateit, 6) & "/" & namecme, path & "\" & namecme) = True Then


with:
Else:
Dim dateyear As Double
dateyear = Left(dateit, 4)
If SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & namecme, path & "\" & namecme) = True Or _
SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & dateyear & "/" & namecme, path & "\" & namecme) = True Or _
SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & dateyear + 1 & "/" & namecme, path & "\" & namecme) = True Or _
SaveWebFile("ftp://ftp.cmegroup.com/pub/span/data/cme/" & dateyear & "/" & Left(dateit, 6) & "/" & namecme, path & "\" & namecme) = True Then

Reply With Quote
The following 2 users say Thank You to Dudetooth for this post:
 
  #403 (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


I have found a bug in the latest XLS-SPAN.

If I have an option or spread on Track and click on Select or Spread to get the data for the date in cell A1 and then I click on H-Track to do a Historic Track of the range of dates from the date in A1 to the date in D1, the results on HistData and Hist Pivot do not include the date in cell A1. They start with the next date.

If you are able to fix this, besides posting a fixed XLS-SPAN spreadsheet, please let us know what changes were made to the macros so we can make those changes rather than having to make all of our modifications to your fixed spreadsheet.

Reply With Quote
 
  #404 (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 have found a bug in the latest XLS-SPAN.

If I have an option or spread on Track and click on Select or Spread to get the data for the date in cell A1 and then I click on H-Track to do a Historic Track of the range of dates from the date in A1 to the date in D1, the results on HistData and Hist Pivot do not include the date in cell A1. They start with the next date.

Sorry for the late response.

It's actually not a bug, it was intentional coding. It was designed to prevent days with missing risk array files from being populated in the Hist_Data (i.e. weekends would show up as 3 consecutive days with the same data). It is comparing the DTE before and after it runs the TrackSelect code for that day. If the DTE is the same it is considering the risk arrays to be missing and prevents a rewrite of the data. If the DTE is different then it is new data and it is copied to Hist_Data.

To get all of your dates when running H-Track:
1) Fill in your option or spread on the Track tab and have your start date in A1 and end date in D1 ... just as normal.
2) If you are tracking a spread add a matching number in S1 column for all legs of that spread.
3) Highlight all options you want to historically track (it can be a mix of spreads an single options).
4) Then instead of clicking Select or Spread to get the first day's data, just click H-Track and the first date will be included in the results. H-Track was designed to run without having to prime the pump with the first day's data.

Hope this helps.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #405 (permalink)
Trading Apprentice
Singapore + Singapore
 
Futures Experience: Beginner
Platform: Zaner360
Broker/Data: DeCarley/Gain
Favorite Futures: Selling options on commodities futures
 
Posts: 12 since Nov 2015
Thanks: 9 given, 2 received

Hi Dudetooth,

Fantastic program. I'm in awe of your programming skills and your generosity in sharing this with the forum.

I have a question if you don't mind.

I managed to get the XLS-SPAN (05a) to work.

The Download and Run macro buttons work beautifully as does the Select macro.

1. In the Track worksheet, I input today's date into cells A1 and D1, before running the Select macro, which populates the necessary data, other than the record-keeping columns.

How to do I populate the record-keeping columns (e.g. Entry Date, Entry DTE, etc.) with my existing portfolio (with positions being entered at different dates) and still get the select button to work. Everytime I key directly into the white cells (e.g. column I) before the Entry Date, the program bugs out on me with a "Run-time Error 6: Oveflow". I'm guessing it's because I can only key into the green cells, but I can't seem to find where I can enter these record-keeping data.

I ran the Entry Values macro, and it populates with today's start date. However, it doesn't seem to allow me to enter earlier dates. Is it because I need to download the risk arrays starting from my entry dates until todate?

Question is how can I populate the entry data for my existing portfolio (positions opened at different dates) and get the Select and Entry values macros to work?

2. Secondly, the All macro doesn't seem to work for me. I get a "Compile error: File or sub function not defined:"

Sorry for asking what must seem to be a noob question, but I've spent the past few hours trying to get this to work with no success.


Many thanks!

Cheers,
K

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

@keong,

I'll try to troubleshoot your issue and give you a few pointers as well:


keong View Post
In the Track worksheet, I input today's date into cells A1 and D1 ...

A1 is the start date and D1 the end date if you are doing multiple dates, like Historic (H-Track or H-Scan) or multiple downloads. If you are just doing a single day Track, Scan or Download you only need a value in A1.


keong View Post
How to do I populate the record-keeping columns (e.g. Entry Date, Entry DTE, etc.) with my existing portfolio (with positions being entered at different dates) and still get the select button to work. Everytime I key directly into the white cells (e.g. column I) before the Entry Date, the program bugs out on me with a "Run-time Error 6: Oveflow". I'm guessing it's because I can only key into the green cells, but I can't seem to find where I can enter these record-keeping data.

The routine Entry Values is using the current date (A1) to calculate and the record that as the first day's data (any column header with Entry in the name). So to set up your portfolio correctly you will need the date you entered the trade in A1, highlight a cell in the row of the option position(s) you entered that day and then click Entry Values. It will crunch the numbers and transfer data to the Entry columns. Typically you only change values in green cells ... you shouldn't have to change anything in the white cells unless the actual price you got for your option is different than the closing price (recorded as Entry Price).


keong View Post
I ran the Entry Values macro, and it populates with today's start date. However, it doesn't seem to allow me to enter earlier dates. Is it because I need to download the risk arrays starting from my entry dates until todate?

Yes. If you put the oldest date you need in A1 and the most recent date in D1 and click Download it will download all of the risk files in that date range.


keong View Post
2. Secondly, the All macro doesn't seem to work for me. I get a "Compile error: File or sub function not defined:"

I had a bit of a coding error there when I adapted that part of the code into this spreadsheet ... you're the first to find this issue. I'm not sure how familiar you are with VBA, so I'll try to walk you through the fix.
1) Press Alt+F11 to open the Marco Editor
2) In the left panel click + next to Modules to see all of them
3) Double-click on the Track module ... that modules code should appear in the main panel to the right
4) Scroll down to find a module with the first line that reads "Sub TrackAll()"
5) Replace all of that code for that module (down until you see "End Sub") with this code:

Sub TrackAll()
Dim rAll As Range, lastrow As Integer
If ActiveSheet.Name = "Track" Then
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
Set rAll = Range("A3:A" & lastrow)
rAll.Select

With InfoForm
.Caption = "Track All Options"
.tbInfo.Value = "Tracking All ..."
.Top = Int(((Application.Height / 2) + Application.Top) - (.Height / 2))
.Left = Int(((Application.Width / 2) + Application.Left) - (.Width / 2))
.Show vbModeless
End With
DoEvents

Call TrackSelect

Range("A1").Select

Else: Sheets("Track").Select
End If
End Sub


6) Save ... it should work now.

If that doesn't work, or if you have any issues with the fix let me know.

Reply With Quote
The following 2 users say Thank You to Dudetooth for this post:
 
  #407 (permalink)
Trading Apprentice
Singapore + Singapore
 
Futures Experience: Beginner
Platform: Zaner360
Broker/Data: DeCarley/Gain
Favorite Futures: Selling options on commodities futures
 
Posts: 12 since Nov 2015
Thanks: 9 given, 2 received

Hi Dudetooth,

Works like a charm now.

I noticed that the TrackAll windows doesn't close automatically after running the macro, so I added in an additional line into the TrackAllNow sub.

A bit of cosmetics but if I can save an extra click, that's one less click that I have to do...

Cheers and thanks so much for your kind help,
K

Sub trackAllNow(control As IRibbonControl)
With InfoForm
.Caption = "Track All Options"
.tbInfo.Value = "All options in 'Open' accounts being tracked ..."
.Top = Int(((Application.Height / 2) + Application.Top) - (.Height / 2))
.Left = Int(((Application.Width / 2) + Application.Left) - (.Width / 2))
.Show vbModeless
End With
DoEvents

Call TrackAll

With InfoForm
.Caption = "Track All Options"
.tbInfo.Value = "Tracking all 'Open' options complete."
.Top = Int(((Application.Height / 2) + Application.Top) - (.Height / 2))
.Left = Int(((Application.Width / 2) + Application.Left) - (.Width / 2))
.Show vbModeless
End With
DoEvents
Application.OnTime Now + TimeValue("00:00:02"), "killInfoForm"
End Sub

Reply With Quote
The following user says Thank You to keong for this post:
 
  #408 (permalink)
Trading Apprentice
Singapore + Singapore
 
Futures Experience: Beginner
Platform: Zaner360
Broker/Data: DeCarley/Gain
Favorite Futures: Selling options on commodities futures
 
Posts: 12 since Nov 2015
Thanks: 9 given, 2 received

Hi Dudetooth,

Now that I've managed to get the xls working (with your help), I ran the Track worksheet for 2 option positions, both singly and as a spread.

A. The IMs for the short position and the spread is correct (compared with the Zaner platform), however, I find that the long leg seems a little off. For e.g., on 20170113,

-1 OEW3J7 P1890 has an IM of 1102
-1 OEW3J7 P1890 +2 OEW3J7 P1675 has an IM of $297

However, the following long positions have IMs which differ slightly from Zaner platform.

+2 OEW3J7 P1675 has an IM of $205, compared to $200 on the Zaner platform.
+2 OESH7 P2025 has an IM of $570, compared to $0 on Zaner.

So now, I'm a little puzzled as to which is correct? Any thoughts?


B. Secondly, how do we enter in the Entry price (if different from the closing price) and have the Track worksheet calculate the Current ROI% and P/L? Will the macro automatically compute or do we have to manually enter in the formulas ourselves?

Looking forward to hearing from you.


Cheers,
K

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


keong View Post
However, the following long positions have IMs which differ slightly from Zaner platform.

+2 OEW3J7 P1675 has an IM of $205, compared to $200 on the Zaner platform.
+2 OESH7 P2025 has an IM of $570, compared to $0 on Zaner.

So now, I'm a little puzzled as to which is correct? Any thoughts?

IM for long options is kind of misleading, since there isn't any really. From CME:

For long option value (money you pay) we create a credit in the PC Span calculation and for short option value (money you collect) we create a debit. This way you are getting credit against the margin (span risk) calculation for the money that you have already paid out. Long option value is always greater than the span risk that is calculated because we understand that you cannot lose more than what you have paid for a long option. For a short option we create a debit because we want to make sure that you are keeping the premium for that option in the account until you unwind the position or it expires. In other words, a short option will also have additional margin that has to be posted that is not covered by the premium collected.

Normally, you will see that the IM calculated for a long option will be nearly identical to the value of the option.


keong View Post
B. Secondly, how do we enter in the Entry price (if different from the closing price) and have the Track worksheet calculate the Current ROI% and P/L? Will the macro automatically compute or do we have to manually enter in the formulas ourselves?

If you use the Entry Values macro to populate the Entry price and it is different that what you actually bought/sold the option, just make the change manually in the Entry Value column to reflect your price. From then on, when you use the Track Select/Spread/All it will calculate profit/loss based on that value.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #410 (permalink)
Trading Apprentice
Seattle, WA
 
Futures Experience: Beginner
Platform: TradeStation
Favorite Futures: Emini
 
Posts: 4 since Dec 2016
Thanks: 2 given, 0 received


Dudetooth,

I echo the praise of many before - amazing work on this tool and some mad VBA skills!!

I've been using Windows Task Scheduler to run a batch file that loads the risk file at the end of the day along with a position file (.pos) covering multiple accounts, exports the results in .xls and sends it out in an email.

This process is automatic but requires PC-SPAN to run.

It looks like it may be possible to open the .pos files in Excel as .xml and perhaps move the position info into your tool and get the summary data that way, sans PC-SPAN.

Does that sound feasible?

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:16 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-06-29 in 0.09 seconds with 19 queries on phoenix via your IP 54.80.248.78