|
PureBytes Links
Trading Reference Links
|
Thanks again for your reply Super. Are you indicating that I can
convert the list that I generate from my Relative Strength
Comparison into Excel format? From looking at the Convert tool in
the Downloader, it appears to convert security data but not the list
I generate. Am I missing something?
Charles
--- In equismetastock@xxxxxxxxxxxxxxx, superfragalist <no_reply@xxx>
wrote:
>
> To pass data out of MS to Excel, open the downloader and use the
> convert function under the tool tab.
>
> You can convert from MS to Excel and from Excel to MS.
>
> Read the help screens under the downloader help section to
understand
> the date and column headings required to import or export data.
It's
> very simple. I just imported 12 years worth of data from the from
the
> CBOE website by downloading it to excel, reformatting the excel
files
> to the MS spec and then importing the excel files into MS. It took
> about 10 minutes.
>
> SpyGlass is the only alternative for external relative strength
that
> I've ever come across. For the relative strength comparatives,
like I
> said the weighted ROC formula that I posted awhile back produces
> almost the same ranking as do other dedicated RSC programs. That
> formula is really cheap.
>
> What is not cheap is turning the weighted ROC into testable
> information, or into a consistent expert system. I guess it all
comes
> down to how much your time is worth.
>
> Have fun with excel!
>
> Super
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "cherotree1" <mass54thcob@>
> wrote:
> >
> > Thanks for the reply, Super and also for clarifying the IBD
> > methodology. I do have Excel but I hardly ever use it and I
> > certainly could not be considered proficient. I do know how to
copy
> > the Metastock list that I produced but I get strange results
when I
> > attempt to paste the results in Excel. Could you share the steps
to
> > paste the list in excel and have it numbered?
> >
> > I did take a look at the Splglass product. I was attempting to
see
> > if I could come up with a usable alternative (and cheaper :-)).
> > Thanks again for your assistance!
> >
> > Charles
> >
> > --- In equismetastock@xxxxxxxxxxxxxxx, superfragalist
<no_reply@>
> > wrote:
> > >
> > > First IBD doesn't compare each stock to a base index. IBD uses
> > > External Relative Strength which compares every stock to every
> > other
> > > stock in the population someone is using.
> > >
> > > I've tested many ranking formulas and External Relative
Strength
> > works
> > > better as a filter than any of the other method including
Relative
> > > Strength Comparatives, which is what you are talking about.
> > >
> > > If you want an ERSC ranking that is the same as the IBD
ranking,
> > the
> > > old SpyGlass plugin does that. It's called Fire now.
> > >
> > > SpyGlass puts a ranking value from 1 to 100 on each stock in
the
> > ERSC
> > > comparison population and the numerical value means the same
thing
> > > from week to week and can be used in the tester.
> > >
> > > RSC values are meaningless in the tester because they are a
> > relative
> > > number only and do not have the same meaning from week to
week.
> > >
> > > As far as counting goes, Roy uses a dll function in the
explorer
> > that
> > > can count but I don't think it can sort on the highest value.
I
> > don't
> > > use it so Roy will have to explain it.
> > >
> > > You can always export your list to excel and have excel sort
and
> > > number them.
> > >
> > >
> > > Super
> > >
> > >
> > >
> > >
> > >
> > > --- In equismetastock@xxxxxxxxxxxxxxx, "cherotree1"
<mass54thcob@>
> > > wrote:
> > > >
> > > > I am using this formula ROC(MOV((C/P),26,S),1,%), and
comparing
> > it to
> > > > a base index, to generate a list of securities which I can
then
> > sort
> > > > by either Relative Strength, Symbol or Security Name.
> > > >
> > > > My question to the group; is it possible to have the printed
> > output of
> > > > this list numbered i.e. number 1 for strongest, up to the
last
> > number
> > > > in my list. Or, is it even possible to rank this list
similar to
> > the
> > > > RS rankings that are listed by Investors Business Daily
(maybe
> > 100-
> > > > strongest to 0-weakest). Any and all replys are appreciated.
> > Peace!
> > > >
> > > > Charles
> > > >
> > >
> >
>
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/
|