Over the years I have encountered the issue of mapping between CIK, company name and stock ticker. Below is a list of useful resources to help with this transcoding: https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=AAPL&count=100&output=xml Requires some additional data extraction https://www.sec.gov/Archives/edgar/cik-lookup-data.txt https://www.sec.gov/include/ticker.txt
Author Archives: Jason Mellone
A low memory, dataframe native accessor
I was recently running into memory issues (related to not closing a mutliprocessing.pool) and came up with the following piece of code while debugging: Although this was unrelated to my pool issue, it is a useful piece of code. What’s nice is that the __get__ behaves like a series or dataframe accessor with only instantaneous […]