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 4,466 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?
MC PL editor upgrade
MultiCharts
Better Renko Gaps
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
REcommedations for programming help
Sierra Chart
Trade idea based off three indicators.
Traders Hideout
 
  #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,103



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