So I've been playing with MSN's MoneyCentral Investor Stock Quotes to pull in data, and it works great. But this connection doesn't bring in certain data I'm looking for (Bid/ask price and bid/ask sizes).
I can get this if I grab external data via the web, but only for a single symbol.
What I'm trying to do is grab data from Yahoo Finance/MSN Money (I don't care which) for a long list of symbols I have in Excel.
Right now I'm only able to bring in one Symbol's data set at a time.
I also tried creating an Excel web query file but that didn't grab the info I wanted either.
Any ideas? I'm pretty sure it can be done by importing via the web but I'm running out of ideas.
I'm trying to learn Macros but I'm a total newbie at the macro stuff.
Thanks for any ideas.
I can get this if I grab external data via the web, but only for a single symbol.
What I'm trying to do is grab data from Yahoo Finance/MSN Money (I don't care which) for a long list of symbols I have in Excel.
Right now I'm only able to bring in one Symbol's data set at a time.
I also tried creating an Excel web query file but that didn't grab the info I wanted either.
Any ideas? I'm pretty sure it can be done by importing via the web but I'm running out of ideas.
I'm trying to learn Macros but I'm a total newbie at the macro stuff.
Thanks for any ideas.
