Home Products & Services Educational Downloads Risk System Financial Ratios System

CALCULUS
Calcs for Financial Market
Excel Add-in
MANUAL and HELP
This paper intends to show details of CALCULUS.XLL add-in system, developed by Élin Duxus Consulting LTDA to Microsoft Excel.
CALCULUS.XLLadd-in implements functions applied to capital markets.
Content
QUICK REFERENCE
1. INSTALLATTION
1.1. Minimum Requirements
1.2. How to Install
1.3. Uninstall
2. USAGE
2.1. Excel Behavior
2.2. System Tools
2.2.1. Help
2.2.1.1 Help Command
2.2.2. Status Indicator
2.2.2.1 Status command
2.2.3. Idioms
2.2.3.1 Idiom command
2.2.4. Brazilian Yield Curve Exponential Interpolation and Extrapolation
2.2.4.1 CC.INTERPOLEX function
2.2.5. Cubic Spline for Brazilian Yield Curve
2.2.5.1 CC.CSPLINE function
2.2.6. Comparative chart for cubic spline and exponential interpolation
2.2.6.1 CSpline x Exp command
2.2.7. Duration, Exposure and Convexity for Fixed Income Portfolios
2.2.7.1 Function CC.DURATION
2.2.8. Hedge by Modified Duration for Fixed Income
2.2.8.1 Function CC.HEDGE
2.2.9. Projected trade volume
2.2.9.1 Function CC.VOLPROJ
2.2.10. Fare Future Value
2.2.10.1 Function CC.INDJUSTO
2.2.10.2 Function CC.INDTAXA
2.2.10.3 Function CC.INDDIF
2.2.11. FRC - Foward Rate Contract - and FRA - Forward Rate Agreement
2.2.11.1 Function CC.ROLIMP
2.2.11.2 Function CC.DESVIMP
2.2.11.3 Function CC.FRA_CURTA
2.2.11.4 Function CC.FRA
2.2.11.5 Function CC.CUPOM_SUJO
3. FAQ
LICENSE AND TERM OF RESPONSIBILITY

Home | Company information | Tools | CED | Forum | News | Links | Clients | Cases | Templates | Careers | Contact
©All rights reserved - Élin Duxus - Brazil - 2002 - 2008


Excel course, formulas, macros, sheets - Finance Mathematics, HP 12C - Options pricing and course, options Greeks analysis - VaR (Value at Risk) course - Equity, stocks, ADR and international arbitrage - Certified Professionals - Excel add-in for finance - Customized Excel add-in - System and application development, technology - C/C++, VBA, macros, models - Communication in Excel, RTD - Financial modeling - Financial consulting, corporate finance - Cash Flow Analysis - Brazilian PPP (Public-Private Partnership) - Excel Add-in Downloads - Templates - Duxus Risk System Élin Duxus Sitemap
Excel course, formulas, macros, sheets - Finance Mathematics, HP 12C - Options pricing and course, options Greeks analysis - VaR (Value at Risk) course - Equity, stocks, ADR and international arbitrage - Certified Professionals - Excel add-in for finance - Customized Excel add-in - System and application development, technology - C/C++, VBA, macros, models - ARCH, GARCH, TGARCH, ICARG - Communication in Excel, RTD - Financial modeling - Financial consulting, corporate finance - Cash Flow Analysis - Excel Add-in Downloads - Templates - Duxus Risk System - Value at Risk - VaR - ALM - Asset Liability Simulation