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

Best Answer

Answers

  • zoya faberov
    zoya faberov

    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)

    image

    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.

  • hugh.nguyen
    hugh.nguyen

    zoya.farberov thank you very much but I am interested in know how to do it using Python, not Excel.

Categories