BasicsInformativeOthersStocks
MarketXLS & ThinkorSwim Integration Walkthrough
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.
Think or Swim Walkthrough (For MarketXLS Users)
MarketXLS now supports integration with major brokers in the market including ThinkorSwim. Here is how you can integrate MarketXLS with ThinkorSwim:
(Steps 1-2 are only necessary if the customer is not already running TOS)
- Make sure the Think or Swim platform is fully installed (not a web-based version)
https://www.tdameritrade.com/tools-and-platforms/thinkorswim/desktop/download.html
- Open the Think or Swim platform and keep it running.
- Open Excel and start using MarketXLS. Functions are pre-loaded. You can find the full list of Think or Swim functions here.
- Type =tos in a cell and the functions list will load
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Stock screens
Public saved screens
Top 100 Gainers Today
Top 100 losers Today
Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Call: 1-877-778-8358
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
Get started today
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todayTop MarketXLS Rank stocks
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.
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)
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
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
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.
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)
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.
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
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.
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
