API / XBRL Financial Report

Question

I wonder if anyone knows how to automatically receive data from Edgar? (free or otherwise)

I looked at it from yahoo / google, but they consolidate the information (for example, different income categories will be grouped into one income element). I have seen several paid sites like Zacks, but they also do consolidation.

Alternatively, is there a way to load various instructions using XBRL via api or otherwise? I can’t say that I fully understand how XBRL works, but it looks like the XML interface has access to various claimed messages (published by the companies themselves).

Answer 1

Looking at this, this is what I defined (note: as an expert on CPA and XBRL, I have limited IT knowledge). SEC offers an RSS feed of all XBRL real-time entries. They also offer FTP XBRL history through the service. I understand that if you know how to write an FTP script, you can use this to load the XBRL into the SQL database. You can then use RSS to collect real-time records in an SQL database.

FTP: ftp://ftp.sec.gov RSS: http://www.sec.gov/spotlight/xbrl/filings-and-feeds.shtml

If you are looking for a way to automate the creation of XBRL, some XBRL tools offer an API for collecting data from accounting systems and financial reporting. XBRL tools will provide you with the ability to "twist" the taxonomy of financial statements from quarter to quarter as needed. It will also provide automated verification and reporting tools. The XBRL software that I am most familiar with is Fujitsu XWand, but there are other good options. XWand has API functionality and can be tightly integrated into the BPM tool associated with Fujitsu for workflow management (http://www.fujitsu.com/global/services/software/interstage/solutions/xbrl/).

Hope this helps,

Jeff

Answer 2

Answering your question "Alternatively, is there a way to load various statements using XBRL via api or otherwise?" I could tell you Gepsio , the XBRL document object model for .NET. You can use it in .NET applications to use, validate, and send reports on various entries in an XBRL document.

Since Gepsio is a .NET component, it can also be used from PowerShell, which mainly brings XBRL consumption and validation in scripting environments. This blog post provides an example of using Gepsio from PowerShell.

Regarding the automated use of Edgar's documents, you should be aware that Gepsio can automatically consume documents hosted on the Internet by specifying the URL of the XBRL document when calling the Gepsio XbrlDocument.Load () method. The PowerShell example shown above on the blog gives an example of downloading XBRL from the Internet.

The blog post posted here also illustrates the use of Gepsio with C #.

Answer 3

@ user117650 How do you want to view the data?

---

You should look at www.finviews.com, we have done all the work for you. We have all the XBRL data (10-Q, 10-K, 20-F, S-1, etc.). Once the company sends its report to the SEC, you will receive it in less than 2 minutes in Excel, for example, so that later you can perform your financial modeling (watch the video on the website).

There are 2 threads:

• one of them is being reported, so by line you will get the same as the company publishes.
• the second is normalized, so you can compare companies among them. For example, some companies report revenue, some other sales, some other sales, etc.