[Company Logo Image]   

We are traders

Arbitrage Research and Trading

 Home News Products Services Research Jobs Forum ARTLib XL - Core Lite


Why you need this software
ARTLibXL Lite: Function List

ARTLib XL - Core Lite

Available at the ARTShop

The ARTLib XL - Core Lite  is a subset of ARTLib XL - Core library/add-in developed by traders including all the functionality expected for a modern professional trading operation (see list below). 

The Lite  version provides sufficient functionality to manage most standard valuation and risk problems in trading, sales, structuring, and risk management ... at a small fraction of the price of a comparable add-in. 

ARTLib XL is also integrated with SmARTWare (pricing/risk for tablets and smart phones).

Be sure to contact us for additional discounts if you have some of our products already, are looking to "bundle" items, etc.

Also, please keep in mind that many  of our books and some of our software is included with ARTSchool Seminars.


The ARTLib XL - Core Lite Version 1.3  expected in 2015, priced at USD 599. and is bundled with CalcPak Lite.

Includes a copy of "A Trader's Guide to Quantitative Methods: Basic Maths & Stats" (worth USD 225)*.

Get a 20% discount towards the full ARTLib XL - Core package+ (worth USD 1,399++) , and more.

There are other special packages, contact us.

BE SURE TO READ "DETAILS/System Requirements" below BEFORE YOU BUY

Available at the ARTShop

Tell a Friend

The functions are geared toward P&L specific trading in the valuation and risk assessment of almost any traditional traded instrument.  Additionally, the functions include many specialised features that arise in a trader's day-to-day requirements.  

The "essential subset" includes machinery for all usual calculations (IR curve generation, FRNs, bond, swaps, caps/floors/swaptions, all the "usual/standard" options, and so forth).  See also the function list below.

The modules are written to have very easy implementation and flexibility to provide very low cost of implementation and development.  For example, a large spreadsheet written to value vanilla caps can be easily converted to value/risk asses exotic options with just the alteration of one or a few cells.  Though there are specialised versions of many of the calculations, in most cases there are "super functions" that access all of the required features from a single interface.  Thus, for example, a bond trader may only ever need to know 1 or few functions.

The calculations/functions are optimised for speed of execution (and are SMP ready***) providing a practical environment for large and/or real time trading/risk analysis (see benchmarks here).

The Core module is also required for the later modules in the ARTLib XL suite, which provides many advanced and sophisticated treatment of trading, position keeping, structuring, and portfolio management (see a comparison of features).

The modules are also available with almost any degree of customisation, for different environments (e.g. LINUX), in different formats (e.g. DLL, static, source code), etc.  Request more information HERE, or write to ARTWare@Arbitrage-Trading.com


List of Function Categories and Resources (see FULL LIST)

The list below shows ("x/y"), where the "x's" are the number of functions in the Lite  version compared to the "y"'s, which are the number of functions in the Core modules.

Date/Calendar/Time Functions: (20/57) functions

Interpolation Functions: (6/12) functions

Present Value & IR Functions: (14/16) functions

IR Curve Generation Functions: (8/16) comprehensive functions

IR Securities Functions: (12/28) functions

IR Derivatives Functions: (8/16) functions

Vanilla Options Functions: (8/30) functions

Volatility Functions: (2/4) functions

Exotic Options Functions: (0/12) functions

Interest Rate Options and Term Structure Functions: (2/16) functions

Mortgage/MBS Functions: (4/12) functions

Structured/Hybrid Products Functions: (0/8) functions

Sundry/Support/Array/Stats Functions: (8/48) functions


Abridged Descriptions (click links for details or , see FULL LIST)

Date/Calendar/Time Functions: (20/57) functions providing almost every conceivable date/calendar calculation for real world application.  In addition to all of the obvious year fraction, interest basis (e.g. 30E/360 etc), basic routines, there are also a large number of functions available to generate "offset" calendar calculations (e.g. next 3rd Wednesday on an IMM calendar for the 5th forward Sep future etc).  Additionally, there are important functions to generate a variety of cash flow date sequences for almost any instrument (e.g. long first, short last, FRN with compounding quarterly coupons at first, then semi-annual later, on modified following basis with custom holiday effects, etc) , see FULL LIST.

