Excel Automating Trading Journal from IB - IB Trader Workstation | futures.io
futures.io futures trading

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Platforms and Indicators > IB Trader Workstation

Excel Automating Trading Journal from IB
Started:September 29th, 2013 (10:46 PM) by aczk Views / Replies:1,755 / 2
Last Reply:October 21st, 2013 (07:38 AM) Attachments:0

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Excel Automating Trading Journal from IB

Old September 29th, 2013, 10:46 PM   #1 (permalink)
Elite Member
London, UK
Futures Experience: Intermediate
Platform: MultiCharts
Favorite Futures: equities, futures
Posts: 36 since Jan 2012
Thanks: 3 given, 2 received

Excel Automating Trading Journal from IB

Hi All

Has anyone ever created an excel trading journal that takes your trades automatically from the API,sort/classifies them properly and computes the usual performance stats.

alternatively just a spreadsheet that automatically recognizes, sorts, and classifies the trades when cut and past from the IB "Trades" window???
This would really save a lot of time, my excel skills are simply not good enough for this.


Reply With Quote

Old October 1st, 2013, 04:46 PM   #2 (permalink)
Elite Member
Futures Experience: None
Platform: None Yet
Favorite Futures: Guitar
MrYou's Avatar
Posts: 402 since Jun 2011
Thanks: 611 given, 192 received


Does The Trade Log do what you want?

EDIT: Maybe there is a compatible template out there that would give you the stats you want.

Last edited by MrYou; October 1st, 2013 at 04:51 PM.
Reply With Quote

Old October 21st, 2013, 07:38 AM   #3 (permalink)
 Vendor: www.tradebench.com 
Aarhus, Denmark
Futures Experience: Advanced
Platform: TradeBench.com, NinjaTrader, TC2000, IB.
Broker/Data: IB/Kinetick
Favorite Futures: Stocks
Posts: 2 since Mar 2013
Thanks: 7 given, 0 received


You could look at Tradervue or TradeBench, import your trades there and, if the reports are not sufficient, download the trades as Excel file including post-trade metrics like P&L etc done for you.

Disclaimer: I am the founder and CEO of TradeBench.

Reply With Quote


futures.io > Futures Trading, News, Charts and Platforms > Platforms and Indicators > IB Trader Workstation > Excel Automating Trading Journal from IB

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sierra Chart Excel Journal drw112 Sierra Chart 4 June 6th, 2013 04:51 PM
BMT Sample trading journal (Excel) Big Mike Trading Journals 1 April 29th, 2012 01:17 AM
Trading Journal example (Excel spreadsheet) Big Mike Psychology and Money Management 20 March 16th, 2012 08:26 PM
Help: Code for Automating ARMA Identification in Matlab Oxymoron Matlab, R project and Python 3 December 21st, 2010 09:17 PM
Working on automating The Holy Grail & Sharky's method BigDog NinjaTrader Programming 15 January 21st, 2010 11:54 AM

All times are GMT -4. The time now is 02:29 AM.

Copyright © 2016 by futures.io. 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.
no new posts

Page generated 2016-10-28 in 0.07 seconds with 19 queries on phoenix via your IP