Stack Overflow
Stack Overflow

Questions tagged [currency-exchange-rates]

For questions relating to issues dealing with currency exchange rates. Examples include reaching currency exchange API services, converting data, historical analyses of international financial data, etc.

108 questions
52
votes
7 answers

On Google Spreadsheet how can you query 'GoogleFinance' for a past exchange rate?

I'd like to know if it is possible to query a past exchange rate on Google Spreadsheet. For example; using formula =GoogleFinance("CURRENCY:USDEUR") will return the USD/EUR rate at this present moment. How can you retrieve a historic rate?
antr
  • 867
  • 1
  • 9
  • 19
43
votes
2 answers

Multi currency - what to store and when to convert?

I have read different Q&A on SO regarding multi currency but none of them are clear to me or do not provide enough details with regards to my use case. Scenario: Company Raddo has 3 branch locations, UK, France and USA. Raddo has base currency US…
Iffi
  • 463
  • 1
  • 4
  • 11
12
votes
2 answers

Issue with Google Finance in Google Sheets for Currency Exchange Rates

I am using the GOOGLEFINANCE() function in google sheets to get an exchange rate for expenses I am entering in for accounting. The issue is that sometimes I get an #N/A error with the message When evaluating GOOGLEFINANCE, the query for the symbol:…
Catu
  • 715
  • 1
  • 6
  • 13
11
votes
3 answers

In a currency exchange rate what is the maximum number of decimal places used?

I need to store currency exchange rate data in the SQL 2008 database. I would like to keep rate as a decimal data type in the database. One thing I am not sure about, is how many decimal places to give (e.g. decimal(18, ?)). Since, I will be using…
mikhail-t
  • 4,103
  • 7
  • 36
  • 56
6
votes
2 answers

Common sense when storing currencies?

After reading up on how to best handle users in multiple timezones properly, I've learned that the way to go is to store all dates in an normalized, application-wide timezone - UTC and then apply the diff between the normalized timezone and the…
Industrial
  • 41,400
  • 69
  • 194
  • 289
4
votes
7 answers

Google currency converter no longer working

It appears that Google Finance Currency Converter has stopped working altogether. A week ago I started getting these email notifications from my Magento 1.9.2 store: Currency update warnings: WARNING: Cannot retrieve rate from…
webrightnow
  • 91
  • 1
  • 8
3
votes
2 answers

Quandl, Quantmod, or TrueFX hourly data

I have been trying to find some source code in R using either Quantmod, TrueFX or Quandl for downloading historical Hourly and H4 currency data. Unfortunately almost every provider only has daily data. TrueFX provides historical tick-data in CSV…
H701
  • 51
  • 3
3
votes
2 answers

Multi currency information system, SQL inaccuracy

I am working on development of information system which must handle multi currencies ( USD, EUR, JPY ). Let's say, user can add products to system. User adds product #1 on 13 Feb 2017, price 2000, currency JPY. User adds product #2 on 14 Feb 2017,…
unnamed
  • 151
  • 1
  • 6
2
votes
0 answers

Is there an R package that allows me to convert a column to USD at varying exchange rates?

I have a dataframe with 18 different currencies over 11 years and would like to convert them all to USD using year-end exchange rates for each year. Basically, I want to convert the value of EUR in 2011 at the USD exchange rate on 31/12/2011, the…
maplesyrup123
  • 303
  • 1
  • 6
2
votes
1 answer

Having some trouble extracting ECB exchange rates in XML with XML.. full source code in question

I need to grab a list of historic Exchange rate reference rates for an internal accounting system. This question is about the following code only, feel free to use this code if you find it useful (and of course once we get an answer to fix the final…
Nick
  • 908
  • 12
  • 29
2
votes
2 answers

Scrape historic Exchange Rate from Web XML table by column in Excel

I am trying to scrape historic exchange rates from a XML on FloatRates into cells in an excel table. It's currently returning #VALUE!. I don't know how to reference the XML structure correctly. A difficulty faced is I want to retrieve the exchange…
Berry
  • 115
  • 9
2
votes
1 answer

PHP - Display data in different time zones

Hello stackoverflow community. I develop a web app and the concept is to display historical currency exchange rates based on time series from past. For example a user may request exchange rates from 22 May 2020 13:00 to 26 MAY 2020 22:00. Then my…
Vasileios Tsakalis
  • 1,101
  • 2
  • 11
  • 25
2
votes
1 answer

Change price field according to exchange rate django

is there anyway to change price field dynamically according to the days exchange rate of dollar? in django?? Example: class Sales(models.Model): price = models.DecimalField() """ other codes goes in here """
Martins
  • 1,130
  • 10
  • 26
2
votes
1 answer

Error in Google finance API

I want to convert currencies using google finance api. But its not working in my local machine(India). It works fine when I hit from one server located in USA and provides proper result. Url :…
maulik sakhare
  • 1,957
  • 1
  • 12
  • 19
2
votes
2 answers

How to list currency exchange rates for each day on Google Spreadsheet?

I would like to know if it is possible to get currency exchange rates for each past day on Google Spreadsheets. Currently I have the following formula (Column B contains all the dates that had cash flow): =GOOGLEFINANCE("CURRENCY:EURGBP", "price",…
Ged
  • 67
  • 2
  • 6
1
2 3 4 5 6 7 8