# exchange rates

1. ### Refresh exchange rates from Bank of Canada site in Excel file?

Hello all, Bank of Canada recently redesigned its website from which I used to pull daily exchange rates and now refreshing my file doesn't work any more. I now need to first specify the currencies I need along with my target date on the new site and then it displays the target rates. If I...
2. ### Calculate a total in the same cell as one of the values

Hi there, I'm trying to calculate an updated cost based on an updated exchange rate (example below) I want to be able to multiply Cell A6 * Cell A2 but keep the solution in Cell A6. The same applies for Cell B6 * Cell B2 etc I have thousands of Costs that need to be applied with the rate and...
3. ### Historical exchange rates

Is there a way to get the historical exchange rates for the dates I have entered in powerbi, so that when there are new dates entered, the exchange rate is automatically placed for that date? I need it to be daily. I tried using json, but it only lets me specify the dates manually, and I need...
4. ### VBA solution for currency change in different columns

Hi guys, wondering if someone could help me get a VBA solution for my currency exchange to different currencies. I am travelling to different countries so I am expending money in different currencies, however, I'd like to have a column where I can see how much did I pay in USD. This is an...
5. ### Bloomberg Historical FX Rate

Hi, I'm trying to pull historical data for a currency pair from bloomberg at a single point in time, but I keep receiving an "#N/A History" error or the values appear as 0. The formula I currently have is: =BLPIT("USDGBP Curncy","Last_Price","15/07/10 15:00") If anyone could help me on this...
6. ### Looking for Currency Exchange Formulas/Spreadsheets

I have an account where the client buys and sells Euros and Dollars on a regular basis. This would be simple enough to track except I have to keep track of the original inventories exchange rate. Let's say an original purchase of 100,000 Euros is at 1.5% (to the Dollar). The client then...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back