Create volume-open-high-low-close chart on new chart sheet

Assignment Help Financial Management

Reference no: EM131851157

You are interested in the stock market. First, you need to research the historical prices for a particular stock, such as Amazon. Click the Historical Prices link. Copy the stock data (date, high, low, open, close, volume) for a six-month period and paste it in a new workbook, adjusting the column widths to fit the data. Display data for only the first date listed for each month: delete rows containing data for other dates. Sort the list from oldest date to the newest date. Use Help if needed to learn how to sort data and how to create a Volume-Open-High-Low-Close chart. Then rearrange the data columns in the correct sequence. Format the data and column labels.

Insert a row to enter the company name and insert another row to list the company’s stock symbol, such as AMZN. Copy the URL from the Web browser and paste it as a source below the list of data and the date you obtained the data. Merge the cells containing the company name and stock symbol through the last column of data and word-wrap the URL.

Create a Volume-Open-High-Low-Close chart on a new chart sheet named Stock Chart. Type an appropriate chart title. Set the primary vertical axis (left side) unit measurement to millions and include an axis title Volume in Millions. Include a secondary vertical axis (right side) title Stock Prices. Apply the Currency number style with the 0 decimal places for the secondary axis values. Change the font size to 11 and the font color to Black, Text 1 on the vertical axes and category axis. Hide the legend.

Use Help to research how to insert text boxes. Insert a text box that describes the stock chart: white fill rectangles indicate the closing price was higher than the opening price; black fill rectangles indicate the closing price was lower than the opening price; etc.

Reference no: EM131851157

Questions Cloud

What is the maximum fuel-repairs and maintenance cost : What is the maximum fuel, repairs and maintenance cost that can be paid each year to operate the loader and still find this investment profitable?

What are the requirements to obtain a capm certification : What are the requirements to obtain a CAPM (Certified Associate in Project Management) certification?

Common stock using a general cash offering : Floral Bouquet needs to raise $21 million to expand its operations nationally. The company will sell new shares of common stock using a general cash offering.

When is each type of analysis appropriate : It appears that qualitative risk analysis is always appropriate as it serves as a general overview of risk for the project .

Create volume-open-high-low-close chart on new chart sheet : You are interested in the stock market. Create a Volume-Open-High-Low-Close chart on a new chart sheet named Stock Chart.

Why have you ever felt bad or guilty about your drinking : Why have you ever felt bad or Guilty about your drinking? Have you ever had a drink first thing in morning to steady your nerves or to get rid of a hangover?

List and describe the key technological trends : Describe how network economics, declining communications costs, and technology standards affect IT infrastructure.

Determined that rate of return : Hanna has determined that a rate of return of 9 percent is applicable to this potential purchase. What is Hanna willing to pay today to purchase Mark, Inc.?

Report on managing and retaining staff : HRMT20024 Assessment - Report on Managing and retaining staff. Discussed news stories and the HR implications arising from these stories

User Account

All Pages