How to Connect Your Interactive Brokers Account to Google Sheets

Manage your Interactive Brokers portfolio like a pro! With SheetsFinance for Google Sheets, you can connect your Interactive Brokers (IBKR) account directly to Google Sheets and access all your up-to-date brokerage data with simple formulas. No more manual exports or clunky third-party tools—just your IBKR data flowing seamlessly into your spreadsheets for custom analysis, tracking, and reporting.

Interactive Brokers is one of the most popular brokers for active traders and international investors. Now you can combine IBKR's powerful trading platform with Google Sheets' collaborative features to build sophisticated portfolio tracking, risk analysis, and performance monitoring systems that you can share with advisors or investment partners.

What we'll cover

1. What data you can access from your Interactive Brokers account
2. Step-by-step guide to connecting IBKR to Google Sheets
3. How to use the SF_BROKERAGE() function to pull your data
4. Example use cases and formulas
5. Privacy and security information

📊 What Interactive Brokers Data Can You Access?

Once connected, SheetsFinance allows you to pull the following data from your Interactive Brokers account directly into Google Sheets:

• Holdings - Current positions across all asset classes (stocks, options, futures, forex, bonds, etc.) including quantity, cost basis, current value, and P&L
• Orders - Recent orders and their status (filled, pending, cancelled, partially filled)
• Balances - Account balances across all currencies, buying power, margin requirements, and net liquidation value
• Options Positions - Detailed options data including strike, expiration, delta, gamma, theta, vega, and P&L

Interactive Brokers supports multiple asset classes and global markets, so all your positions—whether US stocks, European equities, Asian markets, or derivatives—are accessible through SheetsFinance.

🔐 How to Connect Your Interactive Brokers Account to Google Sheets

Prerequisites

Before you begin, make sure you have:

• A SheetsFinance account with an active brokerage subscription
• SheetsFinance installed in Google Sheets (installation guide)
• Your Interactive Brokers account login credentials

💡 Free Trial: New users get a 15-day free trial of the brokerage features, no payment details required!

Step 1: Purchase or Start Your Brokerage Trial

1. Visit the SheetsFinance Pricing Page
2. Select a brokerage plan or start your free trial
3. Complete the checkout process

Step 2: Connect Interactive Brokers on the SheetsFinance Website

1. Log into your SheetsFinance Account Dashboard
2. Navigate to the Brokerage tab
3. Click Connect under "Create New Connection"
4. Search for and select Interactive Brokers from the list of brokers
5. You'll be redirected to Interactive Brokers' secure login page
6. Enter your IBKR username and password
7. Authorise SheetsFinance and our brokerage connections provider SnapTrade to access your account data (read-only)
8. Complete any security device authentication if required

📝 Note: If you have multiple IBKR accounts (e.g., individual account, IRA, margin account), you may be prompted to select which account(s) to connect.

Once connected, you'll see your Interactive Brokers account listed in your Connected Brokerage Accounts section.

Step 3: Set a Nickname for Your Interactive Brokers Account

An account nickname is a custom label you assign to your Interactive Brokers account connection. This nickname is used in Google Sheets formulas to reference your account when pulling data.

SheetsFinance will set a default nickname based on the institution name, in this case, "interactive_brokers". If you have multiple Interactive Brokers accounts then the default nicknames will begin with the institution name, in this case "interactive_brokers", and end with a unique identifier (e.g., "interactive_brokers_1234"). You can keep the default nicknames or customise them to something more descriptive. This does not affect the connection in any way, it's just a label for your reference in Google Sheets.

💡 Tip: If you have multiple Interactive Brokers accounts, use descriptive nicknames like "ibkr_individual" and "ibkr_ira" to keep them organised.

Customise your account nicknames on our website:

1. In the Brokerage tab of your account dashboard, find your Interactive Brokers connection
2. Click Edit Nickname
3. Enter a custom nickname (e.g., "ibkr", "ibkr_main", "ibkr_ira", etc.)
4. Click Save

Customise your account nicknames in Google Sheets:

1. Open Google Sheets
2. Go to Extensions > SheetsFinance > Brokerage
3. The Brokerage sidebar will open showing your connected accounts
4. Click the pencil icon next to your Interactive Brokers account
5. Enter a custom nickname and click Save

Step 4: Enable Brokerage in Your Google Sheet

Due to the sensitive nature of brokerage data, you need to explicitly enable brokerage for each Google Sheet where you want to use it:

1. Open the Google Sheet where you want to access your IBKR data
2. Go to Extensions > SheetsFinance > Brokerage
3. The Brokerage sidebar will open
4. Check the box "Enable Brokerage for this document"
5. You should now see your Interactive Brokers account listed

🔒 Security Note: Brokerage must be enabled individually for each sheet. This prevents accidental data exposure if you share sheets with others.

📈 Using the SF_BROKERAGE() Function

Now that your Interactive Brokers account is connected and brokerage is enabled in your Google Sheet, you can start pulling data into Google Sheets using the SF_BROKERAGE() function.

📚 Jump to the docs: For all the detail on how to use the SF_BROKERAGE() function head to our docs

⏰ End-of-day Only: Our Interactive Brokers integration is currently end-of-day only, meaning that the data will update once per day after the market close.

