Explore BrainMass
Share

Explore BrainMass

    Stock Price Comparison

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I need help with an excel spreadsheet in the format listed below. I have been struggling to finish some accounting that requires me to use aggregate functions inside of Microsoft Excel.

    This is the format originally but needs to be done by the way it is listed below the astericks.

    Symbol Stock Name Mon Tues Wed Thurs Fri

    This assignment requires that I need to look up specific stock symbols, identify the company name, and the closing price-per-share (PPS) value at the end of business for five weekdays. Then, create an average price for the week for each stock. Finally, I need to compare the relative growth of each stock over the course of the week to determine which one performed the best during that time period.

    * * *

    Using Microsoft Excel, create a spreadsheet with a similar format and solve Juan's problem. Use the following stock symbols: MSFT, YHOO, AAPL, IBM, and JAVA. Complete the weekly average analysis using aggregate functions.

    It would be greatly appreciated if oyu can assist me with this. Thanks!!

    © BrainMass Inc. brainmass.com October 9, 2019, 9:01 pm ad1c9bdddf
    https://brainmass.com/business/business-management/stock-price-comparison-170192

    Solution Preview

    Please find attached, a formatted MS Excel spreadsheet containing the information below, as well as notes on how the figures were calculated. Feel free to contact me in the future, in the event that additional assistance is required.

    CLOSING ...

    Solution Summary

    This file contains a formatted MS Excel spreadsheet containing instructions on how to perform a stock price comparison.

    $2.19