Couldn't got w.r.t........please write what it mean...?
A handy abbreviation for 'with respect to'. Let me rephrase my question: how would you define the quantities in column J?
my personal thinking is - change of nifty % should be equal sum of change in all 50 stocks, If u watch the sheet Total change in nifty % is 3.26613%, other side sum of % change in stocks is 3.228344 (there is minor diff. and I am helpless here as it is auto calculated)
This justifies that no index-stock is preferred to over another (or a group of other index-stocks). Which is a reasonable thought I would subscribe to myself. However, I do have my two cents on the difference:
[1] Pedantically speaking the difference is about 1.16%. So, do we smell a smoothing factor which is applied to the net change to all index stocks? [The Conspiracy Theory school of thought
]
[2] Floating point round-off error: this is probably the only plausible reason. Different systems (software and otherwise) have different methods to round-off with floating point data (i.e. fractions) and typically yield results which start differing someplace after the decimal point.
[1] and [2] can be tested for by checking your calculator against historical data and if the difference is random [2] can be assumed to be true. However, a constant difference should hint at [1].
I used ABS just to remove the - sign, else u r right.
I guessed as much. However, not all rows of column J have the ABS() thingy. And it shouldn't be there as it violates the logic (in fact the net diff comes to > 4 if you have ABS everwhere).