Assume that the you buy 10,000 shares common of each an of these corporations (PEPSI / COCA COLA) the day 1st of September of 2016.
During that month, you will be evaluating the behavior of the value of these stock market, day after day, from the time of purchase until September 30, 2016. A table with the day and the closing price of the day for the entire period must be developed. Through the information must assess that factors make that the price of these shares change or is is equal during that period of time. To determine if the behavior of the actions has been influenced by movements in the foreign currency exchange rate.
Is must prepare a graph in excel where present the movement of the value of each action to the period. Indicate therein the areas where change is more drastic and that happened that day that could cause this change.
Attachment:- Stock market- september-1-to-30.rar