u/CuriousNovel9162

I build a tool for analyzing all SEC Edgar concepts for all US public stocks, as well as, analyst ratings, news, and stock prices. I did this firstly for my own self because I wanted a way to easily plot and compare companies, like a quadrant plot.

I also brought all the data to a calendar monthly level so as to compare apples to apples since companies have different fiscal reporting periods, but I kept original values and added references to their filings.

I would really like advise and help with what other features would be useful, and I am hoping this is something others would find useful.

The tool is called Open Terminal, like and open source Bloomberg terminal, but laymans version. I called my company Tesseract Analytics because I like the idea of hyper cubes, and also the Avengers.

My discord to join beta group: https://discord.gg/nB2g4FmVP Live version: https://terminal.tesseractanalytics.ai

I am a data engineer by trade, but am interested in finance, stocks and investing. I used clickhouse to transform the data, and built Open Terminal in javascript, with python backend.

Open Terminal - I built a research tool for US stocks. Pulls financials for ~10k companies from SEC filings. You can chart any metric across companies, filter news by ticker, or write SQL directly against the database, which is the part I use most.

Backend is ClickHouse and DuckDB. Front end is python flask + gunicorn app. I used Cloudfront for static html and javascript caching now.

Posted it to HN a few weeks ago and the server died under traffic, so I've spent the time since fixing performance and the Firefox bugs.

Hosted version: https://terminal.tesseractanalytics.ai
Please give me feedback and whether this would be useful for you! Cheers - Alex