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,781 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
Search this Thread

PC-SPAN

  #381 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


woodward View Post
In that case, @Dudetooth or anyone else, if you have any quick and ready insights into the mysterious format that you'd be willing to share, it would be appreciated. I can always comb through your code but having the CME file formats on hand made everything so snappy.

Just out of curiosity, this thread goes back a while, after ICE raised its rates, @ron99 was skeptical in post #370 about anyone continuing to trade their instruments. How is that playing out?

This is what I used to figure out their format: SPAN for ICE

Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Deepmoney LLM
Elite Quantitative GenAI/LLM
Exit Strategy
NinjaTrader
Futures True Range Report
The Elite Circle
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
ZombieSqueeze
Platforms and Indicators
 
  #382 (permalink)
woodward
Seoul Korea
 
Posts: 4 since Apr 2016
Thanks Given: 7
Thanks Received: 6


Dudetooth View Post
This is what I used to figure out their format: SPAN for ICE

The @Dudetooth abides! Exactly what I was hoping for. Enormous respect for your work and everything you've contributed.

Reply With Quote
Thanked by:
  #383 (permalink)
 Jerard 
Ukraine
 
Experience: Beginner
Platform: Zaner360
Trading: Options on futures
Posts: 14 since May 2015
Thanks Given: 119
Thanks Received: 6


Hi All!

First of all, thanks @Dudetooth for a great spreadsheet. This is a work of art, it helps a lot.

I am trying to figure out how to estimate the initial margin for ES spread, but can't figure out how to do it in the spreadsheet . I am using a @ron99 version of the PC-Span spreadsheet.

My steps:

1. Choose two strikes from the "Scanner"
2. Click send to the tracker
3.Highlight two rows with both strikes
4. Attach the same number under S1 column, e.g 1 on both
5. Press track spread

I have had few attempts to estimate the initial margin for the following contracts in the spreadsheet:

Sell -1 ESZ6 P1660 4.98 delta
Buy +2 ESZ6 P1410 1.53 delta

I have got $210 as for initial margin per one spread as for August 2, 2016.

I have 20160802 in both cells designed to track historic data.

Secondly, i have downloaded a Ron's version of a PC-Span spreadsheet where ES-mini Weekly Options are included in "required format" list by defaultt, although what symbols should i type in the scanner paget so that it would scan a ES-mini weekly options?

I am typing

Futures month: EW3
Min DTE:20
Max DTE:140
Min value: $20
Max Delta: 10
Min ROI: 2%

I am looking for EW3V6 option ( expires on 31 October 2016 )

Eventually, the result would not come up?
Am i doing something wrong here?

Many thanks, Jerard

Reply With Quote
  #384 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


Jerard View Post
I have had few attempts to estimate the initial margin for the following contracts in the spreadsheet:

Sell -1 ESZ6 P1660 4.98 delta
Buy +2 ESZ6 P1410 1.53 delta

I have got $210 as for initial margin per one spread as for August 2, 2016.

I am getting $210 for the spread's IM as well.


Jerard View Post
I am looking for EW3V6 option ( expires on 31 October 2016 )

Are you looking to scan for EW3V6 options are you looking to find a particular one? I don't have Ron's version handy, but I believe that there is a cell for a date on the Scan tab as well ... if you are scanning and you don't have that date correct you might not get what you are looking for.

Reply With Quote
  #385 (permalink)
 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


Jerard View Post
Secondly, i have downloaded a Ron's version of a PC-Span spreadsheet where ES-mini Weekly Options are included in "required format" list by defaultt, although what symbols should i type in the scanner paget so that it would scan a ES-mini weekly options?

I am typing

Futures month: EW3
Min DTE:20
Max DTE:140
Min value: $20
Max Delta: 10
Min ROI: 2%

I am looking for EW3V6 option ( expires on 31 October 2016 )

Eventually, the result would not come up?
Am i doing something wrong here?

Many thanks, Jerard

Did you get any options? I did it using your parameters and I only got 5 options. EW3V6 1880-1900. That was because all lower strikes were lower than 2% ROI.

Lower your Min ROI and you will get more options.

Also make sure you have 20160802 in cell G1.

The Futures symbol (column A) would need to be EW3.

Started this thread Reply With Quote
  #386 (permalink)
 Jerard 
Ukraine
 
Experience: Beginner
Platform: Zaner360
Trading: Options on futures
Posts: 14 since May 2015
Thanks Given: 119
Thanks Received: 6

Futures are lower today. Zaner360 margin calculator showed me a $361 for this spread. I have heard that margin calculators ,and in particular on Zaner360, are not the most accurate to estimate the initial margin, however i'm really curios if margin increased from yesterday settlement more than 1.5 times...

Well, i am literally typing EW1 in scanner. I have added all of EW symbols ( e.g. EW1- EW4 )... and it worked. I am guessing i have typed something else out there.

Reply With Quote
  #387 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


Jerard View Post
Futures are lower today. Zaner360 margin calculator showed me a $361 for this spread. I have heard that margin calculators ,and in particular on Zaner360, are not the most accurate to estimate the initial margin, however i'm really curios if margin increased from yesterday settlement more than 1.5 times...

Some brokerages charge SPAN IM + the value of the position, or Total IM. Yesterday's Total IM for that spread was $340 ($210 SPAN IM + $130 value of spread).

Reply With Quote
Thanked by:
  #388 (permalink)
 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

This is what I just got for that spread using Zaner360






I get 204.60 for IM. So if you add the 204.60 plus the option value of 57.50 you get 262.10. So Zaner includes the option value in the IM.

Started this thread Reply With Quote
Thanked by:
  #389 (permalink)
 Jerard 
Ukraine
 
Experience: Beginner
Platform: Zaner360
Trading: Options on futures
Posts: 14 since May 2015
Thanks Given: 119
Thanks Received: 6


ron99 View Post
This is what I just got for that spread using Zaner360






I get 204.60 for IM. So if you add the 204.60 plus the option value of 57.50 you get 262.10. So Zaner includes the option value in the IM.

The margin i have got from Zaner360 is based on the contract that expires on 16 December. The margin i was referring to is not for EW3 options, but for ESZ6 contract.

Currently for the spread -1 OESZ6 P1660 and +2 OESZ6 P1410 the initial margin is $340. Net option value is $130 respectively. Therefore the spreadsheet shows a SPAN margin $210,less net option value.


You asked what options did i get from the spreadsheet.
The thing is, i am only getting EW1 and EW4 options. I have neither EW2 nor EW3 options. I don't know why is that.

I can not make a screenshot since i am using windows on a Mac and there is no PrtScreen button on the keyboard.

Reply With Quote
  #390 (permalink)
 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



Jerard View Post
The margin i have got from Zaner360 is based on the contract that expires on 16 December. The margin i was referring to is not for EW3 options, but for ESZ6 contract.

Currently for the spread -1 OESZ6 P1660 and +2 OESZ6 P1410 the initial margin is $340. Net option value is $130 respectively. Therefore the spreadsheet shows a SPAN margin $210,less net option value.


You asked what options did i get from the spreadsheet.
The thing is, i am only getting EW1 and EW4 options. I have neither EW2 nor EW3 options. I don't know why is that.

I can not make a screenshot since i am using windows on a Mac and there is no PrtScreen button on the keyboard.

Sorry about me using Oct and not Dec.

I think the version of XLS-SPAN of mine you are using was created before the EW3 contract started being used. You can either download Dudetooth's latest version or you can request me to post my current version which works for EW3.

Started this thread Reply With Quote




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