The purpose of this assignment is to apply the statistical and portfolio concepts provided in the book and discussed in class to compute and compare the returns and the relationships among the three stocks you selected in Project #1. The requirements for this project are:
1.Collect prices for (a) each stock you selected in Project #1, (b) the NYSE composite index(NYA), and (c) the 6-month Treasury Bill rate for the end of each month for the periodbeginning December 2014 and ending December 2019. The data you need can be obtainedon the Internet by going to one of the following websites or websites that provide similarinformation/data.
Yahoo Finance: https://finance.yahoo.com/
Yahoo Finance works best using the Google Chrome search engine.
Type the stock symbol or company name in the search box located at the top of thescreen; click on the appropriate symbol when it appears.
Click â€œHistorical Dataâ€ on the row below the price quote.
In the row labeled â€œTime Period,â€ change the â€œTime Periodâ€ to 12/31/2014 â€“12/30/2019; change the â€œFrequencyâ€ selection to â€œMonthly;â€ click â€œApplyâ€
Click â€œDownload Dataâ€ (located below â€œApplyâ€) to download the prices to an Excelspreadsheet.
You can download stock price data even for stocks not traded on NASDAQ.
Enter the stock symbol in the search box at the top of the page (the box with â€œEntersymbol, name or keywordâ€ written inside).
In the menu shown on the left side of the page click â€œHistorical Quoteâ€ to archive paststock prices.
On the next screen, change the â€œSelect the Timeframeâ€ from 3 months to 6 years.
Once the data are loaded, go to the bottom of the data list to download the numbers intoan Excel spreadsheet (click â€œDownload this file in Excel Formatâ€).
Because you are given daily stock prices, you must edit the data to include only end-of-month prices.
The Wall street Journal: https://www.wsj.com/news/markets
Below the graph that shows current quotes for various global markets (on the right sideof the page; you might have to scroll down to see the graph), you will see a search areanamed â€œQuotes Lookup.â€ In the search box, labeled â€œQuotes & Companies,â€ enter thecompanyâ€™s stock symbol (you can find the symbol by typing the companyâ€™s name;possible symbols will appear in a dropdown menu). Click on the company for which
you want to retrieve data.
On the next page, click on the â€œALL SECTIONSâ€ symbol below the lower right corner
of the graph on the screen; a dropdown menu will appear; click on â€œHistorical Prices.â€
In the boxes located above â€œDATEâ€ (at the top left of the table that contains price data)
enter the range from 12/31/2014 to 12/31/2019; click â€œGOâ€
Click â€œDOWNLOAD A SPREADSHEET,â€ which is located on the right side of the
screen above the data table; the data will be contained in the spreadsheet you download.
Because you are given daily stock prices, you must edit the data to include only end-ofmonth
Treasury-Bill data can be downloaded at:
St. Louis Fed: https://fred.stlouisfed.org/search?st=treasury+bil…
o Look for â€œ6-Month Treasury Bill: Secondary Market Rateâ€
o Click on the word â€œMonthly,â€ and a graph of the monthly rates from 1960 to 2020
o Click the DOWNLOAD tab located above the graph on the right side of the screen;
select the type of file to which you prefer the data to be downloaded.
o Click: â€œTableâ€ below the graph on the left side of the page.
o Click â€œBy Monthâ€ above the table that appears on the next page.
o Highlight the months and values you need for the project, and then cut and paste
those numbers into your spreadsheet
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"