So much thanks Randy. Been looking to see if this can be done for years. My bro said it couldn't be done (but I think he was just being lazy).
I did take a look around, but can I ask some questions? I'd venture to say the answer is yes - but I probably will need to study this a while.
I enter a stock symbol at the Yahoo! Finance option quote page. For example: http://finance.
It brings up the front month or Jan 10 quotes. There is a helpful background color separation (yellow above and white below) between the OTM (out-the-money) and ITM (in-the-money) strike price. For instance ASIA is now quited at 30.06 so the separation is between the strike of 30.00 and 35.00.
There are a total of 16 pieces of data - 8 for each strike that I sweep my mouse across, copy & paste into my Excel spreadsheet. The formulas in my spreadsheet do the rest of the work...but each week a total of 300 sets of option, from stock data need to be placed into it.
I really only need the strike and ask data for 2 strikes (either side of line separation) for each stock symbol and also the stock price. I take it this can be done?
G
--- In ConservativeOptionS
>
> I have an add-in that might be able to automate that for you:
>
> http://finance.
>
> There are also some automated templates using the add-in over in this Yahoo
> group:
>
> http://finance.
>
> On Sun, Dec 20, 2009 at 7:23 AM, Gilbert <gilbert_arevalo@
>
> > (3) Or enter 100 option quotes into an Excel spreadsheet for me to process
> > our weekly watchlist of CC candidates.
> >
>
No comments:
Post a Comment