 Hey guys, welcome back to my YouTube channel. This is Daniel Rosal here. I did a video a few months ago about how to convert currencies using Google Finance. Now this I think is really, really useful and the video is a little bit long so I'm doing it again just to really cut to the chaser. So here is a real world Google Sheet I'm building. Google Sheet of course is an online spreadsheet program part of the Google ecosystem and what I'm doing here is I'm looking at buying a camcorder Canon XA40. I'm going to be in the US in the summer. I'm going to be here now and because this is a somewhat major 6, 7,000 shackle purchase I want to just do my research and see what the different prices are and because I'm looking at buying this also in the US potentially I want to just see what the price difference is there. So I have added a couple of quotes from Israeli websites here and the prices as you can see are as follows 6,649 shackles 5683. Now in order to convert to a different currency whether we're talking you know dollars or pine sterling or euro whatever it would clearly be stupid to do it one by one right. Now what you might think to do is look up today's exchange rate and just apply that to the row the column and there's actually a better way again to do it that's using Google Finance. So the beauty of this Google Finance you're going to be actually calling their API and that means that it's going to be pulling in because it's part of the Google ECO system it's going to be pulling in the live exchange rate and that means that this Google Sheet is going to update automatically. So anytime you go into it you're going to be getting the latest exchange rates and the correct figure. So here's how it works. So firstly for this cell E2 I'm going to be multiplying by equals D2 then multiplied by now open brackets here Google Finance then you want to open another bracket and it goes like this currency colon origin currency is going to be ILS for origin currency first and we're converting to USD close that bracket and wait for it to work and there you go so that is 6,649 and the great thing with Google Sheets is you can just drag like this and you can see so even if I had 20 it would just go and apply another thing I like to do is just to reduce the decimal places and you can also just do that so we only need to know it to the nearest dollar. So this is working now and as the dollar to or shackle to dollar exchange rate fluctuates Google Finance is going to pull this automatically into our Google Sheet and keep it updated so super useful if you're doing some kind of financial work price comparison involving different currencies to know about this so the methodology one more time I'm just going to copy this in from an article I wrote previously it's Google Finance open brackets currency colon and then you can look up these three letter symbols for currencies in Google Finance documentation but they're usually pretty intuitive like euro is eru British Pounds is GBP etc but if you're unclear you can look those up and then you just close off the brackets hope this video is useful thank you guys for watching