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