Connect ThinkorSwim With MarketXLS

MarketXLS and ThinkOrSwim by TD Ameritrade integration

Introduction

Thinkorswim is an electronic trading platform by TD Ameritrade used to trade financial assets. It is suited for self-directed stock, options, and futures traders. TD Ameritrade provides services for self-directed option traders and institutional users who invest in equities, exchange-traded funds, futures, mutual funds, and bonds.

It offers clients a choice of platforms aimed at different levels of expertise, including its basic website, mobile apps, and Thinkorswim, which is designed for derivatives-focused active traders. The platform can be customized to your exact specifications, with tabs allowing easy access to your most-used features.

ThinkorSwim Integration with MarketXLS

MarketXLS now supports integration with major brokers in the market including ThinkorSwim. Follow these steps to integrate:

Prerequisites

Steps 1-2 are only necessary if you don't already have ThinkorSwim running.
1

Install Think or Swim Desktop Platform

Make sure the Think or Swim platform is fully installed (not a web-based version). Download from:

https://www.tdameritrade.com/tools-and-platforms/thinkorswim/desktop/download.htm
TD Ameritrade Tools and Platforms - Think or Swim download page
2

Launch Think or Swim

Open the Think or Swim platform and keep it running in the background.

3

Open Excel with MarketXLS

Open Excel and start using MarketXLS. The ThinkorSwim functions are pre-loaded and ready to use.

4

Access TOS Functions

Type =tos in any Excel cell and the functions list will automatically appear, showing all available ThinkorSwim integration functions.

Integration Complete!

You can now access real-time market data from ThinkorSwim directly in your Excel spreadsheets. Use the =tos functions to pull live trading data.