I came across a situation in my project where, after 2024, there are drastic changes in the share values. We are displaying previous values in billions, but the data in the database is still stored in millions

toddwschneider / sec-13f-filings

A nicer way to view SEC 13F filings data

https://13f.info

MIT License

248 stars 52 forks source link

I came across a situation in my project where, after 2024, there are drastic changes in the share values. We are displaying previous values in billions, but the data in the database is still stored in millions #13

Open ChandraShekar-22 opened 2 months ago

ChandraShekar-22 commented 2 months ago

I came across a situation in my project where, after 2024, there are drastic changes in the share values. We are displaying previous values in billions, but the data in the database is still stored in millions

ChandraShekar-22 commented 2 months ago

toddwschneider commented 2 months ago

Hi @ChandraShekar-22, yes confirmed that at some point the SEC changed their spec to request values in dollars instead of thousands of dollars. My production site handles this change, but this repo currently does not. I will update the code in this repo when I have a chance, but the short version is:

filings from 2022 and earlier should assume raw values from the SEC website are in thousands
filings from 2023 and later should assume raw values from the SEC website are in dollars

There are plenty of errors though where some filers continued to report in thousands after 2023, so that's something to be aware of

ChandraShekar-22 commented 2 months ago

Thanks @toddwschneider . And I also noticed that for Form-D filing we don't have the latest code in the repo. it would be helpful if you update that also.