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
3 1 1 4

API retrieving weird/wrong data for BOPr.AT

Hi,

I am retrieving a total number of shares outstanding for BOPr.AT both via Excel and via API. In Excel, I use "=@RData(A2:A25;"RCA.S.Outstanding";;;"CH:Fd")" to get the correct value. This however, does not work in API and hence I need to use, for example, 'TR.F.ComShrOutsTot', which returns incorrect values.

Do you know where the issue is? And how to emulate RCA.S.Outstanding in Eikon API?

eikon-data-apiapidatadatastream-api
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
Accepted
81.1k 264 53 76

@havlin

Please try the TR.SharesOutstanding field.

df, err = ek.get_data(['BOPr.AT','IBM.N'],['TR.SharesOutstanding'])
df

This field represents the issue-level outstanding shares.

The output is:

1644550871125.png

The values are equal to the values returned from the RData function.

1644551128922.png


1644550871125.png (12.4 KiB)
1644551128922.png (9.9 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.

Thank you! This was exactly what I was looking for :)
Upvotes
10.5k 19 6 9

@havlin So you can use the Data Item Browser App (type DIB in Eikon search bar) to see different fields available:

1644513996240.png

What number is RCA.S.Outstanding returning? I do know there have been some events on this issue the stock was split into old and new I believe. There are a number of this type of field available and some fields may calculate things in a slightly different manner. I hope this can help. If you still believe there is an error in the number you can always raise a content query in Contact Us.


1644513996240.png (452.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.

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.