PC-SPAN (Page 19) - 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,568 / 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 March 15th, 2014, 03:00 PM   #181 (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

PC Span Gaps

Can someone tell me why numerous options have gaps in the strike prices listed in PC SPAN? For example, SBM4 Call Options. Above 21, there are only 2 options that show a SPAN entry and SPAN margin. The highest entry is 22 and it has a Delta of 5.82% (as of 3/14). I would think with the way Sugar has been moving there would be a lot of more activity on the Call side. Is it because there is no Open Interest?

On the put side, Span entries seem to correspond to only those strike prices that have Open Interest. Does SPAN only provide data for instruments that have Open Interest?

TIA.

Reply With Quote
     

Old March 15th, 2014, 03:02 PM   #182 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,327 since Jul 2011
Thanks: 634 given, 3,905 received


mu2pilot View Post
Can someone tell me why numerous options have gaps in the strike prices listed in PC SPAN? For example, SBM4 Call Options. Above 21, there are only 2 options that show a SPAN entry and SPAN margin. The highest entry is 22 and it has a Delta of 5.82% (as of 3/14). I would think with the way Sugar has been moving there would be a lot of more activity on the Call side. Is it because there is no Open Interest?

On the put side, Span entries seem to correspond to only those strike prices that have Open Interest. Does SPAN only provide data for instruments that have Open Interest?

TIA.

Yes

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

Old March 15th, 2014, 03:27 PM   #183 (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



ron99 View Post
Yes

How do you compute an expected ROI in such cases? Don't you sometimes sell options where you make up the entire OI? I sold 40 EW4H4 1420 Puts and I still make up all the OI. I don't remember how I came up with an expected ROI, but I know I wouldn't have entered it without something to go on. In cases where there is no OI in option/strike combinations near where you want to trade, how do you do the math?

Reply With Quote
     

Old March 15th, 2014, 03:44 PM   #184 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,327 since Jul 2011
Thanks: 634 given, 3,905 received


mu2pilot View Post
How do you compute an expected ROI in such cases? Don't you sometimes sell options where you make up the entire OI? I sold 40 EW4H4 1420 Puts and I still make up all the OI. I don't remember how I came up with an expected ROI, but I know I wouldn't have entered it without something to go on. In cases where there is no OI in option/strike combinations near where you want to trade, how do you do the math?

I believe SPAN is calculated for all ES/EW contracts even without OI.

For example the ESk4p900 has zero OI but it does have a SPAN margin.

There usually are strikes close by to where I am trading. I don't think I have done an option when there wasn't.

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

Old May 7th, 2014, 09:47 PM   #185 (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

Date Range for Historic

Futures Edge on FIO

Are you a NinjaTrader user?

 
I don't know why but I could not get "Begin + Days" or "Begin - End" to fill the F Column with dates.

So I changed the procedure as follows:

Sub ChangeDate2() '140206*** New date tool for Historic tab
Dim startDate, endDate As Date
On Error GoTo GetOut
If ActiveSheet.Name = "Historic" Then

DefaultDate = Range("F3")
DefaultDate2 = Range("F3")
startDate = InputBox("Enter Beginning Date DD/MM/YYYY", "Beginning Date", DefaultDate)
endDate = InputBox("Enter Ending Date DD/MM/YYYY", "Ending Date", DefaultDate2)

lastrow = Range("F" & Rows.Count).End(xlUp).Row
Range("F3:F" & lastrow).ClearContents

dayDate = startDate
fRow = 3
Do Until dayDate = DateAdd("d", 1, endDate)

Range("F" & fRow) = Format(dayDate, "YYYY") & Format(dayDate, "MM") & Format(dayDate, "DD")



dayDate = DateAdd("d", 1, dayDate)
fRow = fRow + 1
Loop

End If
GetOut:
End Sub

Reply With Quote
     

Old May 8th, 2014, 07:52 AM   #186 (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


BlueRoo View Post
I don't know why but I could not get "Begin + Days" or "Begin - End" to fill the F Column with dates.

I'm not sure which version you have, and I have been making some minor tweaks on mine since the last release, so I have attached the code I've been using that works in my spreadsheet.

One thing that I noticed is that you have removed any reference to Col A on the Historic tab. Starting at A6 I have the available dates that I have SPAN files for in my C:\Span4\Data folder (skipping weekends, holidays). The code was designed to simply gather those dates from Col A to copy over to Col F.

Hope this helps.

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

Attached Files
Register to download File Type: txt ChangeDates.txt (2.1 KB, 7 views)
Reply With Quote
     

Old May 8th, 2014, 12:22 PM   #187 (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


Dudetooth View Post
I'm not sure which version you have, and I have been making some minor tweaks on mine since the last release, so I have attached the code I've been using that works in my spreadsheet.

