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?