Import Unique Web Data

  • Thread starter Thread starter pjw23
  • Start date Start date
P

pjw23

I am trying to figure out a way to be able to input a stock ticker int
a MS Excel data cell and then create a macro that will use the ticke
from the cell to input it into a web page in order to import the stoc
table information for that particular stock.

Up till now I have been having to go about this the manual way (Data -
Import external Data -> New Web Query....) and it gets a bit tim
consuming. There must be an easier way.

Has anybody else tried to create something like this? It doesn't see
like it would be that hard, but I am having a heck of a time trying t
figure this one out...

I am using OfficeXP on Windows XP Platform.

If anyone has any suggestions, or can point me in the right direction
Please let me know...Thanks for the help
 
pjw23,
Isn't there a .Requery or refresh method of the querytable. Or you set the
refresh rate in the querytables properties.

Nick
 
Not sure what you are tying to say!!!

What I'm trying to do is import data from the web through the use of a
macro. The macro will lookup a value from the spreadsheet and use that
value to obtain a webpage about the particular stock.

There is already a way to do it using the built-in "MSN MoneyCentral
Investor Stock Quotes.iqy". The problem is I don't want to use this
data, I am trying to get a more detailed quote that is in a better
format. The contents of the built in .iqy file look like this...
----start----
WEB
1
http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=["QUOTE","Enter
stock, fund or other MSN MoneyCentral Investor symbols separated by
commas."]

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
----end----

When I try and change the site with the one I would like to use I run
into problems. If anybody has any ideas please let me know...It's
really starting to drive me crazy.
 
pjw23,
Use your macro to set the cell values that the query is expecting as
parameters, once your query points to the correct web page.
Which problems are you running into ?

NickHK
 
Back
Top