The Third Level of the Test in Color Coordination
I have memorized the contents of "Color Harmony (色彩調和)" by today.
Trying Japanese Stocks Analysis
I read "Python for Finance" and I got motivated for stocks analysis. I tried it before, but I lost my motivation in the middle of collecting the data.
I got 1d histrical data from "Yahoo! Finance VIP club" by Yahoo! JAPAN. When I checked Nintendo's stock price in the data, it didn't seem to reflect any adjustments sucn as stock splits. I've created before a scraping tool that acquires information such as division and merging, so I will try using it.
I targeted stocks included in TOPIX500 now. I got CSV file listing them from JPX site.
I got the XBRL files from EDINET. It does not support downloading by specifying a security code, so get daily JSON data and use the docID listed in it to get the XBRL file. I downloaded only the XBRL files of TOPIX500 stocks annual securities reports and quarterly reports. I used to use a external service that allowed me to download an XBRL file by specifying a stock code, but it has been discontinued.
There seem to be various libraries for parsing XBRL, but I decided to parse it as XML/HTML with lxml. I wanted to manage the ZIP files without expanding it, so I read only the necessary files into memory and parsed them. ZIP files for each document are inconvenient, so I'm thinking of saving the information for each stock in JSON and generating a CSV file from there for each purpose.