NexusFi: Find Your Edge


Home Menu

 





Excel Trading for Traders and Brokers?


Discussion in Currencies

Updated
      Top Posters
    1. looks_one Daniel25 with 2 posts (0 thanks)
    2. looks_two Quick Summary with 1 posts (0 thanks)
    3. looks_3 Lornz with 1 posts (1 thanks)
    4. looks_4 sam028 with 1 posts (2 thanks)
    1. trending_up 5,182 views
    2. thumb_up 4 thanks given
    3. group 7 followers
    1. forum 6 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
Daniel25
Delhi, Delhi/India
 
Posts: 23 since Nov 2011
Thanks Given: 2
Thanks Received: 1

Some brokers and firms are using an Excel Trading Spreadsheet to enter orders and manage trades. Is it useful for both traders and brokers or only for broker?


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Ceasefire in Name Only: Three Numbers That Define the Ir …
Prediction Markets & Event Contracts
One Wallet Made $200K in Hours: AP Probes Polymarket Cea …
Prediction Markets & Event Contracts
Q1 2026 Shatters All Derivatives Volume Records -- CME H …
Traders Hideout
Asia Equities Crash Overnight -- Nikkei -5.2%, KOSPI -6. …
Traders Hideout
$500M Riding on World Cup 2026: France/Spain Co-Favored …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Lady Vols Primer: Trading Volatility Journal
7 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Trying to learn Volume and price action correlation
5 thanks
  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,114



Daniel25 View Post
Some brokers and firms are using an Excel Trading Spreadsheet to enter orders and manage trades. Is it useful for both traders and brokers or only for broker?

Excel sheets are used for manual order entry. It is certainly not useful for the broker, as manual entries have two disadvantages. They are error prone and labour intensive.

For a broker it is easier to let the customer directly enter the orders via the interface of a broker supplied software.

The only advantage that I see with using Excel sheet, is that it makes it easier to evaluate your trade performance. But then I would try to use an appropriate trading and charting software for trade execution and later export the trades to Excel for analysis.


Reply With Quote
  #4 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,756 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,632

Check the Interactive Brokers API, they have an Excel worksheet full of macros where you can do everything.
More details here.


Success requires no deodorant! (Sun Tzu)
Follow me on X Reply With Quote
Thanked by:
  #5 (permalink)
 
Lornz's Avatar
 Lornz 
Oslo, Norway
 
Experience: Advanced
Platform: CQG, Excel
Trading: CL
Posts: 1,193 since Apr 2010

Excel is probably the most widely used tool in the financial world, often to the dismay of programmers. It's really easy to use, and with VBA one can do a lot. Alternatively one can write add-ins in C/C++ or use something like Excel-DNA for .NET programming. I only started learning to program this year, so I am definitely not the guy to ask about that!

I use Excel as a quote board, but also for basic real-time and historical analysis. There are lots of people using it for automated trading. I should note, however, that I have moved most of my analysis to MATLAB. The goal is to create a custom application next year.

There are so many resources on the web; search and ye shall find.


Visit my NexusFi Trade Journal Reply With Quote
  #6 (permalink)
Daniel25
Delhi, Delhi/India
 
Posts: 23 since Nov 2011
Thanks Given: 2
Thanks Received: 1

Thanks to all members who replied here and assist me.


Reply With Quote
  #7 (permalink)
 
mattz's Avatar
 mattz   is a Vendor
 
Posts: 2,494 since Sep 2010
Thanks Given: 2,442
Thanks Received: 3,799

You can trade excel via R-Trader pro as well:


Thanks
Matt


Trading futures and options involves substantial risk of loss and is not suitable for all investors. Past performance is not necessarily indicative of future results. You may lose more than your initial investment. All posts are opinions and do not claim to be facts. Please conduct your own due diligence. Use only Risk capital when trading Futures.
1 800 771 6748 local 561 367 8686 email [email protected]
Follow me on X Visit my NexusFi Trade Journal Reply With Quote
Thanked by:




Last Updated on July 26, 2013


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts