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
2
votes
1 answer

Currency exchange in database

I am designing a relational database that includes currency exchange rates. My first intuition was to have a currency table that lists all the currencies and holding as attributes the exchange rate for every other currency. Ex: Currency Table id…
Steven Anderson
  • 455
  • 6
  • 13
2
votes
2 answers

Current exchange rates for Excel

Is there a way to import current exchange rates in MS-Excel and keep them updated? Excel provides a way of calling a URL and import the response into a cell. There are several prof. services on the internet but I wanted to make sure that no data is…
Denis Giffeler
  • 1,499
  • 12
  • 21
2
votes
1 answer

Script is fine, but will not run as imported module

With this script/module, XRateDKKUSD_test.py, I can successfully fetch the exchange rate DKK pr USD. import pandas as pd import pandas.io.data as web import datetime def…
Morten
  • 67
  • 1
  • 7
2
votes
1 answer

How to define range of values of a time series?

First of all, sorry for any mistakes regarding my post, I'm new to this site. I´m getting started with R now and I´m trying to do some analysis with time series data. So, I got a times series at hand and already loaded it into R. I can also plot…
WiWiStudent
  • 39
  • 5
2
votes
1 answer

Is there any way to get settlement figures in the local currency from Amazon MWS?

We're using 3 marketplaces - our local is UK, so we've got GBP figures for the payment settlement reports, but the other 2 are in EUR. I could do with at least knowing how much Amazon have paid us in GBP for the 2 EUR reports, but I can't see any…
wizzardmr42
  • 1,634
  • 12
  • 22
1
vote
0 answers

How to calculate inverse in chainlink tasks?

Hey I am trying to calculate inverse of a value that I got from an API call. I have my tasks like these. Tasks parse [type="jsonparse" path="quotes,USDEUR" data="$(fetch)"] inverse [type="divide" input="1" divisor="$(parse)"…
Prasanth Venugopalan
  • 11
  • 2
1
vote
1 answer

How to implement a Redis Store for Money/Open-Exchange-Rate-Bank Ruby on Rails

I spent days searching the whole internet and couldn't find any implementation. I, therefore, implemented one and will like to share.
Kofi Asare
  • 97
  • 1
  • 5
1
vote
1 answer

Exchange Rate for specific date and currency on a data frame

I need for each observation (each with different currency and date-stamp) the exchange rate for the specifica date and curreny. This is my code so far: library(priceR) library(ggplot2) library(tidyverse) library(tibble) library(dplyr) #Data…
MasterGee
  • 21
  • 4
1
vote
2 answers

Why is django-money running incorrectly in my view?

I'm using django-money to make conversions on my backend of the project but it is converting wrong. For example, I want to convert TRY to USD: I enter 1000000 TRY it returns 480629.66 USD, but it should be: 120055.20 USD. And when I enter 10000 Euro…
stephone
  • 17
  • 3
1
vote
2 answers

How to solve MissingRate error in Django?

I want to convert currencies in my Django app. I created a model Customer. In customer model, there are two fields for that credit_limit and currency_choice. I am using django-money for conversion. But I get an error: MissingRate at /customer Rate…
edche
  • 636
  • 6
  • 33
1
vote
2 answers

Best practice for keeping stable exchange rates for a month

I want to use exchange rates in my application but I do not want to get these rates from a web service. I just want to keep it in somewhere and read it from there and I want to be able to update that rates month by month. I may keep data in database…
brsbilgic
  • 11,613
  • 16
  • 64
  • 94
1
vote
2 answers

Convert into EURO from multiple currencies in R

I have the following dataframe: structure(list(currency = c("NZD", "NZD", "NZD", "NZD", "NZD", "EUR", "SEK", "EUR"), price = c(580.9, 539.75, 567.8, 802, 486, 365, 5088, 111)), class = "data.frame") I would like to add a new column with the value…
AJS
  • 25
  • 6
1
vote
2 answers

Implicitly Calculate Exchange Rates in SQL from Exchange Rate table

I have one table of data with revenue in multiple currencies (let's call this one TRANSACTION_TABLE, with columns as such: TRANSACTION_NAME TRANSACTION_VALUE CURRENCY , and another table with exchange rates (EXCHANGE_RATE) with columns as…
jbentley
  • 163
  • 4
  • 13
1
vote
4 answers

C# Parse XML exchange rates into dictionary from ECB

Using this URL from European Central Bank: www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml I would like to import the currency symbol and rate into a Dictionary or object. I've got it reading into an xml doc but I'm having trouble picking out…
J Benjamin
  • 4,722
  • 6
  • 29
  • 39
1
vote
1 answer

Make graph from dictionary in Python

Unable to create a graph using Matplotlib whilst using this dictionary. Trying to be able to choose the two values, then produce a graph. Eg. select USD and GBP and plot graph. import matplotlib.pyplot as plt exchange_rates = { "GBP": { …
Andrew Shakespeare
  • 15
  • 2
1
2
3 4 5 6 7 8