Author: SGXcafe

Close Price vs Last Traded Price

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...

Read More

Portfolio Changes: Current Cost vs Closed Cost

Wrong Total Cost Recently, a user highlighted that Total Cost in StocksCafe was computed wrongly and he (I assumed it’s a he based on the username) is correct. I previously computed Total Cost as “Sum of [buy price x number of shares] for each stock currently in portfolio”. However, this is inaccurate as he has pointed out, and I agree. Therefore I have changed the definitions of Total Cost and also introduced new terms: – Current Cost (or Current Positions Cost), and – Closed Cost (or Closed Positions Cost). New Definitions Current Cost = “Sum of [buy price x...

Read More

MemCached For A Faster StocksCafe

Since the drastic move to re-architecture StocksCafe and adding support for two new markets at the same time in April, StocksCafe website have became slower. I am aware of that and have been taking significant amount of time trying to improve it. To be very honest, I am not 100% sure what is the true cause although I am inclined to think that it is due to a summation of reasons such as poor database configuration, increased data volume etc instead of a single cause. Speaking of which, if anyone is an expert in MySQL or MongoDB among us,...

Read More

Market Update Emails Fixed

For the past two days, some users have noticed missing information in their market update emails. Specifically, it is the Cost, Day Change, P&L, etc of each portfolio that is missing. This issue affected users who have only a single currency in their portfolio. It has now been fixed and you should see those details in your emails again from today onwards. A big thank you to all users who took time to alert me about this issue. I am personally not affected by this bug as I have multiple currencies in my portfolio and hence would have not...

Read More

Open Invitation to Financial Bloggers and Quick Feature Updates

As StocksCafe is currently expanding beyond Singapore to other markets in Asia, I am now looking to feature financial bloggers from around Asia. If you are a financial blogger or if you know of any financial blogger that writes about stocks or financial related topics focusing on Asia, please let me know either via private messaging or by simply commenting on this article. In other updates, I would like to quickly share a few new features that I worked on this weekend: 1) Portfolio Summary Graph Now, you can have a quick graphical view of how your portfolio has...

Read More

Errors in Portfolio Report

If you looked at your portfolio report these past few days, you might have noticed an unreasonable increase (typically well beyond 1000%) in your portfolio time-weighted returns, as well as a sharp increase in ES3’s monthly volatility (>20%). Firstly, I am very thankful to users who took the time and effort to report this issue. Some users even went a step further to take screenshots to ensure that I can easily understand the problem. In fact, several users did so independently. It is very important for users to report irregularities because many a time, I do not even see...

Read More

Malaysia Bursa Stocks Now Available!

As I was working on the final phase of the HK integration, I realized that it might be better if I also had Malaysia stocks information because news agency and blogs that I wanted to index tend to have news/articles on both markets. Hence, last weekend, I switched gears and started integrating Malaysia stocks into StocksCafe as well. I am happy to share that you can look up information of Malaysia stocks, add them to your portfolio or watchlist, and even screen through them using Screener. However, there are currently two known issues with them: 1) For some reason,...

Read More

Screen for HK Stocks in StocksCafe Now!

This is a short article to quickly share what I did for StocksCafe this past weekend: Screen for HK stocks I have updated the Screener so that you can now also screen for Hong Kong stocks! New Facebook Page As I have recently migrated the website from SGXcafe to StocksCafe, I wanted to change name on the facebook page from SGXcafe to StocksCafe, but was repeatedly rejected by Facebook. Hence, I decided to create a new page and would like to use this going forward. Go here and be the first few to like it ;) Remove Rarely-Used Features...

Read More

Inactive Users

As the number of registered users in StocksCafe continue to increase, there are bound to be users who have registered but stopped using StocksCafe. Currently, I continue to update their portfolio and even send them the daily market update emails (if they have set it up that way). However, this is bad for everyone. For the inactive users, the daily market update emails are likely deemed as spam. For StocksCafe, computing resources are wasted. For current active users, it means less computing resources are spent on them leading to slower response, delayed updates, and later daily market update emails....

Read More

Completed: Phase 2 of Hong Kong Market Integration!

After successfully migrating StocksCafe to the new domain and infrastructure, I have been working on further integration with the Hong Kong Market. Hong Kong Market IntegrationI am glad to share that phase 2 (of 3) of the Hong Kong Market integration is completed. This means you can now add Hong Kong stocks into your portfolio and/or watchlist, and of course also have access to all the associated features. Multiple watchlists are also possible now for users who would like to separate their watchlists by market (or any way you like). As we are now in the last phase of...

Read More

The Great Migration to StocksCafe

The migration of SGXcafe to StocksCafe will happen this weekend! This is more than simply the changing of domain names. When I first started SGXcafe, it was meant for myself hence I simply dumped everything onto a single server. That was easy and convenient, but certainly not robust nor scalable. I have spent the last few days designing and configuring a brand new multi-server infrastructure and now it’s ready to go. I will start the migration on Saturday 8 April at 7am. I expect that the entire migration will take about 3-4 hours. SGXcafe will not be accessible during...

Read More

Hong Kong Stock Exchange Information Now Available!

After many hours of coding, I am happy to share that Phase 1 (of 3) of the expansion to Hong Kong is now complete! Information about Hong Kong stocks is now available in SGXcafe (e.g. CK Hutchison). At the moment, it hasn’t been incorporated into the search yet, but you can find the full list of active stocks in Hong Kong Stock Exchange here. In Phase 2, I will focus on features revolving around adding Hong Kong stocks to your portfolio/watchlist. I expect this to take place over the next 1-2 weeks. As SGXcafe is expanding beyond Singapore, it...

Read More

SGXcafe to Expand to APAC!

After a round of voting and discussion with Friends of SGXcafe, I am happy to share that we have decided to support APAC markets in the upcoming expansion! I have already started work to include Hong Kong exchange data. You should start to see changes within this week. Supporting a brand new market is not easy and would take time to iron out all the details, especially since I developed SGXcafe previously with the assumption that I would only support SGX (as you can clearly tell from the domain :) I estimate it would take until the end of...

Read More

SGXcafe Turns 2!

The first article of SGXcafe appeared on 15 March 2015, hence I set this date to be the birthday of SGXcafe. On this day, let’s review the good and bad that happened in the past year. The Good SGXcafe has grown significantly in the past year; it currently has more than half a million pageviews every month coming from 30,000 unique visitors. More importantly, it has received support from 177 users in the form of money, and numerous others via feedback, bug reports, and suggestions. Thank you all very much! Personally, through SGXcafe, I have also gained in many...

Read More

Stock of The Day

One of the most highly voted feature now in Friends of SGXcafe is “Stock of The Day”. The idea is to feature a stock every trading day based on some criteria. At the moment, I have come up with five criteria to select the stock of the day. 1) Significant Increase in Visitors – The number of visitors viewing a stock’s page significantly increased in the last three days compared to the previous three days. 2)┬áMost Mentions By Blog Posts – A stock that is mentioned numerous times in blog posts in the last two weeks. 3)┬áMost News Views...

Read More

Like us on Facebook

Follow us on Twitter