aboutsummaryrefslogtreecommitdiffstats
path: root/python
diff options
context:
space:
mode:
Diffstat (limited to 'python')
-rw-r--r--python/trade_dataclasses.py4
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',