Historical data incorrect by 2 decimal places, feeds into charts?
I've been trying to work out why historical charts I look at (5 days or more history) have very smooth lines.
I think it's because, for a lot of stocks, the historical data is saved with the decimal place in the wrong place. e.g. MNKS.L
Date Open High Low Close* Adj. close** Volume
24 May 2018 826.38 830.00 821.00 821.00 821.00 258,384
23 May 2018 8.30 8.35 8.24 8.24 8.24 264,398
22 May 2018 8.06 8.06 8.06 8.06 8.06 -
21 May 2018 8.04 8.04 8.04 8.04 8.04 -
18 May 2018 7.96 7.96 7.96 7.96 7.96 -
17 May 2018 7.98 7.98 7.98 7.98 7.98 -
16 May 2018 8.22 8.27 8.20 8.25 8.25 274,239
15 May 2018 7.95 7.95 7.95 7.95 7.95 -
The price of this stock has not increased 10-fold overnight.
The chart data also looks odd because it seems to be based on these figured i.e. going from the 8.00 range to the 800 range.
Data for the same stock from ADVFN:
Date Price Change Change (%) Low High Volume
May 23 2018 824 -8 -0.96% 824 835 261,833
May 22 2018 832 2.00 +0.24% 823 836 277,981
May 21 2018 830 10.00 +1.22% 824 833 338,609
May 18 2018 820 -3 -0.36% 820 827 212,804
May 17 2018 823 -2 -0.24% 818 825 267,784
May 16 2018 825 3.00 +0.36% 820 827 272,839
May 15 2018 822 -3 -0.36% 820 826 366,474
All in the 800 range.