Hi, nksa84!
I insist, it's a web development question more than an Excel question. For example the 2nd site uses this code for the live rates:
-----
"
// To display the live prices
var t;
function CallLivePrice() {
//debugger;
//alert('tset'

;
clearTimeout(t);
$.ajax({
type: ""POST"",
url: ""LivePriceService.asmx/getSVBCPrice"",
data: ""{}"",
contentType: ""application/json; charset=utf-8"",
dataType: ""json"",
success: OnSuccess,
error: OnError
});
}
function OnSuccess(data, status) {
var jSonObj = $.parseJSON(data.d);
$('#lblSpotGold999'

.text(jSonObj.SpotGold999);
$('#lblSpotGold999Big'

.text(jSonObj.SpotGold999);
$('#lblSpotGold999'

.css({ color: jSonObj.colrGold999 });
$('#lblSpotGold999Big'

.css({ color: jSonObj.colrGold999 });
$('#lblSpotSilver999'

.text(jSonObj.SpotSilver999);
$('#lblSpotSilver999Big'

.text(jSonObj.SpotSilver999);
$('#lblSpotSilver999'

.css({ color: jSonObj.colrSilver999 });
$('#lblSpotSilver999Big'

.css({ color: jSonObj.colrSilver999 });
$('#lblSpotGold50gm'

.text(jSonObj.SpotGold50gm);
$('#lblSpotGold50gmBig'

.text(jSonObj.SpotGold50gm);
$('#lblSpotGold50gm'

.css({ color: jSonObj.colrGold50gm });
$('#lblSpotGold50gmBig'

.css({ color: jSonObj.colrGold50gm });
$('#lblSpotGold916'

.text(jSonObj.SpotGold916);
$('#lblSpotGold916Big'

.text(jSonObj.SpotGold916);
$('#lblSpotGold916'

.css({ color: jSonObj.colrGold916 });
$('#lblSpotGold916Big'

.css({ color: jSonObj.colrGold916 });
$('#lblSpotGoldBid'

.text(jSonObj.SpotGoldBid);
$('#lblSpotGoldBidBig'

.text(jSonObj.SpotGoldBid);
$('#lblSpotGoldBid'

.css({ color: jSonObj.colrGoldBid });
$('#lblSpotGoldBidBig'

.css({ color: jSonObj.colrGoldBid });
$('#lblGold'

.text(jSonObj.GoldCMX);
$('#lblGoldBig'

.text(jSonObj.GoldCMX);
$('#lblGold'

.css({ color: jSonObj.colrGoldCMX });
$('#lblGoldBig'

.css({ color: jSonObj.colrGoldCMX });
$('#lblSilver'

.text(jSonObj.SilverCMX);
$('#lblSilverBig'

.text(jSonObj.SilverCMX);
$('#lblSilver'

.css({ color: jSonObj.colrSilverCMX });
$('#lblSilverBig'

.css({ color: jSonObj.colrSilverCMX });
$('#lblUsd'

.text(jSonObj.USDInr);
$('#lblUsdBig'

.text(jSonObj.USDInr);
$('#lblUsd'

.css({ color: jSonObj.colrUSDInr });
$('#lblUsdBig'

.css({ color: jSonObj.colrUSDInr });
// clearTimeout(t);
t = setTimeout(""CallLivePrice()"", 2000);
}
function OnError(request, status, error) {
//alert('f'+status);
$('#lblSpotGold999'

.text(""NA""

;
$('#lblSpotGold999Big'

.text(""NA""

;
$('#lblSpotSilver999'

.text(""NA""

;
$('#lblSpotSilver999Big'

.text(""NA""

;
$('#lblSpotGold50gm'

.text(""NA""

;
$('#lblSpotGold50gmBig'

.text(""NA""

;
$('#lblSpotGold916'

.text(""NA""

;
$('#lblSpotGold916Big'

.text(""NA""

;
$('#lblSpotGoldBid'

.text(""NA""

;
$('#lblSpotGoldBidBig'

.text(""NA""

;
$('#lblGold'

.text(""NA""

;
$('#lblGoldBig'

.text(""NA""

;
$('#lblSilver'

.text(""NA""

;
$('#lblSilverBig'

.text(""NA""

;
$('#lblUsd'

.text(""NA""

;
$('#lblUsdBig'

.text(""NA""

;
// clearTimeout(t);
t = setTimeout(""CallLivePrice()"", 2000);
}
window.onload = function () {
CallLivePrice();
}
"
-----
But you could easily find out this viewing the source code or the page.
For other Excel related questions, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.
Regards!