본문 바로가기

Data Science/Data Collection

[04. 금융감독원 API] 019. 상장기업 재무정보 – XBRL 택사노미 재무제표 양식

728x90

XBRL 택사노미 재무제표 양식은 금융감독원 회계포탈에서 제공하는 IFRS 기반 XBRL 재무제표 공시용 표준계정과목체계(계정과목)을 제공한다. 계정에 대한 설명이기 때문에 크게 사용될 것 같지는 않다.

 

[그림 4.19] XBRL택사노미재무제표양식 개발가이드

 

import json
import pandas as pd
import requests

def get_XBRL_taxonomy_format(api_key, sj):
    fullUrl = 'https://opendart.fss.or.kr/api/xbrlTaxonomy.json?crtfc_key=%s&sj_div=%s' % (api_key, sj)

    response = requests.get(fullUrl, headers={'User-Agent': 'Mozilla/5.0'})
    result = response.text
    result = json.loads(result)

    if result['status'] == '000':
        data = pd.DataFrame(result['list'])

        return data

if __name__ == '__main__':
    api_key = '*'
    sj = 'CIS1'

XBRL_taxonomy_format = get_XBRL_taxonomy_format(api_key, sj)
print(XBRL_taxonomy_format)


결과 값
                                           account_id  ... sj_div
0         ifrs_StatementOfComprehensiveIncomeAbstract  ...   CIS1
1                                     ifrs_ProfitLoss  ...   CIS1
2                       ifrs_OtherComprehensiveIncome  ...   CIS1
3   dart_OtherComprehensiveIncomeThatWillNotBeRecl...  ...   CIS1
4   ifrs_OtherComprehensiveIncomeNetOfTaxGainsLoss...  ...   CIS1
5   dart_OtherComprehensiveIncomeNetOfTaxGainsLoss...  ...   CIS1
6   dart_ShareOfOtherComprehensiveIncomeOfAssociat...  ...   CIS1
7   ifrs_OtherComprehensiveIncomeNetOfTaxGainsLoss...  ...   CIS1
8   dart_OtherComprehensiveIncomeThatWillBeReclass...  ...   CIS1
9   ifrs_GainsLossesOnExchangeDifferencesOnTransla...  ...   CIS1
10  ifrs_ReclassificationAdjustmentsOnExchangeDiff...  ...   CIS1
11  ifrs_GainsLossesOnRemeasuringAvailableforsaleF...  ...   CIS1
12  ifrs_ReclassificationAdjustmentsOnAvailablefor...  ...   CIS1
13  ifrs_GainsLossesOnFinancialAssetsMeasuredAtFai...  ...   CIS1
14  ifrs_ReclassificationAdjustmentsOnFinancialAss...  ...   CIS1
15  ifrs_AmountsRemovedFromEquityAndAdjustedAgains...  ...   CIS1
16           ifrs_GainsLossesOnCashFlowHedgesNetOfTax  ...   CIS1
17  ifrs_ReclassificationAdjustmentsOnCashFlowHedg...  ...   CIS1
18  ifrs_GainsLossesOnHedgesOfNetInvestmentsInFore...  ...   CIS1
19  ifrs_ReclassificationAdjustmentsOnHedgesOfNetI...  ...   CIS1
20  dart_ShareOfOtherComprehensiveIncomeOfAssociat...  ...   CIS1
21  ifrs_GainsLossesOnChangeInValueOfTimeValueOfOp...  ...   CIS1
22  ifrs_ReclassificationAdjustmentsOnChangeInValu...  ...   CIS1
23  ifrs_GainsLossesOnChangeInValueOfForwardElemen...  ...   CIS1
24  ifrs_ReclassificationAdjustmentsOnChangeInValu...  ...   CIS1
25  ifrs_GainsLossesOnChangeInValueOfForeignCurren...  ...   CIS1
26  ifrs_ReclassificationAdjustmentsOnChangeInValu...  ...   CIS1
27                           ifrs_ComprehensiveIncome  ...   CIS1
28     ifrs_ComprehensiveIncomeAttributableToAbstract  ...   CIS1
29  ifrs_ComprehensiveIncomeAttributableToOwnersOf...  ...   CIS1
30  ifrs_ComprehensiveIncomeAttributableToNoncontr...  ...   CIS1
728x90