Excel-Eikon add-in, how to recognize RIC's

taylor_r_wentworth
taylor_r_wentworth Newcomer
in Eikon COM

How can I get the Eikon formula builder to recognize standard ticker symbols without the ".X" Eikon conventions? For instance, I get a spreadsheet of portfolios sent in the morning and I am trying to use the Eikon add-in to populate high/low price data. However, I have to manually add each ticker into the formula builder because it does not recognize the tickers in excel; eg, TSLA instead of TSLA.O

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    In =TR worksheet function you can add CONVERTCODE parameter, e.g.

    =TR("TSLA","HIGH_1;LOW_1","CONVERTCODE:YES")
    This forum is dedicated to software developers using Refinitiv APIs. The best resource to get help with using Eikon Excel add-in is Refinitiv Helpdesk, which you can reach by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application. If you need further help with this, please contact Refinitiv Helpdesk.

Categories