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.
Questions tagged [currency-exchange-rates]
108 questions
0
votes
2 answers
R: Multiply values in one column to those in another if the dates coincide
I've been trying this for some days but I can't seem to find a way to do it.
I have a two dataframes.
One named "df1" with two variables: date, price
date price
2019-12-21 140
2019-10-25 91
2019-10-24 …
Murakmad
- 3
- 1
0
votes
1 answer
Mutate a dataframe based on column name/currency
I have the following code that converts relevant columns in my dataframe to USD from whatever currency it is:
df %>%
mutate_at(vars(contains('cost_AUD')), list(~ . * ER_AUD_USD )) %>%
mutate_at(vars(contains('cost_GBP')), list(~ . * ER_GBP_USD…
Undroid
- 135
- 8
0
votes
1 answer
I can't use the cell content and do formulas with it
Currently I've made an excel document where it gets it data from a website with the help of "Data - From Web".
I've gotten this part to work, however i need to use the cell-content in some of the cells to do calculations, but it appears that these…
SwE3xHD
- 17
- 4
0
votes
3 answers
Can we call external API without API ID?
I am new to API design, I am working on one project where I need to call currency exchange API from National Bank of Poland http://api.nbp.pl but I do not see any indication where I can find API ID. This development is on Spring Boot if I am trying…
Vivek Dharek
- 93
- 1
- 1
- 9
0
votes
0 answers
Adding currency rate to varibles
add_filter( 'gform_field_value_bank20_code', 'my_custom_population_showcountry' );
function my_custom_population_showcountry( $value ) {
$current_user = wp_get_current_user();
$users = $current_user->PROCESSOR;
// For the country Afghanistan
if(…
pandglobal
- 31
- 1
- 9
0
votes
2 answers
Reading real-time value from HTML element in URL page using jQuery
I've got this website: https://coinyep.com/he/ex/ETH-ILS
Inside this URL web page, there is an input element, and its HTML id is: "coinyep-input2".
I need to read its value (= approximately 637.49 ILS) using jQuery in Visual Studio.
So far, I…
חיים חדד
- 512
- 5
- 17
0
votes
1 answer
Rolling regression forecast , DM test, CW test
I have a linear model with the exchange rate as a dependent variable and 7 others independent variables(e.g. inflation, interest rate etc.). I have quarterly data from 1993Q1-2011Q4.
I would like to create a rolling window regression (with the…
Teh Hyped
- 1
- 1
0
votes
0 answers
Handling currency conversion in SQL Server T-SQL
I have attempted to build an SQL script in MS SQL Server T-SQL to split a Sales Invoice Revenue measure into 4 measures representing the following:
Transaction Sales Revenue = The revenue in the originating currency
Home Sales Revenue = The revenue…
Shawn_M
- 35
- 7
0
votes
1 answer
Get historical data from fixer.io except for weekends
Consider the code below, which uses the historical_rates(today) function. I want to take rates for all days except weekends, is there some example on how to accomplish this?
import datetime
from fixerio import Fixerio
today =…
NeoVe
- 3,857
- 8
- 54
- 134
0
votes
2 answers
Facing error while getting currency exchange rate from Google Finance API
Below code was working fine on Production from last few months.
Recently it started breaking.
Yesterday it was giving HTTP error issue for file_get_contents function.
Today, On Execution it shows Undefined Offset error.
I am not sure what has…
Pooja
- 53
- 1
- 1
- 3
0
votes
0 answers
GetResponse Bittrex C#
I try to recover information in C# about crypto currency on the bittrex exchange plateform.
For that I have this website: https://bittrex.com/api/v1.1/public/getticker?market=BTC-LTC.
With Chrome i have this result:…
twenty94470
- 105
- 2
- 12
0
votes
2 answers
How to extract converted value from response using jquery ajax method?
I am using this link :freecurrencyconverterapi to get the converted value from USD to INR.
As you can see in developer mode of browser that the response is {"USD_INR":64.857002}.
Since I am new to programming, is there a way to get the float value…
Savio menezes
- 140
- 1
- 11
0
votes
2 answers
All Currencies with base currency KWD in Yahoo finance
I have a requirement in my application to fetch the currencies conversion rates on a daily basis with a Base Currency KWD . I have checked Yahoo finance ( and few other free providers) for the same. But yahoo shows default base currency as USD or…
user2695433
- 2,013
- 4
- 25
- 44
0
votes
1 answer
Excel Formula to calculate currency exchange rates based on Fixed Rate Table
I have a fixed currency exchange rate table (columns A to C) for 10 different currencies to CAD in Excel as follows:
I would like to know if there is a formula that I can use under Column H to populate all the different combinations of currencies…
Alvin Wong
- 23
- 1
- 5
0
votes
1 answer
Some errors while changing default currency in odoo 10.0...
How to change the default currency in Odoo 10.0 without exchange rate ?
I tried the method from http://www.surekhatech.com/blog/change-currency-in-pos-in-odoo-10
But I got the errors such as
When in POS, I tried to "Validate Closing & Post…
Galvion
- 1,353
- 7
- 23
- 35