One thing that I noticed is that you have removed any reference to Col A on the Historic tab. Starting at A6 I have the available dates that I have SPAN files for in my C:\Span4\Data folder (skipping weekends, holidays). The code was designed to simply gather those dates from Col A to copy over to Col F.

Hope this helps.

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


Yes it helps. As I download risk files my list of previous downloaded dates update. I have not coded it so that the user is informed whether or not the selected date range is within that of the downloaded history. I have started to code a data archive report that would present the user with a date range (with any missing dates within) for the downloaded risk files. I see now that F3 needs to have a date for the changedate code to work. I am working on the idea that:

1. The user needs to know the date range of the risk files downloaded to their nominated directory.
2. That a current list of downloaded dates for say the last 30 days is updated as each download occurrs.
3. That selection of any date range utilises the previous knowledge to inform the user if the selected date range is not represented by the risk files downloaded.

Where am I going with this...

1. I am using the XLS SPAN file within a "Shell" file I have been using to do option analysis.
2. I am interested in time series analysis and charting option prices, volatility and delta for 90 DTE to Expiry.

Reply With Quote
     

Old May 8th, 2014, 01:10 PM   #188 (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


BlueRoo View Post
1. The user needs to know the date range of the risk files downloaded to their nominated directory.
2. That a current list of downloaded dates for say the last 30 days is updated as each download occurrs.
3. That selection of any date range utilises the previous knowledge to inform the user if the selected date range is not represented by the risk files downloaded.

-Once the dates are in Col A things have been working fine for me. The date in cell C5 is the last date in Col A, giving me the range of dates available. The issue would seem to be getting the initial listing of SPAN files in your C:\Span4\Data folder.

-One possible solution would be to have a macro that could query your C:\Span4\Data folder to grab the name of each SPAN file to populate the dates in Col A. Each time you download a SPAN file the code can add that date to the end of the list.

-The code is currently set so that if there isn't an exact match for the date you entered it will grab the next closest date. That way you don't have to look at a calendar to ensure you aren't trying a weekend.

Reply With Quote
     

Old May 8th, 2014, 02:41 PM   #189 (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

Function that collects the date range for saved risk files

I have this code in my shell file. When I choose to set a date range for generate historic data, the getRiskFileDates returns the date range for saved risk files.




Function getRiskFileDates()
Set p = Workbooks("OptionAnalysis.xls").Sheets("Parameters")

With Application.FileSearch
.LookIn = "M:\Trading\Data\CME SPAN\RiskArrays\"
.SearchSubFolders = False
.Filename = "cme*.pa2"
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderAscending) > 0 Then
numberOfFiles = .FoundFiles.Count
For i = 1 To .FoundFiles.Count
'MsgBox .FoundFiles.Count
Filename = .FoundFiles(i)
Length = Len(.FoundFiles(i))
dateInFileName = Mid(.FoundFiles(i), 41, 8) '.Filename

If i = 1 Then
startDate = convertDateCodeToDateProper(dateInFileName)
ElseIf i = numberOfFiles Then
endDate = convertDateCodeToDateProper(dateInFileName)
getRiskFileDates = startDate & " - " & endDate
End If

Next i
Else
MsgBox "There were no files found."
End If
End With
Continue:

End Function

Reply With Quote
     

Old May 9th, 2014, 03:24 AM   #190 (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

Updating all spreads in tracker with one click


Selecting track spread allows the user to select the two legs of a spread through input boxes and then calculates the combined result. If there are several spreads in tracker it seems that this manual selection needs to be done for each one for the results of each spread to be updated. Here is some simple code that could automate this process by a single click.

The issue is that the calMargin code in XLS SPAN consistently seems to change the spread number of the last spread in Col F.

May I suggest that some type of automation as follows is added to the file and the issue of the renumbering of the last spread is addressed.

Private Sub cbTrackAllSpreads_Click()
Set t = Workbooks("OptionAnalysis.xls").Sheets("Tracker")
tRow = 3
Do Until t.Range("A" & tRow) = ""
If t.Range("F" & tRow) <> "" Then
If t.Range("F" & tRow) = t.Range("F" & tRow + 1) Then
putrow = tRow
callrow = tRow + 1
Range("A" & putrow & ",A" & callrow).Select
Call CalcMargin(3, 0)
tRow = tRow + 1
End If
End If
tRow = tRow + 1
Loop
End Sub

Reply With Quote
     

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)
 

Al Brooks: Stop Losing when a Good Trade goes Bad, Correcting Mistakes

Elite only
 

Trading Technologies: ADL hands-on

Dec 13

Normal webinar schedule resumes after the holidays

January

Ernie Chan: Risk Management

Elite only

Dedicated Trading Servers: Advantages/Disadvantages w/sam028

Elite only

An Afternoon with FIO member Massive I

Elite only

Leo Murphy: 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 05:36 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-09 in 0.16 seconds with 20 queries on phoenix via your IP 54.163.94.5