diff options
Diffstat (limited to 'python/load_cf.py')
| -rw-r--r-- | python/load_cf.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/load_cf.py b/python/load_cf.py index c749b712..87ab59aa 100644 --- a/python/load_cf.py +++ b/python/load_cf.py @@ -70,8 +70,8 @@ def get_dist(date): return {"L": np.array(dist[0]),"R": np.array(dist[1])}
def get_dealdata(dealname, tradedate):
- sqlstr = "select \"Curr Collat Bal\" AS currbal, \"Reinv End Date\", \"Deal Next Pay Date\"," \
- "maturity, \"Principal Bal\", \"Pay Day\" from historical_clo_universe(%s, %s)"
+ sqlstr = "select \"Curr Collat Bal\" AS currbal, reinv_end_date, first_pay_date," \
+ "maturity, \"Principal Bal\", pay_day from historical_clo_universe(%s, %s)"
data = {k: v for k, v in query_db(sqlstr, (dealname, tradedate)).items()}
data["mv"] = query_db("select marketvalue from latest_deal_model_numbers where dealname = %s",
(dealname,))[0]
|