Excel Project

As teams of 3 to 4 students, you are required to complete the below requirements using Excel

Instructions Each group is required to create stock portfolio by investing a total of maximum SR 1,000,000 in 50 companies from your choice of Three Stock Markets, analyze the portfolio's performance using Excel, and create charts to evaluate the relative performance of the stocks in the portfolio. For each stock, the spreadsheet is to include the company name, company stock symbol, date bought, number of shares, buying price per stock, total stock cost, current price per stock, current total stock value, and percentage gain/loss. The dates between your dates acquired and current price should be at least one month Create a VLOOKUP table that rates the stocks by their percentage change. The Rating column should also have Conditional Formatting showing different color for each category.

Change	Rating
Less than 1.00%	poor
Between 1.00% and 3.00%	good
Between 3.00% and 6.00%	very good
More than 6.00%	Excellent

Use countif to give total number of stocks from each of the Three Stock Markets. Also for each of the Three Stock Markets, use averageif and sumif to calculate the average and sum of the current total stock value. Finally, create three charts based on your own requirements.