Roaring Kitty stack — inventory & status report

9 community sheets inventoried, mapped, classified. Generated 2026-05-08.

Headline numbers

Sheets

Tabs

111

Formulas

226,065

Error cells

7,169

Rows of data

159,325

External URLs

URLs alive

URLs dead

Per-sheet roll-up

Sheet	Author / role	Tabs	Formulas	Errors	Effort	Detail
flowery_industry_screener	Copy of flowery's industry screener	9	1,263	4	low	→ analysis
flowery_metrics_fmp	Copy of flowerys metrics	10	22,809	43	?	→ analysis
kleven_market_tracker	Copy of Market Tracker	16	89,160	159	HIGH	→ analysis
kleven_metrics	Copy of Metrics	9	428	69	medium	→ analysis
marcus_fundamentals	Copy of Public release of my fundamentals sheet	10	1,826	211	medium	→ analysis
social_tracker	Copy of Social Stock Tracker v1.0	21	16,349	6,207	high	→ analysis
tbill_ladder_v21	Copy of T-Bill Ladder Builder 2.1 (Public)	10	4,174	27	low	→ analysis
tracker_v07d	Copy of Public Tracker - v0.7d	16	89,191	8	medium	→ analysis
universe_v07d	Copy of Public Universe - v0.7d	10	865	441	medium	→ analysis

Critical findings

⚠ Leaked credentials in shipped sheets

TD Ameritrade key L1TT29WF3BHSBMS3DOHASQ14ZCYD1HLQ hardcoded in social_tracker / Sheet19!N3 + 55 sibling cells. Endpoint dead since Schwab killed the API in 2024 — key worthless — but wipe before shipping the rehabbed sheet.
FMP API key 76194d00cde20e858167dfb370efc6eb (the one Flowery pasted in Discord) is hardcoded into flowery_metrics_fmp / ratiosTTM!B1. The key still returns HTTP 200 — don't ship as-is or community traffic will burn Flowery's account.

⚠ The Yahoo single-point-of-failure

Tracker v0.7d and Kleven Market Tracker (the two largest sheets, 178K formulas combined) both depend on a single dead URL: query1.finance.yahoo.com/v10/finance/quoteSummary/ defined in admin!AQ3. Yahoo crawler-locked this endpoint in mid-2023.

Replacing the Python writer that feeds those two cells heals ~124,000 formulas across both sheets.

✓ The replacement story is clean

secfsdstools (Apache-2.0, 82★, last commit 2026-04-14) gives us BalanceSheet / IncomeStatement / CashFlow standardizers from SEC's own quarterly Financial Statement Data Sets. Local SQLite cache, no API rate limits per query. Every dead Yahoo quoteSummary field and dead FMP key-metrics-ttm ratio maps to an equivalent secfsdstools field.

Treasury fiscaldata API probed live (T-Bills 3.696%, T-Notes 3.230% on 2026-04-30) — clean replacement for every dead Treasury IMPORTHTML. FRED, OpenInsider, Reddit JSON all probed alive. Nothing on the data layer requires a paid third-party API.

Top external data sources by usage

URL	Refs	Sheets	Status
https://stockcharts.com/h-sc/ui?s=	32,204	2	✓ 200
http://openinsider.com/search?q=	14,528	2	✓ 200
https://financialmodelingprep.com/api/v3/key-metrics-ttm/	11,409	1	✗ 401
https://financialmodelingprep.com/api/v3/ratios-ttm/	11,348	1	✗ 401
https://seekingalpha.com/symbol/	1,242	2	✓ 200
https://whalewisdom.com/stock/	1,240	2	✓ 200
https://www.sec.gov/edgar/search/?r=el#/entityName=	1,220	2	✓ 200
https://www.google.com/search?q=	1,220	2	✓ 200
https://finance.yahoo.com/quote/	1,220	2	✗ 500
https://finviz.com/quote.ashx?t=	512	1	✓ 200
https://api.tdameritrade.com/v1/instruments?apikey=L1TT29WF3BHSBMS3DOHASQ14ZCYD1HLQ&symbol	56	1	✗ ERR
https://api.quickfs.net/stocks/	22	1	✗ ERR

→ All 61 URLs with full probe results

Outstanding questions surfaced by analysts

Per-user copy vs single shared community sheet? Affects whether IMPORTRANGE chains stay or get flattened.
Twitter feed in Social Tracker — pay X-API / Nitter, or drop the column?
Manual submit ticker form stay alive, or VPS auto-populates from SEC tickers?
Morningstar taxonomy in industry screener — drop (no clean free source) or backfill from FMP/Finnhub?
Fundamentals consolidation — keep Social Tracker's Sheet19 fundamentals workspace, or punt all fundamentals to Marcus?