The Yield Book In Your Spreadsheet
The Yield Book Add-In gives you access to Yield Book data and analytics from within your spreadsheets.
You can incorporate the Add-In into your worksheet through functions and interactive menus. The Add-In
can also be wrapped with other Excel Add-Ins, as well as your own VBA code.
Order a free 30 day trial.
Install in only seconds.
Manual, Example Sheets, and Templates to help you get started.
|
Key Features |
|
Power and Flexibility |
Database Access
Bond indicative data on all bonds in the Yield Book Database
Historical bond, market, and Index data
Closing, historical and live Government and Swap curve data for 45 currencies
Calculations
- OAS
- Durations
- Partial Durations
- Volatility & prepay Durations
- Scenario Analysis
- Forward Pricing
- Cashflow Analysis
- Return Attribution
- Portfolio Analysis
Customization
Use Yield Book data or supply your own Yield and Swap Curves, User Bonds, Prepay Dials, or Loss Scenarios Etc.
|
Controlled Calculations
The Add-In does not push calculations into your spreadsheet automatically. It waits for you to calculate the full
or partial sheet. This allows you to run calculations on a large group of securities or a single security alone.
Calculation Dependencies
The Add-In will recognize dependency trees and follow the desired order for calculations. This allows you to
price securities relative to other securities or based on other data being retrieved from the Add-In.
|
|
Contact Us |
For more info or to set up a demo, please contact your Account Manager.
sales@yieldbook.com
(212) 816-7120
|
|
