def get_curr_fund_value(fund_name_list):
unit_values = {}
for fund in fund_name_list:
fund_id = db.get_fund_id(fund)
data_dict, last_date = get_mf_data(fund_id, utils.last_month(), utils.today())
unit_values[fund] = data_dict[max(data_dict)]
return unit_values
def txn_to_obj_list(txn_string, amc=None, user_id=None):
# TODO: in future, if amc is none, detect it from txn_string
txn_matrix = parse_txn(txn_string)
txn_obj_list = []
if amc.lower() == 'uti':
positions = [0, 1, 2, 3, 4]
elif amc.lower() == 'icici':
positions = [0, 1, 5, 3, 2]
else:
raise
for txn in txn_matrix:
obj = dict(fund_name=txn[positions[0]],
txn_type=txn[positions[1]],
amount=utils.get_float(txn[positions[2]]),
units=utils.get_float(txn[positions[3]]),
date=utils.int_date(txn[positions[4]]))
txn_obj_list.append(obj)
for txn in txn_obj_list:
if txn['txn_type'].lower() in ['purchase', 'new purchase',
'additional purchase']:
txn['txn_type'] = PURCHASE
elif txn['txn_type'].lower() in ['redemption']:
txn['txn_type'] = REDEMPTION
else:
raise BaseException
# Additional details contained in transactions
if amc.lower() == 'uti':
for obj, txn in zip(txn_obj_list, txn_matrix):
obj['remarks'] = txn[6].strip() if len(txn) >= 7 else ''
# DO NOT STORE ICICI NAV. IT IS SoMETIMES AN OLD VALUE
# elif amc.lower() == 'icici':
# for obj, txn in zip(txn_obj_list, txn_matrix):
# obj['nav'] = float(txn[4])
for obj in txn_obj_list:
obj['amc'] = amc.lower() if amc.lower() in ['icici', 'uti'] else ''
for obj in txn_obj_list:
obj['user_id'] = user_id
# TODO Do not make this much api calls to db!!
for obj in txn_obj_list:
obj['fund_id'] = db.get_fund_id(obj['fund_name'])
return txn_obj_list
def __init__(self, fund_name=None, txn_type=None, amount=None, units=None,
date=None, status=None, remarks=None):
self.fund_name = fund_name
if txn_type.lower() in ['purchase', 'new purchase',
'additional purchase']:
self.txn_type = PURCHASE
elif txn_type.lower() in ['redemption']:
self.txn_type = REDEMPTION
else:
raise BaseException
self.amount = utils.get_float(amount)
self.units = utils.get_float(units)
self.date = utils.int_date(date)
self.status = status
self.remarks = remarks
self.fund_id = db.get_fund_id(fund_name)
self.nav = None # NAV on the day the transaction is performed
self.amc = None
