Xml query

Hi Rohan, thanks for your query. If you just want to alter the date in that url string simply use some concatenation:

In cell a1:

="http://www.bmreports.com/bsp/additional/soapfunctions.php?output=XML&dT="

a2

<your date>

a3

= "&element=SYSPRICE&submit=Invoke"

Then in A4:

= A1 & A2 & A3

Hope this helps,

Anthony