24 May Module 02 Excel Project – Spreadsheet Planning And Web Data Sources
Build a portfolio of at least 10 imaginary 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.
Create a worksheet that lists your ten stocks with the following criteria:
- Your columns should include a minimum of the following information: name, ticker symbol, # of stocks purchased, date of purchase, purchase price, total price paid, current price, current worth, money made or lost, and any other relevant data.
- Use Times New Roman Font, bold, with 14 inch font for column titles.
- Use 12 inch font for all other data.
- Add data to the name, ticker symbol, date of purchase, # of stocks purchased, purchased price, and total price (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).
- Use the appropriate proofing tools to check for spelling and grammar errors.
In a separate worksheet (within the same workbook), determine which data sources 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 5 sources.
Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.