Saturday, June 27, 2020

Standardized financials from Earnings Press Release and 8-Ks are now available via the Calcbench API minutes after published.  Calcbench is leveraging our expertise in XBRL to get many of the numbers from the Income Statement, Balance Sheet and Statement of Cash Flows from the earnings press release or 8-K.  

Data for the Dow 30 is @ https://www.dropbox.com/s/9rzxu81w2sitr9l/calcbench_pit_preliminary.csv?dl=0.  The data starts in 2010.

The file includes numbers from the press-releases and the subsequent XBRL filings.  True in the preliminary column indicates the number was parsed from an earnings press-release.  True in the XBRL column indicates the number appeared in an XBRL document.  Therefore, True in the preliminary and XBRL columns indicates Calcbench parsed the number from the press-release and subsequently “confirmed” it in the XBRL document,  True in the preliminary column with False in the XBRL column indicates the number was parsed from the press release and was not subsequently “confirmed” in the XBRL 10-K/Q.  

An unconfirmed number could indicate that the number was reported differently in the XBRL document sometimes it will just be a rounding error, or Calcbench parsed the number from the earnings release incorrectly.  In the case where the XBRL number differs from a previously reported earnings release number the XBRL number will have a revision number greater than 0.

The date_reported column is when Calcbench published the data and it would have been tradable.

This file was created using the code @ https://github.com/calcbench/notebooks/blob/master/standardized_numeric_point_in_time.ipynb.

For a larger sample size and other questions email us@calcbench.com


FREE Calcbench Premium
Two Week Trial

Research financial & accounting data like never before. Get features designed for better insights. Try our enhanced Excel Add-in. Sign up now to try the Premium Suite.