How do I apply automatic Yahoo! Dividend Adjustments
Author: Panache
Creation Date: 1/14/2014 9:25 AM
profile picture

Panache

#1
The User Guide says dividend history can optionally applied to price data without refreshing the data. How do I do that?

I have downloaded split, but not dividend, adjusted Yahoo! data. I now checked the Perform Dividend Adjustment button in Data Manager, but the chart is still showing the Dividend icon with a price drop. I expected that the previous prices would have been adjusted by the dividend. Is there something I'm missing, or do I have to perform the dividend adjustment manually?

Specifically, I am looking at PRMTX between 12/13/13 and 12/16/13.

I think I figured out my own answer -- Fidelity is showing the dividend as a fundamental item, but Yahoo is not showing the dividend. Therefore, there is nothing to adjust on the fly.
profile picture

Cone

#2
The Yahoo! Provider always downloads the raw data. Splits and dividends are applied optionally from the Yahoo! tab in the Data Manager.

The Fidelity Provider does not have a capability to back-adjust for dividends. For Portfolio Simulations, dividends will be added to the equity returns (or subtracted for short positions) provided that you select "Apply dividends to backtest results..." in Preferences (F12) > Backtest Settings.
profile picture

16xx25

#3
When a dividend has 2 parts, income and capital gains, they both appear in charts, marker as 2 dividends, but in accessing the data series within code only one appears. I'm using Fidelity.
profile picture

Cone

#4
The Get/GetNextFundamentalItem functions can return only one item per bar, and I think the very infrequent multiple cash distribution is probably the only case where that can happen. Luckily, you can access the entire List<FundamentalItem> with FundamentalDataItems. See the QuickRef for an example.

profile picture

16xx25

#5
Cone, I tried your suggestion with the following code

CODE:
Please log in to see this code.

But fList.Count equals 0

Peter
profile picture

Eugene

#6
If "cash dividends" is a valid Fidelity fundamental item (I'm not using WLP so I'm not sure), then double check that the fundamental data source has been updated.
profile picture

Cone

#7
The split-adjusted per share dividend item for the Fidelity provider is "dividend"
For Y! it's "Dividend (Yahoo! Finance)"

"cash dividends" is the total cash distributed by the company in thousands (or millions) of dollars, and it will be zero if:
1. The company doesn't distribute dividends.
2. You haven't checked "Fidelity Fundamental Data for Securities" in the Data Manager > Update Data (and then perform an update)
3. The symbol is not a corporation (i.e., index or ETF)

profile picture

16xx25

#8
Cone, as usual your simple explanation was right on. My mixup was first using "dividends", then"cash dividends" rather than "dividend" (without the "s")

Peter
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).