I am using this worksheet to calculate this data …Please suggest is this a correct way ?
View attachment 11539
Column B is a yahoo symbol.
Column C-J is a data fetched from yahoo
Column L – row 14 onward is a number of stocks in Crr, taken from ICICI site.
Based on number of stocks and current price, calculation of current Capital is in column L. = L14*C13
I divide this SUM (M64) by current NIFTY points to get value for 1 NIFTY point L2 =M64/C12
So I get current Nifty points for each stock in column N.
Same way I calculate for previous capital in column P = (H13*L14)
Divide this sum by previous NIFTY point to get previous 1 NIFTY point L3 = =P64/H12
So I get Previous Nifty points for each stock in column Q
Column R indicates the change in Nifty points by each stock.
Sorting at column N always show the current weightage from low ot high.
Hit button in B1 to refresh and get real-time data.
--------
This helps me to understand which stocks are moving NIFTY and what is that stocks volume (strength) ...
View attachment 11539
Column B is a yahoo symbol.
Column C-J is a data fetched from yahoo
Column L – row 14 onward is a number of stocks in Crr, taken from ICICI site.
Based on number of stocks and current price, calculation of current Capital is in column L. = L14*C13
I divide this SUM (M64) by current NIFTY points to get value for 1 NIFTY point L2 =M64/C12
So I get current Nifty points for each stock in column N.
Same way I calculate for previous capital in column P = (H13*L14)
Divide this sum by previous NIFTY point to get previous 1 NIFTY point L3 = =P64/H12
So I get Previous Nifty points for each stock in column Q
Column R indicates the change in Nifty points by each stock.
Sorting at column N always show the current weightage from low ot high.
Hit button in B1 to refresh and get real-time data.
--------
This helps me to understand which stocks are moving NIFTY and what is that stocks volume (strength) ...
Last edited: