Currency Exchange Rates (1 Viewer)

Status
Not open for further replies.

isladogs

MVP / VIP
Local time
Today, 22:22
Joined
Jan 14, 2017
Messages
18,186
The attached database has been created as a practical example using downloaded JSON data from an online source.

The database gets the latest exchange rates from a free online data source at: http://fixer.io
Exchange rates are updated daily for a selection of common currencies
By default, the base rate has been set as British Pounds Sterling (GBP) but can be modified to any other supported currency



NOTE:
1. Other data sources are available if you need LIVE exchange rate data for a larger number of currencies. You may have to pay for live exchange data.

2. For more information about parsing JSON data in Access, please see this thread
https://www.access-programmers.co.uk/forums/showthread.php?t=295789

3. Another application which uses imported JSON data is the UK Address Finder database
https://www.access-programmers.co.uk/forums/showthread.php?t=295378

Any questions, please send me a PM or email me using the link below

UPDATE 29/05/2018:
This version will no longer work after 1 June 2018 - see post 5 for an explanation
Please download the latest version (still free) from my website
http://www.mendipdatasystems.co.uk/free-apps/4592091376
 

Attachments

  • CurrencyExchange.PNG
    CurrencyExchange.PNG
    71.1 KB · Views: 3,535
  • CurrencyExchangeRates.zip
    229.8 KB · Views: 1,203
Last edited:

isladogs

MVP / VIP
Local time
Today, 22:22
Joined
Jan 14, 2017
Messages
18,186
Minor update to v1.1 following user feedback: (Thanks Paul)

Two changes made:
a) selected currency is now retained after changing base currency
b) fixed issue where selected currency becomes new base currency

Any other feedback, please email me

UPDATE 29/05/2018:
This version will no longer work after 1 June 2018 - see post 5 for an explanation
Please download the latest version (still free) from my website
http://www.mendipdatasystems.co.uk/free-apps/4592091376
 

Attachments

  • CurrencyExchangeRates1.1.zip
    244.7 KB · Views: 1,015
Last edited:

Gasman

Enthusiastic Amateur
Local time
Today, 22:22
Joined
Sep 21, 2011
Messages
14,048
Works a treat.

Thank you.
 

isladogs

MVP / VIP
Local time
Today, 22:22
Joined
Jan 14, 2017
Messages
18,186
Currency Exchange Rates TRACKER

I've added an enhanced version of this application to my website.
The new version allows you to:
a) track changes in exchange rates over a period of time
b) plot the data as a chart

See attached screenshots

The updated version is available here:
http://www.mendipdatasystems.co.uk/free-apps/4592091376

Its still free but supplied as an ACCDE file (both 32-bit and 64-bit available).
An ACCDB version with full code can optionally be purchased from the website at a low price
 

Attachments

  • CERT_Tracker.PNG
    CERT_Tracker.PNG
    83.7 KB · Views: 895
  • CERT_Chart2.PNG
    CERT_Chart2.PNG
    61.9 KB · Views: 634
  • CERT_Chart1.PNG
    CERT_Chart1.PNG
    62.8 KB · Views: 742

isladogs

MVP / VIP
Local time
Today, 22:22
Joined
Jan 14, 2017
Messages
18,186
The currency exchange rate tracker has been updated to version 1.42

The main reason for the update is that the data provider fixer.io has updated their service to provide significant additional functionality including support for 168 currencies (previously 32).

The provider has also changed the download site and account settings. This means that the previous version of this app will no longer work after 1 June 2018

From that date, NEW users will have to pay $10 per month.
However because I am an existing customer, I have been transferred to a free legacy account with all the new features.
As the provider put it, I have been 'grandfathered into the legacy account' :D
That's a phrase I'd never heard before and took as a polite way of saying I'm an old customer !

Anyway, the upshot is if you update to the new version, the app & online data is still available FREE.

Its too big to upload to the forum but is now available FREE from my website: http://www.mendipdatasystems.co.uk/free-apps/4592091376
I hope its useful to others.
 
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom