Static Web Query
 

I am trying to research something. How can I make the stock symbols I have
entered into my spreadsheet retrieve static information without me doing
anything. I currently have a daily query that retrieves changes in stock info
so that I can filter out the stocks I like to trade, but it only updates the
stock price daily. In addition to this I would like to be able to use a
static web query for when stock prices reach my entry and exit points. It all
seems very complicated to me. Do I need to create my own web query file? Is
there a macro that I can set up to automatically do this? Or should I set up
a web query with refresh? I think at this point I am led to believe that a
static web query is the most efficient way of doing this? But then I need to
find out were on the web to get the quote information and how to make a
static web query? Am I loosing my mind? LOL
Can someone explain this clearly enough so that I can understand what to do?
Everything I have found online is for those who already know how to do it...
For each stock symbol in column P, I need it to retrieve a stock price in
column AB?
--
Thank you!

Static Web Query
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Doug" wrote in message
...
I am trying to research something. How can I make the stock symbols I have
entered into my spreadsheet retrieve static information without me doing
anything. I currently have a daily query that retrieves changes in stock
info
so that I can filter out the stocks I like to trade, but it only updates
the
stock price daily. In addition to this I would like to be able to use a
static web query for when stock prices reach my entry and exit points. It
all
seems very complicated to me. Do I need to create my own web query file?
Is
there a macro that I can set up to automatically do this? Or should I set
up
a web query with refresh? I think at this point I am led to believe that a
static web query is the most efficient way of doing this? But then I need
to
find out were on the web to get the quote information and how to make a
static web query? Am I loosing my mind? LOL
Can someone explain this clearly enough so that I can understand what to
do?
Everything I have found online is for those who already know how to do
it...
For each stock symbol in column P, I need it to retrieve a stock price in
column AB?
--
Thank you!