Home Page

BondCalc: List of Import Formats Supported

 3 - Comprehensive covering Bonds, Money Market and Commerical &
     Passthrough Mortgages (screens A, F, H and J)

 1 - BondScholar

 2 - 16+ Field Comma Delimited Lotus PRN format (from Tech Data)

 4 - PAM to Bear Stearns format

 5 - Portia output

 6 - CMS BondEdge Import Format (plus optional SF/Call file)

 8 - CMS BondEdge Private Placement Format. Used by PAM.

10 - CMS BondEdge Private Placement Format w/o multipling S.F.
     by 1000. Used by Camra.

 9 - Comm. Mortgage Format (Securitization) - User Defined. See

Help for Commercial Mortgage Import Specification

These are the specifiers for the field positions for Import
Type 9. It reads a file with fixed field positions.

Enter the first column position and the length of that
field. If you don't know what they are, then use Alt-F8 to
invoke the LIST file manager. Find the file and view it.
With Alt-R you can turn on a Ruler line and find the first
position and lengths for the below:

CUSIP - max of 12 in length.

Name - max of 40 in length.

Current Balance - max of 16 in length.

Gross Int Rate - Enter in percent. Max length is 10.

Maturity Date Format Types:

 1 - ccyymmdd
 2 - mm/dd/yy
 3 - mm/dd/ccyy
 4 - yy/mm/dd

Payment Amount - Max length is 13.

First Payment Date - Optional. Must be in same date format
  as Maturity Date. If entered this will be the date of the
  first mortgage payment. It will be used as the end of a
  full period for interest purposes, irrespective of the
  distance from it to the issue date.