janlukasschroeder / sec-api

sec.gov EDGAR API | search & filter SEC filings | over 150 form types supported | 10-Q, 10-K, 8, 4, 13, S-11, ... | insider trading
https://sec-api.io
226 stars 33 forks source link

Issue in Query API -- Not All Filings Seem To Be Available #43

Closed mvg9999 closed 3 months ago

mvg9999 commented 3 months ago

When I run the following query using the SDK

{
    "query": "ticker:INTC AND formType:\"DEF 14A\" AND filedAt:[2016-01-01 TO 2016-12-31]",
    "from": "0",
    "size": "100",
    "sort": [{ "filedAt": { "order": "desc" } }]
}

I receive the DEF 14A filing from 2016 from Intel.

However, when I run the following query

{
    "query": "ticker:GOOG AND formType:\"DEF 14A\" AND filedAt:[2016-01-01 TO 2016-12-31]",
    "from": "0",
    "size": "100",
    "sort": [{ "filedAt": { "order": "desc" } }]
}

I do not receive any filing. This filing does exist (see here: https://www.sec.gov/Archives/edgar/data/1652044/000130817916000384/lgoog_def14a.htm), so I believe there's an issue on the API end?

This behavior also occurs in sec-api sandbox.

LMK if I've missed something

janlukasschroeder commented 3 months ago

Try to use the CIK lookup rather than the ticker filter. Google/Alphabet trades under the tickers GOOG and GOOGL. In some older filing, GOOGL is used rather than GOOG. Searching by Google's CIK 1652044 results in all filings being returned, irrespective of the GOOG or GOOGL ticker.

{
    "query": "cik:1652044 AND formType:\"DEF 14A\" AND filedAt:[2016-01-01 TO 2016-12-31]",
    "from": "0",
    "size": "100",
    "sort": [{ "filedAt": { "order": "desc" } }]
}
mvg9999 commented 3 months ago

awesome, tysm!