diff options
Diffstat (limited to 'python/load_globeop_report.py')
| -rw-r--r-- | python/load_globeop_report.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/python/load_globeop_report.py b/python/load_globeop_report.py index 07a96681..60cf1ab6 100644 --- a/python/load_globeop_report.py +++ b/python/load_globeop_report.py @@ -4,6 +4,8 @@ import pandas as pd from itertools import chain from dates import bus_day from db import dbengine +import task_server.globeop as globeop +import datetime def get_globs(fname, years=['2013', '2014', '2015', '2016', '2017']): basedir = '/home/serenitas/Daily' @@ -51,6 +53,11 @@ def read_pnl_report(f): df.columns = df.columns.str.lower().str.replace(" ", "") return df +def back_fill(start_date = datetime.date(2017,7,20)): + date_rng = pd.date_range(start = start_date, end = datetime.date.today(), freq='B') + for date in date_rng: + globeop.insert_todb(date.date()) + def pnl_reports(): df = {} for f in chain.from_iterable(get_globs('Pnl*')): |