DataCamp
Course Outline

Cross reference sources

100xp

In the previous exercise, you saw that the Yahoo Finance AAPL close prices had a large change caused by a stock split. You also learned that Yahoo Finance provides a column of close prices that are adjusted for splits and dividends.

In this exercise, you will cross-reference the Yahoo Finance AAPL data with AAPL data from Google Finance. Data from Google Finance is already adjusted for splits, but not dividends like the adjusted close from Yahoo Finance, so the close prices from Google won't align closely with the adjusted close prices from Yahoo Finance. Again, you will learn more about the adjustment process in the next video.

You will compare AAPL data from Yahoo Finance with AAPL data from Google Finance. The data have already been loaded to your workspace in aapl_yahoo and aapl_google, respectively.

Instructions

  • Look at the first few rows of aapl_yahoo.
  • Look at the first few rows of aapl_google. Note the split-adjusted Google data do not align with the split- and dividend-adjusted Yahoo data.
  • Finish the command to plot the difference between adjusted close from Yahoo and the close from Google.
  • Finish the command to plot the difference between the volume from Yahoo and Google.
    Take Hint (-30xp)