# Insert Live Exchange Rate?

Jul 14, 2010

I work with different currencies in my company, now I would to get an up to date state of the cask book. So I have \$250, and 500EUR, now I want a formula (connecting to internet) that automatically multiplies the \$250 with the current exchange rate, so I know how much I have in Euros in total.

## Change SUMPRODUCT To IF With Exchange Rate

Mar 31, 2009

As you can see in the attached sample file, I have different currencies, that all need to be converted to USD.

The exchange rate are displayed on sheet 2.

Currently the formula just picks all values without considering the exchange rate to USD. What I need to have, is a formula which, based on the currency, picks the correct exchange rate and outputs USD.

Apart from that, another thing the formula should consider is the value of G1 in sheet 2. With G1, the user can later define a specific type to be calculated by simply pressing down the button and chose either FG or RM.

The formula needs to:

Find out what currency the value is in and automatically convert it to USD via the exchange rate values. It also needs to consider the value of G1 in sheet 2 in order to filter out the other values. If, for example G1 is FG, then only FG should be taken into the process and therefore only values where type FG is marked.

## Range Value: Change The Exchange Rate

Dec 21, 2009

I have a financial sensitivity sheet setup by year, where for example below each year is a cell you can change the exchange rate in and it effects the outcome of cash flow as these cells are linked to part of the finances. Then I have a "reset" button setup that is assigned to a macro. When you click the reset button all cells in the exchange rate row will be changed to a value that is entered in a "base case" cell. That way various years can be changed but also everything can be set back to the default or base case. My macro for that case is this:

## USD Equivalent In Column Based On The Exchange Rate At The Time

May 24, 2007

Dates in Column A
Currency in Column B (expressed as EUR, CHF or GBP)
Amount in Column C

And I'm trying to get the USD equivalent in column D based on the exchange rate at the time.

In Sheet 2 I have a table of the historical exchange rates like this:

DateEURGBPCHF
08/05/20060.786270.538151.2277
09/05/20060.784470.536751.2224
10/05/20060.781360.536271.2185
11/05/20060.778050.530761.2108
12/05/20060.775880.528811.2019
15/05/20060.779780.530911.2089

## EXCEL 2013 :: Show Currency Exchange Rate In One Cell

Apr 16, 2014

Is it possible in Excel 2013 to have one cell show current exchange rate of Euro to dollar?

## Conditional Divide (probs Occur When I Manually Enters The Exchange Rate)

Sep 25, 2007

The file is a simple sheet which upon entering the actual/Invoice cost (C5), calculates the estimated landing/final cost (C8).

In between the process involves changing the currency from US\$ to PKR, make some calculations, and changing back the currency again to US\$.

The default rate of currency exchange is set to ave 60 (C12). However if the user knows the current rate he can put it manually in C6 and sheet will make all the calcs on this instead of using the default rate.

Problem:
Everything is working just too perfect. But probs occur when i manually enters the exchange rate.

It does successfully changes the US\$ to PKR and calculates everything perfectly but doesnt reverts the final cost back to US\$ successfully instead it keeps using the default value instead of user's value

## Compound Rate: Annual Growth Rate %

Jun 4, 2007

The formula I am looking for would tell me what annual growth rate % I would need to achieve to make any investment reach a set target, for instance, what % of fixed annual growth would I need to make 200K grow to 750k in say 10 yrs or any time scale. I was given the formula below but Excel tells me it's wrong, I have tried putting 10 before ^ and the 10 after but to no avail, could some kind soul please put me straight.

r = 100((Y/X)^(1/n))-1)

So for X = 200, Y = 750, n = 10, we have

r = 100((750/200)^(0.1))-1) = 14.1309%

## How To Calculate Trend Line Growth Rate (as Annual Percentage Growth Rate)

Feb 13, 2014

From a chart in Excel I need to automatically calculate what the annual percentage growth rate is of a trend line. How to automate this in Excel? I've attached a sample so you can see what I'm trying to accomplish.

## First Last Name Exchange

Dec 19, 2007

I have a large employee spreadsheet list with first name then last name in the same cell. Is there a formula that will change the order so it will read last name, first name?

