Loading...
It might sound like a riddle, but this is actually a valid question. Retail investors would surely want to know whether there is a correlation between the day of the week and the number of gaining counters outpacing losing counters on that particular day.
It is not just ordinary investors who are curious — stock market gurus would be interested too, especially those who do Live Trading. If possible, they would certainly want to pick the day that statistically shows the highest probability of making a profit.
For this session, we start with a Question, because we do not yet have a specific day that we know for certain has a ''high chance'' of making money. If we already knew, we would formulate a Hypothesis to be tested rather than a Question.
This section covers our data source. It depends on how we want to manipulate our data.

2. Review the extracted data to ensure it is free from errors. In this phase, what we want to see is whether the data is correct or not. How many rows and columns does our data have? Does the extracted data truly cover all the stocks available?

3. Next, we need to determine the day of the week based on the dates we have. If you were to check each date one by one against a calendar and then write it back manually... that would be exhausting. Thankfully, we have programming and computers to make our work easier.

4. Our next task is to identify whether a counter gained, lost, or remained unchanged on that day. For this, we need to find the difference between yesterday''s closing price and today''s closing price.

5. We label each row as gain/loss/unchanged based on the difference between today''s and yesterday''s closing price.
6. After obtaining all labels (gain/loss/unchanged) for all counters, we then tally them by label and also by day of the week (Monday/Tuesday/Wednesday/Thursday/Friday).
7. The final phase is data visualisation. For this session, we only rearrange and slightly modify the structure of our data. In future sessions, to aid understanding, we will present the data in the form of charts and graphs.
In conclusion, the best day to trade is Friday, followed by Wednesday, Thursday and Tuesday. The worst day is Monday.
If you are excited or keen to see the full procedure of this data study from start to finish — including the programme we used, the coding, and so on — you can register as a FREE member of the Mahersaham website.
After registering as a member, you are invited to watch the FULL VIDEO of approximately 40 minutes in the section below (accessible to Mahersaham members only).
What are you waiting for? Open a CDS account now with Mahersaham and you can join exclusive classes for Mahersaham clients.
Based on our statistical analysis of Bursa Malaysia data over a 5-year period, Friday is the best day to trade stocks. It is followed by Wednesday, Thursday, and Tuesday. Monday tends to be the worst performing day.
We analysed historical stock data by comparing each day''s closing price against the previous day''s close. A day is considered ''good'' when the number of gaining counters exceeds the number of losing counters. We only analysed main board counters, excluding warrants.
While our data shows Monday has the weakest performance statistically, it does not mean you should completely avoid trading on Mondays. The data shows a general trend, but individual stock performance can vary. Use this information as one factor in your overall trading strategy.
This analysis covers main board counters on Bursa Malaysia and excludes warrants. External factors such as global market sentiment, economic news, and company-specific events can influence daily performance beyond what the day-of-the-week pattern suggests.
Want to learn more about stock investing and data-driven trading strategies? Open a CDS account with us for complete guidance from basics to advanced. Also download our Free Stock Ebook for a solid foundation.