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

Ron, sorry about the late reply, I've been distracted for a few days. I'm
getting Australian stock data from the ASX and I first noticed this on a
stock called Antares Energy Ltd (AU:AZZ). Its currently around the 67c mark
and according the the ASX website (www.asx.com.au) it opened today 15 Jan at
..705 which so far is the day's high, with a current low at .665 and last sale
at .67

I find the wording of the formatting option a bit ambiguous. Does it refer
to your own pre-set sheet/cell format, or the formatting of the price from
the data source?

"Ron Rosenfeld" wrote:

On Mon, 11 Jan 2010 22:16:01 -0800, Ken G
wrote:

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.


Yes to both questions. And I de-selected the "formatting" option in the MSN
Stock Quote GUI.

I tried several stocks that trade for less than $1 as well as a few foreign
ADR's which also trade that way.

Occasionally there is data well past the 2nd decimal place (e.g.
17.45000076293950, 0.68999999761581) which I assume is just related to the
inability to express some decimal values in binary.

What stocks/values are you seeing?
--ron
.