API Data Error #28
Description
Data Error 1
I'll just show what i bumped into, not sure how many similar ones actually exist.
Code Example
default code from https://simfin.readme.io/reference/statements-verbose-1
import requests
url = "https://backend.simfin.com/api/v3/companies/statements/verbose?id=1252817&statements=BS&period=Q1,Q2,Q3,Q4&start=2024-03-31&end=2024-03-31"
headers = {
"accept": "application/json",
"authorization": "undefined"
}
response = requests.get(url, headers=headers)
print(response.text)
Data Output
"Cash, Cash Equivalents & Short Term Investments": 846684542,
"Cash & Cash Equivalents": 54677000,
"Short Term Investments": 251018000,
Verified with one other source that "Cash, Cash Equivalents & Short Term Investments" math should come up as "Cash & Cash Equivalents" + "Short Term Investments" = 54677000 + 251018000 = 305695000. Unsure how simfin gets 846684542.
Data Error 2
Code Example
url = "https://backend.simfin.com/api/v3/companies/prices/compact?id=808943&start=2024-05-07&end=2024-05-10"
Data Output
Common Shares Outstanding in that date range comes up at: 62551.
Actual value should be: 62551281.
Data Error 3
Code Example
These appear to have changed ticker, which broke the price data. However the balance sheet data is still moving forward.
url = "https://backend.simfin.com/api/v3/companies/prices/compact?id=113247"
url = "https://backend.simfin.com/api/v3/companies/prices/compact?id=998412"
Data Output
113247 prices data stopped at 2024-01-09. Api ticker "ACRX". Actual ticker based on ISIN = "TLPH".
998412 prices data stopped at 2023-02-17. Api ticker = "ISR". Actual ticker based on ISIN = "CATX".
Data Error 4
Code Example
url = "https://backend.simfin.com/api/v3/companies/statements/verbose?id=13950756&statements=BS&period=Q1,Q2,Q3,Q4&start=2022-06-30"
url = "https://backend.simfin.com/api/v3/companies/statements/verbose?id=13511386&statements=BS&period=Q1,Q2,Q3,Q4&start=2023-10-31"
Data Output
13950756 data stops at 2022-06-30, even though newer data is available in the sec.gov link
13511386 data stops at 2023-10-31, even though newer data is available in the sec.gov link
Data Error 5
Code Example
url = "https://backend.simfin.com/api/v3/companies/statements/verbose?id=13511386&statements=BS&period=Q1,Q2,Q3,Q4&start=2023-10-31&end=2023-10-31"
Data Output
"Other Short Term Liabilities": 4069000
"Liabilities from Derivatives & Hedging (Short Term)": 4069000
"Total Current Liabilities": 5213318
"Total Noncurrent Liabilities": 11504000
"Total Liabilities": 20855223
"Preferred Equity": null
"Liquidation Preference": no field?
should be
"Other Short Term Liabilities": 4095271
"Liabilities from Derivatives & Hedging (Short Term)": 4095271
"Total Current Liabilities": 5239589
"Total Noncurrent Liabilities": 15573000
"Total Liabilities": 20812589
"Preferred Equity": 21297669
"Liquidation Preference": 32143761
Have not checked older data, so fix may need backtracked. Also more fields may be wrong that i didn't look into.
Data Error 6
Code Example
url = "https://backend.simfin.com/api/v3/companies/statements/verbose?id=13511290&statements=BS&period=Q1,Q2,Q3,Q4"
Data Output
Most (all?) report dates seem incorrect.
I.e
"Report Date": "2020-03-31",
"Publish Date": "2023-05-12",
should be
"Report Date": "2023-03-31",
"Publish Date": "2023-05-12",