Get the gold price into Excel with Power Query, without writing code or getting an API key. Prices are 15 minutes late without a key and on Free.
1. Open the web connection
In Excel for Windows, choose Data → Get Data → From Web. Paste the keyless URL shown below. If Excel asks how to connect, choose Anonymous.
https://api.goldprice.dev/v1/prices?symbol=XAU-USD-SPOT2. Convert the JSON to a table
Power Query parses the JSON. Choose To Table to continue.
3. Keep the price and timestamp
Expand symbols, then keep price and computed_at.
4. Load the result
Change price to a decimal number, then choose Close & Load.
5. Refresh the price
Use Refresh All to fetch the price again. Keyless access allows 10 requests a minute and 100 an hour per IP.