PC-SPAN (Page 24) - 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,510 / 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 June 29th, 2014, 01:01 AM   #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
     

Old June 29th, 2014, 08:28 PM   #232 (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,904 received

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
     

Old June 29th, 2014, 09:21 PM   #233 (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



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:
     

Old June 30th, 2014, 12:12 AM   #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
     

Old July 1st, 2014, 11:42 PM   #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

Are you a NinjaTrader user?

 
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
     

Old July 1st, 2014, 11:48 PM   #236 (permalink)
Elite Member
Cleveland Ohio/United States
 
Futures Experience: Advanced
Platform: Tradestation
Broker/Data: various
Favorite Futures: futures
 
Posts: 2,195 since Jul 2012
Thanks: 1,004 given, 3,969 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
     

Old July 1st, 2014, 11:56 PM   #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
     

Old July 3rd, 2014, 02:48 AM   #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
     

Old July 3rd, 2014, 10:52 AM   #239 (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,904 received


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
     

Old July 3rd, 2014, 11:35 AM   #240 (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



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 > 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 04:39 AM.

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.14 seconds with 20 queries on phoenix via your IP 54.159.239.251