View Single Post
Old 12-11-2017, 01:01 AM   #44
apriliasiao
Supremacy Member
 
apriliasiao's Avatar
 
Join Date: Dec 2001
Posts: 6,466
Just key in M1, not M1:SP
can you give an example of the working strings? i tried many combo but didnt work like that 1 below since :SP is not needed.

=IMPORTXML("http://www.bloomberg.com/quote/"M1","//div[@class='price']")

i have also tried putting M1 in F3 cell and your code =IMPORTXML("http://www.bloomberg.com/quote/"&F3&":SP","//div[@class='price']") in another cell.
Dint work too.

I notice that Bloomberg is using https instead of http which is in your code.

Last edited by apriliasiao; 12-11-2017 at 01:56 AM..
apriliasiao is offline   Reply With Quote