|
PureBytes Links
Trading Reference Links
|
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@xxx>
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/
|