| How can I join the JUSTCOVEREDCALL group? thanks
--- On Tue, 12/22/09, Randy Harmelink <rharmelink@gmail.com> wrote:
From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: [ConservativeOptionStrategies] Re: Long-Term Growth Strategy
To: ConservativeOptionStrategies@yahoogroups.com
Date: Tuesday, December 22, 2009, 9:36 PM
One of the workbooks I mentioned from the JustCoveredCalls group does this:
 All you need to do is fill in the underlying ticker symbols in the yellow-shaded cells and user-defined functions go out and get the data from the Internet. There are also hidden columns with additional data that are used to compute the values. One issue, which you'll have with cut & paste as well -- is when options have multiple tickers for the same strike price on a given Yahoo page. Sometimes it is because of differing contracts. But some index ETFs (e.g. SPY or IWM) have both the quarter-end and month-end options listed together in the quarter-end months.
Another issue -- option symbols will be changing soon. My broker is already using a new ticker symbol scheme.
On Tue, Dec 22, 2009 at 6:10 PM, Gilbert Arevalo <gilbert_arevalo@ rocketmail. com> wrote: [Attachment(s) from Gilbert Arevalo included below] Hi Larry,
Thank you for helping out. Very little time or effort will be required (at most 1 hour per week) from volunteers, but this help is greatly appreciated.
The strategy will require days and months to add up against each type of market backdrop - but as we discuss. . .you will find the long-term expected results will fall in line.
Attached is an Excel spreadsheet.
Open it and select page "A1(3)".
Open Yahoo! FINANCE "Options" page: http://finance. yahoo.com/ q/op?s=rimm
Note: data example for the first stock ALXN is already inserted into spreadsheet. Simply continue pasting data into appropriate cells as defined below.
-----
Using you mouse, right-click & copy (or use CTRL-C) "RIMM" from cell B6 of spreadsheet.
Enter it (right-click & paste or use CTRL-V) into the Yahoo! FINANCE "Options" page, where it says "Get Options for:" (at the right).
Then click "Go" or press the enter key to pull up the stock and option price data.
Double-click on the stock price, then right-click & copy and enter it (right-click & paste or CTRL-V) into cell "B7" of spreadsheet.
Note: you can use ALT-Tab to toggle between the 2 pages you are working with.
Then go back to the Yahoo! Options page and sweep across (with your mouse) and collect data for both OTM (out-the-money) & ITM (in-the-money) call option quotes.
Note: OTM and ITM data is separated by the (yellow & white) background coloring. Just collect data from the 2 rows.
Simply point your cursor in the white or lower row - at the right of the number for "Open Int" and (holding the left mouse button down) drag across the data, sweeping to the left to collect all of the data below and above the color separation line (just 2 total rows of data) over to and including the strike price in the yellow or upper row.
Once data selection is highlighted, right-click & copy then go to cell "B8" and right-click & paste or CTRL-V.
Example of data set:
RIMM
Cell "B7" contains 48.56
Cells "B8" to "I9" contain,
66.63 RFYAO.X 2.84 1.81 2.80 2.85 2,146 8,207
70.00 RFYAN.X 1.44 1.18 1.41 1.44 22,255 47,690
This may take a bit and a while of practice - but eventually will become routine in gathering 100 sets of data (50 stock symbols and their near-strike OTM & ITM option data into two spreadsheets) .
When done, please click page "A(3)", SAVE, attach & email to me.
Let me know it there is any question or difficulty in understanding the procedure. From this I will then be interpreting the calculated data to get the top CC picks or our watchlist of candidates.
Thanks in advance for your help.
G |
No comments:
Post a Comment