NexusFi: Find Your Edge


Home Menu

 





Selling Options on Futures?


Discussion in Options

Updated
      Top Posters
    1. looks_one ron99 with 2,221 posts (4,489 thanks)
    2. looks_two SMCJB with 346 posts (733 thanks)
    3. looks_3 kevinkdog with 341 posts (400 thanks)
    4. looks_4 myrrdin with 288 posts (408 thanks)
      Best Posters
    1. looks_one SMCJB with 2.1 thanks per post
    2. looks_two ron99 with 2 thanks per post
    3. looks_3 myrrdin with 1.4 thanks per post
    4. looks_4 kevinkdog with 1.2 thanks per post
    1. trending_up 1,934,752 views
    2. thumb_up 9,259 thanks given
    3. group 458 followers
    1. forum 7,370 posts
    2. attach_file 794 attachments




 
Search this Thread

Selling Options on Futures?

  #1671 (permalink)
 crez 
Brisbane , Australia
 
Experience: Intermediate
Platform: NT, OX
Trading: Futures
Posts: 51 since Sep 2009
Thanks Given: 32
Thanks Received: 13


ron99 View Post
Here's a spreadsheet I use when doing spreads.

One chart shows profit/loss. The other ROI%.

The yellow cells are the ones you can change.

A2 is the multiplier or value of $1 of futures. You need to change this based on the commodity. For example, CL is 1000. GC 100, ES 50.

A5 is the interval between prices in cells A6:A106.

A6 is the lowest price for the price range.

B2:E2 is the strike price of the option.

B3:G3 is the premium or price of the future or option.

B4:G4 is the quantity of each.

K2 is the margin required.

Columns T:Z are extra columns if you need them. Copy and insert them between columns B:H

K6:K106 is ROI%. I forgot to label it.

These notes are also on the Worksheet Notes.

Very cool, much appreciated Ron.....

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Request for MACD with option to use different MAs for fa …
NinjaTrader
NexusFi Journal Challenge - April 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
58 thanks
Battlestations: Show us your trading desks!
50 thanks
NexusFi site changelog and issues/problem reporting
47 thanks
GFIs1 1 DAX trade per day journal
32 thanks
What percentage per day is possible? [Poll]
31 thanks

  #1672 (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

To my option chart spreadsheet I added fees per contract in cell I4 so that you can get a true Net P/L and ROI%.

Also in cell L2 I added an excess factor for the cash excess on top of margin. A factor of 2 would be the margin plus 2X times margin in excess. So $500 margin + $1000 excess would be $1500 margin and excess.

Attached Files
Elite Membership required to download: Option Chart.xlsx
Started this thread Reply With Quote
The following 4 users say Thank You to ron99 for this post:
  #1673 (permalink)
 crez 
Brisbane , Australia
 
Experience: Intermediate
Platform: NT, OX
Trading: Futures
Posts: 51 since Sep 2009
Thanks Given: 32
Thanks Received: 13



ron99 View Post
To my option chart spreadsheet I added fees per contract in cell I4 so that you can get a true Net P/L and ROI%.

Also in cell L2 I added an excess factor for the cash excess on top of margin. A factor of 2 would be the margin plus 2X times margin in excess. So $500 margin + $1000 excess would be $1500 margin and excess.


Perfect! Thanks again

Reply With Quote
The following user says Thank You to crez for this post:
  #1674 (permalink)
 
opts's Avatar
 opts 
NW Florida
 
Experience: Intermediate
Platform: OX and TOS
Trading: Futures Options, Stocks
Posts: 234 since Aug 2012
Thanks Given: 29
Thanks Received: 115

Crude up...


Wondering if the low pressure system trying to form in the Gulf of Mex has the oil platform people thinking about shutting down for a few days? I know we need the rain here in NW Florida....

Reply With Quote
  #1675 (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

Hurricanes don't matter as much for crude oil production. The US is down to 17.7% of its oil production coming from offshore in the Gulf. It was 29% 3 years ago.

But they would still matter if they affected oil refineries.

Gulf oil production peaked at 1,752 b/d Sep 2009. March 2013 it was 1,262.

For NG, Gulf production is down too. March 2010 NG from the Gulf was 210,438 for the month. March 2013 it was 119,622. 4.7% of US production. Before 2002 it was 400,000+.