## Exchange Data Between Cells?

Dec 11, 2012

I wanted to exchange data between two cells. i.e if i have mistakenly put one value of A1 in A2 and A2 in A1. How can I exchange it. I am asking this bec by copy paste method one cell is overwritten so the value of that data is lost.

e.g A1 has value 200 but the correct value is 150
A2 has value 150 but the correct value is 200

How can i exchange/swap the values between the two cells..

## Exchange Text In A Cell

Sep 4, 2013

Is possible exchange text in a cell like this "street San Miguel de Allende-Cp 4780 031 1304" to "street San Miguel de Allende, 1304 -Cp 4780 031". how to do this?

## Exchange Data Between Workbooks

Dec 14, 2009

Is it possible when i am in my current workbook to refer to the value in another cell in another workbook within a formula?

Example:

I have a workbook named "Sample1.xls" that contains a spreadsheet "revenue" and in cell C24 is the value that i want to have in my current workbook.

## Exchange A Number For A Letter Forumla

Aug 8, 2009

I have a sheet which calculates payment amounts.

Column titles:
Hours | Rate of Pay | Total

In the hours column usually the entries consist of numbers and everything works fine. However when an employee is on holiday they are still paid.

What I want to do is be able to enter the letter "H" for one of the entries in the hours column. The sheet to translate this as 2 hours.

H=2 x rate of pay = total

I cannot for the life of me get the correct formula to in order to achieve this. I don't particularly want to use a macro for this and others have suggested the "COUNTIF" function.

## How To Keep Track Of Changes In Prices Imported From Exchange

Sep 30, 2013

I work with a broker that have an API function and all the prices goes directly to an Excel Sheet.

What I want is a way to keep track of this prices in a new sheet, as they change. Like a historical price.

Is there any way that excel can do it for me?

## Aligning Two Series Of Currency Exchange Rates With Different Dates?

Nov 28, 2013

I have two different columns of currency time series data with dates that do not align. One trades Monday-Friday, the other seven days a week.

I want to either a) add dates to the shorter series that only trades Monday - Friday (and just use the closing price on Friday for the Saturday and Sunday dates)

b) (not as good an option, as I will lose data) is delete the Saturday and Sunday data from the longer series that trades on the weekend.

## Post Spreadsheet To Microsoft Exchange Public Folder

Sep 18, 2006

I'm looking at publishing a number of spreadsheets to the Public Folders section on our local Microsoft Exchange Server.

In Excel I can select File > Send To > Exchange Folder...
but I was wondering if there is a way to automate this in a macro?
I would also like to specify a folder it should be posted?

## Macro To Access A Website And Copy Exchange Rates

Jan 25, 2007

My task is to somehow access [url] and copy the exchange rates on the table to my Excel workbook. Obviously a macro will not record outside of the Excel program, so I am just wondering if this is possible at all (without hacking of course). My plan B is to have the user manually enter the exchange rates.

Jan 26, 2012

I wanted to know how to download live data (stock data from a a website) through VBA.

## How To Capture The Value From A Running Live Value

Jun 9, 2008

I have a cell (for example, "A1") which is inserted with a WINROS formula to retrieve some data into my spreadsheet. And it is running live at all time.

Actually, I can't think of any formulas to capture the value from cell "A1" to "B1". Because I do not want the value that I captured into cell "B1" running live. I just want the value "B1" fixed after captured.

## Consolidating Live Tables

Nov 26, 2008

I have two tables that pull data from two different SQL tables via an ODBC connection and refresh every 5 minutes. The table headers etc are all identical (it is support call information FYI) but what I want to do is display those tables as one as opposed to two seperate tables - can this be done relatively easily and hopefully without the use of VBA? (Unless anyone is willing to provide the code of course!!)

## Logging Live Data

Nov 30, 2008

I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.

## How To Get An Actual Live Clock

Nov 29, 2009

I am looking to get a Live Clock changing every minute..

Lets say I put the Total Time in the Cell A2 = 15 minutes and I have a Command Button next to it "Start"..

On the Click Event I want the Actual Time time-stamped at that moment in the Cell A3 and in Cell A4 the Time should keep on Ticking...

