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.
NASDAQ: https://old.nasdaq.com/
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
prices.
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
will appear.
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.
Multpl.com
o https://www.multpl.com/6-month-treasury-rate
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!"
