Is there a way to have a list of stocks tickers in one colume and have excel go out to somewhere in the WWW and retrive the current (or closing) price of it?
years ago it could be done using yahoo Fin. but that doesnt work anymore.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Stock price lookup
0
Discussion
There are such ways. And there is code out there you can find and download. Please look to the left on this page. "VBA Macro to Import Web data into Excel: how to create a list of stock prices". You might start there.
Variatus (rep: 4889) Apr 15, '20 at 11:06 pm
Thanks, i'll take a look and see if i can figure it out.
dav Apr 16, '20 at 9:05 am
I think i need more of a plug n play way of doing it, not coding, could handle a simple macro but this is way more involved
dav Apr 16, '20 at 3:33 pm