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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 1 2

Duplicates and missing days in daily data for TR.CompanyMarketCap

When importing daily time series data for TR.CompanyMarketCap there are some duplicates and missing data points. Example:

ek.get_data('SENP.WA', ['TR.CompanyMarketCap.Date', 'TR.CompanyMarketCap.Value'],
            parameters={"Frq": "D", "SDate": '2013-08-01', "EDate": '2013-08-10'})

gives result (see dulicated 2013-08-02 and no data for 2013-08-05):

For ca. 1 million rows of daily data for ca. 400 tickers from Polish market (.WA) 5522 rows for TR.CompanyMarketCap.Value are NaN, so the problem seem to affect around 0,5% of data points in this population.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
1612191069086.png (29.4 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
6.7k 8 6 7

@jakub.wielgus - I can indeed replicate your issue - I have opened a case with our content support team who will look into this data issue with you - your case number is: 09582622 and they will contact you shortly. I hope this can help.

icon clock
10 |1500

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

Click below to post an Idea Post Idea