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¤cy=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?