Hey I was looking for help in regards to creating a VBA that would retrieve real-time stock quotes from the MSN money central investor stock quotes data connection in excel for my list of stocks (over 100). Basically I'm looking to populate with info my: Last Price, Sector, Industry, Country, Market Cap (In millions). If all columns are not possible I would at least be able to attain last price. Please if possible provide me with info on how to do this or if possible a sample code to work from.
Thanks,
Leighton
Bookmarks