I looked at all your variations, but I need only a simple stock quote return.
Giving sysmbol, long name, date, time, current price, last open last close.
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

Form what source?
If you have a realtime trading platform, most have excel a DDE links
available.
Although, depending on what platform you use and your permission level, you
may not get dividend Exdate and Paydate. Probably need Reuters or a Bloomberg
terminal for that.


Rick wrote:
I looked at all your variations, but I need only a simple stock quote return.
Giving sysmbol, long name, date, time, current price, last open last close.
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

--
Message posted via http://www.officekb.com

I'm using Excel 2k.

"blackbox via OfficeKB.com" wrote:

Form what source?
If you have a realtime trading platform, most have excel a DDE links
available.
Although, depending on what platform you use and your permission level, you
may not get dividend Exdate and Paydate. Probably need Reuters or a Bloomberg
terminal for that.


Rick wrote:
I looked at all your variations, but I need only a simple stock quote return.
Giving sysmbol, long name, date, time, current price, last open last close.
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

--
Message posted via http://www.officekb.com

Where are you getting your market data?

Rick wrote:
I'm using Excel 2k.

Form what source?
If you have a realtime trading platform, most have excel a DDE links
[quoted text clipped - 7 lines]
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1

From Cnn, or Yahoo. Their financial pages. I would perfer not to have to do
the lookup and update, in this maner. I would rather use excel to get the
updates.

"blackbox via OfficeKB.com" wrote:

Where are you getting your market data?

Rick wrote:
I'm using Excel 2k.

Form what source?
If you have a realtime trading platform, most have excel a DDE links
[quoted text clipped - 7 lines]
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1

I have a free open-source add-in that can grab quotes and other
financial data from the web. The add-in, documentation on its
functions, and sample templates, can be found in the files area of
this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

For example, there is a function to grab current quotes. Array-
entering this formula over a 2-row by 3-column range:

=RCHGetYahooQuotes("MMM,IBM","snl1")

....would use Yahoo's current quotes interface to return ticker symbol,
company name, and last traded price for tickers MMM and IBM. You can
also refer to cells, as in:

=RCHGetYahooQuotes(H33:H34,I32:K32)

....where H33:H34 are cells that contain ticker symbols and I32:K32 are
cells that contain Yahoo data codes (there are dozens of them).

Microsoft also has an add-in, but theirs is limited to fewer data
items:

http://www.microsoft.com/downloads/d...9-3BF0A740A9B1

On Jul 3, 7:14 am, Rick wrote:
From Cnn, or Yahoo. Their financial pages. I would perfer not to have to do
the lookup and update, in this maner. I would rather use excel to get the
updates.