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.
Does this not work?
https://investexcel.net/live-gold-spot-price-excel/
Please Login to reply.
This is exactly what GOOGLEFINANCE= does in sheets. But right now the ticker price is pulling back NA. It might work a bit later but right now it's not working.
stockhistory func works