Importing stock price from bloomberg to Google sheets

xml google-sheets stockquotes
xryxr picture xryxr · May 19, 2018 · Viewed 9.2k times · Source

I'm trying to import the stock price to my google sheets, unfortunately Google Financials dosen't support stocks from the Oslo Exchange at the moment. I have been browsing online, but none of the code examples works.

E.g.

=IMPORTXML(ʺhttps://www.bloomberg.com/quote/GJF:NOʺ,ʺ//span[@class='priceText__1853e8a5']ʺ)

Should supposedly

Anyone who has an suggestion on how I can make this work?

Answer

Peter picture Peter · Oct 12, 2018

ImportHTML works for me. This returns the USD Spot Gold price

=Round(Index(ImportHTML("http://www.bloomberg.com/markets/commodities/futures/metals/","table",1),4,3),2)

and this GBP/EUR

=round(Index(ImportHTML("http://www.bloomberg.com/markets/currencies/cross-rates","table",1),3,5),5)

ImportHTML needs page source, table on page and row/col coordinates

Related questions

How do I comment out a block of tags in XML?

How do I comment out a block of tags in XML? I.e. How can I comment out <staticText> and everything inside it, in the code below? <detail> <band height="20"> <staticText> <…

Read More
Text editor to open big (giant, huge, large) text files

I mean 100+ MB big; such text files can push the envelope of editors. I need to look through a large XML file, but cannot if the editor is buggy. Any suggestions?

Read More
How do I parse XML in Python?

I have many rows in a database that contains XML and I'm trying to write a Python script to count instances of a particular node attribute. My tree looks like: <foo> <bar> <type foobar="1"/> &…

Read More