时间戳

首页 > 解决方案 > 如何从财务报表数据集中提取合并的经营报表？

xbrl - 如何从财务报表数据集中提取合并的经营报表？

问题描述

所有财务报表数据集均由 SEC 在网页上公开发布：

财务报表数据集

下载数据集文件并使用以下 bash 命令提取数据：

fdata="https://www.sec.gov/files/dera/data/financial-statement-data-sets/2020q4.zip"
wget $fdata
unzip 2020q4.zip
cat  sub.txt | grep  0000320193  | grep  10-K
#get the adsh number for apple
0000320193-20-000096        320193  APPLE INC       3571    US      CA      CUPERTINO
cat  num.txt |sed -n  "1 p"  >  apple.txt
#grep 20200930 to get apple's 2019 financial statement
cat  num.txt |grep "0000320193-20-000096" |grep  "20200930" >> apple.txt

现在获取苹果 2019 年的财务报表。

head -n 10 apple.txt
adsh    tag version coreg   ddate   qtrs    uom value   footnote
0000320193-20-000096    NetIncomeLoss   us-gaap/2020        20200930    4USD    57411000000.0000    
0000320193-20-000096    NetIncomeLoss   us-gaap/2020        20200930    1USD    12673000000.0000    
0000320193-20-000096    PropertyPlantAndEquipmentNet    us-gaap/2020        20200930    0   USD 36766000000.0000    
0000320193-20-000096    PaymentsOfDividends us-gaap/2020        202009304   USD 14081000000.0000    
0000320193-20-000096    ProceedsFromSaleAndMaturityOfOtherInvestments   us-gaap/2020        20200930    4   USD 92000000.0000   
0000320193-20-000096    ProceedsFromPaymentsForOtherFinancingActivities us-gaap/2020        20200930    4   USD -126000000.0000 
0000320193-20-000096    OtherAccruedLiabilitiesNoncurrent   us-gaap/2020    20200930    0   USD 26320000000.0000    
0000320193-20-000096    OtherComprehensiveIncomeLossDerivativeExcludedComponentIncreaseDecreaseBeforeAdjustmentsAndTax  us-gaap/2020        20200930    4USD    -168000000.0000 
0000320193-20-000096    LongTermDebtMaturitiesRepaymentsOfPrincipalInYearTwo    us-gaap/2020        20200930    0   USD 9569000000.0000

如何从包含apple.txt财务报表的数据中提取合并的经营报表？

标签： xbrl

解决方案

推荐阅读