Our new section, "Members' Corner," is ready to host your thoughts, comments, and articles for discussion. All topics welcome. Please send your submissions to me at "ilenecapsw" at gmail. ~ Ilene
PSW Options Evaluator
Courtesy of Clay at PSW
I have a nifty excel spreadsheet that I built and have been using since 3Q2015. I think this spreadsheet might be very valuable to you in evaluating the opportunities that Phil presents in the chat room, the effects that changing market conditions may have on Phil's recommendations before you can fill them, and any other option trades you want to evaluate.
Here's the spreadsheet:
Note: Yodi noted that a blank template for starting with new entries would be helpful, so this revised spreadsheet provides a blank template at the bottom (Row 43).
Notes on how the spreadsheet works:
1. I have examples of previous evaluations loaded in the spreadsheet for SPWR, LL, AAPL, BHI. Some stock evaluations in the spreadsheet appear as duplicate tables that are very similar. I use them to fill in Phil's original trade idea on top to show the economics of Profit and %Rate of Return (ROI) that might be achieved if I can fill it as Phil has suggested. The second table is to evaluate impacts of adjustments to Phil's recommendations that may be required or desired (due to changing market conditions or alternative ideas, etc.).
2. Create a new stock option evaluation form by copying/pasting rows from one of the stock option evaluations previously used into new available rows at bottom of spreadsheet.
3. Load the new stock info in the yellow and blue rows (upper left corner of evaluation table).
4. Fill in the white cells in columns D, E, F, G, H, I and N as appropriate.
5. The spreadsheet calculates everything else.
6. Columns S & T give various Results.
7. Column O is to keep track of orders placed but not filled (Red) vs. orders filled (green).
8. Members might choose to adjust the % margin requirements in the equations of column T. I have the equation set using a default of 25%.
9. Members can view the various equations of cells in Column J, S, T, W to see how calculations are made.
10. The word "Infinity" shows up in Column T when there is no net investment for the spread (i.e., when the spread results in a net credit that requires no net investment capital).
Anyone finding errors (don't know of any) or wish to share suggestions to improve it are invited to advise me at gclaybroussard@gmail.com.
Spreadsheets are always a work in progress!!
GClay
See also: Clay's Butterfly Evaluator.
