Home Forums The XBRL API Retrieving Market Cap as a concept.local-name item from a report.id

This topic contains 9 replies, has 2 voices, and was last updated by  David Tauriello 4 months, 2 weeks ago.

  • Author
    Posts
  • #153442

    Jason Mellone
    Participant

    Assuming I know some report.id, I can retrieve stuff like CommonStockSharesOutstanding using something like:

    def fields_from_report_id(report_id, fields):
        return execute_query('fact/search?report.id=' + str(
            report_id) + '&fact.has-dimensions=false&concept.local-name=' + fields + '&fields=concept.local-name.sort(ASC),fact.value,fact.decimals,period.fiscal-year,period.fiscal-period')

    execute_query just executes the query using my credentials – you can assume this works.

    Now, assuming I want to retrieve Market Cap as a concept.local-name, is this possible?

    Right now, I am calc’ing Market Cap using an external vendor for price, but would rather use the xbrl feed directly, if possible

  • #153801

    David Tauriello
    Keymaster

    Hi Jason – take a look at EntityPublicFloat – it might be helpful to you.

    Here’s a sample of Microsoft’s fact.value history for the concept:

    /report/fact/search?entity.id=6930&concept.local-name=EntityPublicFloat&fields=fact.value,report.document-type,report.period-end.sort(DESC),report.restated-index,dts.id

    Here’s the definition of the concept across all US GAAP Taxonomies:

    /concept/search?dts.id=257581,257584,257585,257586,257587,257588,257589,
    257590,292503,322998&concept.local-name=EntityPublicFloat&fields=
    dts.id.sort(DESC),concept.namespace,concept.local-name,label.text

You must be logged in to reply to this topic.

Comment