In the previous article, I wrote about how to obtain financial statement information from XBRL format data obtained from the Financial Services Agency's EDINET site.
Get information on the financial statements of listed companies from XBRL.
After that, EDINET released a Web API called ** EDINET API **, and it became possible to automatically download XBRL files.
This time, I downloaded the XBRL files of all listed companies for the past 5 years and made a program to convert them to CSV files.
The CSV file of the processing result is below. http://lkzf.info/xbrl/data/summary-join.csv Financial results information is written for each line as shown below. The figures for the settlement of accounts are the values for the consolidated settlement of accounts.
I made a frequency distribution table of gross profit margin (gross profit margin) from a CSV file using spreadsheet software (LibreOffice Calc). I think there are many other ways to use it.
The source of the app is on the same GitHub as the previous article. https://github.com/teatime77/xbrl-reader
The processing contents are explained below. http://lkzf.info/xbrl/doc
I also made a web application that performs financial analysis using CSV file data. You can access the app from the following URL. http://lkzf.info/xbrl/chart/ We have confirmed the operation on Chrome and FireFox. I used Plotly.js to draw the graph. The source is on GitHub. https://github.com/teatime77/xbrl-chart
I just made an app, so I'm currently looking at Yahoo! Finance to see if the numbers match. In the future, I would like to organize the source and documents so that this source code can be used by many people.
If you make a mistake, please write it in the comment section or contact us on Twitter. We will also notify you of updates to the app on Twitter. teatime77
** Thank you for reading this far. ** **
Recommended Posts