Welcome to the Forum

Creating an account is currently only possible via registration at SimFin.

Open/Close outside of Low/High

In a lot of cases, the Open/Close values lie *outside* the Low/High range. This might be due to rounding errors. It could be easily fixed in the user end (simply use low=min(open, close, low) and high=max(open,close,high)) - but fixing it in the source seems more appropriate?

From my report:
Errors for: GOOG (18)
Open < Low (4)
2015-10-13: 643.1271 < 643.15
2018-06-18: 1143.584 < 1143.59
Close > High (1)
2018-01-26: 1175.84 > 1175.762
Open > High (1)
2019-08-30: 1198.5 > 1198.19

Actual data:
GOOG;18;2015-10-13;643.1271;643.1500;657.8130;652.3000;652.30;;1807700

Errors for: ATVI (243)
Open > High (12)
2007-08-15: 9.6954 > 9.695
2008-03-12: 13.6862 > 13.685
Open < Low (7)
2008-05-27: 16.305 < 16.3059
2009-09-21: 11.6292 < 11.63
Close > High (2)
2012-03-29: 12.77 > 12.7699
2013-07-11: 15.31 > 15.3099

Errors for: BLK (914)
Open < Low (14)
2007-01-12: 167.02 < 167.0298
2008-05-01: 200.2469 < 200.25
Open > High (8)
2007-08-24: 160.2056 > 160.2
2008-02-11: 206.0096 > 206
Close > High (2)
2011-04-19: 192.03 > 192.0258
2013-04-10: 260.77 > 260.7581
Sign In to comment.