|
PureBytes Links
Trading Reference Links
|
David
The section called "Roll Your own Indexes" on Page 64 of the FormulaBook.pdf
tells you how to create an index using the "Create Composite" function in
the DownLoader. See the files section of this forum for the file. There is
also a way of simulating the Security() function with MS EOD which I can
explain on the TE forum.
Roy
----- Original Message -----
From: "DAVID H. LINTON" <dhlinton@xxxxxxxxxxxx>
To: <Metastockusers@xxxxxxxxxxxxxxx>
Sent: Monday, November 25, 2002 1:50 AM
Subject: Re: [Metastockusers] Re: Correlation Exploration?
> Roy and Harold
> Slightly off the topic of this thread, but, I think the security function
in
> MS Pro can be used to easily create an index (or base) for Comparative
> Relative Strength work. For example, take 10 stocks of interest, create
your
> index, then use the CRS indicator.
> How do you do this in MS EOD?
> Is the only way to, one by one, build a multi stock composite?
> Thanks
> David
>
>
> ----- Original Message -----
> From: "Roy Larsen" <rlarsen@xxxxxxxxxxxxxx>
> To: <DEFANGED_Metastockusers@xxxxxxxxxxxxxxx>
> Sent: November 23, 2002 6:43 PM
> Subject: Re: [Metastockusers] Re: Correlation Exploration?
>
>
> > Dominick
> >
> > You can use this sort of code in an MS EOD exploration if you first open
> > your reference index (or stock) chart, mark the chart (highlight it),
and
> > substitute "P" or "INDICATOR" for "Security("C:\metastock data\spy",C)".
> > Also be aware that CLOSE is the only price you can pick up from an index
> (or
> > stock) unless you first create a separate indicator for one or more one
of
> > the other prices (O,H,L) then drop that on the chart and mark it instead
> of
> > the base chart.
> >
> > Another way to select a different price would be to drop a 1 period SMA
> onto
> > the chart selecting the required price, then mark the SMA so that it is
> > picked up by the P (INDICATOR) function.
> >
> > Roy
> >
> > > Hi Joe:
> > >
> > > I tried your formula but it came back as "This function ia available
> > > only in MS Pro.
> > >
> > > Any chance of writing one for verf 7.2 EOD.??
> > >
> > > TIA,
> > >
> > > Dominick
> > >
> > >
> > >
> > > --- In Metastockusers@xxxx, "Joe J." <jojab@xxxx> wrote:
> > > > Harold,
> > > >
> > > > Here is a correlation formula I used to try and find out how stocks
> were
> > > > correlated to the SPY. Obviously, you could replace the SPY with
your
> > > > .IXIC or the QQQ for that matter.
> > > >
> > > > I decided to see how the 13 periods EMA's of the two correlated
rather
> > > > than doing a straight correlation thinking this might smooth out one
> or
> > > > two day swings, here and there.
> > > >
> > > > I put this in Col A then used the filter to weed out stocks that
> didn't
> > > > have good average daily volume and meet a certain price range. Then
I
> > > > simply clicked to sort on the report so I could see the most highly
> down
> > > > to least correlated.
> > > >
> > > > From this, you should be able to do what you are looking to do. You
> > > > just have to tell it which security you are using as the base and
> where
> > > > to find it.
> > > >
> > > >
> > > > Mov(
> > > > Correl(
> > > > Mov(
> > > > Security(
> > > > "C:\metastock data\spy",C),
> > > > 13,E),
> > > > Mov(C,13,E),
> > > > 2,0),
> > > > 100,E)
> > > >
> > > > Good Trading,
> > > >
> > > > Joe J.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: hcour
> > > > Sent: Fri 11/22/2002 6:04 AM
> > > > To: Metastockusers@xxxx
> > > > Cc:
> > > > Subject: [Metastockusers] Re: Correlation Exploration?
> > > >
> > > > Thanks Chris, I'm sure FT is great. But I would really have no need
> > > > for it other than that and I'm pretty sure this can be done in MS. I
> > > > just don't know how. The formula is as follows:
> > > >
> > > > Correl(DataArray, DataArray, Periods, Shift)
> > > >
> > > > Now I suppose I would put this in colA with the proper data and then
> > > > in the Filter put "cola > .80". But I don't know how to put in
> > > > the "proper data" or how to make it reference the index.
> > > >
> > > > Again, any help appreciated!
> > > >
> > > > Harold
> > > >
> > > >
> > > > --- In Metastockusers@xxxx, -= Chris ß =- <baudecb1@xxxx> wrote:
> > > > > Harold,
> > > > >
> > > > > FastTrack will do that very quickly. As a matter of fact, that is
> > > > one
> > > > > of it's main feature.
> > > > >
> > > > > see: www.fasttrack.net
> > > > >
> > > > > -= Chris ß =-
> > > > > Using FastTrack/FastRUBE/FastTools/Trade/EZPnF/PSM/AmiBroker
> > > > > FastBreakPro/SpeedResearch/Agent
> > > > > (Moved from MSP to AmiB, and never looked back!)
> > > > >
> > > > > On Thu, 21 Nov 2002 22:12:32 -0000, you wrote:
> > > > >
> > > > > > I would like to find stocks that have high correlations to their
> > > > > > respective indices. For instance stocks that have a .80 or
better
> > > > > > correlation to the .IXIC (Nasdaq).
> > > >
> > > >
> > > >
> > > > Yahoo! Groups Sponsor
> > > > ADVERTISEMENT
> > > >
> > > >
> <http://rd.yahoo.com/M=219695.2596658.3969980.1927555/D=egroupweb/S=1705
> > > >
> 001779:HM/A=1226184/R=0/*http://ad.doubleclick.net/jump/N879.ameritrade.
> > > > yahoo/B1054521.11;sz=300x250;adc=ZHS;ord=1037970272?>
> > > >
> > > >
> <http://us.adserver.yahoo.com/l?M=219695.2596658.3969980.1927555/D=egrou
> > > > pmail/S=:HM/A=1226184/rand=512120737>
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > Metastockusers-unsubscribe@xxxx
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > > > <http://docs.yahoo.com/info/terms/> .
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > Metastockusers-unsubscribe@xxxxxxxxxxx
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Metastockusers-unsubscribe@xxxxxxxxxxx
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> Metastockusers-unsubscribe@xxxxxxxxxxx
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
·FREE Health Insurance Quotes-eHealthInsurance.com
http://us.click.yahoo.com/1.voSB/RnFFAA/46VHAA/zMEolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|