auto_adjust failed with unsupported operand type(s) for /: 'str' and 'float'

[tyler-austin]

First off, awesome library! I am getting a lot of use out of it.

I got the following error when using this library:

Error:
auto_adjust failed with unsupported operand type(s) for /: 'str' and 'float'

Call to reproduce:

import yfinance as yf
from dateutil.relativedelta import relativedelta
from datetime import datetime

def calculate_period_return(stock, hist, start_date):
    """Helper function to calculate return for a given period."""
    try:
        period_hist = hist.loc[start_date:]
        if len(period_hist) > 0:
            period_return = ((hist['Close'].iloc[-1] / period_hist['Close'].iloc[0]) - 1) * 100
        else:
            period_return = np.nan
        return period_return
    except Exception as e:
        return np.nan


stock = yf.Ticker(ticker, session=session)
hist = stock.history(period="max")

end_date = datetime.now(pytz.UTC)
start_date = end_date - relativedelta(years=1)

calculate_period_return(stock, hist, start_date)

I believe the error is coming from here:

yfinance/yfinance/utils.py

Line 453 in 3fe87cb

ratio = (df["Adj Close"] / df["Close"]).to_numpy()

ratio = (df["Adj Close"] / df["Close"]).to_numpy()

Possible Fix:

# Convert columns to numeric, coercing errors to NaN if there are non-numeric values
df["Adj Close"] = pd.to_numeric(df["Adj Close"], errors='coerce')
df["Close"] = pd.to_numeric(df["Close"], errors='coerce')

# Perform the division and convert the result to a NumPy array
ratio = (df["Adj Close"] / df["Close"]).to_numpy()

# Optionally, you could also drop any rows where the conversion resulted in NaN values:
# df.dropna(subset=["Adj Close", "Close"], inplace=True)

[friesentyler]

Did you end up getting this fixed?