Companies that had a 2016 entry, but not a 2017 entry
In [9]:
for company in EdgarCompanyInfo.objects.all().order_by('conformed_name'):
_2016 = EdgarSDFiling.objects.filter(company=company, date__year=2016)
if _2016.count() > 0:
_2017 = EdgarSDFiling.objects.filter(company=company, date__year=2017)
if _2017.count() == 0:
print(company.conformed_name, '({0})'.format(company.cik))
Alcatel was bought by Nokia. Haven't researched others.
Companies with less than four entries
In [8]:
for company in EdgarCompanyInfo.objects.all().order_by('conformed_name'):
if EdgarSDFiling.objects.filter(company=company).count() < 4:
print(company.conformed_name, '({0})'.format(company.cik))
In [ ]: