glourencoffee / pycvm

Python library for processing data from CVM
MIT License
2 stars 0 forks source link

Income and balance sheet statements are not created for some documents in the DFP of years 2010, 2011, 2013, and 2019 #20

Closed glourencoffee closed 2 years ago

glourencoffee commented 2 years ago

Description

The exception ValueError is raised while trying to create an IncomeStatement or BalanceSheet for some documents in the DFP of years 2010, 2011, 2013, and 2019.

Steps to reproduce

  1. Download the DFP of 2010, 2011, 2013, or 2019
  2. Call python -m samples.dfp.print_balances, passing one such DFP file as an argument
  3. Wait for the sample program to finish execution
  4. See missing companies at the end of output

Expected behavior

No exception should be raised for the DFP of those years.

Additional context

This bug results from the refactor implemented by callmegiorgio/pycvm#11. Apparently, the CVM code of some companies were not accounted for because some documents still failed to be read by dfpitr_reader(), as callmegiorgio/pycvm#14 had not been merged to develop yet.

glourencoffee commented 2 years ago

Below is the CVM code and name of missing companies, all of which use the industrial layout:

DFP CVM Code Company
2010 21741 ECO SECURITIZADORA DIREITOS CRED AGRONEGÓCIO S.A.
2010 22756 SAAG INVESTIMENTOS S.A.
2010 22292 STEIN SP II PARTICIPAÇÕES S.A.
2011 22284 MCM CIMENTOS S/A
2013 23299 JP PARTICIPAÇÕES S.A.
2019 24805 VIVARA PARTICIPAÇÕES S.A.
2019 25739 CS BRASIL PARTICIPAÇÕES E LOCAÇÕES S.A.