Top Five Reasons to Document Your Schemas


Schema development is often an iterative process, and developers don’t typically start from scratch – XML Schemas, and, increasingly, JSON Schemas, are pieced together from existing documents or inherited from other teams. The ability to discern how schema components relate and analyze notes about development choices is infinitely helpful – but so often impossible due to lack of effective documentation.

Let’s take a look at some of the reasons documentation should be an integral part of your XSD, JSON, or other schema development.

 Benefits of XSD documentation

Read more…

Tags: , , ,

Compare Financial Data for 2 US Public Companies


Last winter we launched Company Financials – a nifty little app that lets you view and graph financial reports for US public companies based on the XBRL data that they have to file with the SEC. Now we’re proud to announce the new Company Financials 2.2 app, which adds tons of new features, including the ability to compare financial data for 2 US public companies side-by-side!

Lower Manhattan

So when you’re out on the boat this summer, looking back at Lower Manhattan and Wall Street, you can still analyze financial reports and do an in-depth comparison of financial data between two companies – just by typing their stock tickers into your smartphone or tablet.

Read more…

Tags: , ,

Excel Add-in Generates XBRL WIP Data


The reach of the eXtensible Business Reporting Language (XBRL) is rapidly expanding beyond financial reporting requirements to provide the advantages of standardized data submission across verticals. One recent development is the Work in Process XBRL Taxonomy created by XBRL.US for the surety industry.

The good news is that non-technical stakeholders can be completely shielded from the complexity of XBRL using software tools developed in concert with the taxonomy standards.

We’re excited to introduce the Altova Work in Process (WIP) XBRL add-in for Excel: a new product that lets contractors build their WIP reports directly in Excel, where they’re already comfortable working, and then export the reports in WIP XBRL for submission to sureties and underwriters.

Contractors writing WIP XBRL reports in Excel

Read more…

Tags: , ,

XBRL Data Mapping: WIP Taxonomy


The usefulness of the XBRL standard reaches far beyond SEC requirements for filing financial statements. Organizations such as XBRL.US and XBRL International are working to develop XBRL taxonomies and accompanying software solutions for countless other practical applications where standardizing data submission results in increased accuracy and productivity for all involved – for report filing, data analysis, and beyond.

One such project is the Work in Progress (WIP) Taxonomy created by XBRL.US for the surety industry. The new taxonomy helps save time and increase accuracy for report submission, and at the same time enables new opportunities for data analysis and decision making.

Construction-site-surety

Read more…

Tags: , ,

Company Financials App Now Available


US public companies are required to file their company financials – including income statements, balance sheets, and cash flow statements – quarterly and annually with the U.S. Securities and Exchange Commission (SEC). These financial reports provide a snapshot of the financial health of a corporation and any investor interested in fundamental analysis will typically be looking at these reports in great detail and performing financial analysis, including the calculation of important financial ratios.

We have just published the free Company Financials App for iOS, Android, Windows Phone, and Windows 8.1/10 that lets you explore and analyze US public company high-level financial reports automatically extracted from the XBRL filings in the SEC’s EDGAR database. You can search by company name or stock ticker symbol and view the financial reports of the last four quarters or last four years, as well as charts of annual or quarterly data reaching back several years.

In addition, various financial ratios, such as current ratio, quick ratio, cash ratio, gross profit margin, operating profit margin, return on assets, return on equity, debt/equity ratio, capitalization ratio, asset turnover, free cash flow, and many others, are calculated and displayed for the last four quarters or last four years. This makes the Company Financials app very useful for education purposes, such as business school programs in the area of accounting, finance, or corporate management.

 

Company Financials App

Read more…

Tags: , , , , , , , , , , ,

New RaptorXML scripts added: XBRL.US DQC Rules, EFM v35, and EBA Filing Rules


Altova is a member of XBRL.US and has recently joined the XBRL US Center for Data Quality to support the Data Quality Committee’s initiative to address the public’s concerns about the quality and usability of XBRL financial data filed with the SEC.

As such, we are pleased to announce that we have just released a new set of EDGAR Tools for RaptorXML+XBRL Server on GitHub. These new Python scripts for RaptorXML+XBRL Server now support validation against the new Edgar Filer Manual (EFM) version 35, as well as implementing all the Approved DQC Guidance and Validation Rules from XBRL.US.

Data Quality DQC

Read more…

Tags: , , , , , , , ,

Financial Analysis of XBRL Corporate Filings on Mobile Devices


In a previous blog post we’ve described some of the problems that are encountered when processing corporate filings from the SEC’s EDGAR database  in XBRL. Today we present a system that overcomes these issues by downloading and processing XBRL filings on a daily basis, normalizing the financial data, computing common financial ratios, storing all data into a SQLite database, and then presenting the corporate reporting data for financial analysis through a mobile app for iOS, Android, and Windows Phone.

We are making all the sources for the data ingestion and normalization process available as Python scripts on GitHub under an Apache 2.0 license. The actual normalization rules as well as the financial ratios being computed are defined in external JSON files that can easily be modified without the need to edit the Python sources. In addition the MobileTogether Design file describing the mobile app is also available as open source in the same repository on GitHub so the mobile application can be easily customized as well to graph different data, show other financial ratios, or do more sophisticated financial analysis.

SECdb Process Diagram

 

Read more…

Tags: , , , , , , , , , , ,