Alright anyone got a solution to bring spot gold price into Google sheets? Everybody wants a subscription for their api, none of the reg extracts I'm using are working, Google finance doesn't work, it's all fucked and I can't find a solution. Even chat gpt is stumped. I'll give a few sats for a working solution.
Discussion
If you can change over to online excel then MSFT provides a way to pull tickers in
GOOGLEFINANCE= Pulls in tickers but it's not working right now.
Does this not work?