Extraction of all the companies dividend data without listing in instruments. Is it possible ?

hariharan.muniandy

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

aramyan.h

Hi @hariharan.muniandy,

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