hello. The teacher in the subject ''Investments'' gave the task to take 5 companies of the same field of activity and conduct a shallow analysis.  Professor asked to take a temporary passage of 5 years. I'm interested in how to calculate the average stock price for each month, standard deviation, variance and the rest in point 2. Thank you.

Task: 1. Choose five companies (stocks) from your selected (or given) industry and get data from Bloomberg. 2. Extract and calculate the following data (5 years period from 31th of October) - mean, standard deviation, variance, coef.of var, VaR. 3. Calculate the following ratios - Working capital ratio, Quick ratio, EPS, P/E, Debt-to-Equity, and Return on Equity. Show the price chart (5 years) for each of the stock. 4. Make comparison analysis. 5. What is your recommendation, what is your choice and why (justify)? Task: 1. Choose five companies (stocks) from your selected (or given) industry and get data from Bloomberg. 2. Extract and calculate the following data (5 years period from 31th of October) - mean, standard deviation, variance, coef.of var, VaR. 3. Calculate the following ratios - Working capital ratio, Quick ratio, EPS, P/E, Debt-to-Equity, and Return on Equity. Show the price chart (5 years) for each of the stock. 4. Make comparison analysis. 5. What is your recommendation, what is your choice and why (justify)