Interpolation Functions: (6/12) functions to provide all basic interpolation requirements on a variety of basis (constant, linear, exponential, splines etc), see LIST (and also see 12 more interpolation and fitting functions in the ARTLib XL - Adv Trader module for specialised curve/surface functions for complex products, arbitrage, and trade idea generation/ PaR analysis) , see FULL LIST..

Present Value & IR Functions: (14/16) functions providing a wide range of PC and IR functionality and conversions relating PV and IR to discount factors, yields, annutisation, forward rates, etc.  Most functions are also available in "vector/array" format, so for example, an entire sequence of collection of sequences of forward rates can be produced in one step , see FULL LIST..

IR Curve Generation Functions: (8/16) comprehensive functions which not only generate yield curves from market inputs, but also provide flexible and immediate analysis of curve features (e.g. immediately produce dF's, forward rate curves, etc to see where to "trade the curve").  The standard and advanced functions can produce any curve type (LIBOR, Gov, Corp, Mortgage, etc) and can do so for any combination of input contracts (Deposits, Deposit Futures, FRA's Bonds, Bond Futures, Swaps, Mortgages, etc) with a variety of interpolation and fitting methods, with the more sophisticated features available in the ARTLib XL - Adv Trader module , see FULL LIST..

IR Securities Functions: (12/28) functions to cover all aspects of cash flows and risk/valuation of deposits, bonds, FRNs, with almost any degree of sophistication as well as direct functions for standard products.  In most cases, the valuation and risk calculations can be performed on any or all variations of spot, forward start, IO, PO, fees/Spread basis.  In addition to standard bonds and FRNs, the functions can easily handle any generalisation (stubs, step ups, compounding coupons, etc).  Advanced features are incorporated for highly specialised rebalancing and trading needs requiring sophisticated valuation and risk analysis (e.g. funding arbitrage, spread trading, etc, see also the ARTLib XL - Adv Trader module) , see FULL LIST..

IR Derivatives Functions: (8/16) functions covering all aspects if valuation and risk of standard and complex (non-contingent) IR derivatives (FRA's, Deposit Futures, Swaps, Bond Futures, etc).  The valuation and risk calculations, as above, have a considerable sophistication with spot/forward, IO, PO, Fees/Spread, and many other sophisticated analysis.  Even the most basic valuations can generate extra analysis for different rebalancing assumptions and other position keeping implications.  Swaps functions permit "many legs" so in addition to the usual 2-leg format, you may also perform valuation and risk for example on a 4 -leg structure involving basis/fixed-fixed/basis with or without additional "spread legs", or complex notional (e.g. amortising with exchange), or FX curve effects acting on the IR components.  There are also a variety of related functions, such as CTD/Implied Repo etc available for most standard and also some quite general settings (useful in both listed trading and also in OTC trading where margining and other related process are required).  There are also various additional advanced functions for valuation and risk of correlation related issues such as spread/curvature factors, tailing/FRA convexity etc. (see also the ARTLib XL - Adv Trader module), see FULL LIST..

Vanilla Options Functions: (8/30) functions covering individual and "super function" closed form solutions from all common models including for European and American Black-Scholes, Merton, Whaley, Bjerksund, etc as well as some specialised closed from options valuations such as fractal adjusted model.  All functions can also produce a very wide variety of risk and related statistics required in reporting and rebalancing.  Support functions include many Expiration functions, and close control for specialised trading (e.g. very short dated options with "minutes" to expiration etc).  See also the ARTLib XL - Adv Trader module for numerical solutions (e.g. Monte Carlo) that permit a wider range of modelling and real world analysis, while Pr/rO ,  and later modules, also permit synthetic replication analysis for optimal hedge strategies, arbitrage opportunities, and structuring considerations , see FULL LIST.

Volatility Functions: (2/4) functions for traditional historical volatility analysis complement the implied volatility and term-structure volatility related functions, with the advanced functions also capable of analysing "trading volatility", "portfolio/position volatility", and "P&L volatility" (See also the ARTLib XL - Adv Trader , and Pr/rO modules ** ) , see FULL LIST.

Exotic Options Functions: (0/12) functions providing valuation and risk via tradition closed form solutions to all of the "usual suspects" exotic options.  The the ARTLib XL - Adv Trader , Pr/rO ,  and later modules, also provide for advanced numerical methods to value complex options that do not have closed form solutions, or when sophisticated trading/synthetic replication is required, , see FULL LIST.

Interest Rate Options and Term Structure Functions: (2/16) functions that together with the functions above permit sophisticated valuation and risk calculations for all traditional and a large number of complex IR options including vanilla caps/floors/swaptions/bond options/FRA'ptions (IRG's) etc.  The other modules also permit seamless generation of exotic serial options (e.g. knock-out caps etc, with advanced features permitting many additional possibilities, see also the ARTLib XL - Adv Trader , Pr/rO ,  and later modules) , see FULL LIST.

