diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/import_quotes.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/import_quotes.py b/python/import_quotes.py index d6c80475..9538f679 100644 --- a/python/import_quotes.py +++ b/python/import_quotes.py @@ -93,7 +93,7 @@ def insert_index(database, workdate): sqlstr = "INSERT INTO index_quotes VALUES(%s, %s, %s, %s, %s, %s, %s)" for f in filenames: - if datetime.datetime.fromtimestamp(os.path.getctime(f)).date()==workdate+BDay(1): + if datetime.datetime.fromtimestamp(os.path.getctime(f)).date()==(workdate+BDay(1)).date(): data = pd.read_csv(f, skiprows=2, parse_dates=[0,7]) data = data.dropna() data[['Composite Price', 'Composite Spread']] = data[['Composite Price', 'Composite Spread']].applymap(lambda x: float(x[:-1]) if x.endswith('%') else x) |