Subscribe to RSS feed
posted on 18 Jul 2017  -  43,285 views
All along, I have naively displayed "Last Traded Price" and used it for all computations in StocksCafe without much consideration. That is until recently, when a user brought to my attention the difference between "Last Traded Price" and "Close Price". This led me to spend time learning about it and ultimately switch to using "Close Price" in StocksCafe instead.
Close Price vs Last Traded Price
Most of the time, the Close Price and Last Trade Price is the same. However, these two values could differ in some situations.
1) When the last traded price occurred several hours or even maybe several days ago. This usually happens for illiquid stocks where the last traded transaction happened quite some time before the closing time.
2) When a large volume of transactions happened just before the market close. Should the very last traded price be the close price? What if it is different from all the other transactions that happened just
split seconds before it?
Who Uses What?
To illustrate, let us look at an example:
iShares J.P. Morgan USD Asia Credit Bond Index ETF (QL2) in SGX on 18 July.
The Last Traded Price is SGD 14.75, whereas the Close Price is SGD 14.73.
Note: If you are reading this article on 19 July or later, the information in the urls below might have changed as not all websites have the ability to pin to 19 July.
Last Traded Price
BlackRock - The company "distributing" this ETF.
iii) Bloomberg Terminal - According to the user who raised this point to me.
Why Switch To Close Price?
To clarify, it was not a deliberate decision to use Last Traded Price when I started StocksCafe (or SGXcafe then). It just so happened that I started extracting the Last Traded Price and continued to use it.
Upon learning more about it, I agree with the user who highlighted this issue that Close Price is a better value to use as it will reflect the prevailing market conditions more closely and is less susceptible to manipulation, and therefore providing users of StocksCafe with better up-to-date prices for investment decisions and portfolio valuations.
How Do Exchanges Compute Close Price?
This is out of scope of this article but I will list down a few references I found.
How SGX computes Close Price for ETFs
How HKEX computes Close Price
How Thailand Exchange computes Close Price
Next Article >
< Previous Article
Completed! - Hong Kong & Malaysia ...
Portfolio Changes: Current Cost ...
List All Articles
Other articles by evankoh
Past & Future of StocksCafe
It's been three weeks since my last article, but in case you think StocksCafe is going dormant, it is not! During these three weeks, I have still been maintaining StocksCafe, answering queries and fixing reported bugs, etc. It's just that I did not have time to sit down and build a more sizeable feature that is worth mentioning. The main reason for this is because of my recent business trip to United ...
The Story of the Broken Email - "Thanks" to DigitalOcean
I would like to apologize for the email outage for the last three days. I have finally fixed the issue. All emails should be operating as usual from now on. Below is the reason why I had to manually activate accounts for new sign ups and why no daily market update emails were sent. The Short Version - My hosting provider, DigitalOcean, decided to block my SMTP port (needed for sending email) without ...
New Exchange Added: Support for Tokyo Stock Exchange!
I am happy to share that StocksCafe can now fully support Tokyo Stock Exchange! You should be able to use all the features that are available for Tokyo as well. This brings the total number of supported exchanges to six (SGX, HKEX, KLSE, USX, LSE and TSE!) One thing to note though is that I was unable to locate good English sources for news and blogs that covers the Tokyo market. So if you know of ...