I've noticed some sites that read/publish account performance and history in real-time, which is made possible by way of using account credentials to log into broker's server and retrieving account statements periodically.

Microsoft Access and Excel both include features to get external data from other sources, my question is; how does one utilise a similar method of retrieving the above data in real-time and linking it to Access/Excel?

Your suggestions and help is greatly appreciated.