Basic Syntax

=SF_BROKERAGE(account_nickname, type, [metrics], [start_date], [end_date], [transaction_types])

Example 1: Get Your Current Holdings

To pull all your Interactive Brokers holdings/portfolio positions across all supported asset classes (except options), use the "holdings" type:

=SF_BROKERAGE("interactive_brokers", "holdings")

This returns a table with all your positions including:

• Symbol/Contract
• Asset class (Stock, Option, Future, Forex, etc.)
• Units
• Average cost
• Current price
• Market value
• Unrealized P&L
• Currency
• Exchange
• And more!

🤔 Where are my options positions? These are handled separately under the "optionsPositions" type, keep reading to learn more.

Example 2: Get Specific Holding Metrics

As with all SF functions, you can use the & operator to chain together multiple metrics. This allows you to filter down to exactly that data you're after. For example, to show only symbol, units, and market value you can do the following:

=SF_BROKERAGE("interactive_brokers", "holdings", "symbol&units&marketValue&unrealizedPL")

Example 3: Check Your Account Balances

You can pull in your account balances including cash and buying power with the "balances" type:

=SF_BROKERAGE("interactive_brokers", "balances")

This shows your:

• Cash balances (per currency)
• Buying power

Example 4: View Recent Orders

The "orders" type allows you to see your recent orders and their status:

=SF_BROKERAGE("interactive_brokers", "orders")

See your order history including:

• Order type (market, limit, stop, etc.)
• Status (filled, pending, cancelled, etc.)
• Fill price and quantity
• Timestamps
• And more!

Example 5: View Options Positions

Last but not least, you can also access your options positions with the "optionsPositions" type. This is separate from the regular holdings data as options have unique attributes that need to be handled differently. To pull your options positions, use the following formula:

=SF_BROKERAGE("interactive_brokers", "optionsPositions")

This returns detailed options data including:

• Underlying symbol
• Option type (call/put)
• Strike price
• Expiration date
• P&L metrics
• And more!

💡 Practical Use Cases

1. Multi-Currency Portfolio Dashboard

Interactive Brokers supports trading in multiple currencies. Create a dashboard showing:

• Total portfolio value in base currency
• Holdings grouped by currency
• FX exposure analysis
• Currency-adjusted P&L

Use SheetsFinance data for real-time currency conversions and additional market data.

2. Global Asset Allocation

Track your positions across global markets:

• US equities
• European stocks
• Asian markets
• Emerging markets
• Fixed income
• Commodities
• Forex positions

Visualize allocation with Google Sheets' pie charts and geographic maps.

3. Collaborative Portfolio Management

Share your Google Sheet with:

• Investment partners
• Financial advisors
• Tax professionals
• Family office members

Google Sheets' real-time collaboration features allow multiple people to view and analyze your IBKR data simultaneously.

🔒 Privacy & Security

We take the security and privacy of your Interactive Brokers data very seriously. There are two classes of data associated with your brokerage connection:

1. Brokerage Data: This is the data that is pulled in from your brokerage account(s) into Google Sheets and/or Excel.
2. Brokerage Credentials: Randomised tokens that are used to authenticate your brokerage account(s) with SheetsFinance.

SheetsFinance does the following to ensure the security of your data:

1. User data belongs to the user: Your Interactive Brokers brokerage data is your own, we do not touch it without your explicit permission. Only you have access to your brokerage data.
2. No Long-term Brokerage Data Storage: We do not store any of your Interactive Brokers brokerage data in databases on our servers. The only storage medium is temporary caching in-memory whilst actively using the data in Google Sheets and/or Excel, this is to ensure best performance.
3. Encrypted Brokerage Credentials: Your Interactive Brokers brokerage credentials are encrypted, stored securely and regularly rotated. Your brokerage credentials are only valid for the server-to-server connection between SheetsFinance and brokerage providers and are useless outside of this context.
4. Complete Disconnection: If you remove a brokerage connection or your entire brokerage subscription, all brokerage credentials become invalid for future use. Entirely new credentials are generated if you reconnect your Interactive Brokers brokerage account(s).
5. Read-Only Access: SheetsFinance has read-only access to your Interactive Brokers brokerage data. We do not have the ability to execute trades or make any changes to your Interactive Brokers brokerage account(s).

📚 Additional Resources

• Brokerage Documentation - Complete guide to brokerage connections
• SF_BROKERAGE Function Reference - Detailed function documentation
• Supported Brokers - Full list of supported brokerage firms
• Google Sheets Installation Guide - How to install SheetsFinance

🎯 Get Started Today

Ready to connect your Interactive Brokers account to Google Sheets?

1. Sign up for SheetsFinance (15-day free trial)
2. Start your brokerage trial
3. Connect your Interactive Brokers account
4. Start analyzing your global portfolio in Google Sheets!

Interactive Brokers users deserve sophisticated analytical tools. SheetsFinance brings your IBKR data into Google Sheets where you can build the custom analysis and monitoring systems you need, with the added benefit of SheetsFinance data and Google Sheets' powerful features.

If you have any questions or need assistance, our support team is here to help.

Happy trading! 🌍📊