On Wednesday, June 20, 2012 8:01:24 PM UTC+5, joeu2004 wrote:
"PJ Hooker" wrote:
Never mind, sorry to have bothered you all.
[....]
It would seem that Issue date was just mentioned as a
reference and is not required for PRICE calculation of
a security

You got it! Hmm, did it really take me an hour to write my lengthier
explanation of the same conclusions? Or is you computer clock off? Or did
it just take that long for your follow-up posting to propagate to my news
server?

I posted my original question at around 5AM pacific daylight time then wandered out to a local market to have a daily meal of a hamburger. Whilst having my meal, I realized that issue date had no effect on the price and the wording of the article on Microsoft was bit confusing

Then got back home at around 7AM pacific daylight time and posted my observations.

I use Google Groups to post on NewsGroups so I see my posts show up within a 5 to 10 minutes delay

Rhetorical questions. Just wanted to explain that the only reason I seemed
to have posted the same conclusions an hour later was because your follow-up
had not appeared on my news server when I started writing. I did not intend
to post a "me, too" response. :-)

No worries Joe, your answers were right on the point :)
Joe, do you work for Microsoft???
As I noticed you contribute a lot on Microsoft Answers and Microsoft's NewsGroups

[
That is your first mistake:
reading Microsoft documentation. :-) :-)

Just kidding! But the point is:
don't try to read too much into Microsoft documentation.
Often they are full of errors, irrelevancies and poor
examples.

I cannot really speak for the non-finance
English major who wrote the
Microsoft documentation. :-)
]

A while ago I landed on one of Microsoft's documentation page for Excel. The article was revision of on older article yet the revisionist didn't bother to do the investigation of the topic. I am not going to show you the link to it, it will look very bad for Microsoft for someone to read that and knowing that it is plain wrong. In any case if you are curious Google this phrase

"compound amount excel"

without the quotes and follow the link to Microsoft Support site that is the first search result

BTW, I am building my own financial functions library for Excel (you can say reinventing the wheel but it is fun learning) but I am really short on time and it is very hot here so I only get to develop one function in four days after understanding the formula (if one exists) or the numerical method as is the case with Excel's YIELD function for which one has to understand Excel's PRICE function thus my original query

Thanks Joe :)