Thanks Bill, I'll check it out.
Lou
--- In ConservativeOptionS
>
> 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