DataCamp

Adjust univariate data for splits and dividends

Remember that adjustOHLC() only works for OHLC data. If you only have close prices, you can use the adjRatios() function to calculate the split and dividend adjustment ratios. The adjRatios() function has three arguments: splits, dividends, and close. It returns an xts object with two columns, "Split" and "Div", that contain the split and dividend adjustment ratios, respectively.

adjRatios() needs split data in order to calculate the split adjustment ratio. You provide split data via the splits argument. To calculate the dividend adjustment ratio, you need to supply raw dividends and raw prices to adjRatios(), using the dividends and close arguments, respectively.

Once you have the split and dividend adjustment ratios, calculating the adjusted price is simple. You just have to multiply the unadjusted price by both the split and dividend adjustment ratios.

Your workspace still contains the splits, dividends, and raw_dividends objects from prior exercises, and it also contains AAPL data from Yahoo Finance.

Use adjRatios() to calculate the split and dividend adjustment ratios. Assign the output to an object named ratios.
Calculate the adjusted close for AAPL by extracting the close price and multiplying it by both adjustment ratios and assign it to an object called aapl_adjusted.
Look at the first few rows of the adjusted close column provided by Yahoo Finance.
Look at the first few rows of the adjusted close price you calculated, and compare that to the adjusted close from Yahoo Finance.

Take Hint (-30xp)

Exercise

Adjust univariate data for splits and dividends

Instructions