Day Trader Analysis Tool

Our client, a London City based day trader, asked us to develop an Excel based, custom made application for the analysis and accounting of their business.


  • The tool calculates the daily profit and loss by individual trader, by office and grand total.
  • A pivot table analyses all trades by stock by day.
  • Data storage using Microsoft SQL server databases allows fast access and storage of millions of trades.
  • An Interface to trading platform via csv and text files automates the import into the analysis tool.
  • We automated the PDF production and emailing function which allows sending of statements by pushing a button.
  • Multiple exchanges like LSE, CHI-X, TURQUISE, XETRA, EURONEXT, NASDAQ, NYSE, CME etc. can be handled.
  • We allowed the trading of equities and futures.
  • The clients requested to handle complex fee structures.
  • The tool allows for a daily trader performance analysis.
  • Multiple currencies are possible.
  • The tool was programmed in Excel VBA

If interested in our services, please contact us for a free quote.

Excel Software Solutions