- Select 10 stocks of your choice from the NYSE and identify their tickers.
- Collect the prices for each stock from Yahoo! Finance as follows:
a. Enter the stock name/ symbol on the search tab. On the page for that stock, click â€œHistorical Pricesâ€.
b. Enter the â€œstart dateâ€ as Jan 1, 2016 and the â€œend dateâ€ as Jan 1, 2020 to cover the five-year period. Make sure you select â€œmonthlyâ€ frequency.
c. After hitting â€œapplyâ€ button, click â€œDownloadâ€.Open the file and save it as an excel workbook.
d. Delete all the columns except the date and the adjusted close price.
g. Repeat these steps for the remaining 9 stocks, pasting each closing price right next to the other stocks.Make sure that the correct prices on the correct dates all appear on the same rows.