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 RedK with 3 posts (1 thanks)
    3. looks_3 No2Fool with 3 posts (1 thanks)
    4. looks_4 Martzee with 3 posts (5 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,102 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

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

I need a simple spreadsheet (excel or open office) that will show my option trades and adjustments. I know nothing about excel and open office but am currently learning but I need something now. Can anyone assist, I would really appreciate it?

Elwood

Started this thread 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
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
65 thanks
NexusFi site changelog and issues/problem reporting
48 thanks
Battlestations: Show us your trading desks!
36 thanks
GFIs1 1 DAX trade per day journal
32 thanks
What percentage per day is possible? [Poll]
31 thanks

  #3 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,761 since Jun 2009
Thanks Given: 3,824
Thanks Received: 4,629


Check this one: https://www.optiontradingtips.com/resources/OptionTradingWorkbook.xls .
I've been using a modified version of this one for a long time, very useful.

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
The following 7 users say Thank You to sam028 for this post:
  #4 (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

Hello,
It is not exactly what I'm looking for but it is a vault of information that I can use. I'm just looking for a spreadsheet that I can put in the information ie. calendars, Iron condors, butterflies etc. and it will calculate the totals. Also the ability to add adjustment also. But and this is a big but...thanks very much for what you sent it is something I will use often.

Thanks,

Elwood:

Started this thread Reply With Quote
  #5 (permalink)
 Jaap8242 
Netherlands Amsterdam
 
Experience: Advanced
Platform: Sierra Charts
Broker: Infinity Futures
Trading: FGBL
Frequency: Every few months
Duration: Hours
Posts: 86 since Oct 2009
Thanks Given: 136
Thanks Received: 104

May be this is what you are looking for:

Options Strategy Evaluation Tool: Latest Version | Hoadley

Jaap

Reply With Quote
The following user says Thank You to Jaap8242 for this post:
  #6 (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

Hello,
First of all thank you very much for the information but it is not what I'm looking for, unfortunately. I downloaded the setup and took a look at the software but it is more strategy to determine what to trade not a record keeping tool. Much thanks again.

Elwood

Started this thread Reply With Quote
  #7 (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

can you send a mock-up table that you manually create (like in Word), similar to what you need.. maybe include the calculations you wish to see done in different columns.. i'll see what could be done in Excel for you. I do trade options (though single-leg only) and do keep a log that helps me keep track.. so I may be able to get you something ..

cheers,
K

Visit my NexusFi Trade Journal Reply With Quote
The following user says Thank You to RedK for this post:
  #8 (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

Hello again
I apologize, I left a piece of the information out. There should be a column labeled COMMISSIONS, it's $1.50 per contract, to the right of the TRADE ENTRY PRICE.


Good Morning REDK,
Sorry it took a bit longer than anticipated to get this done but here's what I have so far. It's quite self explanatory but if you have any questions just let me know. The most important aspect is the gain/loss, %gain/loss and running total. But if there is anything you want to add - delete to make it better in your eyes please feel free. I'm sure you are aware of my appreciation for your response so I won't dwell on that but thank you in advance.

Regards,
Elwood P. Dowd

Attached Files
You must login first File Type: xlsx Project #1.xlsx (9.2 KB, 313 views)
Started this thread Reply With Quote
The following user says Thank You to elwoodpdowd for this post:
  #9 (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

@elwoodpdowd, sent you email.. then we can come back and post the final for forum members' benefit.

cheers,
K

Visit my NexusFi Trade Journal Reply With Quote
  #10 (permalink)
 jerryd1 
Baton Rouge, Louisiana/ US
 
Experience: Intermediate
Platform: Ninja
Trading: crude
Posts: 1 since Jun 2012
Thanks Given: 8
Thanks Received: 1


Has any progress been made in this spreadsheet? I would be very interested in implementing.

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





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