This needs to be done in an excel spreadsheet using the first 5 stocks This assignment requires creating an Excel spreadsheet that tracks the weekly stock prices for a total of ten stocks, including five provided stocks and five additional stocks specified. Starting from July 12, 2013, which is a Friday, data should be collected for each subsequent Friday over a span of seven weeks, specifically July 12, 2013; July 19, 2013; July 26, 2013; August 2, 2013; August 9, 2013; August 16, 2013; and August 23, 2013. The stock prices for these dates must be accurately retrieved and entered into the spreadsheet. The first column of the spreadsheet should list these dates. Following columns should correspond to each of the ten stocks, with the respective closing prices entered for each week and for each stock. The stocks include the initial five stocks provided in the example, plus the additional five: Corning, Walmart, Best Buy, Pepsi, and Amazon. All retrieved data must be precise and sourced from reliable financial data providers, such as Yahoo Finance or similar platforms, ensuring historical stock prices align with the specific dates mentioned. Special attention should be paid to matching the exact date of each entry and ensuring the price data corresponds to the closing price on that day. In addition to collecting and organizing this data, the instructions on the first attachment should be carefully followed. These instructions may include formatting requirements, header labels, and data organization guidelines, which should be reflected within the Excel sheet to maintain consistency and accuracy. This task emphasizes accuracy in data collection and organization, as well as meticulous adherence to the specified timeline and data sources. The final spreadsheet should serve as a clear, well-organized record of weekly stock prices for the specified period, fulfilling all given instructions fully.
Paper For Above instruction Creating a comprehensive historical stock price spreadsheet is a fundamental task in financial data analysis, offering insights into market trends and individual stock performance over a selected period. This exercise involves meticulous data collection, organization, and presentation, requiring attention to detail and accuracy. The timeline starting from July 12, 2013, necessitates precise retrieval of stock prices on specific Fridays over seven consecutive weeks, which provides a consistent snapshot of market behavior