debug_stocks.py•2.37 kB
# debug_stocks.py - Debug stock data download issues
import yfinance as yf
import pandas as pd
import warnings
warnings.filterwarnings('ignore')
def test_single_stock(ticker):
"""Test downloading data for a single stock."""
print(f"\n🔍 Testing {ticker}...")
try:
# Try to download data
data = yf.download(ticker, period="1y", progress=False)
if data.empty:
print(f" ❌ No data returned for {ticker}")
return False
close = data['Close'].dropna()
print(f" ✅ Downloaded {len(close)} data points")
print(f" 📊 Price range: ${float(close.min()):.2f} - ${float(close.max()):.2f}")
print(f" 📅 Date range: {data.index[0].date()} to {data.index[-1].date()}")
# Test volatility calculation
returns = close.pct_change().dropna()
daily_vol = float(returns.std())
print(f" 📈 Daily volatility: {daily_vol:.1%}")
return True
except Exception as e:
print(f" ❌ Error: {e}")
return False
def main():
"""Test all stocks in lenny_golub portfolio."""
# Your portfolio stocks
lenny_golub_stocks = ['COIN', 'GBTC', 'HOOD', 'MSTR', 'PYPL']
print("🚀 DEBUGGING STOCK DATA DOWNLOAD")
print("=" * 50)
print(f"Testing {len(lenny_golub_stocks)} stocks from lenny_golub portfolio...")
successful = []
failed = []
for ticker in lenny_golub_stocks:
if test_single_stock(ticker):
successful.append(ticker)
else:
failed.append(ticker)
print(f"\n📊 SUMMARY:")
print(f" ✅ Successful: {len(successful)} stocks")
if successful:
print(f" {', '.join(successful)}")
print(f" ❌ Failed: {len(failed)} stocks")
if failed:
print(f" {', '.join(failed)}")
if failed:
print(f"\n💡 TROUBLESHOOTING:")
print(f" • Check internet connection")
print(f" • Try again in a few minutes (API rate limits)")
print(f" • Verify ticker symbols are correct")
# Test with a known working stock
print(f"\n🧪 Testing with AAPL (known working stock)...")
test_single_stock("AAPL")
return successful, failed
if __name__ == "__main__":
main()