🏗️ Overview
FX Rates in Trovata TMS drive currency conversion, portfolio valuation, hedge effectiveness testing, and cash position reporting across all multi-currency instruments.
Rate Source → File/API → Validation → Rate Table Update → Position Revaluation
---
📋 FX Rate Import Methods
Method | Description | Best For |
Manual Entry | Enter rates one by one in UI | Small teams, few currencies |
CSV/Excel Import | Upload a flat file of rates | Mid-size treasury teams |
API Feed | Real-time rates from market data provider | Large treasury, automated |
Bank Rate Feed | Rates provided directly by your bank | FX-heavy organizations |
Bloomberg/Reuters | Direct market data integration | Enterprise treasury |
SFTP Scheduled | Automated daily file drop | ERP-integrated environments |
---
🔧 Step-by-Step Import Process
---
Step 1: Prepare Your Rate File
Ensure your file contains the required fields:
Field | Required? | Description |
Base Currency | ✅ Yes | The from-currency (e.g., USD) |
Quote Currency | ✅ Yes | The to-currency (e.g., EUR) |
Exchange Rate | ✅ Yes | Numeric rate value |
Rate Date | ✅ Yes | Effective date of the rate |
Rate Type | ✅ Yes | Spot, Forward, Budget, Custom |
Rate Source | ⚪ Optional | Bloomberg, Reuters, Bank |
Bid Rate | ⚪ Optional | Buy-side rate |
Ask Rate | ⚪ Optional | Sell-side rate |
Mid Rate | ⚪ Optional | Mid-market rate |
---
Step 2: Understand Rate Types
Trovata TMS supports multiple rate type classifications:
Rate Type | Description | Used For |
Spot | Current market rate | Daily valuations, settlements |
Forward | Contracted future rate | Hedge accounting, FX forwards |
Budget | Internally set planning rate | Annual budget, forecasting |
Historical | Past rates for period-end | Month-end close, revaluation |
Custom | User-defined rate type | Special reporting needs |
WM/Reuters | 4 PM London fix | Standard benchmark rate |
---
Step 3: Download the Rate Import Template
Trovata TMS Menu → Treasury → FX Management → FX Rates → Import → Download Template
Sample CSV Format:
BASE_CCY,QUOTE_CCY,RATE_DATE,RATE_TYPE,EXCHANGE_RATE,BID,ASK,SOURCE USD,EUR,01/15/2025,SPOT,0.9245,0.9240,0.9250,BLOOMBERG USD,GBP,01/15/2025,SPOT,0.7892,0.7888,0.7896,BLOOMBERG USD,JPY,01/15/2025,SPOT,157.42,157.38,157.46,BLOOMBERG USD,CAD,01/15/2025,SPOT,1.4382,1.4378,1.4386,REUTERS USD,EUR,01/15/2025,FORWARD,0.9198,0.9194,0.9202,BLOOMBERG
---
Step 4: Navigate to FX Rate Import
Trovata TMS Menu → Treasury → FX Management → FX Rates → Import Rates
---
Step 5: Configure Import Settings
Setting | Options |
Rate Convention | Direct (USD/EUR) vs. Indirect (EUR/USD) |
Decimal Precision | 4, 6, or 8 decimal places |
Overwrite Existing | Yes / No / Prompt |
Rate Effective Time | SOD (Start of Day) / EOD / Specific time |
Auto-Revalue | Trigger revaluation after import |
Notification | Alert users when rates updated |
---
Step 6: Upload & Validate
Trovata performs automatic validation:
Validation | Check |
Currency pair exists | Both currencies configured in system |
Rate is positive | No zero or negative rates |
Date is valid | Not future-dated beyond allowed range |
Rate reasonableness | Within ±X% of previous rate (configurable) |
Required fields | All mandatory fields populated |
Duplicate check | Rate for same pair/date/type already exists |
Validation Results:
Rate Import Validation: ├── ✅ 142 rates passed validation ├── ⚠️ 3 rates flagged for large movement (>5%) └── ❌ 1 rate failed — currency pair not configured (USD/VND)
---
Step 7: Review Rate Reasonableness Alerts
Flag rates that moved significantly:
Alert Type | Threshold Example |
Large Move Alert | Rate moved >3% from prior day |
Stale Rate Alert | Rate not updated in >24 hours |
Missing Pair Alert | Expected currency pair has no rate |
Cross-Rate Inconsistency | Triangulated rate doesn't reconcile |
---
Step 8: Confirm & Apply Rates
Once validated:
Review Summary → Confirm Import → Rates Applied to System
Post-Import Actions (automatic):
✅ FX positions revalued at new rates
✅ Portfolio P&L updated
✅ Cash positions converted to base currency
✅ Hedge effectiveness recalculated
✅ Risk reports refreshed
---
🔄 Automated Daily Rate Import
For most treasury teams, FX rates should be automated:
Trovata TMS Menu → Administration → Scheduled Tasks → New → FX Rate Import
Setting | Recommended Value |
Frequency | Daily (weekdays) |
Time | 7:00 AM (before markets open) |
Source | Bloomberg API / Reuters / Bank Feed |
Rate Type | SPOT (EOD prior day) |
On Success | Auto-apply + notify treasury team |
On Failure | Alert treasury team + use prior day rates |
Fallback | Use previous business day rate |
---
🌐 Market Data Provider Integration
Bloomberg Integration
Trovata → Administration → Market Data → Bloomberg → Configure: ├── Bloomberg API key ├── Currency pairs to subscribe ├── Rate type (BFIX, BGN, etc.) ├── Pull frequency (real-time / EOD) └── Auto-import on receipt
Reuters/Refinitiv Integration
Trovata → Administration → Market Data → Reuters → Configure: ├── Reuters API credentials ├── RIC codes for currency pairs ├── WM/Reuters 4 PM fix subscription └── Fallback to prior day if unavailable
Bank Rate Feed
Trovata → Administration → Bank Connections → [Your Bank] → Rate Feed: ├── Enable FX rate feed ├── Select currency pairs ├── Set delivery method (SFTP/API) └── Map bank rate types to ATOM rate types
---
📊 FX Rate Management Best Practices
Practice | Why It Matters |
Use WM/Reuters 4 PM fix | Industry standard for period-end close |
Maintain budget rates separately | Isolate planning from actual rates |
Keep 3+ years of history | Required for hedge effectiveness testing |
Reconcile cross-rates daily | EUR/GBP should equal EUR/USD ÷ GBP/USD |
Set reasonableness thresholds | Catch bad data before it corrupts positions |
Archive all imported files | Audit trail for SOX/IFRS 9 compliance |
Separate spot from forward rates | Critical for hedge accounting |
---
🔐 Audit & Compliance
Control | Description |
Rate source tracking | Every rate stamped with source |
Import log | User, timestamp, record count logged |
Override audit | Manual rate changes require justification |
Period-end lock | Rates locked after month-end close |
IFRS 9 / ASC 815 | Forward rates support hedge accounting |
---
🆘 Common FX Rate Import Issues
Issue | Fix |
Currency pair not found | Add currency pair in FX configuration |
Rate outside reasonableness band | Review rate, override with justification |
Stale rates (weekend/holiday) | Configure holiday calendar for auto-rollforward |
Cross-rate triangulation error | Check base currency consistency |
Bloomberg/Reuters connection fail | Check API credentials and network connectivity |
Rates not flowing to positions | Check auto-revalue setting is enabled |
Wrong rate convention | Verify direct vs. indirect setting matches source |
---
💡 FX Rate Types for Different Use Cases
Daily Operations → SPOT rates (real-time or EOD)
Month-End Close → WM/Reuters Fix (standardized)
Annual Budget → BUDGET rates (set by CFO/Treasury)
Hedge Accounting → FORWARD rates (matched to hedge tenor)
Historical Reports → HISTORICAL rates (locked period rates)
Stress Testing → CUSTOM rates (scenario-based)
---