Stock exchange archive data without any adjustment following issue of either bonus share or splitting of face value. For such cases, it is required to make adjustment in the downloaded DATA. First, save data from the SE in an excel file calling it "SE_DATA" sheet. Secondly, copy appropriate columns such as OHLC & Volume in another sheet calling it "Chart" sheet.
Adjustment factor which is such that parity before the ex-date is restored; in case of 2:1 bonus issue, historical prices before bonus issue (in BLUE high lighted area) are divided by 3. For these all cells in the last row (in sheet named "Chart(Historical)" before the ex-date) are to be revised (using "F2" option in Excel ) and then copy/paste over the data range. Data are to be updated in "SE_DATA" sheet only & last row in the Chart(Historical) sheet are to be copied & pasted in next row and final Chart is to be generated from these sheet.
sir if u pls hlp me in calculating eps in case of share split
ReplyDeletesir do add some more useful blog relating to stock market
ReplyDelete