Abu S. Arif
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.
Related searches
- ministry of education abu dhabi
- abu dhabi department of education
- abu dhabi ministry of higher education
- abu dhabi education council calendar
- abu dhabi education council website
- ministry of education abu dhabi location
- abu dhabi education council registration
- abu dhabi education council address
- adec abu dhabi education council
- abu dhabi education council adec
- abu dhabi education council job
- abu dhabi education council sign in