Hybrid Excel-Python Auto-Trading System

Замовник: AI | Опубліковано: 30.01.2026

looking for a developer to build a robust automated trading integration between Excel and my broker's API. The core requirement is a hybrid architecture: I want to maintain all my trading logic, strategy parameters, and position monitoring within Excel for ease of use, while utilizing Python as the engine to handle data execution and API communication. The primary challenge is concurrency and stability. To prevent Excel from freezing or crashing due to frequent formula recalculations and real-time data streaming, Python should act as a middleware. It will fetch market data, monitor the "Trigger" cells in Excel, and execute Buy/Sell orders asynchronously. The Excel sheet must act as a clean dashboard that displays live positions and sends execution signals without lag. Key Technical Requirements: Bi-directional Integration: Use a library like xlwings or similar to allow Python to read triggers and write position updates to Excel in real-time. Asynchronous Execution: Ensure that API calls and order executions happen in the background so the Excel UI remains responsive. Error Handling: Implement robust logging and a "heartbeat" check to ensure the connection between Excel and the broker is always active. Optimization: Logic should be structured to minimize Excel's calculation overhead, offloading heavy lifting to the Python script.