BasicsGetting StartedHow to use MarketXLSInformativePlans, Pricing & PurchasingStock investmentsStocksTechnical analysisTechnical QueriesTradierUsing MarketXLS

Buy Stocks Straight From Your Excel Sheet Using MarketXLS!

Written by Param Shah
Sun Feb 06 2022
Buy Stocks Straight From Your Excel Sheet Using MarketXLS!
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Buy Stocks Straight From Your Excel Sheet Using MarketXLS!
 

MarketXLS provides the data of over 13,574 stocks, 3,119 ETF’s, 26,802 Mutual Funds, and over 9,600 unique cryptocurrency combinations straight to your Excel.

But We Haven’t Stopped,

MarketXLS Now Enables you To Buy Stocks Straight From Your Excel!

We thought that our customers should have the option to execute the trade from the excel sheet itself, where they use Marketxls to do all their stock market research and other financial research to arrive at a conclusion.
For this very reason, we are thrilled to announce that we have partnered with Tradier, to enable you to do exactly that.

Starting now, our users will be able to execute orders from your excel sheet itself!

So What Is Tradier?

Tradier is a broking software that enables easy stock market integration into various apps and services. It is changing the way brokerage services are delivered. Tradier is a technology-focused cloud provider that offers a wide range of services related to the stock market.
Tradier platform lets self-directed investors choose their own end-to-end trading experience, while at the same time, MarketXLS offers the flexibility of customizing your portfolios in Excel. As a result, investors can get an integrated investing and trading experience straight in their Excel.

How Do I Get Started?

Tradier add on enables two modes
Single Leg Tradier
Multi Leg Tradier

Both the modes are more or less the same with a couple of minor differences.

The Single-leg tradier mode as the name suggests allows you to place an order for a single stock/option (leg) at a time.

It also supports multiple arguments such as –
Trade type,Symbol,Quantity,OrderSide,OrderType,Duration,Symbol Option,Price,Trigger Price

The Multi-leg tradier mode on the other hand allows simultaneous execution of multiple stocks/options(legs) at a time seamlessly.
It supports multiple arguments like – order type, duration, price, order side, and multiple symbols at a time.

Let’s Dive Into The Steps To Use These Modes-

1. Single Leg Tradier –

Step 1 – go into a cell and type =TradeSingleLegTradier()
Step 2 – click the insert function button to the left of the formula bar
Step 3 – enter the arguments in the dialogue box
You can enter the following arguments –
Trade type,Symbol,Quantity,OrderSide,OrderType,Duration,Symbol Option,Price,Trigger Price

Buy Stocks From Excel
Step 4 – Press ok and you will see a link has been generated.

Image explaining tradier and marketxls
Step 5 – Click on that link which will redirect you to the tradier page
Step 6 – You can see that all your order details are prefilled, you can click preview to view the final order

Buy Stocks From Excel
Step 7 – Click submit to place the order.

You can click on this link to see a live explanation on Tradier – https://youtu.be/7SURtsxR7So

2. Multi Leg Tradier –

Step 1 – go into a cell and type =TradeMultiLegTradier()
Step 2 – click the insert function button to the left of the formula barBuy Stocks From Excel
Step 3 – enter the arguments in the dialogue box
You can enter the following arguments –
Order type, Duration, Price, Order side, and Multiple option symbols at a time.
Hints for each of the arguments will be displayed towards the bottom of the dialogue box.
(You can also select a single symbol if you so wish)

Buy Stocks From Excel

Step 4 – Press ok and you will see a link has been generated.

Buy Stocks From Excel
Step 5 – Click on that link which will redirect you to the tradier page
Step 6 – You can see that all your order details are prefilled, you can click preview to view the final order
Step 7 – Click submit to place the order.

You can click on this link to see a live explanation on Tradier – I want to watch!

To Summarise –

You can now easily execute a trade or multiple trades from your excel sheet itself using the tradier add-on provided by MarketXLS.
The Tradier add-on is available to all MarketXLS customers as a $10/month add-on to the existing plan. The $ 10-month add-on allows unlimited options trading via Tradier every month.

Visit Our Website To Get Started – https://marketxls.com/pricing
Happy Trading!

 

 

 

 

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

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
Search for a stock

Top MarketXLS Rank stocks

Cowen Inc. logo

Cowen Inc.

30.93
 
USD
 
6.89
 
(28.66%)
83
Rank
Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
21.35   
   41.05
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.12
 
USD
 
-2.72
 
(-2.93%)
82
Rank
Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
69.32   
   93.45
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.41
 
USD
 
-0.14
 
(-0.27%)
81
Rank
Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Amdocs Limited logo

Amdocs Limited

83.04
 
USD
 
-1.41
 
(-1.67%)
80
Rank
Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
67.36   
   87.76
NBT Bancorp Inc. logo

NBT Bancorp Inc.

38.30
 
USD
 
0.14
 
(0.37%)
79
Rank
Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
31.68   
   41.70
CRA InternationalInc. logo

CRA InternationalInc.

89.64
 
USD
 
0.49
 
(0.55%)
79
Rank
Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
78.05   
   115.47
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

10.23
 
USD
 
0.01
 
(0.10%)
78
Rank
Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
7.05   
   12.39
America's Car-Mart Inc. logo

America's Car-Mart Inc.

107.19
 
USD
 
5.55
 
(5.46%)
77
Rank
Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
72.50   
   165.50
ManTech International Corporation logo

ManTech International Corporation

95.66
 
USD
 
0.26
 
(0.27%)
76
Rank
Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
66.09   
   95.87
CACI International Inc. Class A logo

CACI International Inc. Class A

279.18
 
USD
 
-8.01
 
(-2.79%)
76
Rank
Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    
238.29   
   313.52

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!