The purpose of this assignment is to apply the statistical
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/marketsBelow 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 whichyou want to retrieve data. On the next page, click on the “ALL SECTIONS” symbol below the lower right cornerof 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 thescreen 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-ofmonthprices.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 2020will 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.como https://www.multpl.com/6-month-treasury-rateo 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 pastethose numbers into your spreadsheet
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
