Hi, I have been trying to extract dividend data for all of the companies in the database. However, it seems cannot be done without listing the instrument. Is there some way that I could do that ? Thanks in advance
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
Hi, I have been trying to extract dividend data for all of the companies in the database. However, it seems cannot be done without listing the instrument. Is there some way that I could do that ? Thanks in advance
Hi @hariharan.muniandy ,
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.
Thank you,
AHS
I order to request data using one of our APIs like Data Libraries or Eikon, you need to pass the list of instrument RICs to the query: See below an example with Data Libraries:
import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ["MSFT.O", "LSEG.L"], fields = [ 'TR.DividendYield', 'TR.F.DivYldComStockIssuePctAnnized', 'TR.DPSGrowth5Y' 'TR.DivExDate', 'TR.DivPayDate', ] ) df
You can also pass index chains and the query will expand to show information on all constituents:
ftse_dividend = rd.get_data( universe = ["0#.FTSE"], fields = [ 'TR.DividendYield', 'TR.F.DivYldComStockIssuePctAnnized', 'TR.DPSGrowth5Y' 'TR.DivExDate', 'TR.DivPayDate', ], ) ftse_dividend
Hope this helps.
Best regards,
Haykaz