Abu S. Arif - MIS 107
Lab: Stock Analysis using ExcelScenarioYou are a portfolio manager at Dhaka Investments Ltd., a stock brokerage firm located in Dhaka, Bangladesh. You are given the trading prices of GrameenPhone shares and you have to do an analysis (using various calculations and graphs) and present your judgment on buying/selling the stocks.?The dataset is available in an accompanying file, and a “Done” worksheet is provided to you as a sample with a different data set.?ActivitiesFill in the “Personal Info” worksheet with relevant informationChange the date formatCalculate the average price for everydayUse a conditional statement to check if “Volume increased?”Use a color scale to visualize transaction volumeDo the "Volume Analysis" section using excel functionsDo the "Price Analysis" section using the excel functionsUse Vlookup to lookup valuesCreate the candle chartFormat the Excel tables and the chart to make them look professional ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.