Needed options Spreadsheet - Options on Futures | futures.io
futures.io futures trading


Needed options Spreadsheet
Started: by elwoodpdowd Views / Replies:16,104 / 36
Last Reply: Attachments:4

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
 4  
 
Thread Tools Search this Thread
 

Needed options Spreadsheet

  #11 (permalink)
Elite Member
Seattle, WA/United States
 
Futures Experience: None
Platform: think or swim
Favorite Futures: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received

Spreadsheet

Good Evening,
Nothing yet. Tried a couple of times but it became too complicated. I'm just looking for something that will hook up to Think or Swim and an Excel Spreadsheet. I income trade so adjustments are a consideration. Just a simple spreadsheet in excel or open office. Nothing spectacular. I'm a simple country boy.

thanks for your post

Elwood

Reply With Quote
 
  #12 (permalink)
Knowledge Seeker
Dubai, UAE
 
Futures Experience: Intermediate
Platform: TOS, TradeStation
Broker/Data: OX, TradeStation
Favorite Futures: Stocks & Basic Options
 
RedK's Avatar
 
Posts: 171 since May 2012
Thanks: 44 given, 138 received

Ooops! cross-posting.. i gave this a shot but it seems each trader has to design his own report out sheet.. given the different trading styles and views needed..
I have a sheet that I use each quarter to "close" and review my quarter of trades, and biggest learning for me is simply, this is a must-have.

cheers,
K


Last edited by RedK; July 2nd, 2013 at 06:16 AM.
Reply With Quote
 
  #13 (permalink)
Trading Apprentice
warren, michigan
 
Futures Experience: Intermediate
Platform: ThinkorSwim
Favorite Futures: dollar
 
Posts: 2 since Nov 2014
Thanks: 0 given, 0 received

hello


Is someone out there uses open office?. I am totally new to excel and open office. if someone can help me build a spread sheet that can calculate values of jelly rolls I would greatly appreciate it.
formula is simple

Jelly roll value  K *  (d2 -d1) * (r / 360)

and also program this in the spread sheet if possible.
If the call time spread ask minus the put time spread ask is
greater than the value of the jelly roll, the put time spread appears
cheap.
If the call time spread ask minus the put time spread ask is less than
the value of the jelly roll, the call time spread appears cheap.
thanks in advance.

Reply With Quote
 
  #14 (permalink)
Administrator: Retired Backtester
 Vendor: speedytradingservers.com 
Rennes France
 
Futures Experience: Advanced
Platform: NinjaTrader
Broker/Data: IB/Kinetick
Favorite Futures: Futures
 
sam028's Avatar
 
Posts: 3,258 since Jun 2009
Thanks: 3,481 given, 3,849 received


wusman1972 View Post
Is someone out there uses open office?. I am totally new to excel and open office. if someone can help me build a spread sheet that can calculate values of jelly rolls I would greatly appreciate it.
formula is simple

Jelly roll value  K *  (d2 -d1) * (r / 360)

and also program this in the spread sheet if possible.
If the call time spread ask minus the put time spread ask is
greater than the value of the jelly roll, the put time spread appears
cheap.
If the call time spread ask minus the put time spread ask is less than
the value of the jelly roll, the call time spread appears cheap.
thanks in advance.

What are K, d1 d2 and r ?

Usually in trading, those who know don't talk, and those who talk don't know. (Al Brooks)
success requires no deodorant! (Sun Tzu)
Reply With Quote
 
  #15 (permalink)
Trading Apprentice
Vail, CO USA
 
Futures Experience: Intermediate
Platform: ThinkorSwim
Favorite Futures: options
 
Martzee's Avatar
 
Posts: 12 since Jan 2015
Thanks: 6 given, 8 received

Google Spreadsheets

Futures Edge on FIO
I use Google Spreadsheet for this purpose because this allows me to have the spreadsheet accessible from any computer anywhere and anytime.

I am not yet allowed to post links so PM me and I can share it with you. Bellow is a picture of what I use. I can also help you with what you need (but only in Google spreadsheet as my Excel knowledge of financial and date feed functions is limited).

Attached Thumbnails
Needed options Spreadsheet-spreadsheet01.png  
Reply With Quote
The following 4 users say Thank You to Martzee for this post:
 
  #16 (permalink)
Trading Apprentice
Memphis, TN
 
Futures Experience: Beginner
Platform: Think or Swim
Favorite Futures: Stocks
 
Posts: 4 since Jul 2013
Thanks: 1 given, 1 received


Martzee View Post
I use Google Spreadsheet for this purpose because this allows me to have the spreadsheet accessible from any computer anywhere and anytime.

I am not yet allowed to post links so PM me and I can share it with you. Bellow is a picture of what I use. I can also help you with what you need (but only in Google spreadsheet as my Excel knowledge of financial and date feed functions is limited).

I'd love a copy .....great spreadsheet. Uh would you have more stuff like it?

Thanks in advance...........no2fool@hotmail.com

Reply With Quote
 
  #17 (permalink)
Membership Temporarily Revoked
Portugal, Viana do Castelo
 
Futures Experience: Intermediate
Platform: ninjatrader
Favorite Futures: 6e
 
Posts: 358 since Sep 2011
Thanks: 187 given, 343 received

I have actually found a cheap alternative.
https://tradingspreadsheets.wordpress.com/

Reply With Quote
 
  #18 (permalink)
Elite Member
Las Vegas NV USA
 
Futures Experience: Beginner
Platform: TWS, TOS, Multicharts
Broker/Data: IB
Favorite Futures: Stocks, ETFS,Options
 
Lysakat's Avatar
 
Posts: 20 since Jul 2014
Thanks: 11 given, 6 received

Looks Intersting

Have you used it?

Reply With Quote
 
  #19 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 45,663 since Jun 2009
Thanks: 29,045 given, 80,707 received

Be sure to review this as well:

https://futures.io/options-cfd-trading/29125-pc-span.html

Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following user says Thank You to Big Mike for this post:
 
  #20 (permalink)
Membership Temporarily Revoked
Portugal, Viana do Castelo
 
Futures Experience: Intermediate
Platform: ninjatrader
Favorite Futures: 6e
 
Posts: 358 since Sep 2011
Thanks: 187 given, 343 received



Lysakat View Post
Have you used it?

Hi have actually bought the hole bundle last weekend but spend the hole week far from home because my grandfather needed care in the hospital, he eventually died, so I did not get a change to use it this week but it looks good. Will come back on this next week.

Reply With Quote

Reply



futures.io > > > > Needed options Spreadsheet

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

2016 True Edge Awards: Voting is open until Jan 21!

Now
 

Anthony Drager: Pulling the trigger with confidence

Elite only
 

Leo Murphy: The Art and Science of Technical Analysis

Elite only
 

FuturesTrader71: Ask Me Anything

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Options Analysis Software for Options on Futures ChrisB Options on Futures 6 December 7th, 2012 05:47 AM
spreadsheet benrock Psychology and Money Management 8 October 13th, 2012 08:57 PM
spreadsheet novice PandaWarrior Psychology and Money Management 3 December 9th, 2010 09:12 PM
Modeling spreadsheet Saroj Traders Hideout 3 October 7th, 2009 10:12 AM
another spreadsheet to try out Saroj Psychology and Money Management 1 July 26th, 2009 07:45 AM


All times are GMT -4. The time now is 12:34 PM.

no new posts
Page generated 2017-01-22 in 0.17 seconds with 40 queries on phoenix via your IP 54.158.169.168