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

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 futures io?
Time Segmented Volume
NinjaTrader
Holding futures overnight
Traders Hideout
For the experts of Metastock
Platforms and Indicators
Experience with AGN (Introducing Broker)
Brokers
TradingView help in improving Anchored Vwap
Platforms and Indicators
 
 
(login for full post details)
  #3 (permalink)
 sam028 
Site Moderator
 
 
sam028's Avatar
 
Posts: 3,680 since Jun 2009
Thanks: 3,793 given, 4,520 received


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 6 users say Thank You to sam028 for this post:
 
(login for full post details)
  #4 (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

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
 
(login for full post details)
  #5 (permalink)
 Jaap8242 
Netherlands
 
Experience: Advanced
Platform: Sierra Charts
Broker: Infinity Futures
Trading: FGBL
 
Posts: 72 since Oct 2009
Thanks: 77 given, 70 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:
 
(login for full post details)
  #6 (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

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
 
(login for full post details)
  #7 (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

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 futures io Trade Journal Reply With Quote
The following user says Thank You to RedK for this post:
 
(login for full post details)
  #8 (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

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, 299 views)
Started this thread Reply With Quote
 
(login for full post details)
  #9 (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

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

cheers,
K

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #10 (permalink)
 jerryd1 
Baton Rouge, Louisiana/ US
 
Experience: Intermediate
Platform: Ninja
Trading: crude
 
Posts: 1 since Jun 2012
Thanks: 8 given, 1 received


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:


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