Version 1.3 Approx 0.6 MB First Published 31 Dec 2020 Last Updated 5 May 2024
This was created as a response to a question by forum member Gismo at Access World Forums
He wanted code to display live Forex (currency exchange) rates in a ticker tape format on an Access form.
I suggested 4 possible approaches:
1. Use scrolling marquee text - see my Attention Seeking example app.
As for the data, you would need to find a site which gives an XML or JSON output.
This would then need to be imported and parsed to update the display at set intervals of your choice. Potentially complex to do.
2. Use an ActiveX web browser control linked to a site containing this code as an HTML snippet. This has the advantage of being updated automatically.
3. Add a currency exchange ticker widget to your own website using freely available code online. You would then use your webpage in the web browser control.
4. Use my Currency Exchange Rate Tracker app as an alternative approach
This example uses the idea outlined in point 3 above.
There are a number of websites offering free HTML widget code for currency exchange rates.
First of all, I tried a previous version of the dailyforex.com site but the HTML script supplied at that time didn't work for me.
The site has since been updated and their widgets may well work better now.
However, various HTML scripts available from exchangerates.org.uk worked perfectly.
That ticker is more customisable in terms of width, speed & colours. It also indicates up/down trends.
For example:
The Exchange Rates site also has other types of live currency widget scripts including a working forex example - but I prefer this one.
The HTML script used in the widget is:
<
!-- EXCHANGERATES.ORG.UK LIVE CURRENCY RATES TICKER START -->
<iframe src="https://www.exchangerates.org.uk/widget/ER-LRTICKER.php?w=490&s=2&mc=GBP&mbg=F0F0F0&bs=yes&bc=000044&f=verdana&fs=10px&fc=000044&lc=000044&lhc=FE9A00&vc=FE9A00&vcu=008000&vcd=FF0000&" width="490" height="30" frameborder="0" scrolling="no" marginwidth="0" marginheight="0"></iframe>
<!-- EXCHANGERATES.ORG.UK LIVE CURRENCY RATES TICKER END -->
Next I decided to make a working application based on this.
The app references another page on this website where I've removed all other menu items to keep things simple.
If you want to reference that web page in your own apps, the full URL is:
https://www.isladogs.co.uk/live-currency-rates/index.html
The web page includes this live currency rates chart as well as the HTML ticker
The HTML script used in this widget is:
<!-- EXCHANGERATES.ORG.UK LIVE FOREX RATES TABLE START -->
<div style="width:178px;margin:0;padding:0;border:1px solid #cbcbcb;background:#fff;">
<div style="width:178px;text-align:center;padding:2px 0px;vertical-align:middle;color:#003366;font-family:arial;font-size:11px;font-weight:bold;">
Live Exchange Rates
</div>
<div style="padding:0px;text-align:center;">
<script type="text/javascript">
var tz = '0';
var mc = 'GBP';
var nb = '10';
var c1 = 'USD';
var c2 = 'EUR';
var c3 = 'AUD';
var c4 = 'JPY';
var c5 = 'INR';
var c6 = 'CAD';
var c7 = 'ZAR';
var c8 = 'NZD';
var c9 = 'SGD';
var c10 = 'CNY';
var bc = 'Base Currency';
var lc = '003366';
var bdrc = 'cbcbcb';
</script>
<script type="text/javascript" src="https://www.currency.me.uk/remote/FE-FERT-1.php"></script>
<div style="width:178px;text-align:center;padding:2px 0px;vertical-align:middle;color:#003366;font-family:arial;font-size:10px;font-weight:bold;">Real Time Rates by <a rel="nofollow" style="color:#003366;text-decoration:none;font-family:arial;font-size:10px;" href="//www.exchangerates.org.uk" target="_new">ExchangeRates.org.uk</a></div>
</div></div>
<!-- EXCHANGERATES.ORG.UK LIVE FOREX RATES TABLE END -->
A screenshot of the application is shown below.
At first I kept getting script errors at startup. To fix that, I had to add a cookie control on the specified webpage.
Click to accept & it will disappear in the usual way.
NOTE: If you still get a script error (possibly two) just click Yes twice
The same principle can be used with other live HTML scripts e.g. share prices / sports results / news updates.
If you can find a suitable script just adapt the widget on the website.
It would be even better to be able to load the HTML script & run it direct in Access without referencing a web page.
However, I haven't looked into doing this yet
Version History
Version Version date Notes
1.2 2020-12-30 Initial Release
1.3 2024-05-05 Fixed broken link
Download
Click to download:
Currency Ticker LIVE v1.3 (zipped)
For an alternative approach, see the Currency Exchange Rate Tracker application
Feedback
Please use the contact form to let me know whether you found this article / example app useful or if you have any questions.
Do let me know if there are any errors or omissions.
Please also consider making a donation towards the costs of maintaining this website. Thank you
Colin Riddington Mendip Data Systems Last Updated 5 May 2024
Return to Example Databases Page
|
Return to Top
|