Real-time Stock Prices

Hi guys,

I'm tracking my stock portfolio in an Excel sheet, and I wanted to know if there is a way to put a URL or formula in the sheet such that when the workbook is opened it automatically fetches the latest price.

I've tried many guides for this online, but none have worked so far. Let's take the VYM ticker for example.

Your help is much appreciated, and thanks in advance!

Originally Posted by 6StringJazzer

Where are you getting your quotes from currently? It might be possible by using web queries and then using VBA to automatically refresh the queries when the file is opened, or by using VBA to directly fetch the HTML and then parse the HTML.

It doesn't matter, I don't mind getting my quotes from any page. I guess I can get them from where it is easiest to work with in Excel, but ideally Google Finance.

I looked at a couple of finance pages but don't see a straightforward way to grab the current trading price for multiple stocks with a web query. I think it needs VBA to parse the HTML, which I don't have experience with.