| In this demonstration, you are using our bond pricing software running independently on each node of a remote cluster.
System requirements:
- Windows 2000 or higher
- Excel 2003 Professional Edition
An overview of the architecture
Our Excel spreadsheet that you download runs on your desktop.
The Excel spreadsheet includes command buttons that enable you to access our remote cluster and execute the finance application that is embedded in the spreadsheet you download.
The remote cluster you are using has 4 dual processor nodes.
|
|
The application – pricing a portfolio of callable bonds
This application prices a portfolio of callable bonds. For the purpose of this demonstration, you can price a portfolio containing as many as 200 bonds.
Each individual bond is priced on one processor of one of the nodes of our cluster. Each bond is priced independently of all of the other bonds.
Monte Carlo simulation is used to price each bond.
Once a given bond is priced, the results are sent back to your desktop, and the next bond is sent to the idle processor. This process continues until all of the bonds are priced.
|
|
The steps you need to take :
| 1. |
Install Microsoft's .NET Framework 1.1 on your desktop |
Go to Microsoft's website: http://www.microsoft.com .
Select Downloads from the left panel and then enter “Framework” in the search box.
Select Microsoft .NET Framework Version 1.1 Redistributable Package and follow the instructions to download onto your desktop machine.
| 2. |
Download and save the following zip file on your computer |
http://www.tc.cornell.edu/ctc-manhattan/CallableBondDemo/Excel_callable_bond.zip
Unzip the above file. You will find a spreadsheet and a folder containing a dll. Do not open the Excel spreadsheet now.
3. |
Give full trust to our dll that is accessed by the spreadsheet with these steps: |
| 4. |
Go to Control Panel -> Administrative Tools. |
| 5. |
Start Microsoft .NET Framework 1.1 Wizards. |
| 6. |
Click "Trust an Assembly". |
| 7. |
Select "Make changes to this computer". and Click on Next |
8.
|
Click on "Browse...", navigate to Excel_callable_bond.dll
which you extracted in step 2, and select it. Click on Next. |
| 9. |
Move the slider to " Full trust " and click Next , then Finish . |
You are now ready to run the demo. It works best with a screen resolution of 1024x768 or higher.
| 10. |
Open the Excel spreadsheet you extracted from the zip file in step 2. |
| 11. |
Read the Message Box. |
12.
|
Press the “Execute” Button on the left hand side. The color-coded cells at the bottom of the spreadsheet provide information about the status of the pricing of each bond. |
13.
|
The completion of all calculations is announced in the message box at the top of the spreadsheet. Once that message appears, you may wish to click on the “Bonds” tab at the bottom of the spreadsheet to see the pricing results. |
14.
|
The
application can be executed multiple times. Change the number of
bonds if desired, by changing the number in the gray box on the left
hand side of the spreadsheet. |
To exit the demonstration, close the Excel spreadsheet. |
