Automated Stock Trading Journal with IG Labs API Integration
As a Google Apps Script developer specializing in stock trading automation, I craft bespoke solutions that streamline complex financial processes.
This portfolio showcases a robust Google Apps Script stock trading project developed for a client, designed to integrate seamlessly with the IG Labs API for advanced trading functionalities, real-time data management, and insightful reporting within Google Sheets.
The Client’s Challenge: Bridging Real-time Trading Data with Personal Analysis
Before engaging my services, my client, an active stock trader, faced a common yet critical challenge: effectively integrating live market data from their trading broker’s API (IG Labs) directly into their existing personal trading journal in Google Sheets. While dedicated trading platforms offer robust features, they often lack the personalized analytical flexibility and custom reporting capabilities that a bespoke spreadsheet-based journal provides.
The core problem was the manual, time-consuming, and error-prone process of acquiring real-time stock prices and other critical trading information. Relying solely on the broker’s web interface or external tools meant:
- No Live Data in Their Workflow: Data had to be manually copied or frequently checked on a separate platform, disrupting their analytical flow within Google Sheets. This made immediate, data-driven decisions difficult.
- Lack of Customization: Existing solutions didn’t allow them to pull precisely the data points they needed, formatted exactly how they preferred, for their unique analysis and strategy. Their desire was to input a stock ticker in one cell and have live buy and sell prices appear in designated cells, something generic tools couldn’t provide natively.
- Inefficient Order Management: The aspiration to execute trades directly from their customized sheet indicated a need to minimize switching between applications, reduce potential errors, and streamline the entire trading process from analysis to action.
The client specifically sought a Google Sheets solution for several compelling reasons:
- Existing Infrastructure & Familiarity: They already maintained their comprehensive trading journal in Google Sheets and were deeply familiar with its environment. The goal was to enhance this existing, comfortable workflow, not replace it.
- Cost-Effectiveness & Accessibility: As a free, web-based platform, Google Sheets combined with Google Apps Script offered a highly accessible and cost-effective alternative to expensive, complex, or restrictive dedicated trading software.
- Desire for Direct Control & Customization: The client understood that Google Apps Script (which is JavaScript-like) could provide the ultimate level of customization. This empowered them to design exactly how data was pulled, processed, and presented, giving them unparalleled control over their analytical environment and strategic insights.
Key Features & Functionalities of the Solution
This solution transforms Google Sheets into a powerful, automated trading journal
- Secure API Authentication & Session Management: The application provides a secure login and logout mechanism for the IG Labs API, handling identifiers, API keys, and session tokens to ensure authenticated and persistent access to trading data. A custom HTML service creates a secure dialog for password entry, enhancing user security.
(Please note: To protect client and data privacy, all data displayed in the accompanying screenshots are fake sample data and bear no connection to the real data of my client. All business names, addresses, email addresses, and website links are also fictional.)
- Comprehensive Watchlist Management: Users can efficiently manage their investment interests with a full suite of watchlist functionalities:
- Create Watchlists: Easily establish new watchlists by defining a name and adding specific market instruments (EPICs).
- Modify Watchlists: Append new EPICs to existing watchlists or trim unwanted ones, allowing for dynamic portfolio tracking.
- Delete Watchlists: Remove watchlists that are no longer needed.
- List & View Watchlists: Retrieve a comprehensive list of all created watchlists, displaying details such as name, ID, and editability.
- Detailed Market Data Display: Instantly view live market data for all instruments within a selected watchlist, including instrument name, type, expiry, current market status, bid/offer prices, percentage change, and last update times. This provides a real-time overview of critical market movements.
- Advanced Market Data Retrieval: Beyond watchlists, the script offers extensive capabilities for exploring market data:
- Market Navigation: Browse through market categories and sub-categories to discover new trading opportunities.
- Market Search: Quickly find specific market instruments using a search query.
- Detailed Instrument Information: Access in-depth data for any given market instrument (EPIC).
- Automated Positions Tracking: The solution provides automated tracking and management of trading positions:
- Real-time Position Updates: Prices for open positions are automatically updated every minute, ensuring the user always has the latest information at their fingertips.
- Position Management: View, update, and close open positions directly within the Google Sheet interface.
- Historical Positions: Access records of past trading positions for performance analysis.
- Streamlined Order Placement & Management: The application facilitates direct interaction with the IG Labs trading platform:
- Place Orders: Execute trading orders efficiently.
- Manage Working Orders: Create, list, and delete pending or working orders.
- Deal Confirmation: Receive immediate confirmation of executed trades.
- Comprehensive Account Overview:
- Account Details: Retrieve and display essential account information.
- Transaction History: Access a detailed history of all trading transactions.
- Intuitive Google Sheets Integration: All functionalities are seamlessly integrated within a user-friendly Google Sheet interface. Data is presented in an aesthetic and organized manner (some sheets were intentionally left simplistic white for experimental purposes), with interactive elements for input and clear display of retrieved information. The script utilizes Google Apps Script’s capabilities to enhance user experience with browser message boxes for important notifications.
Ready to take your Google Workspace to the next level?
Contact us today to discuss how a tailored web application can transform your business operations.