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


Needed options Spreadsheet
Updated: Views / Replies:17,546 / 37
Created: by elwoodpdowd 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

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

Needed options Spreadsheet

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

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (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,319 since Jun 2009
Thanks: 3,529 given, 3,930 received

Answer
This post has been selected as an answer to the original posters question Answer


Check this one: http://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)
Reply With Quote
The following 5 users say Thank You to sam028 for this post:
 
  #4 (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

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:

Reply With Quote
 
  #5 (permalink)
Elite Member
Netherlands
 
Futures Experience: Advanced
Platform: Sierra Charts
Broker/Data: Infinity Futures
Favorite Futures: FGBL
 
Posts: 27 since Oct 2009
Thanks: 29 given, 23 received

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)
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

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

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

Answer
This post has been selected as an answer to the original posters question Answer

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

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

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
Register to download File Type: xlsx Project #1.xlsx (9.2 KB, 249 views)

Last edited by elwoodpdowd; April 20th, 2013 at 09:26 PM. Reason: More information
Reply With Quote
 
  #9 (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

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

cheers,
K

Reply With Quote
 
  #10 (permalink)
Elite Member
Baton Rouge, Louisiana/ US
 
Futures Experience: Intermediate
Platform: Ninja
Favorite Futures: crude
 
Posts: 1 since Jun 2012
Thanks: 4 given, 1 received

Question


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:

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)

FIO Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

May
 

EasyLanguage ABC's: Mastering TradeStation Programming w/Chris Kaiser

Elite only
 

Prototyping Python Strategies (part 2: Backtesting) w/Ran Aroussi [special time: 1PM ET]

Elite only
 

Portfolio Diversification w/Brendon Delate @ Diversify Portfolio

Elite only

An Afternoon with FIO member Softsoap (being rescheduled)

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 04:47 AM
spreadsheet benrock Psychology and Money Management 8 October 13th, 2012 07:57 PM
spreadsheet novice PandaWarrior Psychology and Money Management 3 December 9th, 2010 08:12 PM
Modeling spreadsheet Saroj Traders Hideout 3 October 7th, 2009 09:12 AM
another spreadsheet to try out Saroj Psychology and Money Management 1 July 26th, 2009 06:45 AM


All times are GMT -4. The time now is 07:32 PM.

Copyright © 2017 by futures io, s.a. Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, 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
Page generated 2017-05-22 in 0.13 seconds with 38 queries on phoenix via your IP 54.162.168.187