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

JS: Iterate over page & convert US Dollars to Rands

I have a client website. Here are test login details Login: TestOne, Password: password. I am trying to convert all values on the page into Dollars. I have changed some subscriptions to nominal values (Neo Natal: Month 0-1 & Neo Natal: Month 1-2) to…
Aaron Matthews
  • 128
  • 3
  • 13
0
votes
0 answers

Javascript Convert Currency

Hello fellow Stackers! I am trying to convert US Dollars to South Africa Rands on a web page. I have a Javascript function attained from here. The function works fine, but I can't seem to return a value for me to use :/ function getRate(from, to) { …
Aaron Matthews
  • 128
  • 3
  • 13
0
votes
1 answer

Open source currency conversion table from currency to dollar

Is there any open source (free) offering historical currency conversion for the database to connect to? My requirement is to convert 10 currencies into dollars and join the table on dates of currency and dates of sale.
PythonDev
  • 41
  • 1
  • 2
  • 8
0
votes
3 answers

Excel VBA - Bitcoin

I'm trying to run this macro on Microsoft Excel, but every time I do, I get a Run-time error '5' What am I doing wrong? This is my first time doing something like this. What's suppose to happen is that everytime I run the Keyboard Shortcut, it's…
user6260366
  • 47
  • 1
  • 7
0
votes
1 answer

Exchange rates for ENDOFMONTH

I have an Exchange Rate table that I'm trying to get the ending months calculation It's using a minimum of 3 currencies lets use GBP USD EUR I need to return when selecting that currency the End of month Currency So something like…
user2181700
  • 147
  • 3
  • 15
0
votes
2 answers

How to extract currency exchange rate json to a Hashmap

In my application i need to find the currency exchange rates of all countries with usd as base.I got a json as the output which contains the exchange rates.Below is the json. { "disclaimer": "Exchange rates", "license": "Data sourced from various…
KJEjava48
  • 1,967
  • 7
  • 40
  • 69
0
votes
0 answers

How to pass customized amount to yahoo currency converter API

I am using yahoo currency converter API in my Application. But it gives the currency exchange rate only. I am not able to pass my customized amount to API. The below is the API Request i am using https://query.yahooapis.com/v1/public/yql?q=select *…
Albert
  • 7
  • 6
0
votes
1 answer

International merchant account services...exchange rate conversions

I'm not sure if this is where to post this but I couldn't find any answers. Hoping some developers have run accross this before. I am building a subscription based product that can be used internationally. I would like to offer the subscription in…
Ronedog
  • 2,313
  • 8
  • 43
  • 85
0
votes
2 answers

Currency exchange calculation in SAS

I have two tables first one Account consist of following data: Code | Exposure | Expo_Curr | Limit | Limit_curr | Date_extr 2105 | 2.354586 | EUR | 288.6 | HUF | 1405 2105 | 25.46658 | USD | 12.32 | CAD | 1203 2105 | 5.987456 | CAD | 321.2 |…
Noza
  • 35
  • 1
  • 7
0
votes
2 answers

SQL - calculate average exchange rate for given periods and use in select

first time poster here. i have two tables 1)transactions (T1) 2) exchange rates(T2). T1 holds daily transaction in several currencies, T2 holds daily exchange rates for all currencies. firstly, i want to calculate the average rate for every currency…
Asad
  • 1
  • 1
0
votes
1 answer

Reconfigure Existing Providers in AX 2012

In the configure exchange rate providers form I have removed the existing providers and they are also removed in their coresponding tables so when I press the add button it shows me the error that could not find the providers.How can I add them…
AXING
  • 41
  • 1
  • 6
0
votes
1 answer

Yahoo Finance sends wrong exchange rates to the server

I'm using Node.js for my project and I'm wondering is there any difference between what Yahoo finance sends to the server machine and "regular" machine. var http = require('http'); var link = "http://download.finance.yahoo.com/d/quotes?s=" +…
Jan
  • 184
  • 2
  • 15
0
votes
0 answers

Append daily exchange rates to Pandas df

I have a dataset like: a = DataFrame({'clicks': {0: 12, 1: 19, 2: 14}, 'country ': {0: 'norway', 1: 'sweden', 2: 'italy'}, 'date': {0: '2/2/2016', 1: '2/3/2016', 2: '2/4/2016'}}) I would like to add a new column to…
chopin_is_the_best
  • 1,951
  • 2
  • 23
  • 39
0
votes
1 answer

Use GoogleFinance Currency Conversion on Sum

I'm trying to use GoogleFinance currency conversion on a sum but can't get the correct format. My cell is as follows: =SUM(((IMPORTRANGE("sheet-key","H2:H300"))/100*40)+(IMPORTRANGE("sheet-key","H2:H300"))) I want the results of the sum to be then…
d1ch0t0my
  • 443
  • 7
  • 22
0
votes
1 answer

Prestashop 1.4 Issue on cart update (currency conversion)

I have a weird issue when I do the $cart->update(); after changing the currency e.g. in pounds the total amount from the cart is £896.32 with the current conversion rate 1.388889 (to EUR) so, in EUR it should be 896.32 * 1.388889 = 1244.89 (rounded…
kenwarr
  • 85
  • 8
1 2 3 4 5
6
7 8