宏观经济仪表板

WHENWhen storing API credentials on filesystem

ACTIONset file permissions to 0o600 to restrict access to owner only

CONSEQUENCEWorld-readable credentials files expose API keys to unauthorized users, enabling data theft or quota abuse on external services

WHENWhen calculating technical indicators from OHLCV data

ACTIONVerify OHLCV DataFrame contains required columns (open, high, low, close, volume)

CONSEQUENCEMissing required OHLCV columns causes ValueError and prevents technical indicator calculation for affected tickers

WHENWhen implementing SMA crossover detection (golden/death cross)

ACTIONUse shift(1) to compare current bar state with prior bar state for transition detection

CONSEQUENCEWithout shift(1), crossover detection uses current bar data causing look-ahead bias where signals appear to fire at the same bar as the cross occurs