Use data for July 2022 June 2023 Data

Assignment Goal: This exercise is designed to allow students to visit a

publicly available data source and extract relevant stock market data.

Assignme

Weekly Outcomes: At the completion of this week's assignment, students

will demonstrate how to select and extract data relevant to assigned tasks.

●

Jala Confection-Stock Market data

Weekly Topics/Tasks: Data Collection

On Yahoo Finance, find July 2021 - June 2022 stock data (not

2018 as the video discusses) and filter monthly for your

assigned company.

Download data from Yahoo Finance and open an Excel spreadsheet.

For certain companies, Yahoo Finance will not display the data

properly (some months missing data, some months with multiple

data points, etc). Please proceed to follow the instructions exactly as

listed in the videos. Even if the Yahoo website appears to display

incorrect data, once downloaded, the Excel sheet will have the

correct monthly data.

●

●

●

In your spreadsheet, format columns to accommodate data width.

• Save worksheet as "Last Name - Company".

Assignment 1 Video: Click on the link below to access the video: