Wrong prices from Yahoo for MRK.DE after June 2014 split
Author: placebo76
Creation Date: 8/2/2015 4:36 AM
profile picture

placebo76

#1
Hi, what is the best way to handle wrong prices from yahoo? Because of that trading strategies can output completely wrong results.

An example of a very big company within the DAX 30

https://de.finance.yahoo.com/q/bc?s=MRK.DE&t=2y&l=on&z=l&q=l&c=

You can see the failure in June 2014

And it's just luck that i saw the failure ...

I think it was a split but i would expect that yahoo delivers the correct prices ...

Regards Daniel
profile picture

Eugene

#2
Hi,

Assuming that the split in MRK.DE happened on 06/24/2014 (as per the prices) and not on 06/30/2014 as stated in the data table, here's what you can do to fix the error:

1. Open the Data Manager, Yahoo! Data tab, click "Ignore selected splits", and add the MRK.DE 06/30/2014 split to the exclusion list.
2. Open up the MRK.DE chart, zero in on 06/24/2014, right click and select "Process a stock split", type in 06/23/2014 and 2:1.
profile picture

Cone

#3
In this case, since there are only 4 bars involved, you can also just edit each bar's OHLC/V values by double clicking each bar.

Edit:
At least I thought that should work. Strangely enough, after editing the 6/24 and then the 6/25 bars, the split was "reversed" showing a price level back around 128 for 6/24 and prior. Why???

Edit 2:
Nonetheless, after refreshing the chart and repeating the process, it worked fine the second time.
profile picture

placebo76

#4
Thanks i have fixed it by the solution of Eugene.

Regards Daniel