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


PC-SPAN
Updated: Views / Replies:50,936 / 478
Created: by ron99 Attachments:113

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

PC-SPAN

  #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
 
  #182 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,648 since Jul 2011
Thanks: 766 given, 4,567 received
Forum Reputation: Legendary


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:
 
  #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
 
  #184 (permalink)
Market Wizard
Cleveland, OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,648 since Jul 2011
Thanks: 766 given, 4,567 received
Forum Reputation: Legendary


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:
 
  #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

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
 
  #186 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 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
 
  #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
 
  #188 (permalink)
Elite Member
Steubenville Ohio
 
Futures Experience: Intermediate
Platform: OX, OEC, RJO
Favorite Futures: Options on Futures
 
Posts: 214 since Sep 2012
Thanks: 26 given, 240 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
 
  #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
 
  #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 > > > > 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
 

An Afternoon with FIO member Softsoap

Elite only

Battlestations: Show us your trading desks and win $750 in prizes

August
 

Extended Ask Me Anything w/Brett Steenbarger

Elite only

Prototyping Python Strategies (part 3) w/Ran Aroussi

Elite only

Brannigan Barrett w/Axia Futures

Elite only

Introduction to Phillip Capital futures brokerage services

Aug TBD

How Monte Carlo Analysis Can Help Your Trading w/Kevin Davey

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 11:03 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-07-20 in 0.07 seconds with 19 queries on phoenix via your IP 54.158.198.141