Home Forums The XBRL API XBRL code changes in office 365

Viewing 1 reply thread
  • Author
    Posts
    • #201377
      Asif Saberi
      Participant

      I am working with the API in excel and noticed that when I use Office 365 online, my XBRl lookup query is changed when I download it to my desktop as follows: “XBRL.SHOWDATA” is replaced by “_xldudf_XBRL_SHOWDATA” and the lookup fails on the desktop.
      =IFERROR(_xldudf_XBRL_SHOWDATA(CONCATENATE($D$11, $D$12, $D$5, “&fields=entity.name,entity.limit(1)”),,,0),”Enter a valid ticker symbol in B1″)
      Thanks in advance for any assistance.

    • #201386
      David Tauriello
      Keymaster

      Hi Asif – the XBRL Filed Data needs to be added to your desktop version of Excel in order to activate the custom XBRL.showData function used to retrieve data from our Public Filings Database.

      Use the ‘Add-ins’ button under the insert menu to download and install this from the Office Add-ins Store.

      • #201397
        Asif Saberi
        Participant

        It had been added. I resaved a file on the Office 365 site and then tried to open it with my desktop Excel App again. However, I went through the Add-In process again and it worked. Thanks!

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Webinar: DQC Rules for BDCs and Public Companies – Rule Set 20
Wednesday, December 14, 2022

Communications & Services Steering Committee Meeting
Tuesday, December 20, 2022

Domain Steering Committee Meeting
Tuesday, December 20, 2022

Public Exposure for Comment – Data Quality Committee Rules and Guidance
Saturday, December 31, 2022