|
PureBytes Links
Trading Reference Links
|
Thanks Roy
Although I have not done it, what I meant by "Is the only way to, one by
one, build a multi stock composite?" is what the Formula Primer calls "Roll
Your own Indexes" on Page 64.
Sounds like a lot of work when you want more than a few custom indices.
Is your approach to "simulating the Security() function with MS EOD" more
efficient?
Thanks
David
----- Original Message -----
From: "Roy Larsen" <rlarsen@xxxxxxxxxxxxxx>
To: <Metastockusers@xxxxxxxxxxxxxxx>
Sent: November 24, 2002 3:38 PM
Subject: Re: [Metastockusers] Re: Correlation Exploration?
> 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/
> >
> >
> >
> >
>
>
>
>
> 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/
|