1. Check the CBOE for market quotes at www.cboe.com
They do NOT offer any sort of automated downloads -- in fact they
PROHIBIT automated downloads. As you might guess, they would get
swamped if they offered a free service like that. But their download
process is very simple. Enter symbol. Click download... so for 10
stocks, it would be less than 10 seconds.
They give you stock price and EVERY option for EVERY month in csv
format -- easy import into Excel, or anywhere else for that matter.
(You can even write a Excel macro that will do the imports for ya,
but that is another subject.)
There are other services that will let you download for a fee, and
probably have more options, etc. But CBOE is the only one I've found
that's free.
2. For a for-fee service that does some (pretty good) analysis, lets
you track a portfolio and doesn't pester you with too much junk mail,
I like Power Options at www.poweropt.
. and they even have a free trial period. I am not an employee or owner -- LOL
Bill
At 09:52 PM 4/5/2010, you wrote:
>
>
>First, It was mentioned to me that there may be a way to
>automatically import streaming quotes into an excel spreadsheet so
>that I don't have to enter them manually every day. Does anyone know of this?
>Thanks for any inputs you may have.
>
>Next a more complicated hypothetical question. I purchase 100 shares
>of CLW @49.84, purchase a May50 put for 3.69, sell a May55 CC for
>1.42, and sell an Oct40 CSP for 2.61 for a net cost, including
>commissions of $49.50.
>Now, even though CLW made an upward move today, I don't like what I
>see and decide to sell. So...I buy back the CC for 1.90, sell the
>May50 put for 2.75 and buy an April 55 put for 4.50.
>So I've increased my cost to 53.15 but will assign the new put,
>selling the stock at 55 for a $1.85 profit which translates to 3+%
>(also including commissions)
>for a week with essentially no risk involved. I've still got the Oct
>short put open, but have plenty of room there and expect it to expire OTM.
>The transaction may or may not be a wise one (there's a lot of work
>and a lot of commission involved), but my question concerns keeping
>track of a basic portfolio of roughly 10 stocks with all the option
>buying and selling and understanding my profit and loss results so I
>could keep refining the method. I'm using an excel spreadsheet but
>it's a lot of work! I have another profession and so have limited
>time. I think I may have asked this before, but does anyone know any
>software that may help me streamline the process?
>Thanks for any advice.
>Lou
No comments:
Post a Comment