[Tim Bui]

Hi Brandon,

I am not sure this source will meet your needs, but I have been using http://www.XBRLXL.com and find the site useful for my purpose. Jim Truscott, the founder, provides Excel spreadsheet for all annual and quarterly financial statements and footnotes. All I have to do is put in a ticker and hit Data Refresh and I get all of the financial data I need. The price is extremely reasonable and the service is superior. Anytime I have a question, Jim answers back by email very quickly.

Tim

[Anonymous]

yes tks

[David Tauriello]

The Statement and Disclosure Explorer google sheet template uses the /relationship endpoint to query parent-child detail from the DTS and includes an attribute called relationship.tree-depth.

While it’s not possible to nest the /relationship and /fact endpoints (taxonomy and instance), you can do two queries and “associate” the data (concept.local-name = relationship.target-name).

See hidden columns A-E on the FinancialsExplorer tab and the FEfacts tab of https://xbrl.us/xbrl-api-explorer for queries that may help you. NOTE: depending on XBRL US Membership, data returned on this template may be limited.

[John Chan]

I have written an email to info@xbrl.us but got no reply. Can anyone share their experience in getting the client ID and Secret?

• This topic was modified 4 years, 2 months ago by John Chan.

[David Tauriello]

Thanks for writing John; your account was provisioned yesterday. We triage by membership status, so there may be a few days delay between the time of request and confirmation.

[Tim Bui]

Hi David,

I can easily get the us-gaap tag (name) and label from the US_GAAP_Taxonomy spreadsheet. Is there a place where I can get all of the extensions to the tags?

Thank you!
Tim

[David Tauriello]

Hi Tim – I hope you’re well. Extensions are created by a company when they’re unable to find an appropriate element in the base taxonomy for their filing that is approved and supported by US SEC.

In the XBRL API, you can use concept.is-base=false as a filter on the /fact endpoint to return facts in a company filing that are extensions. For example, here’s a summary of non-dimensionalized elements Apple created for a filing a couple of years ago (returning concept.namespace so you can see these are extensions):

/fact/search?dts.id=306447&concept.is-base=false
&fact.has-dimensions=false&fact.ultimus=true
&fields=fact.value,concept.local-name,
period.fiscal-year.sort(DESC),period.fiscal-period,
concept.namespace

• This reply was modified 4 years, 2 months ago by David Tauriello.

[Chinmay Laddha]

Hello, Getting an error while changing the options in the drop-down menu:

Request failed for https://api.xbrl.us returned code 401. Truncated server response: {“error”:”invalid_request”,”error_description”:”Bad or expired token”} (use muteHttpExceptions option to examine full response) (line 106)

How to remove this error given my API is already authenticated

[Teji Abraham]

Hi David,
Hope you are keeping well. I had a few questions regarding the extraction and interpretation of Operating Lease related data:
1) Is there possibility of a time delay between the filing of 10-K/10-Q and when Operating Lease data is available on an xbrl-API endpoint. (we encountered this with WMT on the day 10-K was released. When we tried again after a week the data was there).

If is a typical occurrence, is there a way by which we can ascertain if the lack of data is bcos of a delay VS the entity not having any Operating Lease disclosure requirement ?

2) In a prior post, you had pointed out about using fact.has-dimensions=false to return non-dimensional values. However, there are cases where setting has-dimensions as false does not return any operating lease related data (for e.g. GM, cik=0001467858). In this context,
– How do we get operating lease related data (OperatingLeaseLiability, OperatingLeaseLiabilityNoncurrent, OperatingLeaseLiabilityCurrent, OperatingLeaseRightOfUseAsset)
– And how do we select the correct dimension for the consolidated lease data for the entity – because some of the above facts return multiple values
– Is there a xbrl document that explains how to interpret the different dimensions for various concepts.

3) Are there alternative way of extracting the above op. lease related facts when the entity does not disclose during interim intervals (ie quarterly). For e.g. when we try to extract Op. Lease data for GM for 2020 Q1 – we are not getting any values for OperatingLeaseLiability, OperatingLeaseLiabilityNoncurrent, OperatingLeaseLiabilityCurrent. Not sure if this is another case of a delay OR some other reason.

Thanks much, Teji

[Chinmay Laddha]

Hello Tim and Nathan, I am working on a project where anyone can populate the balance sheet, Income Statement, Cash Flow statement and some financial ratios for 6-7 years data into a google sheet in format/template and parameters of my choice. A python program where I could create a GUI, a user can select the company, parameters he/she want to see, then after selecting these parameters will be visible on the google sheet

[Tim Bui]

Hi Chinmay, I would love to see your project. While I have just begun to study Python so I am not sure if I can help in coding, but I do understand finance and financial analysis, so if I can assist in anyway, I would want to do that. Thank you!

[D Q]

Hi Chinmay, how do you solve the problem of standardizing the different tags?

[Tim Bui]

Hi DQ, if you have your method to standardize, maybe you can share with us. Here is how I do it, but I am not there yet.
I download the 2020 US GAAP Taxonomy (https://xbrl.us/xbrl-taxonomy/2020-us-gaap/) using the xls format. The tab “Presentation” inside this spreadsheet lists out all of the US GAAP tags (“name” column) and their sources (“definition” column) in hierarchical order as listed by the numbers on columns “depth” and “order”. I exact similar tags and group them the way I want to see them on a the financial statements. However, since there are so many extensions in addition to the standard tags, I am still missing a lot of tags. I do all of the grouping in SQL Server.

I get additional extensions by using the data downloaded from XBRL.US xsheet. David Tauriello said there is no source to get all of the extensions in one place as they are company specific.

For grouping, I use names like ca_101_cash, ca_102_mrkt_sec, ca_103_restricted_cash,….

So far I get about 26 tags for the cash group.
CashAndCashEquivalents
CashAndCashEquivalentsAbstract
CashAndCashEquivalentsAtCarryingValueNetOfReclassificationAdjustments
CashAndCashEquivalentsExcludingCashWithBroker
CashAndCashEquivalentsExcludingCashWithBrokerTradingAccounts
CashAndCashEquivalentsRelatingToVIEs
CashCashEquivalents
CashCashEquivalentsFederalFundsSoldAndOtherShortTermInvestments
CarryingValueOfCashAndCashEquivalents
CashAndEquivalentsExcludingAssetsHeldForSale
CashAndCashEquivalentsAtCarryingValueExcludingRestrictedCash
Cash
CashAndCashEquivalentExcludingFinancialServicesCashAndCashEquivalents
cashandcashequivalentsatcarryingvalue
CashAndCashEquivalentsAtCarryingValueIncludingDiscontinuedOperations
CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents
CashEquivalentsAtCarryingValue
ShorttermBankDeposits
CashAndCashEquivalentsFairValueDisclosure
CashAndDueFromBanks
CooperativeCentralBankDeposit
CashAndCashEquivalentsAtCarryingValueExcludingCertificatesOfDeposit
CashandCashEquivalentsExcludingTimeDepositsatCarryingValue
InterestBearingDepositsInBanks
TimeDepositsAtCarryingValue
CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations

[Tim Bui]

Sorry for the typo on my note above. It’s not XBRL.US xSheet. It’s XBRLXL xSheet (https://xbrlxl.com/)

[Juan Montano]

Hi everyone!

Does anyone know if it’s possible to get the industry (or sector) of an entity?

Any help is really appreciated!

Thanks!!!

Juan

[Author]

Posts