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?
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.
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.
This post has been selected as an answer to the original posters question
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 ..
The following user says Thank You to RedK for this post:
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.
Elwood P. Dowd
Last edited by elwoodpdowd; April 20th, 2013 at 10:26 PM.
Reason: More information