Wealth-Data dividends
Author: Gamba
Creation Date: 9/2/2016 8:10 AM
profile picture

Gamba

#1
I just saw that dividends of US-Stocks using Wealth-Data and earnings using Street-Insider does not match, but cannot find the reason. Please see attached chart. In addition values are very different.
Earnings from Street Insider seems to be correct.

For german stocks using Wealth-Data it seems to be correct.
profile picture

Eugene

#2
According to the Wealth-Data FAQ:

Is Wealth-Data dividend-adjusted?
Stock prices are not adjusted for regular dividends, but they are adjusted for “special” one-time dividends and other dilutive corporate actions.

P.S. Not sure what earnings by StreetInsider have to do with Wealth-Data dividends, though.
profile picture

Gamba

#3
Hmmmm .... seems to be my fault. I guessed that dividends and earnings are the same. I wondered why dividends in attached charts arrives right after earnings of StreetInsider and fits perfectly for german stocks.

Does StreetInsider have dividends available and do I have to get another fundamental item?
profile picture

Eugene

#4
Like StreetInsider doesn't have dividends (being a niche provider), Wealth-Data doesn't support earnings. However, W-D does have Dividend and Split fundamental items called "Dividend (Wealth-Data)" and "Split (Wealth-Data)", respectively.
profile picture

KGo

#5
Compared Wealth-Data, Tiingo and Yahoo dividends and found these Wealth-Data issues. The analysis was run from 3/25/2019 to 9/25/2020.
QUOTE:
AAPL Wealth-Data dividend W-D All dividends not adjusted for 8/31/2020 split. Recent $0.82 should now be $0.205,
AMLP Wealth-Data dividend WD dividends are not split adjusted
COP Wealth-Data dividend Missing all dividends
EPI Wealth-Data dividend Missing 9/22/2020 dividend
F Wealth-Data dividend Extra dividend on 3/28/2019 $0.15
FDX Wealth-Data dividend 9/3/2020 div missing $0.65
GE Wealth-Data dividend Missing 9/25/2020 $0.01
HD Wealth-Data dividend Missing 9/2/2020
HON Wealth-Data dividend Missing 8/13/2020
HYG Wealth-Data dividend Double value Dividend (Wealth-Data) 8/1/2019 0.734
IJH Wealth-Data dividend Missing Dividend (Tiingo) 9/23/2020 0.833103
IWD Wealth-Data dividend Missing Dividend (Tiingo) 9/23/2020 0.720017
IWF Wealth-Data dividend Missing Dividend (Tiingo) 9/23/2020 0.432848
IWM Wealth-Data dividend Missing Dividend (Tiingo) 9/23/2020 0.566445
JNK Wealth-Data dividend Zero Dividends - all are missing
MCD Wealth-Data dividend Missing Dividend (Tiingo) 8/31/2020 1.25
MDT Wealth-Data dividend Missing Dividend (Tiingo) 9/24/2020 0.58
MDY Wealth-Data dividend Missing Dividend (Tiingo) 9/18/2020 1.0331
MO Wealth-Data dividend Missing Dividend (Tiingo) 9/14/2020 0.86
NTES Wealth-Data dividend Missing Dividend (Tiingo) 8/26/2020 1.4825 Special dividend was 7.59 not 3.35
NXPI Wealth-Data dividend Missing Dividend (Tiingo) 6/12/2020 0.375
OIH Wealth-Data dividend Dividend not split. Dividend (Wealth-Data) 12/23/2019 0.291 / 0.05 = 5.82
PCAR Wealth-Data dividend Differences from special dividend
PG Wealth-Data dividend Missing Dividend Dividend (Tiingo) 7/23/2020 0.7907
QLD Wealth-Data dividend Incorrect Value should be Dividend (Tiingo) 3/25/2020 0.00455 * 2 =Orig Value of 0.0091
QQQ Wealth-Data dividend Missing Dividend (Tiingo) 9/21/2020 0.38824
RTX Wealth-Data dividend Shows split 1.659 only
SDS Wealth-Data dividend Missing Dividend (Tiingo) 9/23/2020 0.0569
SDY Wealth-Data dividend Shows double div amount Dividend (Wealth-Data) 6/19/2020 1.361 should be 0.68
SPLV Wealth-Data dividend "Missing 3 dividends Dividend (Yahoo! Finance) 8/24/2020 0.104 and Dividend (Yahoo! Finance) 9/21/2020 0.074 and Dividend (Tiingo) 4/20/2020 0.11849
"
SPXS Wealth-Data dividend All dividends missing
SQQQ Wealth-Data dividend Not split adjusted
SSO Wealth-Data dividend No dividends split
TXN Wealth-Data dividend Missing Dividend (Tiingo) 7/30/2020 0.9
UNH Wealth-Data dividend Missing Dividend (Tiingo) 9/11/2020 1.25 and Dividend (Tiingo) 6/19/2020 1.25
WMT Wealth-Data dividend Missing Dividend (Tiingo) 8/13/2020 0.54
XLY Wealth-Data dividend Missing Dividend (Tiingo) 6/22/2020 0.296038
XOP Wealth-Data dividend Dividends not split

