NexusFi: Find Your Edge


Home Menu

 





PC-SPAN


Discussion in Options

Updated
      Top Posters
    1. looks_one Dudetooth with 218 posts (213 thanks)
    2. looks_two ron99 with 116 posts (55 thanks)
    3. looks_3 CafeGrande with 30 posts (4 thanks)
    4. looks_4 BlueRoo with 24 posts (5 thanks)
      Best Posters
    1. looks_one Dudetooth with 1 thanks per post
    2. looks_two SMCJB with 1 thanks per post
    3. looks_3 ron99 with 0.5 thanks per post
    4. looks_4 BlueRoo with 0.2 thanks per post
    1. trending_up 188,759 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
 

PC-SPAN

 
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Dudetooth View Post
Can you give a few examples of options you were looking to calculate (month/strike)?

EW G4 ES H4 P 1600 -1
EW1G4 ES H4 P 1600 -1

OK I just got it to work by changing the Under Month to EW H4 or EW1H4 instead of ES H4.

Should it do that?

Started this thread

Can you help answer these questions
from other members on NexusFi?
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
ZombieSqueeze
Platforms and Indicators
Futures True Range Report
The Elite Circle
Exit Strategy
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
65 thanks
Funded Trader platforms
41 thanks
Battlestations: Show us your trading desks!
29 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
The Program
19 thanks

 
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785

I haven't downloaded v3 because it doesn't display SPAN IM.

Started this thread
 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274



ron99 View Post
EW G4 ES H4 P 1600 -1
EW1G4 ES H4 P 1600 -1

OK I just got it to work by changing the Under Month to EW H4 or EW1H4 instead of ES H4.

Should it do that?

The code is looking to the underlying contract when creating the search string. By changing to EWH4 the code goes to the EW section for creating the search string rather than the ES section.

