Untitled

def retira_correl(formulas, ini, fim):
    meses = np.arange(ini, fim + 1)
    txt_meses = tuple(meses)
    data_hoje = datetime.today().strftime('%Y%m%d')

    # Load correlations
    sql_string = \
        "SELECT id_formula1, id_formula2, valor, mes_aplic1, mes_aplic2 FROM (SELECT ufvv.*, ANO1*100+PRAZO1 AS MES_APLIC1, ANO2*100+PRAZO2 AS MES_APLIC2 \
            FROM UDM_FORMULADOR_VOLAT_VALOR ufvv \
                WHERE ID_VOLAT_TIPO = 6 \
                    AND to_date(DATA_CALCULO,'yyyymmdd') = to_date(" + data_hoje + ",'yyyymmdd') \
                        AND ID_FORMULA1 in " + str(formulas) + " \
                            AND ID_FORMULA2 in " + str(formulas) + ") \
                                WHERE MES_APLIC1 IN " + str(txt_meses) + " \
                                    AND MES_APLIC2 IN " + str(txt_meses)

    dados = db.retira_dados(sql_string)
    return dados, sql_string