Cone8
 ( 6.71% )
- ago
I'll try to update this thread as we apply corrections to Wealth-Data. Currently, you'll need to refresh the charts for each symbol to get the corrected data. Later in Build 33+, we'll implement options for automatic refreshes / corrections.

CD.X = Special Dividend
CD.R = Regular Dividend (no adjustment for these)

CODE:
Symbol   Ex-Date      Adj. Factor   Description IBM      2021-11-04   1.0469406   Spinoff Kyndryl (KD) ROL      2021-11-09   1.0022428   CD.X $0.08 (CD.R will be $0.10)
1
2,880
Solved
62 Replies

Reply

Bookmark

Sort
Cone8
 ( 6.71% )
- ago
#1
Example:
You can see that if you had owned IBM on 11/3/2021, your backtest will have realized a loss the next day due to the spinoff. In the real world, you'd get cash or shares for the spun company for the amount of that gap. Accounting for the gap using an adjustment simplifies the simulation, and, it doesn't result in feeding that "step" into indicators you might be using.



Incidentally, I was surprised to read that Kyndryl, about 4.7% of its parent IBM, is a $19 billion start-up with 90,000 employees! However, the market has already given KD a 25% haircut in its first 4 days :/
0
Cone8
 ( 6.71% )
- ago
#2
Note!
Big special dividend adjustment for QRTEA.

CD.X = Special Dividend
CD.R = Regular Dividend (no adjustment for these)

CODE:
Symbol   Ex-Date      Adj. Factor   Description QRTEA      2021-11-12   1.143678   CD.X $1.25 CTRA      2021-11-12   1.008464   CD.X $0.175 (CD.R will be $0.125)
0
Cone8
 ( 6.71% )
- ago
#3
A few special dividends slipped by over the Thanksgiving holiday, and they were just applied to Wealth-Data moments ago.

CODE:
Symbol   Ex-Date      Adj. Factor      CD.X DDS      2021-11-26   1.0413598754   $15.00 GOLD   2021-11-29   1.0072765198   $0.14 PXD      2021-11-29   1.0168989351   $3.02
0
Cone8
 ( 6.71% )
- ago
#4
This adjustment applied for Monday's ex-date

CODE:
Symbol Ex-Date Adj. Factor CD.X WRB 2021-12-06 1.01303441084463 $1.00
0
Cone8
 ( 6.71% )
- ago
#5
This adjustment applied. It was scheduled for tomorrow, but it appears to have gone ex-dividend today.

CODE:
Symbol Ex-Date Adj. Factor CD.X BF.B 2021-12-08 1.0138026225 $1.00
0
Cone8
 ( 6.71% )
- ago
#6
This adjustment applied today 12/11/2021. Previously it was reported as a regular dividend, but actually the regular dividend was $0.11 and this is the variable part.
https://www.devonenergy.com/news/2021/Devon-Energy-Announces-Third-Quarter-Dividend-and-Next-Step-in-Cash-Return-Strategy-with-1.0-Billion-Share-Repurchase-Program

CODE:
Symbol Ex-Date Adj. Factor CD.X DVN 2021-12-09 1.01652331371661 $0.73
0
Cone8
 ( 6.71% )
- ago
#7
More special dividends going ex today, just applied to Wealth-Data -

CODE:
Symbol   Ex-Date      Adj. Factor      CD.X EOG      2021-12-14   1.0232477043   $2.00 SLG      2021-12-14   1.0345247329   $2.4392 (Stock Dividend)
0
Cone8
 ( 6.71% )
- ago
#8
2 special dividends going ex today, and 1 from yesterday .. just applied to Wealth-Data -

CODE:
Symbol   Ex-Date      Adj. Factor      CD.X PGR      2021-12-17   1.014775460   $1.50 LAMR      2021-12-17   1.0043860   $0.50 PCAR      2021-12-16   1.01732306   $1.50
0
Cone8
 ( 6.71% )
- ago
#9
2 special dividends went ex last week, just applied to Wealth-Data now -

CODE:
Symbol Ex-Date Adj. Factor CD.X CME 2021-12-24 1.01439898 $3.25 PCH 2021-12-21 1.07267440 $4.00
0
Cone8
 ( 6.71% )
