Because the feed isn't structured in 

<parent>
    <child>
    <child>

I don't know how to pull out the data using importXML function. 

So right now I'm using  
=Importdata("https://www.igolder.com/GoldData.ashx?type=Historical&hours=24&currency=USD&tz=UTC&unit=oz&output=xml";)
 
and it displays both fields in 1 cell. 

It comes out looking like this - 
https://docs.google.com/spreadsheet/ccc?key=0Am6NbTgOWiSjdFhSUmZVMTRDTHNQTUtDNi1yRXVleWc#gid=0
 

I would like to separate them so I can display the price data (named Value) 
in 1 column and the date in another. 
Does anyone know how to do this either by extracting it from the column, or 
by properly extracting it from the XMLfeed?

Reply via email to