Position data mapping
The raw CSV-formatted position data from Bloomberg is mapped to FA's reconciliation format with the mapping script AIM_reconciliation:
Column number in source file | Target field in FA | Notes |
|---|---|---|
7 | pf_id (Portfolio's short name in FA) | If a portfolio that has the ext ID "AIM-ID" with the given value is found, then that portfolio's short name. Otherwise, the pf_id is assumed to be the field value. |
22 | isin (Security's ISIN code in FA) | |
9 | amount (Position amount in FA) | |
33 | lastTradeDate (Position date in FA) |