question

Upvotes
Accepted
1 0 0 1

Eikon field that returns dividend in the appropriate denomination

Im wokring for an oms/pms provider and we use the EIKON COM API. we ingest a eikon field like tr.isin and a ric and use the output to populate our databases.i need a function like tr.isisn that can output the dividend in the appropriate denomination. so for gbp dividends the value is returned in pence. but the same function would ingest only the ric and return us dividends in dollars.

tr("tr.function", "us ric")= dividend in dollars (#.##)

tr("tr.function", "gb ric")= dividend in pence (###)

eikoneikon-data-apieikon-com-api
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
39.2k 75 11 27

@yashvi.ananda
The simple answer is: to retrieve adjusted gross dividend amount in British pence use field "TR.DivAdjustedGross(Curn=GBp)".
I think you would benefit from checking out this tutorial. It talks at length about metadata discovery (finding field names and parameters) for use with Eikon Data APIs. The same methodology can be used to discover metadata for use with Eikon COM APIs.
For an Excel worksheet example of the dividend data retrieval you're looking for open Excel.Click on Thomson Reuters tab to activate Eikon Excel ribbon. Click Templates button. In the "Search for templates" bar type in "dividend". From the search results select "Dividends, Price Changes and Total Returns for a List of Stocks". The example you're looking for can be found in cell B27 of "Single stock" worksheet.

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