NexusFi: Find Your Edge


Home Menu

 





Excel Automating Trading Journal from IB


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one aczk with 1 posts (0 thanks)
    2. looks_two tradersync with 1 posts (0 thanks)
    3. looks_3 MrYou with 1 posts (0 thanks)
    4. looks_4 rassom with 1 posts (0 thanks)
    1. trending_up 5,395 views
    2. thumb_up 0 thanks given
    3. group 4 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread

Excel Automating Trading Journal from IB

  #1 (permalink)
 aczk 
London, UK
 
Experience: Intermediate
Platform: MultiCharts
Trading: equities, futures
Posts: 36 since Jan 2012
Thanks Given: 3
Thanks Received: 2

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.

Thanks

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NexusFi Journal Challenge - April 2024
Feedback and Announcements
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Futures True Range Report
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #2 (permalink)
 
MrYou's Avatar
 MrYou 
NC, USA
 
Experience: None
Platform: None Yet
Trading: Guitar
Posts: 403 since Jun 2011
Thanks Given: 618
Thanks Received: 196

@aczk

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.

Reply With Quote
  #3 (permalink)
 rassom 
Aarhus, Denmark
 
Experience: Advanced
Platform: TradeBench.com, NinjaTrader, TC2000, IB.
Broker: IB/Kinetick
Trading: Stocks
Posts: 2 since Mar 2013
Thanks Given: 7
Thanks Received: 0


@aczk

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.

Follow me on Twitter Reply With Quote




Last Updated on October 21, 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