SpiderXL
SpiderXL is simplifying the analysis of treasury bonds, futures and options by offering an intuitive, but yet powerful, rich-set of functions directly into your Microsoft Excel spreadsheet. With SpiderXL, the days of modeling common mundane calculations such as fitting zero-coupon curve, calculating conversion ratio, finding cheapest-to-deliver bond, etc. is officially over. SpiderXL wraps those calculations, and avails them as a simple extension to Excel. As a result, Excel can do the work for you, while you focus your efforts on the value-added activities, e.g. devising your strategy or analyzing risk scenario.
An Extension of Excel
SpiderXL is a true extension of Excel that can be used just like any of the native functions in Excel (i.e. SUM, AVERAGE, STDEV, etc.). You can use SpiderXL functions by either manually typing it in your workbooks or by using Excel function wizard.
An intuitive Approach
With SpiderXL, the users develop their financial models in Excel in the same way they always did, but now, they use SpiderXL to retrieve characteristic information such as bond’s coupon rate and future’s last delivery date, and to compute mundane calculation; for example fitting a zero-curve and finding the cheapest to deliver bond.
You’re in control
SpiderXL gives you complete control over the location and format of computed values. Just like a native Excel function, SpiderXL places the calculated results into the selected cell and nowhere else. Once you've created a SpiderXL formula, you can use it just like any other Excel formula by copying or linking to other cells.
Maximize the productivity
SpiderXL is the perfect tool to automate your analysis process. Once a spreadsheet is created with SpiderXL functions for one strategy, running the same analysis for different strategy is as simple as entering a new ticker symbol.
For further information, please refer to online documentation and case studies. For a 60-days trial, go to our download page.