exchange rates

  1. ca.moazzam

    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. M

    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. N

    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. M

    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. J

    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. S

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top