TATA ELXSI
Yesterday while discussing a query on Yes Bank I realised that the EW calculator I made years ago was meant for flats in a normal small range market or bull market. If the fall is zig-zag in a bear market the numbers go negative simply because of the way you use the ratio. Now if I am using it I know the nuances and I do a lot of approx calculations on Metastock using the Fib tool itself.
[What I will need to do is update the calculator and send it out again. Change to make the ratio x/a v/s a/x in a bull/bear market scenario and with an if/then function chose if x>a or x<a for different formula, ignore if too technical for you]
Here is a changed sheet I used to work on Tata Elxsi where it is in a steep decline and I want projections for wave 3 at 161.8% of 1 without going negative.
|
Flats
|
X
|
A
|
%
|
B - 0.618
|
B - 0.50
|
|
|
1010
|
822
|
1.23
|
938
|
916
|
|
|
|
|
|
|
|
|
Zig-Zag
|
B
|
C - 0.618
|
C - 1.0
|
C - 1.382
|
C - 1.618
|
|
|
929
|
1060
|
756
|
706
|
678
|
|
|
|
|
|
|
|
|
Exp Flat
|
B - 1.382
|
B - 1.236
|
C= 0.618 < A
|
|
|
|
|
1082
|
1054
|
|
|
|
|
C - 1.618
|
790
|
770
|
720
|
|
|
Now let us look at the chart of the stock with the markings from the above. Wave 3 of C goes to 756 but an extended third wave as is normal would go to 678. Wave C itself goes to 560. All this is based on where I mark A and B. A is the low after a triangle because triangles are wave iv and so wave v ends after that.
