Mini Projects - Personal Stock Heatmap

like https://jp.tradingview.com/heatmap/stock/?color=Perf.1M&dataset=AllJP&group=sector&size=market_cap_basic

Components

Data Retriever

A CLI tool (in the initial impl) to fetch data from the data sources and build a local cache.

Dependencies

• yfinance ?

Investigations

• API access/libraries

  • https://github.com/pkout/yahoo_finance_api2

  • https://zenn.dev/sre_holdings/articles/a7fdfc20f9d7cd

  • yfinance - https://yfinance-python.org/

    • https://github.com/ranaroussi/yfinance

    • https://pypi.org/project/yfinance/

  • https://pydata.github.io/pandas-datareader/

• Local DB

  • https://www.sqlite.org/faq.html

  • DuckDB

• TOPIX listing master

  • https://www.jpx.co.jp/markets/statistics-equities/misc/01.html

• Learning / Similar Ideas

  • https://cojimaru-chan.hatenablog.com/entry/idx0007

References

• https://qiita.com/Octoparse_Japan/items/785cf24a6b7509c3428a