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 (###)
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks,
AHS
Hello @yashvi.ananda
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks,
AHS
@yashvi.ananda, please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS
@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.
