[Hasnain jaffery]

Hi David,
I have the same Q about the holding of ETFs and Mutual Funds. I was just checking ETF (SPDR® S&P 500® ESG ETF) EFIV (CIK = 1064642) has an entry in the Entity table, but not able to fig out where and how to search its holds
can you please guide me…?
thanks
Hasnain

[David Tauriello]

Hi Hasnain – this information is not submitted to the SEC in XBRL. That said, we’ve drafted a taxonomy and are exploring options for loading the data to our repository.

Stay tuned!

David

[David Tauriello]

Installation:

Install the XBRL Filed Data Add-on for Excel || Get these instructions in PDF

Watch a quick setup demo outlining how to install and get started with the XBRL Filed Add-in for Excel.
1. Open an Excel file from M365 or Office365, choose the Insert menu, click the Get Add-ins button, search for ‘XBRL’ and install XBRL Filed Data.
    
2. Click the XBRL Filed Data menu option, then Get a Free Account and follow the instructions on that page. Everyone, regardless of XBRL US Membership status, is welcome to request provisioning to use the XBRL API.
   

   All XBRL US Member accounts should be able to login and generate client ID and secret pairs. If you’re not able to do this, follow the prompt and request provisioning for this in email.

3. After the Add-in installs, click the XBRL Filed Data menu option to show the ribbon.
    
4. Click the login link in the ribbon to show the Query Wizard task pane.
   

   If you don’t have an XBRL US Web account provisioned to generate client ID and secret pairs, click the Get Account and Credentials button in the ribbon and follow the instructions on the web page.

5. Click the login button on the task pane and enter your XBRL US Web account email, password, client ID and secret, then click the login button at the bottom of the popup window. NOTE: If you use our ‘Sign in with Google’ option, you cannot use your Google account (gmail and password) to authenticate. You must use your Gmail email and XBRL US password.
    
6. Choose one of the functions in the task pane from the dropdown, at least one filter criteria, and the fields that should populate from the ‘Data to Return’ section of the Query Wizard task pane, then click the Search button.

Troubleshooting:

If you’re having trouble getting data to appear, try the following in the listed order, and stop when your issue is resolved:

1. If your account has recently been provisioned and you’re unable to generate client ID and secret pair to use in the Add-in, try using a private/incognito browser window or a different browser to login to the XBRL US web page where these pairs are created (or clear your browser’s cache). If you’re logged in to the interface and cannot create a Client ID and secret, you may have created a password with a character that is not allowed. Update your password to use only letters and numbers (no punctuation marks) – https://xbrl.us/reset-password.
    
2. Use this online script (or this version of the same resource) to confirm you have valid credentials (email, password, client ID and secret) for XBRL API authentication. You only need to run the first gray box and enter your information as it is requested. If you get a message that ‘There was a problem generating an access token with these credentials’, you’ll need to change your password and/or re-generate a Client ID and secret.
    
3. If you’re using the ‘Sign on with Google’ option to login on the XBRL US Web site, make sure you have created an XBRL US Web account with a password (you can use the same email as your ‘Sign on with Google’ email, but it is recommended that you not re-use your Google account password as your XBRL US Account password) and use the XBRL US Web account email and password as the login for the Add-in.
    
4. If you login on the Add-in and the Query Wizard doesn’t show ‘Data to Return’ options, right-click the task pane and choose reload, then click the logout button. After this, click the login button. Still not working? Uninstall the Add-in, close, re-open and re-install the Add-in.
    
5. If you return to Excel and the Add-in task panel shows ‘Unable to open’ the Add-in, click close on the panel, then choose ‘Login / Query Wizard’ to re-initialize the Add-in.
    
6. Clear the cache in your browser (DESKTOP Users – clear the Microsoft Edge browser cache), then close and re-open Excel and the Add-in.

Tried everything and it still won’t work? Post a reply here.

• This topic was modified 3 years, 2 months ago by David Tauriello.
• This topic was modified 3 years, 2 months ago by David Tauriello.
• This topic was modified 3 years, 2 months ago by David Tauriello.
• This topic was modified 3 years, 2 months ago by David Tauriello.

[Robert Koppensteiner]

Is this XBRL Google Sheet and add-on free of charge ? or do I need to pay a membership fee ?

[David Tauriello]

Hi Robert – thanks for writing. Anyone can use the XBRL API and data from our Public Filings Database. XBRL US Members will return more rows with a query (if the additional rows exist), and all XBRL US Members except our Basic Individual Membership are not capped by the number of queries that can be made.

