CODEWITHSUNDEEP
jsontaxonomyxbrledgar
jerry
jerry

Reputation: 41

EDGAR RESTful API dei taxonomy

I'm trying to write a Microsoft Excel UDF to pull information from the U.S. SEC's EDGAR database. The documentation I can find says that I can pull data (for example) this way, and I'll get a JSON response:

https://data.sec.gov/api/xbrl/companyconcept/CIK##########/us-gaap/AccountsPayableCurrent.json

This works, as long as the taxonomy is "us-gaap", but I would have assumed that if I needed something from the "dei" taxonomy, I would just change that section of the URI, but no dice. For example, a company quarterly filing would have, on its cover page, its ticker symbol, which is in the dei taxonomy as "TickerSymbol". This, however, doesn't work

https://data.sec.gov/api/xbrl/companyconcept/CIK##########/dei/TickerSymbol.json

Anybody have experience trying to get this data out? I'm sure I'm missing something obvious, but I've been banging my head on this too long.

Upvotes: 0

Views: 718

Answers (1)

pdw
pdw

Reputation: 983

The concept that you are after is called TradingSymbol not TickerSymbol. Have a look at this Microsoft filing and search for "Symbol":

https://www.sec.gov/ix?doc=/Archives/edgar/data/789019/000156459022026876/msft-10k_20220630.htm

It appears that the concept is reported using a dimensional breakdown so that it is reported for each class of share, and unfortunately, it appears that facts with dimensions are not included in the data.sec.gov data. I can't find any documentation to this effect, but if I look at all facts for the company using this view, I can't find any dimensionally qualified facts:

https://data.sec.gov/api/xbrl/companyfacts/CIK0000789019.json

Given the amount of facts in a typical filing that are dimensionally qualified, this seems like quite an omission.

You might like to take a look at the XBRL US API, which I know does include all facts:

https://xbrl.us/home/use/xbrl-api/

Upvotes: 0

Related Questions