View Single Post
Old 10-11-2017, 03:05 PM   #43
bobbytkc
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
cant seem to get this to work..

formula entered in cell G2

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

Cell F2 i enter Bloomberg code for M1 - M1:SP

i'm getting Error Imported content is empty.

Just key in M1, not M1:SP
bobbytkc is offline   Reply With Quote