NexusFi: Find Your Edge


Home Menu

 





Needed options Spreadsheet


Discussion in Options

Updated
      Top Posters
    1. looks_one elwoodpdowd with 8 posts (3 thanks)
    2. looks_two Smith33 with 3 posts (0 thanks)
    3. looks_3 RedK with 3 posts (1 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.5 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 39,133 views
    2. thumb_up 36 thanks given
    3. group 33 followers
    1. forum 45 posts
    2. attach_file 10 attachments




 
Search this Thread

Needed options Spreadsheet

  #11 (permalink)
 
elwoodpdowd's Avatar
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
Posts: 13 since Sep 2012
Thanks Given: 8
Thanks Received: 7

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 NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
Build trailing stop for micro index(s)
Psychology and Money Management
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
  #12 (permalink)
 
RedK's Avatar
 RedK 
Dubai, UAE
 
Experience: Intermediate
Platform: TOS, TradeStation
Broker: OX, TradeStation
Trading: Stocks & Basic Options
Posts: 171 since May 2012
Thanks Given: 44
Thanks Received: 145

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 NexusFi Trade Journal Reply With Quote
  #13 (permalink)
wusman1972
warren, michigan
 
Posts: 2 since Nov 2014
Thanks Given: 0
Thanks Received: 0


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)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629


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
  #15 (permalink)
Martzee
Vail, CO USA
 
Posts: 12 since Jan 2015
Thanks Given: 6
Thanks Received: 9

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:	726
Size:	65.5 KB
ID:	170397  
Reply With Quote
  #16 (permalink)
No2Fool
Memphis, TN
 
Posts: 4 since Jul 2013
Thanks Given: 1
Thanks Received: 1


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
  #17 (permalink)
 jsengxx2 
Portugal, Viana do Castelo
 
Experience: Intermediate
Platform: ninjatrader
Trading: 6e
Posts: 345 since Sep 2011

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

Reply With Quote
  #18 (permalink)
 
Lysakat's Avatar
 Lysakat 
Las Vegas NV USA
 
Experience: Beginner
Platform: TWS, TOS, Multicharts
Broker: IB
Trading: Stocks, ETFS,Options
Posts: 28 since Jul 2014
Thanks Given: 11
Thanks Received: 11

Have you used it?

Reply With Quote
  #19 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537

Be sure to review this as well:



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #20 (permalink)
 jsengxx2 
Portugal, Viana do Castelo
 
Experience: Intermediate
Platform: ninjatrader
Trading: 6e
Posts: 345 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




Last Updated on February 19, 2021


© 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