swaps_updater.md

---

title: swaps_updater.py

swaps_updater.py (LEGACY)

Exportava histórico de swap; não usado após 2023.

run(dst_file_path, source_swaps_path, swap_src_filename='historical_data.xlsx', is_develop_mode=False)

Faz copia da base historica de swap mantida pela carteira online. Nesse processo, fazemos padding para a carteira historica do global

Parameters:

Name	Type	Description	Default
dst_file_path	_type_		required
source_swaps_path	_type_	description	required
swap_src_filename	str	description. Defaults to "historical_data.xlsx".	'historical_data.xlsx'

Source code in source_bases/scripts/swaps_updater.py

def run(dst_file_path, source_swaps_path, swap_src_filename="historical_data.xlsx", is_develop_mode=False):
    """ Faz copia da base historica de swap mantida pela carteira online.
        Nesse processo, fazemos padding para a carteira historica do global

    Args:
        dst_file_path (_type_): 
        source_swaps_path (_type_): _description_
        swap_src_filename (str, optional): _description_. Defaults to "historical_data.xlsx".
    """
    logger.info("Obtendo base atualizada de swaps...")

    swap_data = pd.read_excel(os.path.join(source_swaps_path, swap_src_filename), engine="openpyxl")

    swap_data.columns = ["Date", "Fund", "Exposure", "USDBRL Chg", "Result", "Day", "Due", "Status"]

    swap_data["Date"] = swap_data["Date"].dt.date

    #base_sample = swap_data.loc[((swap_data["Date"] < dt.date(2022, 1, 26)) & (swap_data["Fund"] == "Mangalarga"))].copy()
    #base_sample["Fund"] = "Global"
    #base_sample["Exposure"] = 0
    #base_sample["Result"] = 0
    #base_sample["Day"] = 0
    #base_sample["Due"] = ""
    #base_sample["Status"] = "ok"

    #swap_data = pd.concat([swap_data, base_sample])

    swap_data.to_excel(dst_file_path, index=False, sheet_name="swap")