Any help would be great thanks.
tradeinterceptor has a excel add on that will update with live price data or use historical data. Its a free add on I think you have to register to be able to download. This add on does not have any sort of formulas included but it is the only free way I have seen to get a live price feed from a broker into excel for free.