Home Forums The XBRL API XBRL code changes in office 365

Viewing 1 reply thread
  • Author
    • #201377
      Asif Saberi

      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

      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

        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.

Upcoming XBRL US Events

Webinar: SEC Rule – Tailored Shareholder Reports for Mutual Funds and ETFs
Wednesday, May 15, 2024

Domain Steering Committee Meeting
Tuesday, May 21, 2024

Communications & Services Steering Committee Meeting
Tuesday, May 21, 2024

GovFin 2024: Municipal Reporting Workshop
Tuesday, July 30, 2024