Home Forums The XBRL API Revenue Pull

Viewing 1 reply thread
  • Author
    Posts
    • #214696
      Jeremie Hicks
      Participant

      i got it linked up with google sheets, and now i just want to pull a company annual revenue. is that to simple?

    • #214762
      David Tauriello
      Keymaster

      Hi Jeremie – after you login and re-open the the spreadsheet extension, there are a number of filters to guide this search. On the fact function, you’ll want to use the ‘Get Facts by Entity Name’ for the company (ie. type and select Adobe Inc. when it appears), remove all but the 10-K value in the Filter by Document Type field and add the fiscal year 2022 and period Y (for year) in the corresponding form fields for the search.

      Adobe Inc. uses Revenues * in its reporting, so put that in the Filter by Concept Name field, set “Get Latest Facts’ to true and then click ‘Get’ for a result. If you remove the year from the query, you’ll get Adobe’s revenues for all years as reported in XBRL.

      We’ve posted several templates on the Data Community page linked at right, along with documentation for the parameters and fields you can use with the XBRL API.

      * There are a number of concepts companies can use to report revenue – this decision-making process is guided by the company’s research of the Financial Accounting Standards Board’s US GAAP Taxonomy, where these concepts are defined. Annual versions of the taxonomy are available from the XBRL API, and you can also get details from the ‘Taxonomy Viewer’ link on the right side of this page.

      Some of the most common concepts used are:

      • Revenues
      • RegulatedAndUnregulatedOperatingRevenue
      • InterestAndDividendIncomeSecurities
      • ResultsOfOperationsRevenueFromOilAndGasProducingActivities
      • LeaseIncome
      • RevenueFromContractWithCustomerIncludingAssessedTax
      • RevenueNotFromContractWithCustomerExcludingInterestIncome
      • RevenueFromContractWithCustomerExcludingAssessedTax
      • RevenueFromCollaborativeArrangementExcludingRevenueFromContractWithCustomer
Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Thursday, March 14, 2024

Domain Steering Committee Meeting
Tuesday, March 19, 2024

Communications & Services Steering Committee Meeting
Tuesday, March 19, 2024

FDTA: Entity and Security Identifiers
Thursday, March 28, 2024