I would suggest using Google Sheets to track current stock prices. It's much easier to accomplish this. Refer to this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4tsJZeB8AoI.html
Let's say I've got a portfolio of, say, 60 stocks, and I want to track certain aspects of their daily rate of change; is there a way to get excel to connect with yahoo finance and download all 60 tickers together; rather than taking an hr to download them one at a time?
I hear you. I track hundreds of stocks and the best way by far is using Google Sheets. I did a video on this in the past showing how you can do that and import in Excel if you wanted to. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H1jH74kAp6M.html