I work work for an Asset Management firm. They asked me if it was possible to write VBA code for a spreadsheet that will retrieve a clients financials from a TD Ameritrade account and put it into an excel spreadsheet. I imagine that is possible although I'm not sure how to accomplish such a task. I'm not familiar with how to use VBA to interact with the internet.

So essentially how could you take an account username and password, put it into a browser and fetch the financials from the site and put it into a spread sheet? Thus automating a lot of what interns do.