1 files changed, 2 insertions, 1 deletions
diff --git a/python/parse_gs_exchange.py b/python/parse_gs_exchange.py
index f0e49702..5aac63ae 100644
--- a/python/parse_gs_exchange.py
+++ b/python/parse_gs_exchange.py
@@ -4,6 +4,7 @@ from pytz import timezone
 from parse_emails import write_todb
 import datetime
 import logging
+import os
 import pandas as pd
 import re
 
@@ -73,7 +74,7 @@ def parse_email(email, fwd_index):
                      'index': indextype,
                      'series': series,
                      'ref': refspread if indextype == "IG" else ref,
-                     'msg_id': get_msg_id(email)}
+                     'msg_id': int(get_msg_id(email), 16)}
                 if indextype == "IG":
                     d['fwdspread'] = float(fwspread)
                 else: