import Currency rates via API

[kokowawa]

hello ,

i am building a database that require a daily update for about 20 currencies rates between them and the USD , it is hard to update it manually which will opend the door for human mistakes that will cost money ,
i have searched along to have somthing do this via api , but i was not able to understand the api thing so i couldnt do it ,


can anyone of the prof. help me .
i need a code that update the currency rates table on daily basis or on the time interval that i define .
the table i need to have the fields :

currency from
currency to
exchange rate
update date
update reference

example :
currency from : Euro
currency to : USD
exchange rate : 1.252
update date : 17.05.20
update reference : yahoo finance.

i have searched for some sites that give currency rates feeds for free like

free.currencyconverterapi.com/
fixer.io/
code.google.com/archive/p/currency-converter-api/

 

[isladogs]

Have a look at my Currency Exchange Rate Tracker app

 

[kokowawa]

Have a look at my Currency Exchange Rate Tracker app

i did have a look into it , i have tested many things in it , it have good features that i need but in a different way.
it gives me error when i click update
it seems the api key expiered .
can u help and give simple code example for the table update based on the currency i define from another table.
a table have the currency from and to and the other table have the the updated rate as the pic in the previous post.

 

[arnelgp]

I made from other samples.
may not work in the future since we use web scraping.

 

[isladogs]

Sorry - the API key supplied with the app is no longer active
You will need to get your own API key to use my application.
It uses downloaded JSON data -rather than web scraping

 

[Gasman]

Mine does still work, but you have to leave the base currency as EUR

 

[kokowawa]

I made from other samples.
may not work in the future since we use web scraping.

@arnelgp

thank you for the example , this also helped , but as i see that it copy the whole table from the xml file of the website and replace the old table , is there is a way that can get only update of some selective currencies and keep the record.

 

[kokowawa]

@arnelgp
i have found a way to make my curr list .
floatrates.com/custom-exchange-rates.html .
i will work on copying data from your sample to my table of currency , as the one you did delete the older table

 

[kokowawa]

hello @arnelgp ,
i have managed to create my custom list of rates and evolved the table and added more currencies to be exchanged , see PIC .
it was working fine and suddenly it stopped and now giving me an error , i don't know what is the cause.
the same happened when i used the sample you provided me in post #4

please see the pic i attached to help me fixing it .
links i grab rates from also attached.

USD link http://www.floatrates.com/widget/00001019/480701fbaf6d647f1bc51fc7bd7b7c5b/usd.xml
EGP Link http://www.floatrates.com/widget/00001019/480701fbaf6d647f1bc51fc7bd7b7c5b/usd.xml

 

[uncleh]

I made from other samples.
may not work in the future since we use web scraping.

HI,arnelgp,​

thank you for the example , this also helped , but i uesing win 11 now, no IE app it doesnt work, would you please help to change to Edge? thank you

 

[arnelgp]

i change the code and it will work now.

 

[uncleh]

wow wow wow,, thats great..thank you very much!!!!!!!!!!!

 

[mike60smart]

i change the code and it will work now.

Hi Arnelgp

I downloaded your example db ExchangeRate2 which is just brilliant.

It gives conversions as 1 USD = 0.919 EUR

Is it possible to do the conversion so it says:-

1 EUR = 1.08923 USD

1 GBP = 1.27961 USD

Any help appreciated

 

[Gasman]

Hi Arnelgp

I downloaded your example db ExchangeRate2 which is just brilliant.

It gives conversions as 1 USD = 0.919 EUR

Is it possible to do the conversion so it says:-

1 EUR = 1.08923 USD

1 GBP = 1.27961 USD

Any help appreciated

Why not just do the math?
$1 = EUR 0.9183
1 EUR = 1/0.9813 = 1.0191 USD

 

[mike60smart]

Why not just do the math?
$1 = EUR 0.9183
1 EUR = 1/0.9813 = 1.0191 USD

Hi Gasman
That is very neat.
Just shows I was not good at maths at school.