closing values on ETFs change overnight without explanation
This happens with some regularity. Here are the results of one set of ETFS that I track:
Ticker Tuesday close Wednesday a.m. Difference
XLE $76.44 76.44 $0.00
XLF $29.14 29.15 -$0.01
TLT $125.04 124.52 $0.52
IEF $104.62 104.62 $0.00
IVV $279.18 278.9 $0.28
IYY $138.51 138.5 $0.01
ITB $44.97 44.97 $0.00
EFA $73.43 73.43 $0.00
IOO $96.45 96.45 $0.00
EEM $49.32 49.32 $0.00
EWJ $63.46 63.46 $0.00
IWM $156.18 156.14 $0.04
SLV $16.25 16.25 $0.00
OIH $28.51 28.51 $0.00
SMH $102.82 102.82 $0.00
XLB $62.66 62.65 $0.01
DBC $16.89 16.89 $0.00
QQQ $164.02 164.02 $0.00
DIA $257.85 257.91 -$0.06
GLD $127.15 127.17 -$0.02
MDY $354.53 357.2 -$2.67
USO $12.76 12.76 $0.00
XLU $50.15 50.15 $0.00
VGK $61.80 61.79 $0.01
SEA $12.03 12.03 $0.00
ITA $196.66 196.66 $0.00
RSX $22.81 22.78 $0.03
JJC $36.66 36.66 $0.00
IBB $110.60 111.98 -$1.38
xbi $86.85 86.84 $0.01
FXE $118.16 118.16 $0.00
IYW $170.18 170.18 $0.00
I can't find a notice of a dividend or anything else. I don't understand how this happens. What does seem true is that a 4 p.m. close is a mere suggestion. Is there an explanation?
Charles Blaine
shared this idea
-
Charles Blaine
commented
This week, I've noticed that one day's closing price will be different the next day as a prior day's price. Here are some examples.
Company As reported as Wed. close As reported Thur. as prior day close Difference Wed. to Thurs
Pope Resources, A Delaware Limited Partnership POPE $69.40 $67.60 $1.80
Avista Corp. AVA $49.20 $48.83 $0.37
Red Lion Hotels Corporation RLH $10.50 $10.35 $0.15
Digimarc Corporation DMRC $30.70 $30.55 $0.15
FLIR Systems, Inc. FLIR $48.29 $48.15 $0.14
Sound Financial Bancorp, Inc. SFBC $35.15 $35.05 $0.10
Esterline Technologies Corp. ESL $75.80 $75.70 $0.10
Red Robin Gourmet Burgers Inc. RRGB $52.45 $52.40 $0.05
Schnitzer Steel Industries, Inc. SCHN $35.10 $35.05 $0.05
Micron Technology Inc. MU $44.57 $44.54 $0.03
Hecla Mining Co. HL $3.79 $3.77 $0.02
Marchex, Inc. MCHX $3.32 $3.30 $0.02
RealNetworks Inc. RNWK $2.80 $2.78 $0.02
Columbia Sportswear Company COLM $74.46 $74.44 $0.02
PACCAR Inc. PCAR $69.24 $69.22 $0.02
Microsoft Corporation MSFT $91.50 $91.49 $0.01
Umpqua Holdings Corporation UMPQ $22.27 $22.26 $0.01
Alaska Air Group, Inc. ALK $64.68 $64.69 -$0.01
Costco Wholesale Corporation COST $185.74 $185.75 -$0.01
Nike, Inc. NKE $67.04 $67.05 -$0.01
Electro Scientific Industries Inc. ESIO $17.89 $17.90 -$0.01
Portland General Electric Company POR $39.95 $39.96 -$0.01
Timberland Bancorp, Inc. TSBK $28.91 $28.92 -$0.01
IsoRay, Inc. ISR $0.43 $0.44 -$0.01
Expedia Inc. EXPE $102.97 $102.99 -$0.02
T-Mobile US, Inc. TMUS $59.40 $59.42 -$0.02
Immune Design IMDZ $3.35 $3.40 -$0.05
eMagin Corp. EMAN $1.50 $1.55 -$0.05
Cray Inc. CRAY $21.90 $21.95 -$0.05
First Financial Northwest, Inc. FFNW $15.71 $15.77 -$0.06
Redfin RDFN $21.20 $21.30 -$0.10
Alibaba BABA $188.67 $188.82 -$0.15 -
Charles Blaine
commented
These are the closing values I downloaded at roughly 2:50 a.m. ET today (2/22/18) for this set of ETFs:
XLY $104.32
XLP $53.68
XLE $66.61
XLF $28.91
XLV $84.13
XLI $76.53
IYZ $27.58
XLB $60.01
XLK $66.81
XLU $48.83
XLRE $29.84
SPY $270.05
SPYG $34.32
SPYV $30.20This is the prior day's closes (i.e., Wednesday) listed on Yahoo today
XLY 104.32
XLP 53.69
XLE 66.61
XLF 28.93
XLV 84.12
XLI 76.53
IYZ 27.58
XLB 60
XLK 66.81
XLU 48.82
XLRE 29.81
SPY 270.05
SPYG 34.32
SPYV 30.2Here are the differences
XLY 0
XLP 0.01
XLE 0
XLF 0.02
XLV -0.01
XLI 0
IYZ 0
XLB -0.01
XLK 0
XLU -0.01
XLRE -0.03
SPY 0
SPYG 0
SPYV 0I am a bit of a pain on this point, but let me note that I have been unable to find on Yahoo Finance a note that ETF data can change overnight. It doesn't happen daily, but it happens often multiple times a week. Sometimes, it's because your system has not picked up the right prior-day data. (I'm a pain on that, too.) But this instance doesn't appear to be a software glitch. If there is a reasonable explanation for this (i.e., the ETF companies can't get the data collected fast enough), then you should tell investors to be careful or buy a Bloomberg subscription.
These are the closing values I downloaded at 2:50 a.m. on a second set of ETFs:
XLE $66.61
XLF $28.91
TLT $116.75
IEF $101.60
IVV $272.01
IYY $135.21
ITB $40.53
EFA $70.40
IOO $92.71
EEM $48.82
EWJ $60.51
IWM $152.24
SLV $15.54
OIH $23.76
SMH $103.66
XLB $60.01
DBC $16.60
QQQ $164.82
DIA $247.77
GLD $125.65
MDY $342.68
USO $12.28
XLU $48.83
VGK $59.25
SEA $11.17
ITA $201.11
RSX $23.23
JJC $36.42
IBB $109.08
XBI $91.05
FXE $118.30
IYW $171.71These are the prior day values now
XLE 66.61
XLF 28.93
TLT 116.74
IEF 101.6
IVV 272
IYY 135.08
ITB 40.53
EFA 70.41
IOO 92.71
EEM 48.82
EWJ 60.49
IWM 152.24
SLV 15.54
OIH 23.77
SMH 103.69
XLB 60
DBC 16.6
QQQ 164.82
DIA 247.72
GLD 125.66
MDY 342.68
USO 12.29
XLU 48.82
VGK 59.25
SEA 11.17
ITA 201.11
RSX 23.23
JJC 36.42
IBB 109.08
XBI 91.05
FXE 118.3
IYW 171.45Here are the price differences
XLE $0.00
XLF $0.02
TLT -$0.01
IEF $0.00
IVV -$0.01
IYY -$0.13
ITB $0.00
EFA $0.01
IOO $0.00
EEM $0.00
EWJ -$0.02
IWM $0.00
SLV $0.00
OIH $0.01
SMH $0.03
XLB -$0.01
DBC $0.00
QQQ $0.00
DIA -$0.05
GLD $0.01
MDY $0.00
USO $0.01
XLU -$0.01
VGK $0.00
SEA $0.00
ITA $0.00
RSX $0.00
JJC $0.00
IBB $0.00
XBI $0.00
FXE $0.00
IYW -$0.26Can we get an explanation. Maybe it's not you. Maybe it's the ETF companies, but I don't want to spend a half-hour a day wondering if the data is fiction.
I posted this idea earlier. This is a repost because I neglected to include some data.
-
Charles Blaine
commented
This is what I saw last night. The closing values on these tickers before 3 a.m. ET were
XLE $68.46
XLF $28.86
TLT $117.67
IEF $101.74
IVV $271.66
IYY $135.06
ITB $40.80
EFA $70.68
IOO $93.06
EEM $48.70
EWJ $60.38
IWM $151.18
SLV $15.91
OIH $24.34
SMH $101.73
XLB $60.25
DBC $16.51
QQQ $162.68
DIA $249.30
GLD $128.23
MDY $341.38
USO $12.18
XLU $48.60
VGK $59.68
SEA $11.44
ITA $197.87
RSX $23.07
JJC $36.83
IBB $109.73
xbi $91.65
FXE $119.96
IYW $168.95These are the prior day's closes downloaded at 1:45 p.m. ET
XLE $68.46
XLF $28.86
TLT $117.67
IEF $101.74
IVV $271.65
IYY $135.06
ITB $40.76
EFA $70.66
IOO $93.06
EEM $48.70
EWJ $60.38
IWM $151.15
SLV $15.91
OIH $24.34
SMH $101.73
XLB $60.25
DBC $16.51
QQQ $162.68
DIA $249.30
GLD $128.23
MDY $341.38
USO $12.18
XLU $48.60
VGK $59.67
SEA $11.45
ITA $197.87
RSX $23.07
JJC $36.83
IBB $109.73
xbi $91.65
FXE $119.96
IYW $168.95These were the tickers where closing values last night (2/14/18) changed today (2/15/18
SEA chg. = -0.01
VGK chg. = +0.01
IVV chg, = +0.01
EFA chg. = +0.02
IWM chg. = 0.03
ITB chg. = 0.04I don't understand how the data collector, which I assume is Morningstar, lets this happen.
-
Charles Blaine
commented
In my portfolio on S&P 500-related ETFs, I got these 2/7/18 closing values at 12:53 a.m. ET. (I also refreshed the portfolio page before putting the data in my spreadsheet):
XLY $104.32
XLP $54.77
XLE $68.80
XLF $28.42
XLV $83.90
XLI $75.96
IYZ $28.17
XLB $59.53
XLK $64.70
XLU $48.09
XLRE $30.34
SPY $267.67
SPYG $33.70
SPYV $30.25AT 1:15 p.m. today (2/8/18) the prior day's closes are listed as
XLY $104.32
XLP $54.78
XLE $68.80
XLF $28.41
XLV $83.86
XLI $75.95
IYZ $28.17
XLB $59.51
XLK $64.69
XLU $48.10
XLRE $30.35
SPY $267.67
SPYG $33.65
SPYV $30.24Here are the differences.
XLY $0.00
XLP -$0.01
XLE $0.00
XLF $0.01
XLV $0.04
XLI $0.01
IYZ $0.00
XLB $0.02
XLK $0.01
XLU -$0.01
XLRE -$0.01
SPY $0.00
SPYG $0.05
SPYV $0.01That's 10 out of 14 tickers where the 2/7 closing data as of 1 a.m. don't match the prior day's closing data 12 hours later. Can someone explain this to me?
-
Charles Blaine
commented
If you want a spreadsheet, let me know. There are tabs between the values. So, they should drop into a spreadsheet.
-
Charles Blaine
commented
This is the Monday closing data I downloaded at 2 a.m. ET
XLY $101.90
XLP $57.07
XLE $75.42
XLF $28.39
XLV $84.94
XLI $77.94
IYZ $29.51
XLB $62.96
XLK $66.55
XLU $51.81
XLRE $32.49
SPY $273.94
SPYG $34.10
SPYV $31.30This is what Yahoo says now was the Monday closes for the same ETFS.
XLY 101.78
XLP 57.07
XLE 75.42
XLF 28.37
XLV 84.94
XLI 77.94
IYZ 29.51
XLB 62.95
XLK 66.55
XLU 51.81
XLRE 32.49
SPY 273.92
SPYG 34.1
SPYV $31.30Can you or Morningstar explain the difference. I can't see these are dividend differentials.