If you add the following code under the ES section in the original code you could use 4 or 5 characters in column A (e.g. EWG4 or EW1G4 ... you'll still need EWH4 in column B) without changing any other code and it should calculate properly:

ElseIf con1 = "EW" Then
If Len(c1) = 5 Then
str1 = "CME" & Left(c1, 3) & " ES OOF" & cp1
strSearch4 = "B CME" & Left(c1, 3) & " OOF201" & yr1 & umo1 & " 201" & yr2 & omo1
Else:
str1 = "CMEEW ES OOF" & cp1
strSearch4 = "B CMEEW OOF201" & yr1 & umo1 & " 201" & yr2 & omo1
End If
str1 = str1 & "201" & yr1 & umo1 & " 201" & yr2 & omo1
strSearch = str1 & " " & Application.WorksheetFunction.Text(stk1, "0000000")
strSearch2 = "3 SP"
strSearch3 = "4 SP"
imm2 = 1
v1 = 0.5

There are 7 spaces between " and ES in the 3rd line ... spaces stripped when posted.

To get the correct expiration date you'll have to change the strSearch4 as well. Code above is one way to do it.

Thanked by:
 
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785


Dudetooth View Post
Here's the latest spreadsheet (v3) with a few updates (just in time for the Holidays):

As usual, please let me know if you find any issues and I will try to get them fixed.

Thanks. I got it converted for my needs. I wish I had marked the all the changes I made in the code of v2.

In the Sub SpreadRisk() it doesn't check cell O2 to get the excess factor for ROI. Calc Risk does do that.

Started this thread
Thanked by:
 
 ron99 
Cleveland, OH
 
Experience: Advanced
Platform: QST
Broker: QST, DeCarley Trading, Gain
Trading: Options on Futures
Posts: 3,081 since Jul 2011
Thanks Given: 980
Thanks Received: 5,785

Dudetooth, your v3 fixed the milk contract option value being wrong for options that settled at cabinet. It was showing 100 and now it correctly shows 10.

Thanks.

Started this thread
 
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274

No problem ... after you posted the link that detailed the Type 8 records I realized I didn't read it through as thoroughly as I should have, so I went back trough the code to see what I could extract from the risk arrays rather than trying to calculate trying to speed things up ... cabinet values happened to be some of the data it grabs now.

 
 mu2pilot 
Dallas, TX
 
Experience: Advanced
Platform: T4, Zaner360, TOS
Broker: DeCarley Trading
Trading: Options
Posts: 104 since Sep 2013
Thanks Given: 134
Thanks Received: 52


Dudetooth View Post
No problem ... after you posted the link that detailed the Type 8 records I realized I didn't read it through as thoroughly as I should have, so I went back trough the code to see what I could extract from the risk arrays rather than trying to calculate trying to speed things up ... cabinet values happened to be some of the data it grabs now.

Dudetooth, you mention speeding things up. I was under the impression that the file read access was the bottleneck in the calc process. Sequentially searching thru 500k lines of text is a slow process. I've looked at pulling the span files into a sql db and querying it to speed up the process and may do that at some point, but I've got other project to do before that.

mu2pilot

 
 kevinkdog   is a Vendor
 
Posts: 3,645 since Jul 2012
Thanks Given: 1,890
Thanks Received: 7,338


mu2pilot View Post
Dudetooth, you mention speeding things up. I was under the impression that the file read access was the bottleneck in the calc process. Sequentially searching thru 500k lines of text is a slow process. I've looked at pulling the span files into a sql db and querying it to speed up the process and may do that at some point, but I've got other project to do before that.

mu2pilot

I have a 2 year old PC, and I am able to run through about 3700 options in an hour. One thing I did to speed it up was add a "pre-processor" - since I am only interested in options with delta < .05, I skip any that will be above this criteria. Cuts the time required by about 66%.

Thanks again to @Dudetooth for this incredible tool. I am rarely wowed by free stuff, but his spreadsheet has improved my decision making by a ton:

Before I started using his spreadsheet, I had to manually hunt and peck for options to sell. My median ROI for those trades was 4.0%. I considered that pretty good.

Now, with the spreadsheet, I can find many higher quality options. Since I started using dude's spreadsheet, my median ROI has gone up to 5.5%!!!!!! I know it is because it is easier now to find the right options.

/end of unpaid testimonial

Follow me on Twitter
 
 mu2pilot 
Dallas, TX
 
Experience: Advanced
Platform: T4, Zaner360, TOS
Broker: DeCarley Trading
Trading: Options
Posts: 104 since Sep 2013
Thanks Given: 134
Thanks Received: 52


kevinkdog View Post
I have a 2 year old PC, and I am able to run through about 3700 options in an hour. One thing I did to speed it up was add a "pre-processor" - since I am only interested in options with delta < .05, I skip any that will be above this criteria. Cuts the time required by about 66%.

Thanks again to @Dudetooth for this incredible tool. I am rarely wowed by free stuff, but his spreadsheet has improved my decision making by a ton:

Before I started using his spreadsheet, I had to manually hunt and peck for options to sell. My median ROI for those trades was 4.0%. I considered that pretty good.

Now, with the spreadsheet, I can find many higher quality options. Since I started using dude's spreadsheet, my median ROI has gone up to 5.5%!!!!!! I know it is because it is easier now to find the right options.

/end of unpaid testimonial

I agree 100%. My post was in no way meant to be a criticism of what Dudetooth has created. It is a GREAT RESOURCE. I hope to help make it even better.

 
 kevinkdog   is a Vendor
 
Posts: 3,645 since Jul 2012
Thanks Given: 1,890
Thanks Received: 7,338



mu2pilot View Post
I agree 100%. My post was in no way meant to be a criticism of what Dudetooth has created. It is a GREAT RESOURCE. I hope to help make it even better.

Sorry, I did not think you were criticizing his work. Faster is always better, and a database may be the way to go. I wish I was able to do that - that's why I had to pre-process instead.

Follow me on Twitter
Thanked by:

 




Last Updated on September 23, 2021


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts