PC-SPAN (Page 8) - 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,527 / 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 December 1st, 2013, 02:50 PM   #71 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


kevinkdog View Post
This is a great tool, @Dudetooth ! Thanks for putting it together.


I was running some Lean Hog calcs, and the price seems to be wrong for some of them. Everything else looks OK. Can you check this? I don;t know if it is an error in the SPAN file, but the OEX margin calculator seems to give the right price.

Thanks


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

At 87 the price goes to over 1.000 and to 4 digits from less than 1.000 and only 3 digits.

EDIT I noticed that on the Temp worksheet cell A12 has this statement
=IF(U5>1000,5,U5)

That is where the 5 is coming from. I don't know why that is there. Cell U5 does have the correct price.


Last edited by ron99; December 1st, 2013 at 02:58 PM.
Reply With Quote
     
The following user says Thank You to ron99 for this post:
     

Old December 1st, 2013, 04:00 PM   #72 (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


kevinkdog View Post
I was running some Lean Hog calcs, and the price seems to be wrong for some of them.

You're welcome ... glad it is a help.

Got the issue:
1- Go to the Temp page, cell A12
2- Replace the formula with this one: =IF(U5>9999990,5,U5)

SPAN is odd that when an option is cabinet: they give it a value of 9999999 instead of 0. This is just how the spreadsheet takes care of that. Before Lean Hogs were added the formula =IF(U5>1000,5,U5) would have handled it, but this will work better. I have only tested this on cabinet positions in ES and EC (should work in other currencies) ... not really sure if there are other markets that have cabinet positions.

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

Old December 1st, 2013, 04:20 PM   #73 (permalink)
Elite Member
Cleveland Ohio/United States
 
Futures Experience: Advanced
Platform: Tradestation
Broker/Data: various
Favorite Futures: futures
 
Posts: 2,195 since Jul 2012
Thanks: 1,004 given, 3,969 received



Dudetooth View Post
You're welcome ... glad it is a help.

Got the issue:
1- Go to the Temp page, cell A12
2- Replace the formula with this one: =IF(U5>9999990,5,U5)

SPAN is odd that when an option is cabinet: they give it a value of 9999999 instead of 0. This is just how the spreadsheet takes care of that. Before Lean Hogs were added the formula =IF(U5>1000,5,U5) would have handled it, but this will work better. I have only tested this on cabinet positions in ES and EC (should work in other currencies) ... not really sure if there are other markets that have cabinet positions.

Thanks! What is a cabinet position? Does that mean a zero price?

If you have any questions please send me a Private Message or use the futures.io "Ask Me Anything" thread
Reply With Quote
     

Old December 1st, 2013, 04:29 PM   #74 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


kevinkdog View Post
Thanks! What is a cabinet position? Does that mean a zero price?

Cabinet is zero at OX but it is half a tick at most other firms. LH, LC, ES have cabinet positions. Probably others.

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

Old December 1st, 2013, 04:29 PM   #75 (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

Futures Edge on FIO

kevinkdog View Post
Thanks! What is a cabinet position? Does that mean a zero price?

From CME's site:
Cabinet Price
Nominal price for liquidating deep-out-of-the-money options contracts. Defined as the lowest possible tradable price for this option, and is determined within the Clearing System. Trades on options done at a price equal to zero are considered cabinet trades.


On statements I get from RJO they will list positions as cabinet when they get to a point where they are practically worthless. Not sure if they can still be traded at that point.

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

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

Old December 1st, 2013, 04:36 PM   #76 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received

It is possible to trade at cabinet. I have done it.

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

Old December 2nd, 2013, 02:28 PM   #77 (permalink)
Elite Member
Chicago, IL
 
Futures Experience: Beginner
Platform: RTrader
Favorite Futures: CL
 
Posts: 15 since Apr 2013
Thanks: 9 given, 1 received

algorithm for initial margin

Dudetooth,

Thanks for developing this software. Can you describe for me your algorithm for finding the Margin in the cme settlement's file, (such as: cme.20131129.s.pa2.zip). I don't use Excel, and I want to write my own Python program that can extract the information myself. (I'll post it here after I'm done so others can use it.)

I know that the file itself, when unzipped is a normal text file. However there are a number of fields per line. From reading the thread it seems that you pull the maintenance margin from the file and then calculate the initial margin using the options price information. Is that correct?

Thanks in advance.

Reply With Quote
     

Old December 2nd, 2013, 03:32 PM   #78 (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


enderqa View Post
Can you describe for me your algorithm for finding the Margin in the cme settlement's file, (such as: cme.20131129.s.pa2.zip) ... From reading the thread it seems that you pull the maintenance margin from the file and then calculate the initial margin using the options price information. Is that correct?

I'd gather that you are looking for a step-by-step on how this is done within the spreadsheet. That will take me a little bit to jot down in a narrative form to show you where the data is within risk arrays and explain the process. If you give me some time, I'll see what I can come up with.

Even though you donít use Excel, if you can look through the spreadsheet and its VBA code some of the process may make sense with your ability to program in Python.

Reply With Quote
     

Old December 2nd, 2013, 03:48 PM   #79 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


enderqa View Post
From reading the thread it seems that you pull the maintenance margin from the file and then calculate the initial margin using the options price information. Is that correct?

He takes the IM & MM and adds the option price to get Total IM & Total MM.

Reply With Quote
     

Old December 2nd, 2013, 05:10 PM   #80 (permalink)
Market Wizard
OH
 
Futures Experience: Advanced
Platform: QST
Broker/Data: QST, DeCarley Trading, Gain
Favorite Futures: Options on Futures
 
Posts: 2,324 since Jul 2011
Thanks: 634 given, 3,905 received


I just noticed that PC-SPAN uses the settlement date and not the expiration or last trade date.

For example, LHG4 options expiration or last trade date is 2/14/14. Settlement date is 2/19/14.

So the DTE in our spreadsheet uses the 2/19 not the 2/14.

I also just noticed that QST lists 2/14 as the expiration date but OX lists 2/19. Futures last trading day is 2/14.

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)
 

NinjaTrader 8: Features and Enhancements, Tips and Tricks

Dec 6
 

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

Elite only
 

Trading Technologies: Algo Design Lab hands-on

Dec 13
     

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 08:06 PM.

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-07 in 0.13 seconds with 20 queries on phoenix via your IP 50.16.17.16