PC-SPAN (Page 39) - 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,589 / 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 May 20th, 2016, 07:43 AM   #381 (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


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
     
The following user says Thank You to Dudetooth for this post:
     

Old May 20th, 2016, 08:33 AM   #382 (permalink)
Trading Apprentice
Seoul Korea
 
Futures Experience: Beginner
Platform: None
Favorite Futures: None
 
Posts: 4 since Apr 2016
Thanks: 7 given, 6 received


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
     
The following user says Thank You to woodward for this post:
     

Old August 3rd, 2016, 09:43 AM   #383 (permalink)
Elite Member
Ukraine
 
Futures Experience: Beginner
Platform: Zaner360
Favorite Futures: Options on futures
 
Posts: 11 since May 2015
Thanks: 116 given, 6 received


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
     

Old August 3rd, 2016, 10:14 AM   #384 (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


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.


Last edited by Dudetooth; August 3rd, 2016 at 10:16 AM. Reason: changed comment
Reply With Quote
     

Old August 3rd, 2016, 10:35 AM   #385 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,329 since Jul 2011
Thanks: 634 given, 3,909 received

Futures Edge on FIO

Are you a NinjaTrader user?

 

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.

Reply With Quote
     

Old August 3rd, 2016, 10:39 AM   #386 (permalink)
Elite Member
Ukraine
 
Futures Experience: Beginner
Platform: Zaner360
Favorite Futures: Options on futures
 
Posts: 11 since May 2015
Thanks: 116 given, 6 received

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
     

Old August 3rd, 2016, 12:42 PM   #387 (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


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
     
The following user says Thank You to Dudetooth for this post:
     

Old August 3rd, 2016, 01:35 PM   #388 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,329 since Jul 2011
Thanks: 634 given, 3,909 received

This is what I just got for that spread using Zaner360

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


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



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.

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

Old August 3rd, 2016, 04:33 PM   #389 (permalink)
Elite Member
Ukraine
 
Futures Experience: Beginner
Platform: Zaner360
Favorite Futures: Options on futures
 
Posts: 11 since May 2015
Thanks: 116 given, 6 received


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

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


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



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
     

Old August 3rd, 2016, 04:45 PM   #390 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,329 since Jul 2011
Thanks: 634 given, 3,909 received



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.

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)
 

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 02:56 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-10 in 0.14 seconds with 20 queries on phoenix via your IP 54.167.129.169