Excel and Yahoo Finance

david_oc

Hi,



Does anyone know if it's possible to get Excel to auto-download stock quotations from Yahoo Finance?



There's a VBA add-in, XLQuote, but it only works for Windows.

grayshades

Quote:

Originally Posted by david_oc


Hi,



Does anyone know if it's possible to get Excel to auto-download stock quotations from Yahoo Finance?



There's a VBA add-in, XLQuote, but it only works for Windows.

Try these two links from MS: One is estbalishing the query,a dn the other uses VBA to automate.



How to create Web queries in XL for Mac



How to Programmatically Perform a Web Query, even though it says XL 98, the process should still work through XL 2004.