Collect the daily stock prices over

January 16, 2021| Pro Writer

Collect the daily stock prices over the past year from Yahoo! Finance for SPY, which is the symbol for the exchange traded fund that attempts to mimic the S&P 500 index, which is often used as the pro

  1. Collect the daily stock prices over the past year from Yahoo! Finance for SPY, which is the symbol for the exchange traded fund that attempts to mimic the S&P 500 index, which is often used as the proxy for the market portfolio, and two other stocks of your choice that have been publicly traded firms for at least one year. Follow the guidelines in the “Obtaining Historical Returns from Yahoo” document.
  2. Use the Excel file I posted called M5 Project 1 Excel Class to calculate the same statistics. See the formulas in the cells as a guide.

Better yet, try to match your return cells with my return cells so that everything automatically populates.

Follow the “Obtaining Historical Returns from Yahoo” file to see what I mean by this.

3.Discuss your findings. This should include:

A discussion of the main statistics, such as

  • the expected return for each stock,
  • the standard deviation for each stock, the expected return of the portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%) provided in the sheet,
  • AccountingEnglishBusinessHistoryPhilosophyLawEconomicsPsychologyReligionSociologyArtManagementMarketingEducationScienceNursingLiteraturePolitical ScienceComputer ScienceTechnologyBiologyGeographyPhysicsChemistryMathematicsAnthropologyMedical, and Finance.

    Order Custom Paper ( Get 100% Original and Plagiarism Free Work )


    Post your own question and get a custom answer

    Hire Writer Today and Get A + Work

    Ecadimi Will Provide You Custom Work 100% Original and Plagiarism free. ( Written From Scratch )
    We can write all sorts of essays on multiple subjects. The covers we cover for essays include subjects: English, Business, History, Philosophy, Law, Economics, Psychology, Religion, Sociology, Art, Management, Marketing, Education, Science, Accounting, Nursing, Literature, Political Science, Computer Science, Technology, Biology, Geography, Physics, Chemistry, Mathematics, Anthropology, Medical and Finance.

    Step 1 of 2

    50%
    • Drop files here or
      Optional

Categories: Homework Answers

Leave a Reply

Your email address will not be published. Required fields are marked *

Rating*

Support