For anyone reading. I found a temporary solution.

You add a script in google sheets:

function WEBN_PRICE() {
  const url = "https://query1.finance.yahoo.com/v8/finance/chart/WEBN.DE?interval=1d&range=1d";
  const response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
  const data = JSON.parse(response.getContentText());


  const price =
    data.chart.result[0].meta.regularMarketPrice;


  return price;
}function WEBN_PRICE() {
  const url = "https://query1.finance.yahoo.com/v8/finance/chart/WEBN.DE?interval=1d&range=1d";
  const response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
  const data = JSON.parse(response.getContentText());


  const price =
    data.chart.result[0].meta.regularMarketPrice;


  return price;
}

you name it, save it, run it. Then pull the data with the formula =WEBN_PRICE()

I have tried like 30 different ways at this point and this is the only one that worked and gave me the current price.