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.

Reply to this note

Please Login to reply.

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.

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