How do I get the most recent equity/debt issuance from a company using eikon data api?

Hello @hugh.nguyen,

I am glad to discuss how I would approach this and similar requirements.

The quick approach is to use Screener tool. It is available from:

Eikon Excel -> Thomson Reuters-> choose a cell->Screener

In the tool, select

• Universe = Deals
• Asset class = Equity (perhaps we would like to examine the output from all 4, one by one, to see the results)
• Include = required company (we edit "Include" to do so)

once we "Insert Screen" and the content loads, we should have the expression to use within get_data method, to get this specific result.

Chances are, that the first result will not be entirely satisfactory. Using Screener tool we will be able to, iteratively:

1. Adjust the parameters and tune the result
2. Display the Screener query
3. Move the end result (the query) into your custom Python API code

For example, once we see the dates of the issues returned, we may wish to adjust the filter "Issue Date" to only include the last issue

If we are not able to identify the required content, the next best step is to contact Refinitiv Content Helpdesk, specifying Eikon as product, so Eikon content experts can help identify the required content.