By doing this high comes to 201.10 but actual high is 200.
Can you explain detail like you have done for low value.
Also how can we find values for next day.
Thanks
I am trying to make a vedio which i can upload so u people will get complete idea .
See why u get this 201.10 instead of 200 .I want to u first get there bcoz there is one more thing which i want to tell u but at that time if i told U things get mixed .
See in my rule i have written that OPEN OF 29june is very imp nw u will see the importance of that .
29june open
196.75
+1.14 ----stock % change
+1.45 ----nifty % chnage
if u see here DLF is a high beta stock means if market is showing +1.45% increase it is showing only +1.14 . if u go according to beta it have to jump up to +1.75 or more .
So although stock is showing strong uptrend but due to this opening value we can say that TODAY it is facing some difficulty .
so earlier u have divided by 7/2 = 3.5 but actually u have to divide
6/2 + 1(we have taken whole 1 value for open bcoz here it is lacking the trend )
3+1 = 4 the actual value by which u have to divide . so your max will come exact 200
THATS WHY I AM TELLING EVERYONE , WE CAN NOT GO FOR EXCEL IN THIS METHOD,,,, IT HAS TO BE DONE MANUALLY