• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

SanzProphet

DYI Investing, Quant tools and thoughts on the market

  • Start Here
  • Crypto Management
  • About
  • Contact
  • Disclaimer

Trading Log for Amibroker

April 4, 2011 by sanz prophet 1 Comment

I have been looking into software to log my trades and keep track of actual trade performance. I was looking for:

1.  Simple import process from Interactive Brokers TWS Log Files.
2.  Be able to code and run custom statistics on portfolio level trades, not just per instrument.
3.  Be able to see my entry and exit on a price chart.
4.  Visualize Portfolio Equity Curve.

There are some great commercial software out there but they mostly lack the ability to visualize entry and exit points. I liked trading diary pro as it works well with IB. But it’s more of a bookkeeping tool than a custom analysis tool.
 I also tried Excel to no avail.

So I wrote my own script for Amibroker (mostly based on an existing script in the AB library written by Herman).
The scripts reads the trades from IB’s TWS export.
Here is a screenshot:
Note: The equity curve is for ALL instruments traded.

There’s still a lot to be done:
1. Export sorted trades and make  backup copy to Excel.
2. Append TWS daily .csv files automatically.
3. Equity Curve taking into account daily prices, not just entry and exit. (Hard).
4. Equity Curves per Instrument.
5. More Stats: Drawdown, CAR/MDD, etc.

Filed Under: Amibroker

Reader Interactions

Comments

  1. Anonymous says

    May 31, 2015 at 7:38 pm

    Great blog with some amazing insights!! Did you ever finish writing this script? Am curious to see how it turned out!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Keep in touch

Managed Crypto Funds

via TokenSets.com

Categories

Archives

Footer

RSS Portfolios from Logical-Invest.com

  • Bond ETF Rotation Strategy: Low-volatility portfolios for smart investors from Logical Invest
  • BUG Permanent Portfolio Strategy: Quantitative investment models from Logical Invest
  • Crypto & Leveraged Top 2 Strategy: Risk-adjusted investment portfolios from Logical Invest
  • Dow 30 Strategy: Quantitative investment models from Logical Invest

Pages

  • About
  • Contact
  • Disclaimer
  • Start Here

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · @SanzProphet.com· Log in