In: Finance
For 5 points of extra credit, prepare a graph in Excel that plots the daily price fluctuations (daily closing price) from the day you purchased the stock to the current date. You need to create a graph for only one stock. To find the historical daily prices, Yahoo/Finance has a good tool.
We have collected the data of Share price Movement of Goldman Sachs from Yahoo Finance. Below is for your kind perusal
Date | Close Price |
Feb-27 | 198.1 |
Feb-28 | 196.7 |
Mar-01 | 198.2 |
Mar-04 | 195.98 |
Mar-05 | 196 |
Mar-06 | 194.74 |
Mar-07 | 192.77 |
Mar-08 | 195.24 |
Mar-11 | 195.97 |
Mar-12 | 196.63 |
Mar-13 | 197.25 |
Mar-14 | 197.47 |
Mar-15 | 198.26 |
Let us assume that you purchased the stock of Goldman Sachs on 27th of Feb, 2019. @198.1
USING A LINE CHART TO PRESENT THE SAME.