Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Basics

MarketXLS & Interactive Brokers Integration Walkthrough

Written by Meesha Ghedia
Tue Sep 14 2021
interactive brokers
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
interactive brokers
 

Introduction

Interactive Brokers LLC operates the largest electronic trading platform by the number of daily average revenue trades in the U.S. It brokers and connects to any electronic exchange globally that enables investors to trade stocks, options, futures, EFPs, futures options, forex, bonds, and funds. It is well known for its wealth of tools for sophisticated investors who are interested in tracking global investing trends. 

Interactive brokers mainly cater to institutional investors and sophisticated, active traders around the globe. They provide a wide range of offerings and stay on top of changes in market conditions to achieve optimal execution. 

The Interactive Broker Trade Station

Everything about Interactive Brokers centers around Traders Workstation (TWS). TWS is a powerful and extensively customizable downloadable platform. It provides solid fundamental research and the charts are very good with a suite of indicators. 

Once you get into TWS, Interactive Brokers’ trading experience stands out among all brokers. It lets you set order defaults for every possible asset class, as well as define hotkeys for rapid order transmission. Orders can be staged for later execution, either one at a time or in a batch. You can set a date and time There are practically unlimited ways an order can be entered.

Interactive Broker Walkthrough (For MarketXLS Users)

MarketXLS now supports integration with major brokers in the market including Interactive Brokers. Here is how you can integrate MarketXLS with Interactive brokers:

(Steps 1-3 are only necessary if the customer is not already running TWS)

  1. Make sure Interactive Brokers Trader Workstation is fully installed (not web-based version)
    https://www.interactivebrokers.com/en/index.php?f=16042  

interactive brokers

2. Also install TWS API
https://interactivebrokers.github.io/downloads/TWS%20API%20Install%20976.01.msi
When you’ll install TWS API, please open the TWS application and go to Global Configuration -> API -> Settings

Interactive brokers

Make sure ActiveX and Socket Clients checkbox is enabled. Socket port should be 7496

Click OK

 

3. Open Interactive Brokers TWS and keep it running.


4. Open Excel and start using MarketXLS. Functions are pre-loaded. You can find the full list of Interactive Broker functions here.

5. Or type =ib in a cell and the functions list will load.

Interactive brokers

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

42.74
 
USD
 
1.08
 
(2.59%)
85
Rank
Optionable: Yes
Market Cap: 451 M
Industry: Capital Markets
52 week range    
28.41   
   50.14
Midland States Bancorp Inc. logo

Midland States Bancorp Inc.

27.57
 
USD
 
0.66
 
(2.45%)
83
Rank
Optionable: No
Market Cap: 589 M
Industry: Banks - Regional - US
52 week range    
23.48   
   30.60
Kroger Company (The) logo

Kroger Company (The)

48.41
 
USD
 
-0.78
 
(-1.59%)
83
Rank
Optionable: Yes
Market Cap: 35,325 M
Industry: Grocery Stores
52 week range    
41.82   
   62.78
Ingles Markets Incorporated Class A Common Stock logo

Ingles Markets Incorporated Class A Common Stock

100.76
 
USD
 
-0.34
 
(-0.34%)
83
Rank
Optionable: Yes
Market Cap: 1,910 M
Industry: Grocery Stores
52 week range    
74.63   
   102.88
Amdocs Limited logo

Amdocs Limited

89.99
 
USD
 
1.13
 
(1.27%)
82
Rank
Optionable: Yes
Market Cap: 10,525 M
Industry: Software - Infrastructure
52 week range    
69.79   
   90.77
Tecnoglass Inc. logo

Tecnoglass Inc.

30.37
 
USD
 
1.37
 
(4.72%)
81
Rank
Optionable: Yes
Market Cap: 1,349 M
Industry: Building Materials
52 week range    
16.05   
   34.08
Interpublic Group of Companies Inc. (The) logo

Interpublic Group of Companies Inc. (The)

34.46
 
USD
 
0.10
 
(0.29%)
81
Rank
Optionable: Yes
Market Cap: 13,330 M
Industry: Advertising Agencies
52 week range    
25.14   
   39.98
Guess? Inc. logo

Guess? Inc.

20.71
 
USD
 
-0.05
 
(-0.24%)
81
Rank
Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
14.27   
   25.27
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

80.88
 
USD
 
0.60
 
(0.75%)
81
Rank
Optionable: Yes
Market Cap: 168,030 M
Industry: Drug Manufacturers - Major
52 week range    
55.76   
   81.44
Best Buy Co. Inc. logo

Best Buy Co. Inc.

86.47
 
USD
 
1.17
 
(1.37%)
81
Rank
Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    
60.79   
   112.96

More Features