Hi, I have an excel sheet that gets reloaded with new symbols twice a day, using a simple macro to cut and paste from an outside source into excel. What I would like to be able to do is automate the importation of two fields - today's volume, and average volume - from the net into excel. I plan on using 20min delayed data. I have my symbols running down a column, and I would need to have the query automated so that it reads each symbol, and then puts today's volume and the average volume for each symbol in the next two columns. I realize that excel has a query file prebuilt for stock quotes, but I'm not sure how to use it for a column of tickers.... Anyone know the quickest way to get that stuff into excel?? thanks! -bung
(1) First try cutting and pasting the ticker data into Excel. If this is not possible and there is no other way of producing a suitable format from the source, try using a text capture with SnagIt - maybe this will be more amenable to importing. (2) Sort the table from (1) alphabetically by stock symbol. (3) Use the VLOOKUP function to fill your 2 columns from the corresponding imported table. Once all the quirks in (1), (2) and (3) are ironed out, automate the process with a macro. Disclaimer : Never done this myself, just trying to help.
Thx anyway...found a plug-in I downloaded that will do it with minimal effort. Only thing I don't have yet is avg volume.