Started this thread Reply With Quote
The following user says Thank You to ron99 for this post:
  #1676 (permalink)
 
eudamonia's Avatar
 eudamonia 
Sacramento, CA
 
Experience: None
Platform: None
Broker: ADM and Sierra Charts
Trading: ES, CL
Posts: 315 since Jul 2010
Thanks Given: 308
Thanks Received: 449


Quoting 
NEW YORK--Cotton futures for delivery next month continued their climb on Tuesday after a limit-up settlement in the previous session, a sign of concerns over supplies of the fiber in the near-term.

Cotton for delivery in July on ICE Futures U.S. were up 0.9% at 83.03 cents a pound. Benchmark prices for the fiber fell to a four-and-a-half-month low last week, which encouraged buying, analysts said.

"We got cheap enough," said Sharon Johnson, a senior cotton specialist at Knight Futures. "These mills just jumped all over it."

The price difference between cotton for delivery in December, which corresponds to the upcoming crop year, and July narrowed to 0.82 cents, from 2.7 cents on Friday. The movement shows higher near-term demand for fiber.

For those of us still short July cotton calls.

However, keep in mind:


Quoting 
Ideas of good weather for U.S. crops are still around and were supported in part by the USDA reports released yesterday afternoon. Speculators and mills were said to be the best buyers. The weather has improved in all areas with some precipitation in Texas areas and drier weather in the forecast for the next few days for the Delta and Southeast. Dry weather is forecast for the Delta and Southeast, and warm weather is expected in Texas this week. Ideas are that farmers can get a lot of planting done with dry and warm conditions.


Visit my NexusFi Trade Journal Reply With Quote
  #1677 (permalink)
 
opts's Avatar
 opts 
NW Florida
 
Experience: Intermediate
Platform: OX and TOS
Trading: Futures Options, Stocks
Posts: 234 since Aug 2012
Thanks Given: 29
Thanks Received: 115


ron99 View Post
Hurricanes don't matter as much for crude oil production. The US is down to 17.7% of its oil production coming from offshore in the Gulf. It was 29% 3 years ago.

But they would still matter if they affected oil refineries.

Gulf oil production peaked at 1,752 b/d Sep 2009. March 2013 it was 1,262.

For NG, Gulf production is down too. March 2010 NG from the Gulf was 210,438 for the month. March 2013 it was 119,622. 4.7% of US production. Before 2002 it was 400,000+.


Well SHugar Ron. You were supposed to say "Yes, that's exactly right!"

Wondering why the production in the Gulf is down. There has been so much news about the US slowly becoming oil independent because of the new drilling methods, oil fields, and more fuel efficient vehicles. Are the fat oil barons purposely slowing down production in hopes of causing a shortage scare to support prices? We'll never know. Oil companies will always and forever have control until I get my patent on my cold fusion drive. That'll show 'em!

Reply With Quote
  #1678 (permalink)
 rosho01 
London/UK
 
Experience: Intermediate
Platform: IBs ladder / Market Delta charts
Broker: IB / IQfeed
Trading: Bund
Posts: 438 since Sep 2012
Thanks Given: 260
Thanks Received: 96


ron99 View Post
Interesting. ES was up 16 out of 18. But the ES was up big a lot of those days. The average for the last 18 Tuesdays is +8.25.

For 2012 ES was up 26 out of 51 Tuesdays. No pattern.

so it came to an end after 20 up tuesdays in the DJI, not seen since 1900. shame i was just about to double up next tuesday.

Visit my NexusFi Trade Journal Reply With Quote
  #1679 (permalink)
MGBRoadster
Lancashire UK
 
Posts: 52 since Jan 2013
Thanks Given: 42
Thanks Received: 32


ron99 View Post
It's best to use yesterday's settlement price for the option when calculating ROI and figure that margin and premium will move at about the same rates up or down.

Is there somewhere in OX that I can find yesterday's settlement price, or is it better to download it from the exchange?

Reply With Quote
  #1680 (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



MGBRoadster View Post
Is there somewhere in OX that I can find yesterday's settlement price, or is it better to download it from the exchange?

OX doesn't show settlement prices but you can get them by subtracting today's change from the current price. That is available on the Order Detail page. The Option Chain page. And your Positions page.

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





Last Updated on July 28, 2023


© 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