Author: SGXcafe

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 States due to my day job. During this period, one interesting feature that was suggested was to have a timeline so that users can know what is...

Read More

Try Award-winning Trading Platform And Be Friend of StocksCafe Forever

The first donations for StocksCafe came in May 2016. Although I was very thrilled to know that whatever I built is of enough value to people that many are willing to back it up, it was not my intention to build a paid product. However, the truth is StocksCafe is very dependent on donations as the ad revenue sustains only about 35-45% of current operating costs of StocksCafe. I have been thinking of and searching for ways to increase revenue without putting a strain on users, and I might have found a potential way, which is through the affiliate...

Read More

Dividends Projection

A little more than a year ago, Iadded a feature that projects how much dividends you are likely to receive for the current year in your Portfolio Report. Although it is a simple feature with naive assumptions, it is actually one of the top most-liked features. Hence, upon the request of Friends of StocksCafe, I spent some time over the weekend to include dividend projection in more areas of StocksCafe. 1) All Projected Dividends – List of all stocks with projected dividends. 2) Individual Stock – You can see it in both Stock Dividend Summary and Stock Dividend Details. 3) Portfolio Projected Dividends...

Read More

Current Cost vs Total Cost vs Max Deployed Capital

Recently, I have changed how the “P&L + Dividends + Closed” percentage was computed, from being based on “Current Cost” to “Total Cost” (read more about it in this article). However, several users have reached out and suggested that to base the “P&L + Dividends + Closed” percentage on “Total Cost” would penalize users who trade more frequently. Upon further discussions, we came up with “Max Deployed Capital” as one possible candidate to base “P&L + Dividends + Closed” percentage upon. However, not everyone agrees that it is the best approach. But perhaps, there is no single best approach....

Read More

Completed! – Hong Kong & Malaysia Market Integration

I am happy to share that after almost four months of effort, I have completed the integration for both Hong Kong & Malaysia. Almost every feature that is available for the Singapore market is also available for Hong Kong and Malaysia markets. A few exceptions are Dividend Strength, Future Yield (which is based on Dividend Strength) and Earnings Release. I will be attempting to build Dividend Strength models for Hong Kong and Malaysia stocks in the near future. Earnings release is also in the pipeline. What’s Next? For the past few months, I was overwhelmed by the boring integration...

Read More

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

Like us on Facebook

Follow us on Twitter


Recent Comments