Stock Quotes to Excel

[Angelika & Rocky Mckinley]

Hi,

Is there a way to pull stock quotes directly from the internet using Excel
vb? All I want is simple code where I read the ticker symbol in cells(1,1)
in the activesheet and it pulls the latest stock quote into cells(1,2). I
can write the rest of the code. My only hitch is that I'm running Mac
Office 2004.

Thanks in advance,

Rocky

 

[David]

Hi,
Take a look at the Data Menu/Import External Data/New Web Query
David

 

[ryguy7272]

This probably has everything you could want or need:
http://groups.yahoo.com/group/xltraders/

Create an account (if you don't have one), login, and click 'Files' on the
upper left hand side of your screen.

Also, if you use MS Explorer, you can get on a stock-related web site,
right-click, and click 'Export to Microsoft Excel'.

Regards,
Ryan---

 

[Don Guillett]

I have some free files there under donaldb36 but I don't think there are
many for mac

 

[Angelika & Rocky Mckinley]

Excel 2004 for Mac doesn't seem to recognize this command and I can't find
any vb help on it either, so maybe it doesn't exist.

Rocky

 

[Angelika & Rocky Mckinley]

Hi I tried what you said and created an account but none of the files
actually worked in excel 2004 for Mac. Too bad I'd like to pull live quotes
in and manipulate them for analysis.

Regards,
Rocky

 

[Don Guillett]

Maybe?? this will help
http://www.google.com/search?source...4GFRD_en___US219&q=stock+quotes+for+excel+mac