Eikon excel API HELP

ylan
ylan Newcomer
in Eikon Data APIs

Hi, the eikon excel API sort an Error "Invalid Value CODE parameter". Could anyone help me?

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @ylan,

    the only part of your formula I'm not sure of is the first element, i.e. the universe: "LIST(Full list)"

    I attached a small sheet (sampleforylan.zip) which uses a list of instruments as input, defined as FullList, which is the range of cells A3:A11 (note: the name cannot contain a space).

    My working formula is the following:

    =TR(FullList,"DSPLY_NAME;CF_LAST;CF_TICK;CF_VOLUME;PCTCHNG;TR.PricePctChgYTD;YRHIGH;YRLOW;TR.EV;TR.CompanyMarketCap;TR.Revenue;TR.PriceToSalesPerShare;TR.NetDebtToEBITDA;TR.TtlCmnSharesOut;TR.NetDebtTot","CH=Fd RH=IN")

    That said, I'd guess the error is elsewhere in your sheet, considering the error message.

    PS: you cannot attach an Excel file, but you can attach a zip file to work around that limitation.

Answers

  • Christiaan Meihsl
    Christiaan Meihsl LSEG

    @ylan, could you please post the excel sheet you are using ? That will help us debug the issue.

  • ylan
    ylan Newcomer

    I can't upload a xls document.

    =TR("LIST(Full list)";"DSPLY_NAME;CF_LAST;CF_TICK;CF_VOLUME;PCTCHNG;TR.PricePctChgYTD;YRHIGH;YRLOW;TR.EV;TR.CompanyMarketCap;TR.Revenue;TR.PriceToSalesPerShare;TR.NetDebtToEBITDA;TR.TtlCmnSharesOut;TR.NetDebtTot";"CH=Fd RH=IN")

    Doyou see any errors?

  • ylan
    ylan Newcomer

    Thanks for the reply. It's TR Eikon who controls the LIST.

    Here is the zip of my excel sheet.

    Finally I don't know why it works but it works.

    tj-copie.zip

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    https://community.developers.refinitiv.com/discussion/comment/43538#Comment_43538

    @ylan, oh yes, obviously, your formula was referring to an Eikon list, of course !

    I just made a quick test, the formula accepts a list name that contains a space character, so the space was not the cause of the "Invalid Value CODE parameter" message you saw.

    So finally we both don't know why it works, but it works, and that is the main point. If it crops up again, tell us and we will investigate further.

Categories