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,316 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?
Roland Garros Final Day: $3M on Zverev at 80.5% -- Leban …
Prediction Markets & Event Contracts
Ninjatrader users - good CONNECTIONs post and article fr …
NinjaTrader
Warsh Rate Hike at 40%, Iran June 15 Expires Tonight at …
Prediction Markets & Event Contracts
April CPI Preview: +3.7% YoY Expected at 8:30 AM ET -- C …
Traders Hideout
I Have a Thing Called Iran -- Trump Stays in DC as Airsp …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
6 thanks
Darmok and Jalad at Tanagra
1 thanks
  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Legendary 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,117



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,758 since Jun 2009
Thanks Given: 3,828
Thanks Received: 4,643

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)
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,801

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