Get gold and silver price into spreadsheet?

[MikeIOW]

New to libre office, so be gentle!
I have installed the financials .oxt extension, and that helped me get stock tickers into my worksheet.

However, I am struggling to figure out how to get the current spot price for gold & silver into a cell.
My old google sheet had me use this form to scrape a table from a web page:
=IFERROR(__xludf.dummyfunction(“ImportHTML(”“https://bullionbypost.co.uk”","“table”",1)"),"")

I’m not clear how to achieve the same (or even better, just find the price).
I know it is on Yahoo at Gold Apr 25 (GC=F) stock price, news, quote and history - Yahoo Finance, but treating that the same as a stock, like I did for =GETREALTIME(“BNC.L”,21,“YAHOO”), doesn’t work.

Any top tips please?

[Villeroy]

https://help.libreoffice.org/25.2/en-US/text/scalc/01/func_webservice.html?System=UNIX&DbPAR=CALC&HID=SC_HID_FUNC_ENCODEURL#bm_id121517132649769

[MikeIOW]

Not clear to me how that helps?

[DTSA2428]

I have the same issues. Want to use a metals-api and Webservice and cannot seem to get it to work. Tried all different syntax but still getting errors.

=WEBSERVICE(“https://www.goldapi.io/api/XAU/USD?access_key=goldapiSSSSSSSSS-io”)

Very new to Libre

[mariosv]

Menu>Sheet>External Links.

[DTSA2428]

Thanks… But cannot find any link that will populate the tables/ranges?