I am new to ZOHO CRM

I have a field named Dollar in a new price list module I created. And I want to update it each time by the creation date of the record. I have an address:

Http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.xchange where pair in ("USDILS") & env = store: //datatables.org/alltableswithkeys

Which returns me to XML.

this way:

<Query xmlns: yahoo = "http: En-US ">

<Results>

<Rate id = "USDEUR">

<Name> USD / EUR </ Name>

<Rate> 0.8923 </ Rate>

<Date> 6/19/2017 </ Date>

<Time> 11:42 am </ Time>

<Ask> 0.8928 </ Ask>

<Bid> 0.8923 </ Bid>

</ Rate>

</ Results>

</ Query>

I want to extract the XML from the value in the <Rate> tag and update it in the Dollar field in my Price List module.

What is the easy way?