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 sam028 with 1 posts (2 thanks)
    3. looks_3 Fat Tails with 1 posts (0 thanks)
    4. looks_4 mattz with 1 posts (1 thanks)
    1. trending_up 4,460 views
    2. thumb_up 4 thanks given
    3. group 7 followers
    1. forum 6 posts
    2. attach_file 0 attachments




 
Search this Thread

Excel Trading for Traders and Brokers?

  #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?
ZombieSqueeze
Platforms and Indicators
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
REcommedations for programming help
Sierra Chart
Trade idea based off three indicators.
Traders Hideout
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
31 thanks
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
20 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102



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,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629

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 Twitter 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,493 since Sep 2010
Thanks Given: 2,441
Thanks Received: 3,791

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 Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:




Last Updated on July 26, 2013


© 2024 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 - Privacy Policy - Downloads - Top
no new posts