Comment on Live Example - 2

Pramod commented on 23 Jun 2018, 04:49 PM

I want to check which stock is driving bank nifty on any single day if bank nifty is in good momentum.
That is why i want to know how much points are contributed by any bank nifty constituent stock say ICICI bank.
Eg
If icici bank changes by 4 points how much change there will be in bank nifty is other stock are assumed to be constant.

Is this kind of working possible in excel? if yes.
Then can u please help in doing this analysis

Thanks you

View the full comment thread »