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
- Data Mapping Tool
- Integrated Contractor’s Administration and Accounting Tool in Excel
- Investment Portfolio Recommendation Tool
- Management Reporting Tool
- Multi-Currency Cash Book in Excel
- Payroll and Personnel Costs Planning Tool
- Quotation Tool using Excel VBA
- Sales Forecasting Tool
- Upgrade to New Excel Versions
- Workflow Automation For Personnel Planning