HackerRank take-home: using the provided information sheet and Excel workbook, work through and write up questions about trade settlement.
Asked in the HackerRank take-home stage. The task is described as not difficult, but requires reading the prompt carefully and using basic Excel functions.
Requirements
- Identify the key settlement KPIs requested or implied by the materials, defining each clearly.
- Calculate the relevant metrics from the workbook, showing the Excel logic or formulas used.
- Compare settlement outcomes across the dimensions available in the workbook, such as status, date, market, or trade type.
- Highlight notable exceptions, trends, or data-quality issues.
- Write concise conclusions that distinguish observed results from assumptions.
Data Available
- The provided information sheet, containing definitions, instructions, and business rules.
- The provided Excel workbook, containing the trade-level or settlement-level records required for the analysis.
- Any workbook fields needed to identify trades, settlement status, dates, exceptions, or relevant categories.
