← Back

Stock Database

Manage the stock data used for backtesting.

Current Status

Loading...

Refresh Stocks

Updates screener data for all stocks, then enriches detailed metrics (ratios, key metrics, income statements, quotes) starting from where the last run left off. Each run processes as many stocks as possible within a 4-minute window.

Refresh All chains runs automatically until every stock is enriched. Run 1 Batch processes a single batch (~200 stocks) and stops.

Historical Prices

Fetches 20 years of monthly price data from Yahoo Finance for all stocks and computes annual returns used for backtesting charts and performance metrics. Also populates the S&P 500 (SPY) benchmark. No API key required.

Purge Non-Companies

Removes mutual funds, indexes, ETFs, SPACs, trusts, preferred securities, and other non-operating-company entries from the database.

Advanced: Full Database Reset

Full Database Reset

Drops and recreates the stocks table from scratch. Only enriches the top ~200 stocks by market cap in a single run. All existing enrichment is lost. Only use for initial setup or if the database is corrupted.