profile picture

Cone

#6
Thanks for that analysis. I'll work on the Wealth-Data side of things.

... although just as a quick peek, this one isn't true:
COP Wealth-Data dividend Missing all dividends

Occasionally, I've seen some "dividend cross talk" between symbols in Wealth-Data. It seems impossible to catch when you're looking for it, but if you observe too many dividend reports for a symbol, it's time to delete and refresh your Wealth-Data. Use the Data Manager > Wealth-Data > [Clear All Data] button for that.

For COP, for example, if you do a simply chart refresh, you'll get a chart without dividends. You need to do an update in the Data Manager for splits and dividends to populate. And, if you had a chart open, close and re-open it after the update.
profile picture

Cone

#7
Where there were issues, fixed! Most of the 2020 missing dividends were due to missing the quarterly dividend update that occurred on 9/30/2020.

CODE:
Please log in to see this code.
profile picture

KGo

#8
Thanks for the follow-up.

I will clear all data and reload tomorrow morning. Then report if any are still not updating correctly. COP, JNK and SPXS have no dividends after Data Manager update this morning but seems it should populate tomorrow after clearing all data.

Note: NTES special dividend was 7.59 not 3.45 on 12/5/2019. Not sure that would be in the update

Edit: I updated tonight before clearing data and all the split fixes were applied. Thank you! COP, JNK and SPXS however still have no dividends so will clear all data and download all tomorrow.
profile picture

Cone

#9
QUOTE:
NTES special dividend was 7.59 not 3.45 on 12/5/2019. Not sure that would be in the update
In reality, the breakout is like this:
2019/12/05 NTES NetEase.com Inc. 3.4500 Special Dividend
2019/12/05 NTES NetEase.com Inc. 4.1400 Regular Dividend (added this)

From their Nov. 20, 2019 PRNewswire...

Quarterly Dividend

The basic net income per ADS was US$13.80 for the third quarter of 2019. The board of directors has approved a dividend of US$7.59 per ADS for the third quarter of 2019. Such amount includes a regular quarterly dividend of US$4.14 per ADS (equivalent to approximately 30% of the Company's net income attributable to the Company's shareholders), plus a special dividend of US$3.45 per ADS. The total dividend of approximately US$1.0 billion is expected to be paid on December 13, 2019 to shareholders of record as of the close of business on December 6, 2019.
profile picture

KGo

#10
Re-downloaded all data this AM.
- NTES is correct by adding $4.14 dividend which split correctly today to Dividend (Wealth-Data) 12/5/2019 0.828
- SPXS dividends downloaded correctly
- COP dividends downloaded correctly
- JNK dividends downloaded but are split incorrectly at Dividend (Tiingo) 5/1/2019 0.5124 * 0.3333333333 =Orig Value of 0.1708 . WD applied the split twice to get Dividend (Wealth-Data) 5/1/2019 1.53900 which is applied to all prior dividends.

With that the last 18 months look good.

profile picture

Cone

#11
JNK fixed! Thanks!
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).