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


PC-SPAN
Started: by ron99 Views / Replies:43,076 / 413
Last Reply: 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

  #231 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 189 since Jan 2014
Thanks: 108 given, 171 received


Griffith View Post
Man, this looks cool, but I've spent a couple hours and I just cant get it to work.

After pressing "Download Risk Arrays" i'm just not getting anything in my destination folder.

Any ideas?


Did you double check to make sure the date is correct? It has to be in this format: 20140627

That's Friday. As far as I know, it won't pull in the closest business day, so you have to be precise.

If the download happens, you still won't see any data in Excel's "scanner" tab unless you select one or more (or all) commodities to scan.

You won't see any data in the "tracker" tab unless you've entered the data for one or more options in columns A-E. When you "track all" or "track select" it will then populate columns H-AD. Note: you can hide some of the columns in the H-AD range, if you don't use them.


Last edited by CafeGrande; June 29th, 2014 at 01:07 AM.
Reply With Quote
 
  #232 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,374 since Jul 2011
Thanks: 650 given, 4,029 received
Forum Reputation: Legendary

Anybody have an easy way to enter the Trade Dates on the Historic page? Column A. I have been hand typing them in.

Reply With Quote
 
  #233 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 183 since Sep 2012
Thanks: 25 given, 205 received



ron99 View Post
Anybody have an easy way to enter the Trade Dates on the Historic page? Column A. I have been hand typing them in.

This will list every pa2 file in your data folder in column A:

Sub ListPA2Files()
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim ws As Worksheet

Set objFSO = CreateObject("Scripting.FileSystemObject")
'Set ws = Worksheets.Add
Sheets("Historic").Select

