Stock Quote and Last Price in Excel 2007

[JKC]

How can I get the Last Price value from the Stock Quote function in Excel 2007.

 

[Don Guillett]

goto
(e-mail address removed)
and look in the files section. There are several free files.
I have a couple of free files under author donalb36

 

[JKC]

How do I go to (e-mail address removed) ? Can you give me a link.
Thanks

 

[Don Guillett]

http://tech.groups.yahoo.com/group/xltraders/

 

[JKC]

Thanks for your quick response. I went to
(e-mail address removed), joined xltraders group and look into the
5 files you created. Although a few files showed Last Price but it is not
using the stock quote function of Excel 2007. I used MSNStockQuote in Excel
2003 and able to get the Last Price, but it does not work in Execel 2007. I
am using Excel 2007 trial version and would like to get production version if
I can get Last Price working.

 

[Don Guillett]

I do NOT use that function. I prefer to write my own and use Yahoo or other
source.