[R-SIG-Finance] yahoo dates

Paul Gilbert pgilbert902 at gmail.com
Thu Jul 5 19:33:50 CEST 2012


Occasionally this week it seems that yahoo is using the previous day's 
date on holidays (I believe, at least yesterday evening there were two 
entries dated July 3). There is a possible logic to this, since holiday 
data may be just adjustments to the previous day's data. However, in 
some downloads this is done, and other downloads of the same data it 
seems the holiday is simply removed, suggesting that it is really a bug 
at yahoo.  For example, the evening of July 4 the data for "^gspc" was

         Date    Open    High     Low   Close     Volume Adj.Close
1 2012-07-03 1365.75 1374.81 1363.53 1373.97  277158200   1374.02
2 2012-07-03 1365.75 1374.81 1363.53 1374.02 2116390000   1374.02
3 2012-07-02 1362.33 1366.35 1355.70 1365.51 3301650000   1365.51
4 2012-06-29 1330.12 1362.17 1330.12 1362.16 4590480000   1362.16
5 2012-06-28 1331.52 1331.52 1313.29 1329.04 3969370000   1329.04
...

whereas this morning, July 5, it is
         Date    Open    High     Low   Close     Volume Adj.Close
1 2012-07-03 1365.75 1374.81 1363.53 1374.02 2116390000   1374.02
2 2012-07-02 1362.33 1366.35 1355.70 1365.51 3301650000   1365.51
3 2012-06-29 1330.12 1362.17 1330.12 1362.16 4590480000   1362.16
4 2012-06-28 1331.52 1331.52 1313.29 1329.04 3969370000   1329.04
...

The holiday with the previous days date causes duplicate index entries, 
which causes zoo to issue warnings, and causes a failure when there is 
an attempt to put two series together into a multivariate series.

Does anyone know what is going on at yahoo?  What is the convention at 
other data suppliers for adjustment data on holidays, or are these  real 
prices and volume that occurred after July 3?

Paul



More information about the R-SIG-Finance mailing list