Ideal Verge - Your Daily Dose of Knowledge and Inspiration.

Since last Diwali following stocks managed to deliver awesome returns while benchmark indices fetched investors a meager returns  in the 8-10 % range.

Scrip	Return %	Sector
Goenka Diamonds	661	Gems & Jewellery
Wockhardt Pharma	278	Pharma
JK Laxmi Cement	228	Cement
Vakrangee Software	213	Software
JK Cement	194	Cement
Vaibhav Gems	180	Gems & Jewellery
Heritage Foods	163	Food Processing
Amar Raja Batteries	148	Auto Ancillaries
VGuard	128	Electricals
Shree Cement	128	Cement
Ajanta Pharma	125	Pharama
Geometric Software	124	Software
Atul	123	Speciality Chemical
Dishman Pharma	123	Pharma
helios & Matheson IT	123	Software
20 Microns	117	Minerals
Zicom Security Systems	115	Security Systems
MCDowell No. 1	114	Liquor & Spirits
Madras Cement	114	Cement

A couple of days back, I had written an AFL required by a boarder of a forum I frequent which marked highest/lowest close on a chart by placing a hollow colored rectangle near the close price and printed highest/lowest close value on the stock chart.

We are often required  to ascertain the highest/lowest value for a  a period and this AFL caters this need. We get highest/lowest price bars without actually straining our brain especially in a candlestick chart.
One can change the period as per his requirement while 7 being the default value.



Desired AFL is as follows:


prd=Param("Period",7,5,5000,1);
Hv=LastValue(HHV(C,prd));Lv=LastValue(LLV(C,prd));
t1=H*1.01;t2=L*.998;
bi=BarIndex(); Lb=LastValue(bi);

Hbi=LastValue(ValueWhen(C==Hv,bi));

ph=LastValue(ValueWhen(bi==Hbi,H))*1.01;

Lbi=LastValue(ValueWhen(C==LV,bi));
PlotShapes(IIf(bi==hbi ,shapeHollowSquare,shapeNone),colorTurquoise,0,t1);
PlotShapes(IIf(bi==lbi ,shapeHollowSquare,shapeNone),colorDarkYellow,0,t2);

dch=LastValue(ValueWhen(bi==Hbi,C));
zz=dch*1.01;
dcl=LastValue(ValueWhen(bi==lbi,C));
yy=dcl*.99;

GfxSetBkColor(colorWhite);
GfxSetTextColor(colorDarkGreen);
GfxTextOut("Highest "+prd+" Day Close:"+dch,250,50);

GfxSetTextColor(colorRed);
GfxTextOut("Lowest "+prd+" Day Close:"+dcl,250,150);

Rakesh Jhunjhunwala, the legendary Indian billionaire investor known for his his expertise in value investing  saw some  of his stocks beating  the returns given by the NSE benchmark index Nifty while rest of stocks under performed and  a few even gave the negative returns since last Diwali to this Diwali.
RK is a long term investor and does not get perturbed when his shares perform unfavorably  for a year or two.

Ticker	LTP	Return %
GEOMETRIC	103	122
AUTOIND	167	52
TITAN	294	36
KARURVYSYA	471	25
LUPIN	585	21
GEOJITBNPP	22	20
PANTALOONR	198	8
ATFL	428	8
CRISIL	930	7
RALLIS	157	-4
PIPAVAVDOC	82	-5
VICEROY	25	-8
HINDOILEXP	98	-10
PFOCUS	48	-14
NCC	41	-23
DELTACORP	74	-24
RBN	43	-33
ALPHAGEO	55	-34
ORCHIDCHEM	103	-35
PRAJIND	46	-44
VIPIND	78	-54
SUBEX	14	-66
A2ZMES	60	-67

Year 2007 was really a boom year when  bourses rose meteorically following a huge FII inflows.
following is a list of top 10 best returns from their 2007 high close.

SN Ticker LTP Highest close Price Appreciation (%) of 2007 since 2007 1 TTK Prestige Ltd 3358.15 196 1613.34 2 Page Industries 3327.1 480.1 593 3 Ajanta Pharama 363.1 57.03 536.74 4 Eicher Motors 2503.25 472.2 430.12 5 somany Ceramics Ltd 86.1 16.73 414.64 6 Vakrangee Soft. Ltd 55.05 12.84 328.82 7 GSK Consu. Healthcare 3051.5 740.15 312.28 8 Rallis India Ltd. 148.95 37.1 301.45 9 Lupin Ltd. 584.7 146.42 299.33 10 Amar Raja Batteries Ltd. 257.35 67.3 282.39

Save following simple code in  the 'Formulas\custom ' folder with the name as CountTickers. afl or other name of your choice.


Filter=1;
AddColumn(Status("StockNum"),"no",1);

Run the AFL in the Automatic Analysis window and this AFL shall rank each ticker. The rank of the last ticker is the count you were looking for. 

For that click on the 'no' ticker to get the count in descending order.

Ticker	SCRIP	Today's Close(Rs.)
DCHL	Deccan Chronical Holdings	7.3
EMKAY	Emkay Global Fin Services	20.95
INVENTURE	Inventure growth & securities	13.7
JUPITER	Jupiter Bio Science	5.45
KSOILS	KS Oils Ltd.	4.3
KWALITY	Kwality Dairy Ltd.	25.75
MARG	Marg Limited	70.15
SEZALGLASS	Sezal Glass Ltd.	3.55
TARMAT	Tarmat Ltd.	18
ZENITHBIR	Zenith Birala India	2.75

NB : Low price doesn't indicate value and this data is for information purpose value.