# Instala pandas en el entorno de Python usado por reticulate
reticulate::py_install("pandas")

## Using virtual environment "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs" ...

## + "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs/Scripts/python.exe" -m pip install --upgrade --no-user pandas

# Instala matplotlib en el entorno actual de reticulate
reticulate::py_install("matplotlib")

## Using virtual environment "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs" ...

## + "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs/Scripts/python.exe" -m pip install --upgrade --no-user matplotlib

# Instala yfinance en el entorno de Python que reticulate está usando
reticulate::py_install("yfinance")

## Using virtual environment "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs" ...

## + "C:/Users/fmartinez/AppData/Local/R/cache/R/reticulate/uv/cache/archive-v0/L5cyX8ObtxYeIqWmda_cs/Scripts/python.exe" -m pip install --upgrade --no-user yfinance

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime
import yfinance as yf

# Descargar TRM histórica desde Yahoo Finance
start_date = "2010-01-01"
end_date = "2024-12-31"
symbol = "USDCOP=X"  # Tasa COP/USD

trm_data = yf.download(symbol, start=start_date, end=end_date)

## YF.download() has changed argument auto_adjust default to True
## [*********************100%***********************]  1 of 1 completed

trm_data = trm_data['Close'].dropna()
trm_data.name = "TRM"
print(trm_data.head())

## Ticker         USDCOP=X
## Date                   
## 2010-01-04  2020.900024
## 2010-01-05  1987.000000
## 2010-01-06  1970.500000
## 2010-01-07  1936.800049
## 2010-01-08  1936.900024