It looks like the ability to download current stock prices (and other data) from Yahoo Finance (as a CSV file) has been discontinued (since 11/1/17). I've been using the code below to download a bunch of data for a list of comma-separated ticker symbols (StockTickers). Now it always gives the dreaded Run-time Error '1004':
Is there another option to download current stock data? If so, sample VBA code would be very helpful. I found info for the IEX API, but I don't know how to translate that into VBA (or if that's even possible).
The most crucial data I need is Last Price (or most recent price). I'd also like to grab other data like 52-week high and low, book value, P/E ratio, etc. if it's available.