search

WhyDRS / Database

The WhyDRS database is a collection of data on transfer agents for public companies.
https://database.WhyDRS.org
Other
3 stars 1 forks source link

🐛 Fix "Update Google Sheet + Database with SEC Data" Workflow #24

Open JamesAlfonse opened 4 weeks ago

JamesAlfonse commented 4 weeks ago

About a week about this error started popping up when fetching SEC data. Not sure why it's happening now. Could it be that there's two entries with the same CIK and ticker? Should there be a third key established for issuer name to resolve this issue?

Screenshot 2024-10-25 at 12 38 21 AM

JamesAlfonse commented 2 weeks ago

Seems to have been caused by a duplicate entry. I deleted the duplicate entry from the Google sheet, but the .db file still has the two entries. MGR was listed twice, unsure why/how that happened. Last time this happened I had to download the file and manually delete the rows, then reupload the file. Would love to figure out a better way to resolve this in the future (maybe using bigquery solves this?).