Tony Kobine

I'm a consultant software developer specialising in front office Excel applications for investment banks. My business experience covers Equity Derivatives, Cash Equities, FX and Structured Finance.

I interface directly with traders to gather requirements and return regularly to them to confirm that development is proceeding in the direction they wish. I also interface with other groups within the bank-–quants, risk, pricing, market data, middle and back office, for example–-to secure the infrastructure components, analytics and data feeds that the application requires.

In addition to designing, implementing and testing code, I manage end-to-end production of user documentation, Help files and training courses.

I was previously a founder of FCMC plc, a UK software company that brought Finar, Fingroup and Staffware to market. FCMC subsequently went public on the London Stock Exchange as Staffware plc until it was delisted in 2004 for private sale to TIBCO.

Let me take a look at some of your more pressing Excel development needs and I will give you a firm quote for how long the job will take.

To email me, click here

Sample List of Consulting Projects

Merrill Lynch – Equity Derivatives

Lead a team providing tactical Excel-based solutions to the entire Equity Derivatives business – sales, structurers, traders, middle and back office. Solutions cover the full range of business activity - pricing, booking and risk, execution, contribution and market access, exchange reporting, restricted list feed and analytics delivery. Solutions tend to be highly tactical and often serve to fill a need while a long-term strategic solution is being developed. Excel VBA, Reuters, Bloomberg, Fidessa, Trading Screen and a broad range of internal feeds, databases and strategic applications.

HSBC Investment Bank – FX

Create an intraday pricing system to support a secondary market in Medium Term Notes (MTNs) by publishing mark-to-market prices to Bloomberg, Reuters and the HSBC DMDS internal market database. The asset class is a Fixed Income issue whose coupon is tied to the exchange rates of a basket of emerging market currencies. The MTN business has grown rapidly and ad hoc, per deal pricing could no longer satisfy Sales’ requirements for quotations. An analysis of all trades for the purpose of categorising them then building standard pricing templates for each trade type was first performed then the system was implemented using Excel, VBA, Reuters InsertLink and Spreadsheet Publisher, Bloomberg PriceLink.

Developed a Straight Through Processing methodology for booking top-ups and buy-backs of the above MTNs into Murex by intercepting, saving and modifying MXML to save repetitive re-entry of trade economics.

Barclays Capital – Exotic Equity Derivatives

Develop the Equities Derivatives pricing sheet of Merlin+, a global framework for pricing and risking derivatives trades and provides a single platform for generating prices and risk for derivative deals across Fixed Income derivatives, Equity Derivatives, Commodity Derivatives, Emerging Market Derivatives & FX Derivatives. This single platform is supported and enhanced by teams in London, New York & Asia. Calculations can be run locally or distributed across PCs, in a remote server farm, to greatly improve the speed of risk generation.

Standard & Poor’s – Structured Finance

Standard & Poor's is the world's foremost provider of independent credit ratings, indices, risk evaluation, investment research, data and valuations. I was retained by the Structured Finance department to create a rating product for European Covered Bond (ECB) issuers. A suite of Excel workbooks is currently being used internally for ECB rating. I am adding new functionality and ‘productising’ them for use by external customers.

ABN AMRO - MS Office Upgrade

This global investment bank was upgrading from Windows NT / Office 97 to Windows XP / Office XP. I had specific responsibility for converting all user-written applications in Excel (including Market Data apps) to ensure their smooth migration. Managed a team of 6 Data Conversion Analysts supporting the migration of over 1,000 workstations.

AXA Investment Managers - MS Office Upgrade

This asset manager was upgrading 2,500 workstations from Windows NT / Office 97 to Windows XP / Office 2003 with new hardware. I had specific responsibility for all user-written applications in Excel, Access and VB6 to ensure their smooth migration. These applications were written by fund managers and traders to support investment decisions, interface with market data feeds (Bloomberg, Reuters, Thomson Financial’s DataStream) and were mission critical. Upsized Access to SQL Server and thick client VB6/Excel to ASP.NET/SQL Server for the Compliance department. Industrialised applications for Fixed Income and Quants.

AXA Insurance - ERM System

Develop VB and Office 97 application programs under NT front-ending Access, SQL Server 7 and Oracle 8 databases that manage personnel records for several hundred IT staff of this multinational insurance company. Design and implement a skills questionnaire generation and routing system using Excel, Outlook, Exchange, Collaboration Data Objects and Routing Objects. Redesign a large, single-tier application (thick client + Access) to an ASP client, a middle-tier VB COM component and a SQL Server 7 back end. Train staff programmer to take over maintenance and development of the system.

A Real-Time Investment Decision Support System

A small group of private investors, swing- and day-trading the US equities and options markets, required a flexible decision support system to scan real-time data feeds based on their highly personalised trading criteria. Design and write this system in VB and interface it to an Internet trading platform. Design and write a VB program to host Microsoft IE to scan financial news feeds. Web pages are downloaded in a background process, scanned using the Document Object Model (DOM) then stored in a SQL Server 7 database and linked to trading alerts.