Live Forex ticker HTML code
- Thread starter Gismo
- Start date
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 22:45
- Joined
- May 7, 2009
- Messages
- 19,881
Gasman
Enthusiastic Amateur
- Local time
- Today, 14:45
- Joined
- Sep 21, 2011
- Messages
- 15,925
isladogs created this DB
https://www.access-programmers.co.uk/forums/showthread.php?t=295342
Look at the Scrolling Marquee Text to get the ticker tape effect.
Now all you have to do is get your data to add to it.
HTH
https://www.access-programmers.co.uk/forums/showthread.php?t=295342
Look at the Scrolling Marquee Text to get the ticker tape effect.
Now all you have to do is get your data to add to it.
HTH
isladogs
MVP / VIP
- Local time
- Today, 14:45
- Joined
- Jan 14, 2017
- Messages
- 18,576
Gismo
Four choices for you
1. Gasman has already pointed you to my scrolling marquee text which will get the effect you want.
As for the data, you will need to find a site which gives an XML or JSON output which you can then import and parse to update your display at set intervals of your choice.
2. The alternative of using a web browser control has the advantage of being updated automatically. So if you can find a suitable forex ticker site, just use that.
3. If you have a website you can add your own forex ticker widget. See https://www.realtimeforex.com/widgets/forex-web-ticker/
You would then use your webpage in the web browser control.
4. For a completely different approach look at my free Currency Exchange Rate Tracker app available from http://www.mendipdatasystems.co.uk/cert/4594365453
HTH
Four choices for you
1. Gasman has already pointed you to my scrolling marquee text which will get the effect you want.
As for the data, you will need to find a site which gives an XML or JSON output which you can then import and parse to update your display at set intervals of your choice.
2. The alternative of using a web browser control has the advantage of being updated automatically. So if you can find a suitable forex ticker site, just use that.
3. If you have a website you can add your own forex ticker widget. See https://www.realtimeforex.com/widgets/forex-web-ticker/
You would then use your webpage in the web browser control.
4. For a completely different approach look at my free Currency Exchange Rate Tracker app available from http://www.mendipdatasystems.co.uk/cert/4594365453
HTH
isladogs
MVP / VIP
- Local time
- Today, 14:45
- Joined
- Jan 14, 2017
- Messages
- 18,576
Sorry but that doesn't make sense. None of the codes give an error?
What codes are you copying and from where?
Which method from those suggested previously are you trying to do?
Which have you tried and rejected?
I googled live forex ticker websites, quite a few with codes to be copies, as the ttps://www.realtimeforex.com/widgets/forex-web-ticker/ which you supplied.
not familiar with the scrolling marquee so i dumped that on for now. so currently I am looking at the web browser option. Your website is not quite what i am looking for. i would like to just have the running bar if possible but keep in getting the bracket error
not familiar with the scrolling marquee so i dumped that on for now. so currently I am looking at the web browser option. Your website is not quite what i am looking for. i would like to just have the running bar if possible but keep in getting the bracket error
isladogs
MVP / VIP
- Local time
- Today, 14:45
- Joined
- Jan 14, 2017
- Messages
- 18,576
I've now looked into this idea properly.
I also had problems with the HTML script from the realtimeforex.com link I supplied in post #7.
However, I found another site that worked perfectly: https://www.exchangerates.org.uk/webmasters/live-currency-rates-ticker.html
That ticker is more customisable in terms of width, speed & colours. It also indicates up/down trends:
The site also has other types of live currency widget scripts including a working forex example - but I prefer this one
The HTML script used for this is:
You can see the currency ticker in action (scrolling) on the currency exchange tracker app page on my website: http://www.mendipdatasystems.co.uk/cert/4594365453
Next I decided to make a working application based on this - attached.
This references another temporary page on my website where I've removed all other menu items to keep things simple.
That web page has a live currency rates chart as well as the ticker.
At first I kept getting script errors at startup
To fix that, I had to add a cookie control on that 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. I haven't looked into this as yet
If this seems useful to others, I'll add it to sample databases later
Attachments
Last edited:
isladogs
MVP / VIP
- Local time
- Today, 14:45
- Joined
- Jan 14, 2017
- Messages
- 18,576
One user (Gasman) has reported problems opening the live utility in Access 2007.
If anyone else has issues, try opening in a trusted location, then click past both script errors if these appear before the cookie control & finally click Accept on that.
Alternatively, try first going to the home page of my website (see link below) and click the cookie control on that page.
All feedback appreciated
EDIT: Attached is a short video showing this in use. Its in WMV format
If anyone else has issues, try opening in a trusted location, then click past both script errors if these appear before the cookie control & finally click Accept on that.
Alternatively, try first going to the home page of my website (see link below) and click the cookie control on that page.
All feedback appreciated
EDIT: Attached is a short video showing this in use. Its in WMV format
Last edited:
isladogs
MVP / VIP
- Local time
- Today, 14:45
- Joined
- Jan 14, 2017
- Messages
- 18,576
Arnel
Well it certainly works but at the moment you have to visit my website
Obviously the site should be altered by anyone doing this.
In any case, I only intend to keep that page active for a short period.
As I wrote before:
Ideas for achieving that welcomed
EDIT: what did you mean by a 'running label' in post #4
Last edited:
Jane Sandpiper
New member
- Local time
- Today, 14:45
- Joined
- Feb 12, 2020
- Messages
- 1
Similar threads
