Build a portfolio of at least 10 stocks using information from the web.

Build a portfolio of at least 10 stocks using information from the web. A portfolio is a grouping of financial assets such as stocks, bonds, and mutual funds. In general, a portfolio is made up of diverse investments to ensure proper allocation between risk and return. For our project, we will be focusing on stocks and tracking their performance within an Excel workbook we will be building and formatting.

The first task is to conduct research to determine which 10 stocks you will be analyzing in your portfolio, determine which data sources you will use in your portfolio workbook and format your workbook for upcoming analysis. The amount invested can be anything over $1,000, and since this is all imaginary, the amount invested can be set very high.

Check your essay before you submit. See exactly what your professor sees.

See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.

Get Plagiarism Report Humanize My Essay

Create a worksheet in excel that lists your ten stocks with the following criteria:

Add a title row to your worksheet and center it.
Your column headings should include a minimum of the following information: name, ticker symbol, number of stocks purchased, date of purchase, purchase price, total price paid, current stock price, current stock value, money made or lost, and any other relevant data.
Use Times New Roman Font, bold, with 12 inch font for column titles.
Use 11 inch font for all other data.
Add data to the name, ticker symbol, date of purchase, number of stocks purchased, purchase price, and total price paid for each stock (use a formula when appropriate).
Resize the columns so that all the information fits appropriately.
Format the cell types appropriately (e.g. date, text, currency).
Rename this worksheet to “Summary”.
Use the appropriate proofing tools to check for spelling and grammar errors.
In a separate worksheet (within the same workbook), determine which data sources (Yahoo Finance is a particularly good option for this assignment) you will use in your portfolio workbook. The data sources should report periodically throughout the day on the stock performance, keep historical data on performance, and offer other important information.

Create a list of web data sources that you either plan to use or are considering for use for this project.
Be sure to include the website title and URL for each source, and include at least five sources.
Rename this worksheet to “Web Sources”

use excel for all the works