If you’re considering publishing an article or research based on conclusions drawn from use of our Database, or if you’re interested in commercial access, you’ll need an Organizational Membership.

See this page for complete details.

[Laura Rusu]

Hi David,
This is really great!
How many data points can non-members request (as opposed to members)? are there any other restrictions for non-members?
Thank you,
Laura

[David Tauriello]

Hi Laura – thanks for writing and I’m glad you’re interested in the XBRL Data Filed add-in for Excel.

This is from the Terms of Use Agreement that governs access and us of our Public Filings Database:

XBRL US Membership improves data access (see below). Sole Practitioners and Organizational Members also enjoy publishing rights and commercial use of data returned from our Database of Public Filings.

Membership Type	Records per query	Record offset limit
non-Member *	100	1,000
Basic Individual *	500	2,000
All Other Members	2,000	unlimited

* Account limit: 100,000 queries

In addition, the /document endpoint is not accessible to non-Members. Check out the documentation for full details on the XBRL API specification – https://xbrlus.github.io/xbrl-api

[Laura Rusu]

Thank you very much, David!

Kind regards,
Laura

[Arthur Olevskiy]

Hi David,

Can you give advise in the field of us-gaap statement standardization? Maybe XBRL US has some articles or related information?

Best,
Arthur

[David Tauriello]

Hi Arthur – take a look at the balance sheet template contributed by Peter Guldberg – https://xbrl.us/xbrl-api-balance-sheet – it’s a good example of a mapping activity that might be useful to you in considering how to standardize financial statement data

[hypnos hyp]

Data is not being loaded even after all the troubleshoots. Though CILK gets loaded for selected ticker.

[David Tauriello]

Hi Hypnos – does the Google Sheet side panel appear when you use the menu options: Add-ons >> XBRL API Access >> Authentication Menu – ?

If the Authentication Menu shows you as logged in (logout button appearing in the panel), what happens if you create a new Google Sheet (not a copy of one of our templates), click your cursor into cell A1 and paste the following into the formula bar above the spreadsheet (you might need to remove line breaks):

=showData("https://api.xbrl.us/api/v1/fact/search?entity.cik=0001108524&concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-period=Y&period.fiscal-year=2020&fact.ultimus=true&fields=entity.name,period.fiscal-year.sort(DESC),fact.numerical-value,member.local-name.sort(ASC),dimensions")

If that doesn’t resolve the issue, what happens if you move to a browser on another computer (on a different network, if you’re in an organization or within a VPN) and log in?

[sabbir ahmed]

Hello Everyone,

I have a good interest for 2 data points, here are they

1. Net profit of a company.
2. Number of employees of a company.

Here, I found “Net Profit” in 10-K filings of a company, I use this API-endpoint to retrieve data

https://api.xbrl.us/api/v1/fact/search?entity.cik=0001326801&report.is-most-current=true&fields=report.%2A/fact/search?entity.cik=0001326801&concept.local-name=NetIncomeLoss&fact.ultimus=true&period.fiscal-period=Y&fields=entity.name,fact.value,fact.decimals,unit,report.filing-date.sort(DESC),concept.local-name

But when I’m trying for different company’s CIK like Apple Inc. (CIK = 0000320193), API response breaks. And I can’t find any API to retrieve second data point. Is there any good way to do this? Please help.

[David Tauriello]

Hi Sabbir – apologies for not responding sooner. The SEC requirement allows companies to create extensions for concepts that are not defined by the base US GAAP Taxonomy. So, it’s possible a company does not report Net Profits because the definition in the taxonomy does not match any facts they report.

One of our Power User Members – Peter Guldberg – put together a Google Sheet template for the Balance Sheet that ‘maps’ taxonomy concepts to a single line in a report – see https://docs.google.com/spreadsheets/d/16f6CRVvfyyVEhpfm3lJCXODtRUUMhMi1I7XMR324qU0/edit#gid=1819560642&range=A1 for the map. You’ll need to make a copy of this Google Sheet in your Google Account to see how it works.

Applying this mapping technique to your use case for the data (standardization) would help you collect Net Profit for companies under a single term.

Sincerely,
David

[Mikko Olkkonen]

I plan to import https://www.sec.gov/dera/data/financial-statement-data-sets.html data to a MySQL database.
Are there any ready-to-use table definition SQL scripts for forming a suitable SQL database?

[Author]

Posts