def get_fecha_habil_anterior(date):
query = "Select fecha from Fechas_habiles where id in (Select id-1 from Fechas_Habiles where fecha='AUTODATE')"
query=query.replace("AUTODATE", str(date))
fecha_habil_anterior = fs.get_val_sql_user(server="Puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query)
fecha_habil_anterior = fecha_habil_anterior.date()
if (fecha_habil_anterior.month==12 and fecha_habil_anterior.day==31):
query_bancario = "select Fecha from fechas_habiles where id in (select id-1 from Fechas_habiles where fecha='AUTODATE')"
query_bancario = query_bancario.replace("AUTODATE", str(fecha_habil_anterior))
fecha_habil_anterior = fs.get_val_sql_user(server="Puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query_bancario)
fecha_habil_anterior = fecha_habil_anterior.date()
#retorno un datetime.date
return fecha_habil_anterior
def get_UF_spot(date):
query = "SELECT Valor FROM Indices_Dinamica WHERE Index_Id = 23 AND Fecha = '{}'".format(
date)
UF_spot = fs.get_val_sql_user(server="Puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query)
return UF_spot
def get_UF_fwd(date, periodo):
query = "SELECT Yield FROM ZHIS_RA_Curves WHERE Curve_name = 'NDF UF/CLP' AND date = '{}' AND tenor = {}".format(
date, periodo)
UF_fwd = fs.get_val_sql_user(server="Puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query)
return UF_fwd
def get_fecha_habil_posterior(date):
query = "Select fecha from Fechas_habiles where id in (Select id+1 from Fechas_Habiles where fecha='AUTODATE')"
query=query.replace("AUTODATE", str(date))
fecha_habil_anterior = fs.get_val_sql_user(server="Puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query)
#retorno un datetime.date
return fecha_habil_anterior.date()
def get_tpm_and_icp(date):
date_ayer = utiles.get_fecha_habil_anterior(date)
date_ante_ayer = utiles.get_fecha_habil_anterior(date_ayer)
query_tpm = "Select Fecha, valor from Indices_Dinamica where Index_Id=459 and Fecha>='DATE_1' and Fecha<='DATE_2'"
query_tpm = query_tpm.replace('DATE_1',str(date_ante_ayer)).replace('DATE_2', str(date_ayer))
df_tpm = fs.get_frame_sql_user(server="puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query_tpm)
query_icp = "Select valor from Indices_Dinamica where Index_Id=4 and Fecha='DATE'"
query_icp = query_icp.replace('DATE', str(date))
print(query_icp)
icp = fs.get_val_sql_user(server="puyehue",
database="MesaInversiones",
username="******",
password="******",
query=query_icp)
return df_tpm, icp
