Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
kerem.baykal avatar image
18 ●1 ●1 ●2

Turkey single stock prices are wrong for period before 27/07/2020

In Python, ek.get_timeseries() for most Turkish stocks have started to produce wrong historical OPEN/HIGH/LOW/CLOSE values for the period prior to 27/07/2020. Problem started occuring on 19/10/2020.

When I check the CHTV for single Turkish stocks on Reuters Eikon App, same problem is seen there as well. It appears that there is a databse issue, from which both the python api and the CHTV app are pulling wrong prices.

Turkey single stock prices prior to 27/07/2020 seem to have been divided by 100. This may be an unintended consequence of the fact that Borsa Istanbul divided equity index values by 100 on 27/07/2020. While prices for equity indices were divided by 100, prices for single stocks were not.

This is a major issue affecting all scripts written using Eikon.

Any help is appreciated,

Kerem


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiequities
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image   Jirapongse

@kerem.baykal

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

3 Answers

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @kerem.baykal

I think this is an issue on the backend.

I tested this code for several times, sometime the data return on the same scale 7.xxx but sometime the data are on the different scale 7.xxx vs 0.07xx


I raised a ticket no. 09277217 on your behalf to Refinitiv Content Helpdesk asking them 2 questions:

1. Why the scale of the data jumps a lot

2. Why the result sometimes on 7.xxx scale sometimes on 0.07xx scale


ahs.png (85.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kerem.baykal avatar image kerem.baykal

Chavalit thank you, I agree that it seems to be a backend database issue. Thank you for double checking. I've raised the issue with helpdesk but have not received anything from them. It is helpful that you also raised it. Thank you very much, I will wait for a response from them

Upvotes
kerem.baykal avatar image
18 ●1 ●1 ●2

sorry to break this into 2 messages


To give a few examples, in both ek_get_timeseries() and Eikon CHTV app,

a) Closing price of GARAN.IS jumps from 0.08 on July 24th 2020 to 7.02 on July 2th 2020
B) Closing price of ASELS.IS jumps from 0.33 on July 24th 2020 to 35.26 on July 27th 2020


Same problem persists across all single stocks in Turkey. Prices before July 27th 2020 seem to have been divided by 100 across the board and are wrong. There is a huge jump in all single stock prices on July 27th because they revert to normal.

Hope this makes the issue more clear

Kerem

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
kerem.baykal avatar image
18 ●1 ●1 ●2

This issue has been fixed on the back end as of 21/10/20 18:30 istanbul time

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.