SEC forms are thin

[miha42-github]

Introduction

For at least the following companies a small number of SEC forms is reported back.

• Apple Inc
• IBM
• Schlumberger

Potential cause

A change was introduced to detect multiple CIKs and only return the values from one CIK, this change could result in there only being the first return. Specifically, the SQL change to include the DISTINCT command could be the culprit. This should be quickly investigated and resolved.

Action

• [x] Test the removal of the DISTINCT clause from the SQL statements in edgar.py: This did not resolve the matter
• [x] Fix how the names of companies are uses as keys in the reporting dict(): This resolved the problem

[miha42-github]

Closing as resolved. The logic to remove duplicated companies from what's reported via edgar.get_all_details() actually did not resolve the original matter completely. The change was to make the name of the companies consistent, all uppercase and without any punctuation. However this is likely a quick and weak solution to the problem. A better approach would be to use the CIK as the dict() key and then unwind the structure to be based upon company name. This will be considered for a later date.