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.
View 1 Replies
ADVERTISEMENT
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.
View 3 Replies
View Related
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?
View 9 Replies
View Related
Apr 16, 2014
Is it possible in Excel 2013 to have one cell show current exchange rate of Euro to dollar?
View 1 Replies
View Related
Oct 25, 2011
There is a database of rates, stored in an excel table. There are dates (in the format MMYY) and corresponding currencies (100 in total)
I would like to have a custom function where I could type
=RATELOOKUP("EUR","0911")
And the corresponding rate will appear
The excel file with the rates is stored read only in a locked folder on the network so the format and layout will not be affected
How could I macro this? - then turn the result into an addin so that everybody can take advantage of this.
View 9 Replies
View Related
Aug 15, 2007
formula is needed to get excel to calculate all A rates seperate from B rates and C rates example 10 A rates @ 50.00 9 B rates @ 40.00 and 6 C rates @ 30.00 so although the rates could be mixed up (not following in any particular order the result which I would like to appear on a separate spreadsheet would be A = 500.00 B = 405.00 C = 180.00 then to get them to total up = £1085.00
A 50.00
B 40.00 then separate sheet with answer a 100.00 b 40.00 c 60.00
A 50.00
C 30.00
C 30.00
View 9 Replies
View Related
Jul 30, 2012
I have two worksheets in which I am trying to get the blue bold data (not text) derived from a formula.
Main
A
B
C
1
Site #
First Apt Date
Last Apt Date
[Code]....
Apt Report (month/day/year)
A
B
1
Site #
Apt Date
2
1001
[Code]....
I have some restrictions:
I cannot alter the format of Main, except I can add columnsI cannot alter at all the data or format on Apt Report (I cannot sort, filter, pivot, add columns...etc)
Any way for Main to look at Apt Report and give me the earliest and latest appointment?
I have tried the DMIN function but am limited it seems to being able to change Main to accommodate it. I have tried an array with MIN(If but ran into issues with the cells on Apt Report that are blank...it would return those as the earliest appointment....albeit it is correct...but not what I need!!!
The Apt Report will continually be updated to, so I need to be able to search the entire Apt Date column.
View 5 Replies
View Related
Mar 11, 2012
How to make EXCEL 2007 Automatically convert all my CURRENCY symbols in all cells formatted for CURRENCY in THE SAME SHEET to the one and ONLY currency selected in JUST ONE cell ? (i mean, after conversion, all of them are Not just display currency symbols, but Calculable monetary values like regular Excel's built-in currency format)
I am a dummy in VBA so I really am not familiar at all if the solution is really one of VBA. I don't even know how to start programming VBA at all in Excel.
View 3 Replies
View Related
Apr 23, 2009
I have several rows which lists different currencies - USD, GBP, EURO, JPY etc.,
A1 usd 5000
A2 GBP 7000
A3 USD 3400
A4 EUR 12000
A5 JPY 89000
A6 EUR 1000
At the bottom I want to show the total of each currency separtely.
View 13 Replies
View Related
Jul 11, 2007
i am trying to both identify the start date and the end date of a series in excel.
if you will, picture a spreadsheet with two rows with data. the top row is comprised of dates in mm/dd/yy (end of month) format. the bottom line is percentages . . . a corresponding % for each date directly above. these percentages add to 100%. in two separate formulas, I would like to identify:
1. the date in which the first %>0 occurs (start date)
2. the date in which the cumulative addition of all months %'s equate to 100% or the date in which the last %>0 occurs (end date)
keep in mind many if not most of the %'s will be 0%.
View 13 Replies
View Related
Sep 24, 2009
I have a spreadsheet that lists items in column A with a start date in column B. What I need to do is in in column C list the next review date in increments of 5 days, but I only want the next day to show from the current date, not the inputted start date.
For example:
Column A Column B Column C
Item Start Date Next Review Date
Item A 12-Sept-09 27-Sep-09
Can I get a formula to calculate the increments and only show the next calendar date for the review, and then to change to the next date once the previous date has passed.
Alternatively, I have another sheet in my workbook that calculates the dates, is there some way I can display the next future date in a line of dates?
View 5 Replies
View Related
May 19, 2014
How to get "only Sunday" highlighted in a series of dates included in excel columns. I tried some formulas found from the web pages, but they all deal with both "Saturday and Sunday"...
View 6 Replies
View Related
Nov 12, 2008
My intentions are for Excel to recognize a series of dates as a particular week in the year. For example: 12/28/2008 thru 1/3/2009 equals Week 1, 1/4/2009 thru 1/10/09 equals Week 2.
I cannot for the life of me calculate a working formula.
View 7 Replies
View Related
Aug 9, 2008
i have a time series of data at one hour interval ( from 6:00 hrs to 18:00 hrs ) each day and again from 6:00 to 18:00 hrs next day and so on for several years. in this series many data are missing. i ve to fill in these missing data in such a manner so that the new values becomes the linearly interpolated values in between the data given at any two hours. no rows are allowed to be inserted in between 18:00 hrs of the previous day to 6:00 hrs on the next day. pl see the attatchment.
View 2 Replies
View Related
Oct 8, 2013
I have a database where I would like to plot graphs from data of different periods and different series.
My current method is to go to the data set formulas and changing data range. The tricky part is that I might skip data series because I am selecting the series required for each chart.
How to do plot the different graphs efficiently and quickly.
View 2 Replies
View Related
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?
View 9 Replies
View Related
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..
View 2 Replies
View Related
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?
View 3 Replies
View Related
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.
View 2 Replies
View Related
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.
View 9 Replies
View Related
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.
View 10 Replies
View Related
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.
View 5 Replies
View Related
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:
View 5 Replies
View Related
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?
View 6 Replies
View Related
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
View 9 Replies
View Related
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?
View 6 Replies
View Related
Jun 24, 2008
i have a bunch ofdaily rates back from 2005. sometimes ill have one or even 2 or 3 missing rates in a row. when there is a blank rate, i just want excel to calculate the average of the date below and the date after. right now, ive just been going manually to each missing date's rate and calculating the average.
View 9 Replies
View Related
Aug 4, 2014
I run a large simulation experiment. I have a loop plotting data in excel of a user defined area. Because of the limit of 255 series I have allowed a maximum of 250 simulations (they all need to be plotted). But the length of each simulation is free. I know there is a limit of 32.000 data points in a graph and I have this as a condition too.
If I set the data range to 100 columns and 3000 rows the graph is produced when I plot by columns. (code below)
But if I set the data range to 250 columns and 1000 rows I get the above mentioned error message. Even though I only have 250 series.
After the data is plotted it is the code below that gets the error:
[Code] .....
View 1 Replies
View Related
Dec 22, 2011
I have the following code:
Sub Macro5()
ActiveSheet.ChartObjects("Chart 243").Activate
ActiveSheet.ChartObjects("Chart 243").Activate
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SeriesCollection(2).Delete
End Sub
However, if there is no SereisCollection(1) actually present in the chart I get an error. How can I work around this? I will need an IF statement I assume, just not sure what it will look like.
View 4 Replies
View Related
May 31, 2008
I just recently installed Excel 2007 and I would like to know if it's possible to change all data points of a chart at the same time. In Excel 2003, I would normally hold down shift while clicking on each of the data points to make a global change. However, it appears I cannot do that in 2007.
I would like to display each data point's series name. When I go to Layout on the Excel Ribbon, and click on "Data Labels", and click on "More Data Label Options", the actual Y-axis values are shown for each data point. However, I do not want this - I actually only want the Series Name, but when I uncheck "Value" and check "Series Name" instead (under "Label Contains"), it only changes it for one of the series. Is there a better way, instead of going through each and every single series to make this change?
View 4 Replies
View Related