Stock quotes pullup into Excel

S

Sam

How does one pull stock quotes automatically into excel 2000. There is a add-in function available for 2002 and 2003. It does not seem to work with excel 2000.
 
K

Kevin Stecyk

Hi Sam,

I know Don Guillett has helped several people with stock quotes. Hopefully
he will stop by and assist you.

But if by chance he misses your message, you might wish to search through
Google:

http://www.google.com/advanced_group_search?q=group:*excel

using Don Guillett as the author and "stock quote" (without the quote marks)
as the all words. You will see posts by Don concerning this topic. I don't
believe you need to upgrade from XL 2000.

I'll be watching because this topic interests me too.

Good luck.

Best regards,
Kevin


Sam said:
How does one pull stock quotes automatically into excel 2000. There is a
Click to expand...
add-in function available for 2002 and 2003. It does not seem to work with
excel 2000.
 
D

Don Guillett

I use the query tables method to get from Yahoo.

X = [quotes!a65536].End(xlUp).Row
For Each c In Sheets("quotes").Range(Cells(5, 1), Cells(X, 1))
symbols = symbols & "+" & c
Next

URLAddress = "http://finance.yahoo.com/d/quotes.csv?s="
mystringend = symbols & "&f=snd1t1l1ohgpv&e=.csv"
qurl = URLAddress + mystringend
With Sheets("Data").QueryTables.Add(Connection:="URL;" & qurl, _
Destination:=Sheets("Data").Range("b2"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

--
Don Guillett
SalesAid Software
[email protected]
Sam said:
How does one pull stock quotes automatically into excel 2000. There is a
Click to expand...
add-in function available for 2002 and 2003. It does not seem to work with
excel 2000.
 
Top