I've noticed some sites that read/publish account performance and history in real-time, which does so by way of logging into the server and retrieving account statement periodically at set intervals.

I would rather use my own analysis methods and store the data locally using Access and Excel - both have built in features to get external data from other sources.

How do I go about logging in to the server to link my account to my spreadsheet?

Your suggestions and help is greatly appreciated.