Thread: Stock Quotes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken G Ken G is offline
external usenet poster
 
Posts: 34
Default Stock Quotes

Two things - have you allowed for more than 2 decimal places in your
formatting, and secondly, only smaller priced stocks trade in fractions of
cents, so if you have all blue chips for example, you'll only get two decimal
places. Add a couple of penny stocks to your list and see if you get 3
decimals.

"Ron Rosenfeld" wrote:

On Mon, 11 Jan 2010 19:31:01 -0800, Ken G
wrote:

Look here ...
http://www.microsoft.com/downloads/d...displaylang=en


"Ron Rosenfeld" wrote:


what add-in?
--ron
.


Interesting.

I use that add-in, and all my quotes come back with just two significant
decimal places.

The data providers are listed in Help for the add-in.
--ron
.