ufo-> python

UfoCatch -> python

Try to access XBRL with reference to UfoCatch Usability wants to be closer to UfoCatch

http://tecaweb.net/archives/290/ufocatch_2_0_3

Acquisition source TDNET → Securities Report EDINET → Financial Statement / Corporate Governance Report (instance only?)

Get a list of reports on EDINET for a stock →UCXEdinetXBRLInstance(code)

Acquisition of financial information (sample sheet) →UCXEdinetXBRLInstanceLatestASR(code,close_date) Get the url of the securities report that matches the year period with the string contained in the url of xbrl →UCXFact(url,elementName,baseDate,[periodStart],[consolidated],[namespace])

Whether the element is a single year / consolidated value is judged by Consolidated .. of contextRef.

I didn't notice the details of xbrl when I read the book, so Focus on the annual securities report and check only the necessary parts each time. → Internet financial information system-using XML technology and XBRL data standards

2009-58th term-Securities Report of Hioki Electric Co., Ltd. (code: 6866) http://resource.ufocatch.com/xbrl/edinet/ED2010030100130/S0005ASQ/jpfr-asr-E01999-000-2009-12-31-01-2010-03-01.xbrl

xbrl securities report

-Root:<xbrli:xbrl>
-1:<link:.../>
-1:<xbrli:context id=..>..</xbrli:context>
-1:<xbrli:unit id=..>...</xbrli:unit>
-1:<jpfr-t-cte:.. unitRef=.. contextRef=.. ..>..</jpfr-t-cte>
-1:<link:footnoteLink ..>..</link:footnotelink>
-</xbrli:xbrl>

Check the making by referring to the following article http://www.primal-inc.com/column/2009/11/03-000045.php?page=1

For a list of elements, see UfoCatch Reference_Financial Statements, etc. Subject List Sheet Sales-> NetSales Shareholders' equity ratio-> shareholdersequity

This report alone uses 195 errors, but many are not on the UfoCatch list. It doesn't seem like a lot of work, so if necessary, I hope I can reverse the error.

finance(codelst,entrylst) -> DataFrame(columns=enrylst,index=codelist)

It's easy if you get the data from the annual report like

Postscript (6/19)

Since the data extraction did not go well, I left the contents of ufo-catch as it is

Get facts()...
  If (node.baseName <> "schemaRef" And _
    node.baseName <> "context" And _
    node.baseName <> "unit" And _
    node.baseName <> "footnoteLink") Then

Recommended Posts

ufo-> python (3)
ufo-> python
ufo-> python (2)
ufo-> python (4)
Python
kafka python
Python basics ⑤
python + lottery 6
Built-in python
Python comprehension
Python technique
Studying python
Python 2.7 Countdown
Python memorandum
Python FlowFishMaster
Python service
python function ①
Python basics
Python memo
Python comprehension
install python
Python Singleton
Python basics ④
Python Memorandum 2
python memo
Python Jinja2
Python increment
python tips
Installing Python 3.4.3.
Try python
Python memo
Python iterative
Python algorithm
[Python] Variables
Python functions
Python sys.intern ()
Python decimals
python underscore
Python summary
Start python
[Python] Sort
Note: Python
Python basics ③
Python basics
[Scraping] Python scraping
Python update (2.6-> 2.7)
Python memorandum
Python nslookup
python learning
Hannari Python 2020
[Rpmbuild] Python 3.7.3.
Prorate Python (1)
python memorandum
Download python
python memorandum
Python memo
started python
Python #JSON
python quiz
Python encoding
Python note