From the price data sheets downloaded above, use only the closing price of the day. Perform data normalization (edit data for price changes due to issue of bonus share and/or share split besides taking care of missing dates).
finance
Description
1. Select Any 12 stocks (each from Different Industry) from NSE “NIFTY” List (As given in Annexure 1).
2. Download their prices (NSE DATA only) from 1st April, 2020 to 15th January, 2021 (9 ½ months). Save each company data in a separate Excel Worksheet and Label each sheet as “”Sr.No.” “Company Name””. For example, if you select Reliance Industries Ltd. as the first stock, the sheet will be named as “1 RIL”. Also download NIFTY data for the corresponding period and put it in sheet labelled as “13 NIFTY”.
3. From the price data sheets downloaded above, use only the closing price of the day. Perform data normalization (edit data for price changes due to issue of bonus share and/or share split besides taking care of missing dates).
Show in a single EXCEL worksheet “14 Master Data”: all the Dates (1st Column), 12 selected Stocks prices (Column 2 to 13) and NIFTY Values (Column 14).
