Home Forums The XBRL API entity.ticker does not return any value

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  Tim Bui 6 months, 4 weeks ago.

  • Author
    Posts
  • #128890

    Tim Bui
    Participant

    Hello,
    I use the code below to get some data. with entity.name I do get the company name, however, the entity.ticker does not return value. Would anyone please point me to the right direction? Thank you
    =CONCATENATE(A1&”/fact/search?entity.cik=”&TEXTJOIN(“,”,TRUE,Call!B22:B179)&”&fact.has-dimensions=false&fact.ultimus-index=1&concept.local-name=”&Call!G19&”&period.fiscal-period=”&Call!D1&”&period.fiscal-year=”&TEXTJOIN(“,”,TRUE,Call!A2:I2)&”&fields=entity.cik,period.fiscal-year,period.fiscal-period,concept.local-name,concept.id,fact.value,concept.balance-type, entity.name,entity.ticker”)

  • #129019

    David Tauriello
    Keymaster

    entity.ticker is not available on the /fact endpoint (see XBRL API Documentation).

    You might be able to return this detail if you use /report/fact/search? instead of /fact/search? – note: this might ‘nest’ the results in Google Sheets and make that approach impractical. In that case, consider including dts.id or report.id as one of the fields in your initial query, then set up a second query to return entity.ticker as /report/search?dts.id=(INTEGERS,FROM,YOUR,QUERY)&fields=entity.ticker

  • #129754

    Tim Bui
    Participant

    Thank you for your explanation, David.

You must be logged in to reply to this topic.

Comment