Back to Exchange
About
Build a liquidity monitoring dashboard with PostgreSQL:
1. Cash position by bank account
2. Available credit lines with utilization
3. Total liquidity = Cash + Available Credit
4. Daily liquidity trend (30 days)
5. Liquidity coverage ratio calculation
6. Alerts for accounts below minimum balance
Database: bank_accounts (id, name, bank, current_balance, minimum_balance), credit_lines (id, name, total_limit, drawn_amount), daily_positions (id, date, account_id, balance). Seed with 5 accounts and 30 days history.
1. Cash position by bank account
2. Available credit lines with utilization
3. Total liquidity = Cash + Available Credit
4. Daily liquidity trend (30 days)
5. Liquidity coverage ratio calculation
6. Alerts for accounts below minimum balance
Database: bank_accounts (id, name, bank, current_balance, minimum_balance), credit_lines (id, name, total_limit, drawn_amount), daily_positions (id, date, account_id, balance). Seed with 5 accounts and 30 days history.
Required Configuration
| Key | Description | Required |
|---|---|---|
DATABASE_URL | - | Required |
_RAILWAY_PROJECT_ID | - | Required |
_DATABASE_SERVICE_ID | - | Required |
_DATABASE_PRIVATE_URL | - | Required |
Reviews (0)
No reviews yet
Be the first to share your experience.
Something wrong? Report this listing