Mortgage/MBS Functions: (4/12) standard MBS functions for valuation and risk assessment of standard mortgage and  MBS products with our without pre-payment, and as always can be performed on any combination of  spot, forward start, IO, PO, spread/fees basis.  Additional functions permit detailed cash flow analysis, various  tranching strategies (e.g. IO, PO and others) and basic CMO  analysis.  The ARTLib XL - Adv Trader , Pr/rO ,  and later modules permit advanced functions for pre-payment modelling, simulations, and complex structuring , see FULL LIST.

Structured/Hybrid Products Functions: (0/8) basic functions for the valuation and risk assessment of basic structured products including convertible bonds, equity swaps, fair-way bonds, simple baskets, index/futures arbitrage, and the like.  Fully comprehensive treatment of structured/hybrid products (especially with complex features) requires The ARTLib XL - Adv Trader , Pr/rO ,  and later modules, see LIST ****.

Sundry/Support/Array/Stats Functions: (8/48) functions providing support for the ARTLib functions and providing additional fast analysis , see FULL LIST.



1) This is Version 1.3, for delivery during 2015.

2) This is a full commercial product, but you are expected to apply appropriate due diligence.

3) This packages have been tested in Windows 2000 and XP (r) with Excel 2000, 2002, 2003, and 2007/2010. 

The package  works with Excel 2007/2010, but those versions of Excel have many "issues".  Versions prior to 2007 work far better in every respect, and we strongly recommend staying away from 2007/2010 if at all possible. 

4) This package includes the "A Trader's Guide to Quantitative Methods: Basic Maths & Stats" e-Book from the  TG2 Books set.  Please contact us if you are looking for a "package deal".  Other packages include books and various other extras. 

5) The CalcPak Lite  is "bundled"  with the package.  CalcPak includes various "pre-built/automation" of calculators/tickets, bucket reports, curve generators, analysis, etc.

6) The package includes various user/reference documents, and spreadsheets examples and formula references.

7) The package is provided with "email technical support".  Premium Technical Support, as well as ART's "Trading/Risk" Support are available also, please contact us.  Technical Support provides assistance with the "package/formulas" etc, while Trading/Risk Support provides assistance with "understanding usage" of the package in the much larger context of trading and risk in the real world (e.g. you can talk to our highly experienced traders regarding pricing/risk/structuring/sales etc issues).

8) The package relies on Digital Right Management (DRM) facilities for licensing and various "protections".  The DRM package requires that you have a working internet connection, and if you use proxies/firewalls, that you can adjust those as need be to have clear internet connection to the DRM system.

9) Other conditions may apply, please contact us with any questions prior to purchase.


Click here for a comparison of features

Click here for ARTWare Home

Available at the ARTShop

Tell a Friend


**** Note: this segment is under review, and the final edition of splitting structuring functions between the Core module and the Adv Trader module is yet to be determined.

*** SMP: Symmetric Multi-Processor ready code means that it can immediately take advantage of multiple CPU's on the client PC.   In many cases there is near linear scaling with number of CPU's, e.g. 2 CPU's implies nearly twice the speed of execution.  There are various limits on the total number of CPU's used during the calculations that limited by the version of the module and the client's requirements.  The full benifits of vector/parallel processing require the Adv Trader module.

**Pr/rO  is also included as part of the ARTPr/rO advisory service.

* These are the e-Book additions.  Hardcopy is available with small additional admin charge, and shipping is extra.

+ As it becomes available.

++ Plus applicable taxes etc.


Hit Counter


Home Up Feedback Search Investor Login Company Profile

Send mail to webmaster@arbitrage-trading.com with questions or comments about this web site.
Copyright Arbitrage Research and Trading Ltd.

The contents of this web are presented by ART for viewing purposes only, and ART makes no warranties as to accuracy.

Last modified: July 25, 2011