I’ve built an Excel Add-In which feeds live financial data to cells via simple formulas. I currently have data from Yahoo Finance and IG Index, I am working on other data providers.
For example to populate a cell with the latest Apple stock price: =EPF.Yahoo.Price(“AAPL”)
I have some users using it to automatically keep track of the value of their portfolio across different brokers and I also helping one guy working on an automated trading system in Excel.
Here's a tutorial on using it to build a realtime investment portfolio
You can try it free for 10 days at https://www.excelpricefeed.com
Hope it helps somebody!