Yellow: is the company which their stock performance was forecasted by analyst
Blue: is the name of the company which made the recommendation by the analyst who work for it
Red: is the name of the analyst who made the recommendation (work for the company in the left column "blue")
Green : is the recommendation
Pink: is the date of the recommendation released by the analyst
The excel file is about the recommendations done by the analyst on the Saudi stocks listed in the Saudi stock market . so we need to evaluate these recommendations by taking each recommendation done on each stock and track the stock price for the next 4 or 5 months (information is available in the stock market website which I gave you) and see did the stock act like what the analyst expect and gave his recommendation based on or not ? in order to evaluate the analyst job in the Saudi market. for example let us say one analyst his recommendation was to buy the stock of SABIC so you need to go to the stock market and track the price of SABIC stock for the next months to see if the price is increasing or not.
You are supposed to have a very good knowledge of FINANCE and especially the "analyst recommendations" otherwise you will not be able to write this report. I am not asking for complexity at all but I need the work to be done in a good ,organize and scientific way that is easy for a junior student to understand and give as a report which deserves a good grade.