'Get the folder object associated with the directory
Set objFolder = objFSO.GetFolder("C:\Span4\Data\")
'ws.Cells(1, 1).Value = "The files found in " & objFolder.Name & " are:"

'Loop through the Files collection
x = 5
For Each objFile In objFolder.Files
If InStr(objFile.Name, "cme") > 0 And InStr(objFile.Name, ".pa2") > 14 Then
x = x + 1
ws.Cells(x, 1).value = Mid(objFile.Name, 5, 8)
End If
Next

'Clean up!
Set objFolder = Nothing
Set objFile = Nothing
Set objFSO = Nothing
End Sub


You could add something like this to the bottom of the download_risk_files routine to add the date every time you download a new pa2:

Range("Historic!A" & lastdate + 1) = CStr(Range("Scanner!G1"))

Hope this helps.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
  #234 (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
This will list every pa2 file in your data folder in column A:

Sub ListPA2Files()
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim ws As Worksheet

Set objFSO = CreateObject("Scripting.FileSystemObject")
'Set ws = Worksheets.Add
Sheets("Historic").Select

'Get the folder object associated with the directory
Set objFolder = objFSO.GetFolder("C:\Span4\Data\")
'ws.Cells(1, 1).Value = "The files found in " & objFolder.Name & " are:"

'Loop through the Files collection
x = 5
For Each objFile In objFolder.Files
If InStr(objFile.Name, "cme") > 0 And InStr(objFile.Name, ".pa2") > 14 Then
x = x + 1
ws.Cells(x, 1).value = Mid(objFile.Name, 5, 8)
End If
Next

'Clean up!
Set objFolder = Nothing
Set objFile = Nothing
Set objFSO = Nothing
End Sub


You could add something like this to the bottom of the download_risk_files routine to add the date every time you download a new pa2:

Range("Historic!A" & lastdate + 1) = CStr(Range("Scanner!G1"))

Hope this helps.

Look at you and your tight object oriented code!

Reply With Quote
 
  #235 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 189 since Jan 2014
Thanks: 108 given, 171 received

An incomplete download?

Futures Edge on FIO
For the first time, the two daily files are not downloading and unzipping/extracting themselves. I thought it might be "my" version of PC-SPAN so I downloaded a fresh copy from the first page of this thread and the same thing happened.

Here's what theSPAN data folder looks like today. Note the CME file is not unzipped and it looks like the ICE file was not downloaded at all.

FWIW, I deleted the zipped CME file and tried again for 20140701 ... same result.

Attached Thumbnails
PC-SPAN-span.png  
Reply With Quote
 
  #236 (permalink)
Elite Member
Cleveland Ohio/United States
 
Futures Experience: Advanced
Platform: Tradestation
Broker/Data: various
Favorite Futures: futures
 
Posts: 2,212 since Jul 2012
Thanks: 1,010 given, 4,017 received


CafeGrande View Post
For the first time, the two daily files are not downloading and unzipping/extracting themselves. I thought it might be "my" version of PC-SPAN so I downloaded a fresh copy from the first page of this thread and the same thing happened.

Here's what theSPAN data folder looks like today. Note the CME file is not unzipped and it looks like the ICE file was not downloaded at all.

FWIW, I deleted the zipped CME file and tried again for 20140701 ... same result.

I had no problem today. Maybe just manually unzip the cme file, and grab the ice file from the ftp site, and manually unzip that too, and try again tomorrow.

Maybe you have a hard disk issue (hard disk out of space, for example)?

If you have any questions please send me a Private Message or use the futures.io "Ask Me Anything" thread
Reply With Quote
 
  #237 (permalink)
Trading for Fun
St Paul, MN, USA
 
Futures Experience: Advanced
Platform: Abacus
Broker/Data: RJO, Interactive Brokers
Favorite Futures: Commodity Futures & Options
 
Posts: 189 since Jan 2014
Thanks: 108 given, 171 received

Well, whaddya know. A complete shut-down and reboot and now it works fine.

I'll leave the post up in case someone has a similar problem in the future.

The puzzling thing was the partial download over a couple of instances ... computers can make you crazy.


Last edited by CafeGrande; July 2nd, 2014 at 12:03 AM.
Reply With Quote
 
  #238 (permalink)
Trading for Fun
Brisbane, Queensland, Australia
 
Futures Experience: Intermediate
Platform: OX, Z360, Excel
Broker/Data: DeCarley
Favorite Futures: Futures and Future Options
 
Posts: 121 since Aug 2013
Thanks: 75 given, 96 received

Adding Greeks and Aggregate Greeks

CafeGrande,

I have been working on this in a number of different ways. I currently have the track sheet working in a category or group manner. See the screen shot below. The groups here a based different accounts, candidate selection and trade execution.

Considering the Ib risk naviagator I am thinking that such groups could be at a product level or at a product contract. For example; Soyabeans or Soyabeans July and Soyabeans August.

It occurs to me that you may wish to manage the greeks for different months differently. So to lump a trade you have in july with a trade you have in August would be unhelpful.

Thinking about how we can create a portfolio sheet with greeks and portfolio margin with profit/loss should not be too difficult but just getting the structure of the idea right first may be very helpful.

Any ideas or suggestions that you have would be appreciated.

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

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


Dudetooth View Post
You could add something like this to the bottom of the download_risk_files routine to add the date every time you download a new pa2:

Range("Historic!A" & lastdate + 1) = CStr(Range("Scanner!G1"))

Hope this helps.

I added this but it doesn't work for me. Can you explain lastdate in that line? My column A is formatted as text. The dates are in the 20140702 format as text not dates.

Reply With Quote
 
  #240 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 183 since Sep 2012
Thanks: 25 given, 205 received



ron99 View Post
I added this but it doesn't work for me. Can you explain lastdate in that line?

Sorry, it should make more sense if you see it in the entire routine. Here's my sub for downloading the pa2 files ... the last block of code adds the new date if it doesn't already exist.

Sub download_risk_files()
On Error GoTo GetOut
Dim RetVal
Dim Batchfile As String
Dim path As String
Dim dateit As Double
Dim namecme As String, namenyb As String
Wait.Show vbModeless
DoEvents
dateit = Range("Scanner!G1").value
namecme = "cme." & dateit & ".s.pa2.zip"
namenyb = "nyb." & dateit & ".s.pa2.zip"
path = Range("Setup!A5").value '"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 'delete zipped risk arrays
Kill path & "\" & namenyb
Kill path & "\cme.s.pa2" '140215*** added update to cme/nyb file
Kill path & "\nyb.s.pa2"
FileCopy path & "\" & Left(namecme, Len(namecme) - 4), path & "\cme.s.pa2"
FileCopy path & "\" & Left(namenyb, Len(namenyb) - 4), path & "\nyb.s.pa2"

If Range("Setup!A18") = "Delete Dates" Then
If Dir(path & "\cme.s.pa2") <> "" Then 'delete old pa2 files if they exist
Kill path & "\cme.s.pa2" 'delete old pa2 files
End If
If Dir(path & "\nyb.s.pa2") <> "" Then 'delete old pa2 files if they exist
Kill path & "\nyb.s.pa2"
End If
Name path & "\" & "cme." & dateit & ".s.pa2" As path & "\cme.s.pa2"
Name path & "\" & "nyb." & dateit & ".s.pa2" As path & "\nyb.s.pa2"
End If

lastdate = Range("Historic!A" & Rows.Count).End(xlUp).Row '140222*** add dates to hist when downloading new pa2
Dim rng1 As Range
Dim strSearch As String
strSearch = dateit
Set rng1 = Range("A6:A" & lastdate).Find(strSearch, , xlValues, xlWhole)
If rng1 Is Nothing Then
Range("Historic!A" & lastdate + 1) = CStr(Range("Scanner!G1"))
End If

GetOut:
Unload Wait
End Sub

Reply With Quote
The following user says Thank You to Dudetooth for this post:

Reply



futures.io > > > > PC-SPAN

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

2016 True Edge Awards: Voting is open until Jan 21!

Now
 

An Afternoon with FIO member Massive l

Elite only
 

Anthony Drager: Pulling the trigger with confidence

Elite only
 

Leo Murphy: The Art and Science of Technical Analysis

Elite only
 

FuturesTrader71: Ask Me Anything

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 08:25 PM.

no new posts
Page generated 2017-01-18 in 0.15 seconds with 21 queries on phoenix via your IP 184.73.21.101