Google sheet importxml xpath query -

Google sheet importxml xpath query -

i'm trying info "next earnings announcement" http://www.bloomberg.com/quote/1880:hk site.

i have tried

=importxml( "http://www.bloomberg.com/quote/1880:hk", "//span[@class='company_stat']" )

=importxml( "http://www.bloomberg.com/quote/1880:hk", "/html/body/div[2]/div[1]/div[1]/div[2]/div[2]/div[2]/div[1]/div[1]/div[3]/table/tbody/tr[16]/td/text()" )

getting #n/a, want 10/27/2014 result

instead of fragile, horribly complicated xpath expression, seek useful one:

class="lang-none prettyprint-override">//th[normalize-space() = 'next earnings announcement']/following-sibling::td

xpath google-spreadsheet