Can someone attach a file in Windows 2003 i.e .xls format and also explain the code if possible.

## Live Currency Rates

Dec 7, 2006

I know that Excel has a function to import currnecy rates from the MSN Money web site. But MSN Money doesn't support all currencies. I would like to build an excel sheet where a user can maintain the currency codes and the currency rate is being fetched from the internet. Does anybody have a suggestion from where I could get currency rates into Excel?

## Creating List With Live Numbering

Apr 11, 2014

I have a spreadsheet set up in the following way;

Excel Sheet Set Up.JPG

What I'm trying to replicate in column A is similar to the live bullet point numbering that can be found in Word documents where if a line is deleted the section numbering (think bullet points in Word) automatically fall into line and update i.e what was 1.4 automatically becomes 1.3 and so on.

So far I've tried the simple formula of = cell above +0.1 which works fine until i have to remove lines.

## Display Live Internet Data

Jun 19, 2009

eg having a live rate of intrest or exchange rate from the internet that is updated live whenever you load up excel and you are connceted to the intenet.

## Split Buy And Sell From Live Feed

Jan 17, 2014

I am not good at excel. I would like to split buy and sell orders from the live feed and updating when new feeds come in.

LIVE FEED
B 4150
S 6200
S 4300 CHANGE TO
B 3350 B 4 150
B 2180 B 3 350 S 6 200
S 2220 B 2 180 S 4 300
B 1120 B 1 120 S 2 220

## Formula Or Macro: Live Search Name

Jan 21, 2009

i try create formula or macro, which will search in data during writing in cell.
F.e. i have column
A
1 dano black
2 dodo red
3 phil blue
4 black jack

I want something, what will be look in this column "A" up, during my writting in cell B1 and show results in C1. When i write „b“, it will show in B1 „dano black“, if i add „l“ (it will be written „bl“), it shown again „dano black“. If i add „u“ (it will be written „blu“) , it shows „phil blue“

## Removing Noise From Live List?

Apr 25, 2014

I'm attempting to remove erroneous noise from a list of data by removing 20% of the highest numbers in that list.

For example: I have 2000 pieces of data, summed. when a new piece of data is added, the last one drops off. This is a rolling sum. When seen on a graph, there are occasional spikes of erroneous readings, causing large fluctuations in the graph. Of the total 2000 peices of data, I want to find and remove the highest 20% (400) of them, leaving behind 80%. Removing those erroneous spikes would show a softer version of the original data when looked at in a graph.

This needs to be done in such a way as to allow me to do it continuously. If I add live data points, I want to be able to find and remove the highest 20% automatically, or by copying the contents of this cell.

## Counting Colours And Losing The Will To Live

Oct 20, 2008

I've got a function called countcolor (which I take no credit for) which counts a particular color in a range.
---------------------------------------------------------------------
Function CountColor(rColor As Range, rSumRange As Range)

Dim rCell As Range
Dim iCol As Integer
Dim vResult

iCol = rColor.Interior.ColorIndex

For Each rCell In rSumRange
If rCell.Interior.ColorIndex = iCol Then
vResult = vResult + 1
End If
Next rCell

CountColor = vResult
End Function

I have then set up a couple of macros which, when ran, fills a range of cells with a particular color. These colors are closely related but as you can see from the two macros below they ARE different. I'm finding my countcolor function is counting them twice though even though as you can see the color values are different.....
---------------------------------------------------------------------------
Sub pegcharged()
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 25600...........................

## Multiple Live Feed / Data

Aug 28, 2009

I have set an excel spreadsheet set up to update live data from a URL every 5 minutes. However I am wanting to do try and save a bit of time if possible.

Basically I am monitoring horses bought on a game website. Each horse has the same URL except for the number at the end which goes up in 1 increments. The URL is already set up and when the horse is bought it changes from being blank to having the horses details etc.

At the minute I am able to autofill cells with each uinique URL using fill, then series menu. This is so I dont have to manually enter each URL, as hundreds may be bought each day so it would take too long to do this.

My question is this, am i able to have a automatic series linked to the 'data from web' function in data tab, instead of having to manually adjusting each URL for each individual horse.