Stock Quotes

[Guest]

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.

 

[blackbox via OfficeKB.com]

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.

 

[Guest]

I'm using Excel 2k.

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.

 

[blackbox via OfficeKB.com]

Where are you getting your market data?

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]

 

[Guest]

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.

Where are you getting your market data?

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.

 

[Randy Harmelink]

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/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1