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
tta avatar image
39 ●3 ●3 ●7

inconsistent shares outstanding from ek.get_data()

Hi,

I get inconsistent data on shares outstanding for the same instrument (SPY) in two almost identical queries with ek.get_data() with the only difference being the time periods which are overlapped.

Here are my queries:

df1, err = ek.get_data(['SPY'], ['TR.NETASSETVAL.date', 'TR.NETASSETVAL','TR.SharesOutstanding', 'TR.DividendYield'], {'SDate':'2021-01-01', 'EDate':'2022-01-21'})

df2, err = ek.get_data(['SPY'], ['TR.NETASSETVAL.date', 'TR.NETASSETVAL','TR.SharesOutstanding', 'TR.DividendYield'], {'SDate':'2022-01-01', 'EDate':'2022-01-21'})

The data returned for Outstanding Shares are quite different for the overlapped period from Jan 02, 22 - Jan 21, 22.

df1

271SPY2022-01-17T00:00:00Z464.71799<NA>1.230464272SPY2022-01-18T00:00:00Z456.180463<NA>1.252648273SPY2022-01-19T00:00:00Z451.768523<NA>1.265791274SPY2022-01-20T00:00:00Z446.815784<NA>1.279958


df2

10SPY2022-01-17T00:00:00Z464.717999520321161.23046411SPY2022-01-18T00:00:00Z456.1804639520321161.25264812SPY2022-01-19T00:00:00Z451.7685239520321161.26579113SPY2022-01-20T00:00:00Z446.8157849520321161.279958


I would appreciate if you can check this inconsistency.

Thanks,

TH

eikon-data-apietf
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

@tta

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

tta avatar image   tta Jirapongse
Hi,

I did not see any "Accept" button to click on.

Thanks,

TTA

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

3 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
78.6k ●248 ●52 ●74

@tta

You need to request the TR.SharesOutstanding.date field to check the date of the TR.SharesOutstanding field. 

df1, err = ek.get_data(['SPY'], ['TR.NETASSETVAL.date', 'TR.NETASSETVAL','TR.SharesOutstanding.date','TR.SharesOutstanding', 'TR.DividendYield'], {'SDate':'2021-01-01', 'EDate':'2022-01-21'})

The dates are overlapped.

1642999539737.png


1642999539737.png (46.4 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.

Upvotes
tta avatar image
39 ●3 ●3 ●7

Thank you so much for the suggestion. It's interesting to see that the dates are not aligned with each other. It seems the field Sharesoutstanding has fewer observations than the other fields. I was wondering why it is the case?

Thanks again for the support.

TH


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.

Upvote
zoya faberov avatar image
32.2k ●40 ●11 ●20

Hello @tta ,

Following up on the answer from @Jirapongse on how to obtain the content set using Eikon Data API, for an expert explanation and clarification on the actual content, the best way is to refer to Refinitiv Eikon content experts directly, via Refinitiv Helpdesk Online -> Content -> Eikon while this forum will be of most help to you with EDAPI usage questions.

Let us know if you are able to proceed, or would like us to help submit on your behalf?

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.