Trading212 Portfolio Manager

A comprehensive portfolio management application that integrates with Trading212 API and Yahoo Finance to provide real-time portfolio tracking, analysis, and screening capabilities.

Features

• Portfolio Tracking: Real-time portfolio value, profit/loss, and performance metrics
• Technical Analysis: RSI, SMA, Bollinger Bands, and other technical indicators
• Stock Screening: Advanced screening capabilities with customizable criteria
• Chart Visualization: Interactive charts for price and metric analysis
• Top Movers: Track top gainers and losers across different time periods
• Allocation Analysis: Sector and country allocation breakdowns
• Async Backend: High-performance async FastAPI backend
• Modern Frontend: React-based responsive web interface

Architecture

• Backend: FastAPI with async SQLAlchemy and PostgreSQL
• Frontend: React with modern UI components and charts
• Data Sources: Trading212 API, Yahoo Finance API
• Database: PostgreSQL with optimized queries and caching
• Background Tasks: Celery with Redis broker for scheduled data updates

Background Tasks (Celery)

The application uses Celery for periodic background data updates. Tasks are automatically scheduled via Celery Beat.

Scheduled Tasks

• update_data_task: Updates portfolio holdings, prices, currency rates, and technical indicators

  • Runs every 4 hours
  • Fetches fresh data from Trading212 API and Yahoo Finance

• calculate_portfolio_returns_task: Calculates Money-Weighted Rate of Return (MWRR) and Time-Weighted Rate of Return (TWRR)

  • Runs every 4 hours on weekdays and every 8 hours on weekends (staggered 5 minutes after update_data_task)
  • Uses incremental update_returns(rebuild=False) for fast daily updates

Running Celery

# Start Celery worker (task executor)
celery -A celery_tasks.celery_app worker --loglevel=info

# Start Celery beat (task scheduler)
celery -A celery_tasks.celery_app beat --loglevel=info

Database Migrations

The project uses Alembic for database migrations.

Creating a Migration

To create a new migration after modifying models.py:

alembic revision --autogenerate -m "Description of changes"

Applying Migrations

To apply pending migrations to the database:

alembic upgrade head

Reverting Migrations

To revert the last applied migration:

alembic downgrade -1

Running Scripts Manually

All scripts are located in the scripts/ directory. When running manually, you must set the PYTHONPATH environment variable to the project root:

# From the project root directory
PYTHONPATH=/home/debian/sites/portfolio_tracker python scripts/backfill_portfolio_daily.py
PYTHONPATH=/home/debian/sites/portfolio_tracker python scripts/update_data.py

Available Scripts:

• backfill_portfolio_daily.py: Backfill and calculate MWRR/TWRR metrics for historical dates
• update_returns.py: Fast incremental MWRR/TWRR updates (--rebuild for full historical recalculation)
• update_data.py: Update all database tables with fresh API data
• backfill_currency_rates.py: Backfill historical currency exchange rates
• update_history_from_csv.py: Import Trading212 CSV transaction exports
• update_pies.py: Update Trading212 Pies data
• scrape_macrotrends_pe.py: Scrape PE ratios from Macrotrends
• scrape_wisesheets_pe.py: Scrape PE ratios from Wisesheets
• populate_cik.py: Populate missing instrument CIK values from SEC ticker map
• scrape_13f.py: Scrape SEC 13F institutional holdings data
• get_earnings_reports.py: Fetch SEC filings (10-Q/10-K/20-F/40-F/6-K) and generate structured LLM summaries
• get_uk_earnings_reports.py: Fetch UK RNS earnings announcements from Investegate for .L tickers not routed via SEC, and generate the same structured LLM summaries
• ingest_earnings_pr.py: One-shot ingest of a single earnings-release PDF or HTML page as a temporary PR row, intended for same-day signal weeks before the canonical SEC filing lands; replaced by get_earnings_reports.py once the official filing arrives

Code Quality

This project maintains high code quality standards with comprehensive typing, documentation, and automated quality checks.

Quality Tools

# Code style and linting
pycodestyle --max-line-length 120 --exclude frontend/ .
flake8 --exclude frontend/ --max-line-length=120 .
pylint --max-line-length=120 backend/

# Code formatting
ruff format --line-length 120

# Type checking
mypy .
mypy . --check-untyped-def

# Import organization
isort .

Quality Standards

• 100% Type Coverage: All functions have comprehensive type annotations
• Complete Documentation: All functions have detailed docstrings
• Async Best Practices: Proper async/await patterns throughout
• Error Handling: Comprehensive error handling and logging
• Code Organization: Clean separation of concerns and modular design
• Performance: Optimized database queries and efficient data processing

Documentation Standards

• Module-level docstrings explaining purpose and functionality
• Function docstrings with Args, Returns, and Raises sections
• Inline comments for complex business logic
• Type hints for all parameters and return values