Friday, February 10, 2012

V/MMM -- Adjustment

Although I had decided not to trade MMM because I think it's overbought, I decided to simulate trading on it in my OptionsXPress virtual account to see what would have happened if I had continued to trade:

Stock Price Date Description Total xIRR
$87.67 2012-02-03 Buy 2000 shares MMM @ $87.67 -$175,340.00 --
$87.67 2012-02-03 Sell 20 MMM 2/10 2012 $87.50 Call @ $0.77 $1,510.05 41.9%
$87.20 2012-02-10 Buy 20 MMM 2/10 2012 $87.50 Call @ $0.08 -$189.95 12.1%
$87.03 2012-02-10 Sell 20 MMM 3/17 2012 $87.50 Call @ $1.54 $3,050.05 16.4%

 

5 comments:

  1. Just found the blog and like the looks of it. How are you copying in your spreadsheet data with borders into your blog. I can't get a table to cut and paste into blogger without losing all the formatting. I wanted to do a blog that helps me track my learning progress.

    ReplyDelete
  2. I use the ASAP Utilities add-in. It's a free add-in with a number of enhancements to EXCEL:

    http://www.asap-utilities.com/

    One of its menu options is to export a range as an HTML table, which is what I'm using to get the tables over here from EXCEL.

    ReplyDelete
  3. Works great. I used to think I was a excel expert. Now I realize its a constant learning process. Thamks

    ReplyDelete
  4. Thank you for the informative post. I think additional market commentary on rolling would be instructive. This summary really helps me to with my various options strategies.

    ReplyDelete