Addressing latency issues with Microsoft Excel.

Andy Webb outlines one way of addressing the latency issue for one of the most ubiquitous applications in financial markets - Microsoft Excel.

First Published: e-Forex Magazine 21 / Traders Workshop / October, 2005

Latency has been an increasingly hot topic in FX of late, with several data vendors recently announcing lower latency versions of their feeds. However, any gain in delivery speed is all too easily negated by the latency of the applications that process the data. Andy Webb out-lines one way of addressing this latency issue for one of the most ubiquitous applications in financial markets - Microsoft Excel1.In finance, as in so many other areas of human endeavour, ease of use usually comes with a com-promise price tag attached. In some cases that compromise is restricted functionality or flexibility - in others it is speed. Excel is a good example of the latter case. While it allows those with minimal pro-gramming expertise to achieve productivity, its performance can be less than ideal for production use in highly active markets such as FX.An obvious example of this problem is exotic FX options, where many traders and quants use Excel for prototyping and testing pricing models. While performance issues are no...continued

Exclusive Content

The full article is only available to current subscribers. Click here to sign in or subscribe by clicking here