- ago
#10
The big special dividend for SIRI, just applied to Wealth-Data -

CODE:
Symbol Ex-Date Adj. Factor CD.X SIRI 2022-02-10 1.037821462 $0.25

Careful here if you had entered a Position using Wealth-Data!
0
Cone8
 ( 6.71% )
- ago
#11
Supplemental dividend of $1.45 just applied to Wealth-Data for WY.

CODE:
Symbol Ex-Date Adj. Factor CD.X WY 2022-02-17 1.0358822112859 $1.45
0
Cone8
 ( 6.71% )
- ago
#12
We noticed that settled Closing prices were incorrect for yesterday's session on 01 March 2022 for about 50 symbols. In most cases, they differed by only a penny or two, but some were more -

AAPL, Was: 163.38,  Is: 163.20
AMAT, Was: 129.79,  Is: 129.61
ATVI, Was: 81.125,  Is: 80.88
ISRG, Was: 291.86, Is: 291.55
GOOGL, Was: 2684.145,  Is: 2681.23

I'd recommend that you use the Data Manager to truncate Wealth-Data's S&P 500 and Nasdaq 100 DataSets after 28 Feb 2022, and then update (or just re-run your strategies).

On special dividends, we changed the previously-reported PXD $3.78 dividend on 2/25/2022 into 2 parts, $0.78 for the Regular Dividend, and a $3.00 Special Dividend. (https://investors.pxd.com/news-releases/news-release-details/pioneer-natural-resources-declares-first-quarter-dividend-common) This correction was just applied:

CODE:
Symbol Ex-Date Adj. Factor CD.X PXD 2022-02-25 1.013458977952730 $3.00



Also, ZBH spun off ZimVie (ZIMV) resulting in this correction
https://investor.zimmerbiomet.com/news-and-events/news/2022/03-01-2022-120035502
CODE:
Symbol Ex-Date Adj. Factor Spin off basis ZBH 2022-03-01 1.030796666092460 $3.80

0
Cone8
 ( 6.71% )
- ago
#13
The data for ZBH is correct above, but it wasn't applied correctly until now. Please refresh your Wealth-Data ZBH Daily chart!
0
Cone8
 ( 6.71% )
- ago
#14
This special dividend adjustment was just applied to COP.
CODE:
Symbol Ex-Date Adj. Factor CD.X COP 2022-03-30 1.00298834545273 $0.30
0
Cone8
 ( 6.71% )
- ago
#15
This special dividend adjustment was just applied to FCX. You'll see a $0.15 dividend in Yahoo! Finance, for example, but like in January, this was made up of the declared $0.075 dividend and a special $0.075 dividend.

CODE:
Symbol Ex-Date Adj. Factor CD.X FCX 2022-04-13 1.001564945226917 $0.075
0
Cone8
 ( 6.71% )
- ago
#16
A special dividend and an SDR Rights Offering adjustment were just applied to JD and TIGO, respectively.

CODE:
Symbol   Ex-Date      Adj. Factor   CD.X CTRA   2022-05-11   1.015448   $0.45 FANG   2022-05-11   1.01843282   $2.35 JD   2022-05-19   1.02523028   $1.26 TIGO   2022-05-20   1.25585


Edit - Corrections to several symbols for 5/9/2022 were applied to close and volume - Examples:
CODE:
ABNB   Was: 119.49   Is: 119.37 DDOG   Was: 97.38   Is: 97.53 INTU   Was: 367.40   Is: 367.01 ISRG   Was: 208.92   Is: 208.71 KELYA   Was: 19.095   Is: 19.07 LCID   Was: 16.37   Is: 16.35 LRCX   Was: 447.63   Is: 447.15 MCHP   Was: 64.43   Is: 64.31

Refresh those Wealth-Data charts!
0
Cone8
 ( 6.71% )
- ago
#17
Adjustments just applied.

CODE:
Symbol   Ex-Date      Adj. Factor   CD.X PXD   2022-05-27   1.0242413   $6.60 GOLD   2022-05-26   1.004728   $0.10

To be clear, these special dividends are applied as Splits using the Adjustment factor.
1
Cone8
 ( 6.71% )
- ago
#18
I forgot to post that this adjustments was applied to LYB last weekend.

CODE:
Symbol Ex-Date Adj. Factor CD.X LYB 2022-06-03 1.047251 $5.20
0
Cone8
 ( 6.71% )
- ago
#19
EOG adjustment for its special dividend, just applied.

CODE:
Symbol Ex-Date Adj. Factor CD.X EOG 2022-06-15 1.0139039 $1.80
0
Cone8
 ( 6.71% )
- ago
#20
Adjustments for special dividends just applied...

CODE:
Symbol Ex-Date Adj. Factor CD.X WRB 2022-06-24 1.0076393957 $0.50 COP 2022-06-27 1.0077596821 $0.70
0
Cone8
 ( 6.71% )
- ago
#21
After a Wealth-Data QA pass, we've made some important adjustments for Spinoffs and special dividends that we missed applying in the past year -

CODE:
Symbol Ex-Date Adj. Factor Event BDX 2022-04-01 1.0257042452 EMBC Spinoff BFH 2021-11-08 1.25368249294 LYLT Spinoff COP 2021-12-31 1.00277469478 CD.X $0.20 IP 2021-10-01 1.047976 SLVM Spinoff O 2021-11-15 1.032652 ONL Spinoff PXD 2021-09-02 1.0103135032 CD.X $1.51

Although these adjustments won't affect recent trading, now's a good time to refresh your Wealth-Data in WL8.
0
Cone8
 ( 6.71% )
- ago
#22
A big special dividend in TDG looks like it will be applied today, so data has just been adjusted to reflect it. A few others were updated last week too..

CODE:
Symbol Ex-Date Adj. Factor Event TDG 2022-08-18 1.0284471 CD.X $18.50 FANG 2022-08-15 1.01758 CD.X $2.30 CTRA 2022-08-12 1.017343 CD.X $0.50 PSA 2022-07-29 1.0405927 CD.X $13.15

0
Cone8
 ( 6.71% )
- ago
#23
A large dividend in PXD today and data has just been adjusted to reflect it.

CODE:
Symbol Ex-Date Adj. Factor Event PXD 2022-09-02 1.0310823 CD.X $7.47

0
Cone8
 ( 6.71% )
- ago
#24
A couple more applied recently -

CODE:
Symbol Ex-Date Adj. Factor Event EOG 2022-09-14 1.0123548 CD.X $1.50 DVN 2022-09-09 1.0202843 CD.X $1.37

0
Cone8
 ( 6.71% )
- ago
#25
FBIN, formerly FHBS, spun off MBC this week resulting in a significant correction to the history, applied as a split. I would have expected this one to automatically correct in Wealth-Data (with "Allow Data Corrections" in Data Preferences), but it did not. You should refresh FBIN manually. DDS's adjustment for the $15.00 special dividend was nearly 5% - make sure to refresh that one too.

CODE:
Symbol   Ex-Date      Adj. Factor      Event FBIN   2022-12-15   1.170132355      MBC Spinoff ($9.00 distribution) PCAR   2022-12-15   1.028011214      CD.X $2.80 EOG      2022-12-14   1.011908550      CD.X $1.50 LAMR   2022-12-16   1.000310302      CD.X $0.30 DDS      2022-12-14   1.048143250      CD.X $15.00
0
Cone8
 ( 6.71% )
- ago
#26
CODE:
Symbol   Ex-Date      Adj. Factor      Event CME    2022-12-27   1.026654      CD.X $4.50 HST      2022-12-29   1.012788      CD.X $0.20 COP      2022-12-23   1.006239      CD.X $0.70 PCH      2022-12-20   1.021824      CD.X $0.95
0
Cone8
 ( 6.71% )
- ago
#27
GE spun off GEHC (GE Healthcare Technologies Inc) yesterday, and it replaced VNO in the S&P 500. This significant split was just applied:

Ex-Date Adj. Factor
2023-01-04 1.28149194

Check your Wealth-Data chart for GE and refresh if required!
0
Cone8
 ( 6.71% )
- ago
#28
JEF spun off VTS (Vitesse Energy Inc VTS) on 1/14/2023. This split was just applied:

Ex-Date Adj. Factor
2023-01-14 1.04538

Check your Wealth-Data chart for JEF and refresh it from the provider to get the split correction. Reminder: periodically it's a good idea to refresh all of Wealth-Data to ensure you have all the corrections.
0
Cone8
 ( 6.71% )
- ago
#29
Concerning the NYSE opening glitch on 24 Jan. 2023, the following significant corrections have been made in Wealth-Data. In some cases, price corrections are 10% or more.

Most often, wild low volume trading occurred on non-NYSE exchanges during the first minute after which trading was halted. Later, trading re-opened on NYSE at the time indicated, which Wealth-Data uses as the opening print.

Recommend that WL8 users refresh their Wealth-Data cache now.
1. Data Manager > Historical Providers
2. Right click Wealth-Data > Delete Local Files
3. Update the DataSets


CODE:
Symbol   Open      Re-open time KO      61.8500      093000   H: 61.8500   L: 59.9050       LUMN   5.0500      093951   H: 5.4900   L: 5.0500 MA      376.0000   093056   H: 381.4800   L: 376.0000 MET      69.5000      093646   H: 71.2700   L: 68.7100 MMM      117.5000   093814   H: 119.9200   L: 114.5000 MOS      48.00      094348   H: 50.4000   L: 45.6000 MO      44.3500      093750   H: 45.9300   L: 44.3500 MPC      124.2000   094023   H: 130.7400   L: 124.2000 MS      95.9500      093736   H: 96.8100   L: 95.0000 NEM      53.5000      094338   H: 53.86000   L: 53.0400 NKE      126.7800   093942   H: 128.0050   L: 126.6300 OKE      69.0000      094024   H: 69.7200   L: 67.8016 OXY      67.0700      094119   H: 67.4600   L: 64.2480 PLD      126.0000   094509   H: 126.9900   L: 121.8700 PPL      29.0800      094240   H: 29.5600   L: 28.8600 PRU      98.2600      093708   H: 101.1500   L: 98.2600 PSX      104.3600   093742   H: 107.2600   L: 104.3600 RIG      6.0000      093717   H: 6.3100   L: 6.0000 SHEL   57.8000      093621   H: 58.2000   L: 57.5000 SO      66.4000      093927   H: 67.3050   L: 65.8400 T      18.7000      093804   H: 19.4700   L: 18.7000 TFC      48.22      093725   H: 49.24 TT      171.00      094546   H: 175.30 UNP      205.00      093945   H: 207.00 V      220.25      093929   H: 229.7400   L: 219.7950 VLO      144.10      094030   H: 145.7800   L: 141.8500 VZ      38.75      093823   H: 40.7300   L: 38.5300 WFC      44.85      094225   H: 45.2000   L: 44.3700 WMT      141.51      094037   H: 143.9950   L: 141.0000 WRB      73.60      093515   H: 73.6000   L: 69.4800
1
Cone8
 ( 6.71% )
- ago
#30
Corrections just applied - Ford's special dividend of 65 cents is significant - related to its unloading of stock in the EV startup Rivian.

CODE:
Symbol   Ex-Date      Adj. Factor      Event F    2023-02-09   1.050623      CD.X $0.65 HP    2023-02-10   1.0051654   CD.X $0.235
0
Cone8
 ( 6.71% )
- ago
#31
Apologies for this late correction just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event WY    2023-02-14   1.02702705   CD.X $0.90
0
- ago
#32
@Cone,
I followed your advice in Post #29 and deleted all local files and updated the datasets. Now I have a bunch of symbols with NO data; these are probably all expired symbols but the data is important for backtesting purposes.
What to do about these symbols?
0
Cone8
 ( 6.71% )
- ago
#33
We don't remove symbols or their data. Try updating again. It must have been a transmission error. If it persists, let me know the symbols.
0
- ago
#34


Tried x2.
0
Cone8
 ( 6.71% )
- ago
#35
Okay, thanks. We need to look into that!
0
Cone8
 ( 6.71% )
- ago
#36
Not quite sure what's causing that today, but it happened to me too. I had to restart WL8 and update again to get all the symbols. Clearing requests wasn't enough. For good measure, enable Preferences > Data > Allow Data Corrections from Historical Providers.
0
- ago
#37
2 symbols in S&P 500 still didn't download: RDS.A, TWTR.
Hopefully they'll be fixed soon.

BTW, kudos for doing the data corrections, many other data providers haven't done it (and may never will). Symbol VZ was one of the most egregious examples... it made a 1-year High and a 1-yr Low on the same bar (before data correction)!! LOL
0
Cone8
 ( 6.71% )
- ago
#38
These were a result of errors in our constituents database that didn't properly change the symbols. TWTR doesn't exist, its data is TWTR.221027.P. RDS.A (and .B) is SHEL - https://investorplace.com/2022/02/shel-stock-in-focus-as-shell-waves-goodbye-to-royal-dutch-name-and-rds-a-rds-b-stocks/

This is fixed. Restart WealthLab to get the changes, which will have a minor effect on S&P 500 backtests with Wealth-Data.
0
Cone8
 ( 6.71% )
- ago
#39
We just realized today that STLD, a S&P 500 stock, had been inadvertently marked as "delisted" and hasn't been updated since 22 Dec 2022. This was just corrected!
0
Cone8
 ( 6.71% )
- ago
#40
Significant adjustments for special dividends applied.

CODE:
Symbol   Ex-Date      Adj. Factor      Event PXD    2023-03-03   1.0273235      CD.X $5.58 FANG    2023-03-02   1.0150909   CD.X $2.15
This is why PXD is indicated nearly $5 today in today's premarket. If you're trading PXD with Wealth-Data, refresh your chart for new signals!
0
Cone8
 ( 6.71% )
- ago
#41
Correction for yesterday's PXD adjustment. $1.10 of the $5.58 special dividends was actually a regular dividend.

CODE:
Symbol   Ex-Date      Adj. Factor      Event PXD    2023-03-03   1.02181956      CD.X $4.48
0
Cone8
 ( 6.71% )
- ago
#42
VEON's scheduled 1:25 reverse split was applied (multiple times) yesterday, but it turns out that the action was postponed -

https://finance.yahoo.com/news/veon-announces-postponement-effectiveness-ratio-060000237.html

Check your VEON data and refresh the chart if the split was applied.

In any case, we're considering terminating the VEON series instead of doing the 1:25 reverse split (if it happens) so that the price level is maintained for the time it was in the N100 - better for backtesting.
0
Cone8
 ( 6.71% )
- ago
#43
VEON split confirmed for today -
https://finance.yahoo.com/news/veon-confirms-revised-timing-effectiveness-153000419.html

I was just looking at the timing of when VEON was added to the "Nasdaq 100 Trading System" - it was in Oct. 2013. Apparently, someone thought the chart pattern looked like a cup & handle. That was a mistake and VEON was removed about 2 years later.

If you have a strategy that filters by market price, make sure to use the SplitRev indicator for that rule!
0
Cone8
 ( 6.71% )
- ago
#44
PODD replaced SIVB in the S&P 500 - officially before Wednesday's open.

Special dividends applied today -

CODE:
Symbol   Ex-Date      Adj. Factor      Event MOS    2023-03-14   1.005282      CD.X $0.25 DVN    2023-03-14   1.0139989   CD.X $0.69
0
Best Answer
Cone8
 ( 6.71% )
- ago
#45
FICO replaced LUMN in the S&P 500 - officially before Monday's open for the quarterly rebalance.

Special dividends applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event EOG    2023-03-15   1.00924217      CD.X $1.00 CTRA    2023-03-15   1.0150897   CD.X $0.37
0
Cone8
 ( 6.71% )
- ago
#46
MNST Splits 2:1 today.

Special dividend just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event COP    2023-03-28   1.0061933      CD.X $0.60
0
Cone8
 ( 6.71% )
- ago
#47
Crane Holdings, Co., is spinning Crane Company, which retains the symbol, CR. The distribution appears to be $40.30, from a last closing price of 114.42, which makes for a split adjustment factor of 1.54128408.

https://finance.yahoo.com/news/crane-company-completes-separation-crane-210100518.html

As for Wealth-Data, I think later this wee we'll preserve the pre-split Crane Holdings, Co series as CR.20230403.R for backtesting purposes. The new CR will retain the history, post split.
0
Cone8
 ( 6.71% )
- ago
#48
Missed this HP special dividend correction last week.

Special dividend just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event HP    2023-04-17   1.0076411      CD.X $0.235


You'll need to refresh your chart in WL8 to get the change, and remember, it's a good idea to periodically refresh all Wealth-Data so that you don't miss any corrections.
0
Cone8
 ( 6.71% )
- ago
#49
Special dividend just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event PXD    2023-05-31   1.0102345292      CD.X $2.09
0
Cone8
 ( 6.71% )
- ago
#50
Special dividend just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event DVN    2023-06-14   1.010427132      CD.X $0.52
0
Cone8
 ( 6.71% )
- ago
#51
Make sure these splits were applied to your Wealth-Data, and if not, right click and "Reload Chart Data from Provider".

CODE:
Symbol   Ex-Date      Adj. Factor      Event LH      2023-07-03   1.164046    LH spins Fortrea Holdings (FTRE) BWA      2023-07-05   1.136871    BorgWarner spins PHINIA Inc (PHIN)

0
Cone8
 ( 6.71% )
- ago
#52
Make sure this splits is applied to your Wealth-Data, and if not, right click and "Reload Chart Data from Provider".

CODE:
Symbol   Ex-Date      Adj. Factor      Event FWONA      2023-07-20   1.018816    "Split-off" Atlanta Braves Holdings

Story: https://www.businesswire.com/news/home/20230719777751/en/
0
Cone8
 ( 6.71% )
- ago
#53
The history for STCN has been restored following an issue processing the reverse split on 6/22/2023. Refresh your STCN charts from Wealth-Data now!

Nonetheless, since STCN really only interests us for the time it was in the Nasdaq 100 (1999-2000), we created a series STCN.20071031.S. This series ends on the 10/31/2007 and its prices are "reverse-adjusted" for the 2 large reverse splits (1:10 and 375:3500) and the 1.16111 special distribution on 3/15/2011. In other words, the prices do not include these "future splits" and are more "in range" of prices when STCN was actually trading in 2001.

After you restart WealthLab, STCN.20071031.S will replace STCN in the WealthLab Nasdaq 100 DataSet.
0
Cone8
 ( 6.71% )
- ago
#54
Both CPRT and SRE split 2:1 today, but we didn't get that applied last night in time for updates. Check your Wealth-Data charts for these symbols and Reload if required.
0
Cone8
 ( 6.71% )
- ago
#55
Special dividend just applied -

CODE:
Symbol   Ex-Date      Adj. Factor      Event WRB    2023-09-22   1.0077364   CD.X $0.50
0
Cone8
 ( 6.71% )
- ago
#56
A 1.127958 Split has been applied to DHR for the VLTO spinoff.
https://www.wealth-lab.com/Discussion/S-P-500-VLTO-replaced-DXC-10227

Refresh your Wealth-Data DHR chart if you still see a large step in the data from 9/29 to 10/2/2023.
0
Cone8
 ( 6.71% )
- ago
#57
Special dividend just applied - this one's a little late, so be wary if you have a position in COP and are using Wealth-Data.
In any case, you'll need to refresh COP to get the adjustment.

CODE:
Symbol   Ex-Date      Adj. Factor      Event COP    2023-09-27   1.0050192   CD.X $0.60
0
Cone8
 ( 6.71% )
- ago
#58
LIN (Linde, plc) switched from the NYSE to Nasdaq on 11/7/2023.
We just caught that today so we corrected the opening prices for the primary market open.

Refresh your Wealth-Data chart LIN to get the corrections.
0
Cone8
 ( 6.71% )
- ago
#59
WOR spinoff -> WS
If required, refresh your Wealth-Data chart for WOR.

CODE:
Symbol Ex-Date Adj. Factor Event WOR 2023-12-01 1.622172 CD.X $27.50

0
- ago
#60
LABU & TMF just split, can wealth data be updated? Thanks!
1
Cone8
 ( 6.71% )
- ago
#61
You got it. Thank you!
0
Cone8
 ( 6.71% )
- ago
#62
COST $15 Special dividend goes ex tomorrow - this adjustment applied.

CODE:
Symbol Ex-Date Adj. Factor Event COST 2023-12-27 1.0227404 CD.X $15.00

0

Reply

Bookmark

Sort