[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Re: Maintaining optionables List



PureBytes Links

Trading Reference Links

The choices for updates may show up on the first page..


--- In equismetastock@xxxxxxxxxxxxxxx, "rsb_44" <rsb_44@xxx> wrote:
>
> I start with
> 
> http://888options.com/resources/literature/files/doelo.xls
> 
> and then clean it up. The first time is very time consuming. I 
remove 
> all stocks that are no longer trading or have gone off the regular 
> exchanges, etc.
> 
> Once I have the first clean list, I cross match succesive lists 
(they 
> don't come out on a regular schedule)via vlookup in excel. That 
leads 
> to "I have they don't"  and "They have I don't" lists" (relatively 
> small numbers) which I can check out by dumping the tickers into a 
> Yahoo portfolio. I maintain spreadsheets with of Invalid Tickers. 
It 
> makes the cross matching easier as it takes a while for the changes 
> to appear. In part that's because as long as any option of a stock 
is 
> being traded, the stock doesn't come off the list.
> 
> If you want to stay more current you can get regular e-mail alerts 
to 
> new listings. The choice is on the second page of the choices.
>  
> http://www.theocc.com/market/occ_e_mail_alerts_form.jsp
> 
> You should still probably do the cross matching whenever the doleo 
> list is updated.:
> 
> 
> Regards
> Ron
> 
> 
> --- In equismetastock@xxxxxxxxxxxxxxx, Kevin Barry <kevin_barry@> 
> wrote:
> >
> > Hello Ron,
> > 
> > Would you mind expanding on your method for keeping your list of 
> optionable 
> > stocks updated? I have been using eSignal's list and it leaves a 
> (hell of 
> > a) lot to be desired.
> > 
> > Many thanks in advance.
> > 
> > Regards,
> > Kevin
> > 
> > 
> > 
> > At 03:17 25/03/2008 +0000, you wrote:
> > 
> > >Thanks Preston -
> > >
> > >I maintain a pretty (very?) clean list of optionable stocks. 
> Vlookup
> > >against the result set from Zachs works for optionable.
> > >
> > >The criteria their method uses are pretty good for
> > >finding "reasonably" priced stocks in fairly good companies. 
Follow
> > >that with a little MS magic and viola!
> > >
> > >--- In 
> > ><mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx, 
> > >pumrysh <no_reply@> wrote:
> > > >
> > > > Ron,
> > > >
> > > > Might also want to check this:
> > > >
> > > > <http://www.stockfetcher.com>http://www.stockfetcher.com
> > > >
> > > > You can screen for optionable stocks.
> > > >
> > > >
> > > > Preston
> > > >
> > > >
> > > >
> > > > --- In 
> > > <mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx, 
> > > "rsb_44" <rsb_44@> wrote:
> > > > >
> > > > > Thanks Preston.
> > > > >
> > > > > I'm setting up the screens suggested by Hooper and Zalewski 
in
> > > > > Covered Calls and Leaps- A Wealth Option. I'm not 
> recommending it
> > > > > that's for sure.
> > > > >
> > > > >
> > > >
> > 
> 
><http://www.amazon.com/review/product/0470044705/ref=cm_cr_pr_redirec
> t>http 
> > >://www.amazon.com/review/product/0470044705/ref=cm_cr_pr_redirect
> > > > >
> > > > >
> > > > > It may provide some added useful input to folks already 
doing
> > > > covered
> > > > > call writing. I should be able to create most of the info 
in 
> the
> > > > > $80/month service "soon" from free sources. The data for the
> > >screen
> > > > > isn't terribly dynamic.
> > > > >
> > > > > The method is quite successful in a flat to slightly up 
> trending
> > > > > market. A method for writing covered calls where you want 
to 
> be
> > > > > called out and where the risk of a major down turn is modest
> > >works
> > > > > then.
> > > > >
> > > > > I'm able to get most of the data needed from Zachs, do some
> > > > massaging
> > > > > in Excel, send a ticker list to MS where I can do some TA
> > > > screening,
> > > > > and wind up with a reasonably short list to do the option 
> pricing
> > > > > analysis on.
> > > > >
> > > > > About 20 years ago there was a program running on a MAC
> > > > > (Tickerwatcher now Investor RT) that could do this analysis
> > >across
> > > > > the entire universe of optionable stocks. It also enabled 
you 
> to
> > > > > maintain a totally current list of optionable stocks. Of 
> course
> > > > that
> > > > > was 20 years ago and things have "improved" so much you 
can't 
> do
> > >it
> > > > > now
> > > > >
> > > > > I will check out Domash's site.
> > > > >
> > > > > Regards,
> > > > > Ron
> > > > >
> > > > >
> > > > > --- In 
> > > <mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx, 
> > > pumrysh <no_reply@> wrote:
> > > > > >
> > > > > > Ron,
> > > > > >
> > > > > > Some time ago I visited the webite of Harry Domash listed 
> below
> > > > > >
> > > > > > 
> > > 
> 
<http://www.winninginvesting.com/sector.htm>http://www.winninginvestin
> g.co 
> > > m/sector.htm
> > > > > >
> > > > > > There I found some interesting screens that he had done 
for
> > >MSN.
> > > > He
> > > > > > had also written a couple of articles about the screens. I
> > >tried
> > > > to
> > > > > > look up the links but can't find them at the moment.
> > > > > >
> > > > > > If you look up articles under his name at MSN you should 
be
> > >able
> > > > to
> > > > > > find them. As I remember some of the screens were 
available 
> as
> > > > hot
> > > > > > links in the articles.
> > > > > >
> > > > > > At MSN I remember getting beyond the 200 limit but had to 
> use
> > >the
> > > > > > deluxe screener to do it. Found here:
> > > > > >
> > > > > > 
> > > 
> 
<http://moneycentral.msn.com/investor/finder/predefstocks.aspx>http://
> mone 
> > > ycentral.msn.com/investor/finder/predefstocks.aspx
> > > > > >
> > > > > >
> > > > > > Hope this helps,
> > > > > >
> > > > > >
> > > > > > Preston
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In 
> > > <mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx, 
> > > "rsb_44" <rsb_44@> wrote:
> > > > > > >
> > > > > > > The issue isn't getting below 200. It's accessing the 
> results
> > > > if
> > > > > > > there are over 200. I can readily (as you suggest) 
create
> > >sets
> > > > of
> > > > > > > scans such that the result set of each scan is <=200. 
That
> > > > > becomes
> > > > > > > simple if I chop up one variable into mutually 
exclusive 
> bits
> > > > and
> > > > > > > load each bit into its own scan.
> > > > > > >
> > > > > > > I've gotten Zachs to work well enough to be usable. It 
> wasn't
> > > > > > > functioning very well over the weekend. I'll have to 
check
> > >it's
> > > > > > > values against other screeners. It's Optionable result 
set
> > >was
> > > > a
> > > > > > > disaster...
> > > > > > >
> > > > > > >
> > > > > > > --- In 
> > > <mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx, 
> > > Rod Whitley <rbw1226@>
> > > > > > > wrote:
> > > > > > > >
> > > > > > > > Hi Ron,
> > > > > > > > As for msn site you can do a search with 2 last 
prices.
> > > > > > > > Example;
> > > > > > > > Last Price >= 1
> > > > > > > > Last Price <= 5
> > > > > > > > and/or 2 market caps
> > > > > > > > cap >= 100mil
> > > > > > > > cap <= 500mil
> > > > > > > > Depending on your other search criteria this can 
bring 
> in
> > > > > results
> > > > > > > under the 200 limit.
> > > > > > > >
> > > > > > > > Burt
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > ----- Original Message ----
> > > > > > > > From: rsb_44 <rsb_44@>
> > > > > > > > To: 
> > > <mailto:equismetastock%
> 40yahoogroups.com>equismetastock@xxxxxxxxxxxxxxx
> > > > > > > > Sent: Monday, March 24, 2008 3:18:42 PM
> > > > > > > > Subject: Re: [EquisMetaStock Group] Stock screener
> > > > > > > >
> > > > > > > > Hi Burt -
> > > > > > > >
> > > > > > > > Thanks for the list. I've tried them.
> > > > > > > >
> > > > > > > > <http://moneycentral>http://moneycentral .msn.com/ 
> investor/ 
> > > finder/customsto
> > > > cks.asp
> > > > > > > > Only gives the first 200 in the result set. Doesn't 
> really
> > > > > cover
> > > > > > > > analyst recs.
> > > > > > > >
> > > > > > > > <http://screener.>http://screener. finance.yahoo. 
> > > com/newscreener. html
> > > > > > > > Use the Java based screener limits results to 200
> > > > > > > >
> > > > > > > > <http://www.zacks.>http://www.zacks. com/screening/ 
> custom/
> > > > > > > > Is perhaps the best. No limit on result set displayed
(?)
> > >Easy
> > > > > > > export
> > > > > > > > to csv. Can do workaround on the Analyst recs.
> > > > > > > >
> > > > > > > > <http://www.stockta.>http://www.stockta. com/cgi-bin/ 
> screen.pl
> > > > > > > > Has nice TA screens, but nothing I want.
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > > Ron
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >__________________________________________________________
> > > > > > > ______________
> > > > > > > > Never miss a thing. Make Yahoo your home page.
> > > > > > > > <http://www.yahoo.com/r/hs>http://www.yahoo.com/r/hs
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > 
> > 
> > [Non-text portions of this message have been removed]
> >
>



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/