Repository files navigation

Automated trading bot for executing earnings calendar spread strategies using options in a workflow automation. Integrates with Google Sheets for trade tracking and Alpaca for order execution.

• Automated Earnings Calendar Spread Trading: Opens and closes calendar spreads around earnings events based on strict screening criteria.
• Kelly Criterion Position Sizing: Uses a 10% Kelly fraction for optimal, risk-managed position sizing.
• Google Sheets Integration: Tracks trades and workflow status in a Google Sheet via Apps Script.
• Alpaca API Integration: Places and closes trades automatically using Alpaca brokerage API.
• Configurable and Extensible: Modular codebase for easy strategy tweaks and integration.

We implement an earnings volatility selling strategy focusing on calendar spreads around earnings events:

• Rationale: Implied volatility spikes ahead of earnings due to hedgers and speculators, creating an opportunity to profit from IV crush and muted stock moves.
• Trade Structure: At-the-money calendar spreads with a 30-day expiration gap for stability, offering controlled risk compared to straddles.
• Screening Criteria: Filter for high-probability trades using:
  • Term Structure Slope: Negative slope between front-month and 45-day expirations (backwardation).
  • 30-Day Average Volume: Ensures sufficient liquidity and price-insensitive demand.
  • IV/RV Ratio: High implied-to-realized volatility ratio indicates overpriced options.
• Position Sizing: Apply a 10% Kelly fraction for optimal, risk-managed sizing.

git clone https://github.com/yourusername/earnings-calendar-spread-bot.gitcd earnings-calendar-spread-bot

Create a copy ofhttps://docs.google.com/spreadsheets/d/1qOu4PJtcpYwLZgFFIpVr8FXD12dXoWZaKxSeg9FR7lU/ and add code.gs to App Script

Create a.env file in the root directory with your credentials:

APCA_API_KEY_ID=your-alpaca-keyAPCA_API_SECRET_KEY=your-alpaca-secretGOOGLE_SCRIPT_URL=your-google-apps-script-urlALPACA_PAPER=true  # Set to 'false' to use live trading (default is 'true' for paper trading)

pip install -r requirements.txt

Before running the bot for the first time (or to start fresh), delete the existing SQLite database file:

rm trades.db# Mac/Linuxdel trades.db# Windows (PowerShell)

python automation.py

• Fork the repository to your GitHub account (required to enable Actions).
• In your fork, navigate toSettings > Secrets > Actions and add your environment variables.
• Enable the GitHub Actions workflow in theActions tab.

• Screen for Earnings: Bot fetches tomorrow's earnings tickers.
• Screening & Sizing: For each ticker, applies IV/volume/slope criteria and calculates position size using Kelly.
• Open Trades: Places calendar spread trades at the correct time (BMO/AMC logic).
• Track & Close: Monitors open trades and closes them at the correct time, updating Google Sheets.

This software is provided solely for educational and research purposes. It is not intended to provide investment advice. The developers are not financial advisors and accept no responsibility for any financial decisions or losses resulting from the use of this software. Always consult a professional financial advisor before making any investment decisions.

Happy trading, and trade responsibly!