Needed options Spreadsheet - futures io
futures io



Needed options Spreadsheet


Discussion in Options

Updated
      Top Posters
    1. looks_one elwoodpdowd with 8 posts (2 thanks)
    2. looks_two RedK with 3 posts (1 thanks)
    3. looks_3 Smith33 with 3 posts (0 thanks)
    4. looks_4 No2Fool with 3 posts (1 thanks)
      Best Posters
    1. looks_one dave01 with 3.5 thanks per post
    2. looks_two sam028 with 3 thanks per post
    3. looks_3 Rambo with 3 thanks per post
    4. looks_4 Martzee with 1.7 thanks per post
    1. trending_up 32,404 views
    2. thumb_up 34 thanks given
    3. group 32 followers
    1. forum 45 posts
    2. attach_file 10 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
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.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Needed options Spreadsheet

(login for full post details)
  #11 (permalink)
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received

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

Started this thread Reply With Quote

Can you help answer these questions
from other members on futures io?
Holding futures overnight
Traders Hideout
Portfolio Management Tool/Software
Psychology and Money Management
Time Segmented Volume
NinjaTrader
Color templates for MT5 40 items
Platforms and Indicators
1 min chart v-shape scan help please
ThinkOrSwim
 
 
(login for full post details)
  #12 (permalink)
 RedK 
Dubai, UAE
 
Experience: Intermediate
Platform: TOS, TradeStation
Broker: OX, TradeStation
Trading: Stocks & Basic Options
 
RedK's Avatar
 
Posts: 171 since May 2012
Thanks: 44 given, 143 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

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #13 (permalink)
wusman1972
warren, michigan
 
 
Posts: 2 since Nov 2014
Thanks: 0 given, 0 received


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
 
(login for full post details)
  #14 (permalink)
 sam028 
Site Moderator
 
 
sam028's Avatar
 
Posts: 3,680 since Jun 2009
Thanks: 3,793 given, 4,520 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 ?

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
 
(login for full post details)
  #15 (permalink)
Martzee
Vail, CO USA
 
 
Posts: 12 since Jan 2015
Thanks: 6 given, 9 received

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
Click image for larger version

Name:	spreadsheet01.png
Views:	504
Size:	65.5 KB
ID:	170397  
Reply With Quote
The following 5 users say Thank You to Martzee for this post:
 
(login for full post details)
  #16 (permalink)
No2Fool
Memphis, TN
 
 
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 [email protected]

Reply With Quote
 
(login for full post details)
  #17 (permalink)
 jsengxx2 
Portugal, Viana do Castelo
 
Experience: Intermediate
Platform: ninjatrader
Trading: 6e
 
Posts: 343 since Sep 2011

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

Reply With Quote
 
(login for full post details)
  #18 (permalink)
 Lysakat 
Las Vegas NV USA
 
Experience: Beginner
Platform: TWS, TOS, Multicharts
Broker: IB
Trading: Stocks, ETFS,Options
 
Lysakat's Avatar
 
Posts: 27 since Jul 2014
Thanks: 11 given, 11 received

Have you used it?

Reply With Quote
 
(login for full post details)
  #19 (permalink)
 Big Mike 
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: Custom solution
Trading: Futures & Crypto
 
Big Mike's Avatar
 
Posts: 50,131 since Jun 2009
Thanks: 32,602 given, 98,793 received

Be sure to review this as well:



Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/

Visit other sites? Please spread the word about your experience with our community!
Follow me on Twitter Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #20 (permalink)
 jsengxx2 
Portugal, Viana do Castelo
 
Experience: Intermediate
Platform: ninjatrader
Trading: 6e
 
Posts: 343 since Sep 2011



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


futures io Trading Community Traders Hideout Options > Needed options Spreadsheet


Last Updated on February 19, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing

Your Charts Should Speak To You w/Bob Cometta

Elite only
 

Our 12-year anniversary w/ $$,$$$ prizes (check soon)

August
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), info@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