Excel automated web query to get delayed info

B

bungrider

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.
 
You must log in or register to reply here.
Back
Top