ABS Report Description
Overview
The ABS Report page provides a detailed, real-time report on Asset-Backed Securities (ABS) issues and their associated tranches. This report is designed to help users quickly retrieve and analyze structured finance data for a specific security by entering its Issue ID.
How It Works
- The website is hosted on Microsoft Azure, ensuring high availability and scalability.
- When a user enters an Issue ID and submits the form, the site makes secure REST API calls to a backend service.
- The backend REST API is built to support CRUD operations and is also hosted on Azure.
- This API communicates with an Azure SQL Database, which stores all the relevant ABS issue and tranche data.
- The API returns structured JSON data, which is then rendered into user-friendly reports on the page.
Report Details
The report is divided into two main sections:
- Issue Details: Displays key information about the selected ABS issue, such as its name, categorisation, closing date, origination, book runners, legal advisors, collateral nationality, listing exchange, and total issuance amount.
- Tranche Details: Presents a side-by-side comparison of all tranches associated with the issue, including their codes, currencies, redemption status, ratings, coupon or margin details, maturity dates, and other financial characteristics.
Technical Architecture
- The frontend is built using ASP.NET Core Razor Pages and styled with Bootstrap for a modern, responsive user experience.
- All data retrieval is performed asynchronously using HTTP requests to the Azure-hosted REST API.
- The API is responsible for querying the Azure SQL database and returning the results in a structured JSON format.
- This architecture allows for easy extension, maintenance, and integration with other Azure services.
Database Structure (Estimated)
While your schema will be far more comprehensive, I've guessed that the database likely includes tables for Issuers, Issues, Tranches and TrancheDetails.