FILTERXML function
Summary
Returns specific data from the XML content by using the specified XPath This function is not available in Excel for the web.
Syntax
FILTERXML(xml, xpath)
The FILTERXML function syntax has the following arguments.
xml Required | A string in valid XML format
xpath Required | A string in standard XPath format
Notes:
If xml is not valid, FILTERXML returns the #VALUE! error value.
If xml contains a namespace with a prefix that is not valid, FILTERXML returns the #VALUE! error value.
xml Required | A string in valid XML format
xpath Required | A string in standard XPath format
Notes:
If xml is not valid, FILTERXML returns the #VALUE! error value.
If xml contains a namespace with a prefix that is not valid, FILTERXML returns the #VALUE! error value.
Example
=WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2))
=FILTERXML(WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2)),"//QuoteApiModel/Data/LastPrice")
=FILTERXML(WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2)),"//QuoteApiModel/Data/LastPrice")