diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/trade_dataclasses.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/python/trade_dataclasses.py b/python/trade_dataclasses.py index 0a8ce485..8c1020a0 100644 --- a/python/trade_dataclasses.py +++ b/python/trade_dataclasses.py @@ -301,7 +301,7 @@ class BbgDeal: ) elif deal_type == DealType.Fxswap: cls._bbg_sql_insert = ( - f"INSERT INTO fx_tickets VALUES({','.join(['%s'] * 210)})" + f"INSERT INTO fx_tickets VALUES({','.join(['%s'] * 211)})" ) @classmethod @@ -782,6 +782,8 @@ class FxswapDeal( far_sell_amount = line['Far Counter Amount'] far_buy_currency = line['Currency 1'] far_buy_amount = line['Far Amount Dealt'] + sql_line = [None if not value else value for value in list(line.values())] + cls._bbg_insert_queue.append(sql_line) return cls( folder = '*', portfolio= 'UNALLOCATED', |
