forex

  1. K

    Excel forex formula help needed

    Soo, I have this worksheet as seen in the attached picture. Basically, I have this table with live exchange rates that refresh every minute. The exchange rate data is sourced from a website. The only relevant exchange rate from the table is the EUR/USD. On the left-hand side We have the current...
  2. P

    Trying to make a formula to calculate the Profit and Lose in Forex trades.

    Hello Dears, As in image above : i am trying to make a formula for column J and K: - As in column "J" i need the Pips In Lose to be calculated in case i type "L" in column "I" - As in column "K" i need the Pips in Profit to be calculated in case i type "P" in column "I" - In column "I" when i...
  3. S

    Downloading Forex Data

    Can anyone suggest a site for free downloads of historical Forex data into Excel? A year or two ago I got it from Oanda.com, but they now charge, and the code I found on the web to download their data doesn't work, even for the amount of data they provide for free. Thanks in advance
  4. S

    Lookup based on two reference and then FX conversion

    To whom it may concern, I am having a problem for a couple of weeks now wherein I am trying to find the Match of Table C to Table based on CF General and Dates, and then convert them to USD. I have been using a couple of combination of formulas (Vlookup, SUMIF, Substitute) in the formula bar...
  5. A

    Import exchange rates in 1 cell only

    Hello everyone, I was trying to figure out the way of how to import only one exchange rate instead of the table. One excel VBA function popped in into my mind but it stopped working since Yahoo changed structure of their link. Function FXRate(currency1 As String, currency2 As String, rateType...
  6. M

    Automatically Insert Daily Forex Data in Excel

    Hi everyone, I'm in the process of building a huge forex database in excel for my own analysis purposes. I have collected the past 30 years forex data for top four currency pairs! I would also like to keep the database up-to-date with daily forex information such as, opening, closing, high, low...
  7. 7

    Automatically copy cells value and paste into next available empty cell

    Hi, Cell range in Sheet1 -- A1 : A15 updates value with forex rate every minute, linked with a DDE external data link. . Need to copy each cell value and paste into Sheet2 rows starting from A1:A15 next available empty cell every 5 minutes. . Example: Sheet1/A1 value should be copy/paste to...
  8. 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...

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top