-
Notifications
You must be signed in to change notification settings - Fork 35
Open
Description
SEC-API provides financial statements in separate tables such as BalanceSheet
, StatementsOfIncome
and many others.
But looking at some of the companies/cik the xbrl_to_json
api is providing data from some other tables which does not belong to the Balancesheet
or the StatementsOfIncome
One such company is 0000764897
If we select only the RevenueFromContractWithCustomerExcludingAssessedTax
of the company in StatementsOfIncome
,
it gives some extra data which is not present in StatementsOfIncome
, rather in some other tables.
from sec_api import XbrlApi
xbrlApi = XbrlApi(api_key)
url = "https://www.sec.gov/Archives/edgar/data/0000764897/000156459021018959/brst-10k_20201231.htm"
json_statements = xbrlApi.xbrl_to_json(htm_url=url)
revenues = [rev for rev in json_statements['StatementsOfIncome']['RevenueFromContractWithCustomerExcludingAssessedTax']
if rev['period']['endDate'] == '2020-12-31']
print(revenues)
Output:
[{'decimals': '-3',
'unitRef': 'U_iso4217USD',
'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
'segment': {'dimension': 'srt:ProductOrServiceAxis',
'value': 'brst:CommissionsMember'},
'value': '2437000'},
{'decimals': '-3',
'unitRef': 'U_iso4217USD',
'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
'segment': {'dimension': 'srt:ProductOrServiceAxis',
'value': 'brst:ManagementAndOtherFeesMember'},
'value': '1358000'},
{'decimals': '-3',
'unitRef': 'U_iso4217USD',
'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
'segment': [{'dimension': 'srt:ProductOrServiceAxis',
'value': 'brst:LeasingCommissionsMember'},
{'dimension': 'us-gaap:AdjustmentsForNewAccountingPronouncementsAxis',
'value': 'us-gaap:AccountingStandardsUpdate201409Member'},
{'dimension': 'us-gaap:TimingOfTransferOfGoodOrServiceAxis',
'value': 'us-gaap:TransferredAtPointInTimeMember'}],
'value': '2313000'},
{'decimals': '-3',
'unitRef': 'U_iso4217USD',
'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
'segment': [{'dimension': 'srt:ProductOrServiceAxis',
'value': 'us-gaap:AssetManagement1Member'},
{'dimension': 'us-gaap:AdjustmentsForNewAccountingPronouncementsAxis',
'value': 'us-gaap:AccountingStandardsUpdate201409Member'},
{'dimension': 'us-gaap:TimingOfTransferOfGoodOrServiceAxis',
'value': 'us-gaap:TransferredOverTimeMember'}],
'value': '711000'},
.....
.....
.....
]
Extra data are fetched from the following tables,
Metadata
Metadata
Assignees
Labels
No labels