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

Re: [EquisMetaStock Group] Comparing multiple issues by percentage



PureBytes Links

Trading Reference Links




<FONT face=Verdana 
size=2>Leo,
 
Attached please find a chart which I use to track 
the various industry groups on the NSE (India).
 
Here is the sample formula to generate the 
"sectoral indices".



Choice:= 
Input("1=Normal;2=Normalised",1,2,1);D1:=Input("Normalise from 
Date",010100,123199,010101);
 
aa:= Security("D:\MetaStock 
Data\NSE\A\AAAAA",C);bb:= Security("D:\MetaStock 
Data\NSE\A\ABABAB",C);cc:= Security("D:\MetaStock 
Data\NSE\C\CCCCC",C);dd:= Security("D:\MetaStock 
Data\NSE\W\WWWWW",C);ee:= Security("D:\MetaStock 
Data\NSE\I\IIIII",C);ff:= Security("D:\MetaStock 
Data\NSE\I\IJIJIJ",C);gg:= Security("D:\MetaStock 
Data\NSE\M\MMMMM",C);
 
in:=(aa+bb+cc+dd+ee+ff+gg);
 
den:= If(aa > 0, 1, 0) +If(bb > 0, 1, 0) +If(cc > 0, 
1, 0) +If(dd > 0, 1, 0) +If(ee > 0, 1, 0) +If(ff > 0, 1, 0) 
+If(gg > 0, 1, 0) ;
 
ind:= in/den;
 
L01:=LastValue(ValueWhen(1,Month()=(Int(D1/10000)) AND 
DayOfMonth()=(Int(D1/100)-((Int(D1/10000))*100)) AND 
Year()=(If(Mod(D1,100)>30,1900+Mod(D1,100),2000+Mod(D1,100))),ind));
 
If(Choice = 1, ind, (ind/L01)-1)



You will need to substitute the data path and the Ticker Symbols with those 
of your choice. You can either plot each as an overlay without scale or 
"normalise" it to a specific date, the choice is yours.
 
DusantChief Architect<A 
href="">http://www.candlestrength.com/
 
----- Original Message ----- 
From: "Larry Carhartt" <<A 
href=""><FONT face=Verdana 
size=2>lc@masterdata.com>
To: <<A 
href=""><FONT face=Verdana 
size=2>equismetastock@yahoogroups.com<FONT face=Verdana 
size=2>>
Sent: Tuesday, September 07, 2004 8:18 
AM
Subject: RE: [EquisMetaStock Group] Comparing 
multiple issues by percentage
<FONT face=Verdana 
size=2>> Hi Leo,> > Should not be too difficult using 
MetaStock's "security" function (although> I think you will only be able 
to plot a line chart, not a bar or candle> chart for each ETF).  
Personally, I like to set one custom indicator solely> for the purpose of 
defining the issue of interest (using the "security"> function) and then 
use that indicator in my subsequent custom indicators> (i.e. figuring out 
the percentage change in your case), but that is up to> you.  You 
can then have as many custom indicators reflecting the percentage> 
changes in your chart as your CPU and memory allows.> > Hope this 
helps get you started.> > Best,> > Larry 
Carhartt> Index & ETF Component Data> <A 
href=""><FONT face=Verdana 
size=2>www.MasterDATA.com> <A 
href=""><FONT face=Verdana 
size=2>lc@masterdata.com> 
818-701-6686> > > > -----Original 
Message-----> From: leomkarl [mailto:leokarl@brownscreek.us] > 
Sent: Monday, September 06, 2004 4:19 PM> To: <A 
href=""><FONT face=Verdana 
size=2>equismetastock@yahoogroups.com<FONT face=Verdana 
size=2>> Subject: [EquisMetaStock Group] Comparing multiple issues by 
percentage> > > I'm new to metastock and would appreciate 
assistance on how to > approach the following:> > How can I 
display several stocks on a single chart such that the > relative 
movement of each stock is shown as relative percentage rise > or fall 
rather than absolute price.   In other words, the horzontial > 
axis would be time, while the vertical axis would be percentage > 
movement from the left most point on the chart.> > My thought is 
to show relative performance of multiple issues on a > single chart, and, 
to be able to change the presentation from day to > day without having a 
complex rebuilding process.  It's an effort to > follow sectors 
(ETFs) and determine the best and worst performers > over time.> 
> If I should succeed in developing a workable method, I would then be 
> interested in how to go about running a system test --- but, first 
> things first.> Thanks,  Leo> > > 
> > > >  > Yahoo! Groups Links> 
> > >  > > > > > 
> > ------------------------ Yahoo! Groups Sponsor 
--------------------~--> > $9.95 domain names from Yahoo!. Register 
anything.> <A 
href=""><FONT 
face=Verdana 
size=2>http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/BefplB/TM<FONT 
face=Verdana size=2>> 
--------------------------------------------------------------------~-> 
> >  > Yahoo! Groups Links> > <*> 
To visit your group on the web, go to:>     <A 
href=""><FONT face=Verdana 
size=2>http://groups.yahoo.com/group/equismetastock/<FONT 
face=Verdana size=2>> > <*> To unsubscribe from this group, send 
an email to:>     <A 
href=""><FONT face=Verdana 
size=2>equismetastock-unsubscribe@yahoogroups.com<FONT 
face=Verdana size=2>> > <*> Your use of Yahoo! Groups is subject 
to:>     <A 
href=""><FONT face=Verdana 
size=2>http://docs.yahoo.com/info/terms/<FONT face=Verdana 
size=2>>  > > 







Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/equismetastock/ 
To unsubscribe from this group, send an email to:equismetastock-unsubscribe@yahoogroups.com 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.







Attachment:
BSE Sectors.png

Attachment: Description: "Description: PNG image"