# currencies

1. ### LME copper in Excel

Is there a nice easy way to get copper prices into excel? (the London metal exchange numbers) ie these here https://www.lme.com/Metals/Non-ferrous/LME-Copper#Trading+day+summary or Copper Prices - 45 Year Historical Chart current price Excel has the functionality for Stocks and Currencies built...
2. ### Totaling of different currencies in a column separately

Dear Experts, I have a range of currencies in a single column, I want to have totals currency wise separately. the example values are given below. I want the 3 currencies totals separately in another column. <colgroup><col></colgroup><tbody> GBP 428.00 GBP 264.11 GBP...
3. ### SUM of different currencies in single column, SUM of filtered data with criteria.

Hi every one, I'm preparing a database for my company's sales data. we deal in different currencies, but I want all the accounting values of one category in single column. This led to having different currencies in single column. Also I have categorized data into fiscal quarters with a formula...
4. ### Currency Calculator

Hello! I want to make a currency calculator in Excel but not quite sure how to do it. Basically, I want 2 sheets. The first sheet is where I can calculate the currencies and the second sheet where the data is located. So in the first sheet, I have a drop down for types of currencies (USD, BHD...
5. ### Adding Columns with Various Currencies

Hi All, I have quite a few tabs, I need to go into each one and add a "Total" column at the end. However my problem is I want to separate the currencies so if column A =EUR AND B has the corresponding value, I want to place this into a column marked "Total EUR", how is this done as there are a...
6. ### How to get live exchange rate data in excel using Oanda?

Hi all, I have a number of currencies (all the currencies that are mentioned in Oanda's currency converter dropdown) in hand and I want to convert those in USD. This I need to do every day from the currency converter page of Oanda. Is there any way I can automate the task? I tried some of the...
7. ### help with workbook-wide cell formatting

Good day, I have been looking for a solution existing on the forums but have come up empty handed. I am looking for VBA code (from my understanding) in order to replace all cells within worksheets of my choosing with a different format, and vice-versa. Detail: I have financials and models...
8. ### Noob - Create a UDF for currency conversion with VBA only - no external connections

I am a beginner in VBA</SPAN> The main objective is to create a, UDF with 2 parameters (Currency, Date) in order to display currency exchange rate based on the currency and date. Let’s say I want to find an exchange rate between USD/ EUR, then I would have a formula something like “=FX(EUR...
9. ### 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