Forum Replies Created
-
AuthorPosts
-
Hasnain jafferyParticipant
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
HasnainDavid TaurielloKeymasterHi 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 TaurielloKeymasterInstallation:
Install the XBRL Filed Data Add-on for Excel || Get these instructions in PDF
- 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.
- 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.
- After the Add-in installs, click the XBRL Filed Data menu option to show the ribbon.
- 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.
- 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.
- 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.
Watch a quick setup demo outlining how to install and get started with the XBRL Filed Add-in for Excel.Troubleshooting:
If you’re having trouble getting data to appear, try the following in the listed order, and stop when your issue is resolved:
- 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.
- 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.
- 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.
- 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.
- 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.
- 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, 5 months ago by David Tauriello.
- This topic was modified 3 years, 5 months ago by David Tauriello.
- This topic was modified 3 years, 5 months ago by David Tauriello.
- This topic was modified 3 years, 5 months ago by David Tauriello.
Monday, March 1, 2021 at 2:49 AM in reply to: Getting started with the XBRL Google Sheet and add-on #189260Robert KoppensteinerParticipantIs this XBRL Google Sheet and add-on free of charge ? or do I need to pay a membership fee ?
Monday, March 1, 2021 at 4:42 PM in reply to: Getting started with the XBRL Google Sheet and add-on #189309David TaurielloKeymasterHi 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.
Monday, March 8, 2021 at 5:43 PM in reply to: Getting started with the XBRL Filed Data Add-in for Excel #189457AnonymousInactiveHi 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,
LauraWednesday, March 10, 2021 at 7:27 AM in reply to: Getting started with the XBRL Filed Data Add-in for Excel #189509David TaurielloKeymasterHi 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
Wednesday, March 10, 2021 at 7:28 PM in reply to: Getting started with the XBRL Filed Data Add-in for Excel #189582AnonymousInactiveThank you very much, David!
Kind regards,
LauraArthur OlevskiyParticipantHi David,
Can you give advise in the field of us-gaap statement standardization? Maybe XBRL US has some articles or related information?
Best,
ArthurDavid TaurielloKeymasterHi 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
Thursday, March 25, 2021 at 11:07 PM in reply to: Getting started with the XBRL Google Sheet and add-on #190383hypnos hypParticipantData is not being loaded even after all the troubleshoots. Though CILK gets loaded for selected ticker.
Friday, March 26, 2021 at 8:35 AM in reply to: Getting started with the XBRL Google Sheet and add-on #190398David TaurielloKeymasterHi 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 ahmedParticipantHello 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
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 TaurielloKeymasterHi 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,
DavidMikko OlkkonenParticipantI 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? - 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.
-
AuthorPosts