High-Value Bond Pricing Report
Budget: ₹600 – ₹1,500 INR
I need a concise summary report in Excel that captures up-to-date pricing details for an upcoming sequence of high-value trades. The scope is tightly focused on:
• Municipal bonds only
• Any LEI-linked issues on my trade list
• Companion SPDR instruments that form part of the strategy
No trade volumes or performance metrics are required—just clean, well-structured price information.
Workbook structure
A single .xlsx file with three data tabs (Municipal Bonds, LEI-Linked Issues, SPDRs) and one dashboard tab that rolls the numbers into an at-a-glance view. Each data tab should show last price, bid-ask spread, yield to maturity, timestamp, and any Bloomberg/Refinitiv codes used, with transparent formulas and clearly labelled columns. Protect non-input cells to prevent accidental edits while allowing the data areas to refresh easily.
Deliverables
1. Finished Excel workbook (.xlsx) as described
2. A brief read-me sheet inside the file that explains data sources, any APIs or terminal pulls used, and how to refresh the figures
Acceptance criteria
• Only municipal bonds, the specified LEI-linked issues, and the relevant SPDR instruments are present
• Prices reconcile with the latest market close to within ±1 tick
• The workbook opens without external-link warnings and recalculates error-free
This report will feed directly into trade execution, so accuracy, clear labelling, and repeatability are essential.
• Municipal bonds only
• Any LEI-linked issues on my trade list
• Companion SPDR instruments that form part of the strategy
No trade volumes or performance metrics are required—just clean, well-structured price information.
Workbook structure
A single .xlsx file with three data tabs (Municipal Bonds, LEI-Linked Issues, SPDRs) and one dashboard tab that rolls the numbers into an at-a-glance view. Each data tab should show last price, bid-ask spread, yield to maturity, timestamp, and any Bloomberg/Refinitiv codes used, with transparent formulas and clearly labelled columns. Protect non-input cells to prevent accidental edits while allowing the data areas to refresh easily.
Deliverables
1. Finished Excel workbook (.xlsx) as described
2. A brief read-me sheet inside the file that explains data sources, any APIs or terminal pulls used, and how to refresh the figures
Acceptance criteria
• Only municipal bonds, the specified LEI-linked issues, and the relevant SPDR instruments are present
• Prices reconcile with the latest market close to within ±1 tick
• The workbook opens without external-link warnings and recalculates error-free
This report will feed directly into trade execution, so accuracy, clear labelling, and repeatability are essential.