Thank you Siran & Acorn,
Yes, it appears that a simple interval timer works; added an intro image to start too: https://livedata.initiostar.co.uk. You can wait up to 5 mins to see any updates (Google update policy for published docs) and the various exchanges have to be open.
HTML Code:
<iframe id="MyIndices" src="https://livedata.initiostar.co.uk start.png" height=200 width=680 scrolling=no "></iframe>
<script>
setInterval(
function myRefresh() {
document.getElementById("MyIndices").src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSeFi_s6Kjx6WXqEPm53JFEQAlPTZr2jCRFqmfJWOyfy0SeqL6Gh-wbN5DSDQIrhsS47ZFUTXmIABKu/pubhtml";}, 5000);
</script>
An alternative solution is just to call the function through onclick as required.
HTML Code:
<iframe id="MystaticIndices" src="https://livedata.initiostar.co.uk/start.png" height=200 width=680 scrolling =no ></iframe>
<button onclick="myRefresh ()">Refresh</button>
<script>
function myRefresh()
{ document.getElementById("MystaticIndices").src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSeFi_s6Kjx6WXqEPm53JFEQAlPTZr2jCRFqmfJWOyfy0SeqL6Gh-wbN5DSDQIrhsS47ZFUTXmIABKu/pubhtml"; }
</script>
Through the Google console though I receive a message "target-densitydpi" is not supported, so my guess is it might not work in Safari? It does work on Android though.
Thank you both for your help.
Gary
Bookmarks