Over the last few months I have been trying to find way to be more disciplined towards my trading as well as automating most of my analysis, calculations and stock selection activities. Some of my specific objectives are:
This is a long discussion and requires a number of posts but I want to present one of the tools I have been working for quite a while now, my Fundamental Stock Selector and Scoring Tool, or simply Stock Selector. The purpose of this tool is:
I have done a preliminary scanning to find the Top Stocks based on my own screening critieria, which is mostly focused on finding Growth Stocks. At a high level, here are my filter and scoring parameters:
The first part of the tool (which was built in Excel) is called the Stock Score. This tool will output a “score” which quickly tells me about the stock health - please note this scored is based on my “own” critieria. The score varies from 0-90 and the higher the score the better. I will not trade any stocks with score below 60. Let’s look at two scenarios, one high score stock and another low score. When I type a stock symbol here’s what I get:
Goodness reflected on the chart
![]()
And now let’s look at a low scored stock;
![]()
pain reflected on the chart:
Scoring Multiple Stocks - here’s what the “alpha version look like” — these are the top scored Canadian (TSX only) stocks in my list:
Why do I bother with this “fundamental” stuff ? It’s just another edge to the technicals.
That’s it for tonight, long day at work and writing. Have a good working and trading day tomorrow.
This is another process that is part of my Trading Plan. Once I have my Universe-TSX and Universe-US watch lists in place I will scan the stocks inside this lists for technical signals. My scanning will be done using one or more of the following techniques:
As described in my selection process, stocks displaying trading potential will be moved to my "Hot" watch list.
Removing Stocks from my Hot Watch List - I will perform a daily visual scan on the stocks inside my "Hot" list and if I see any candidates that are no longer considered tradeable I will remove it from the list. During this procedure I will also make decisions on stocks that I want to trade.
Selecting Candidates for Trading - Once I decided on the stocks I am considering opening a position, I will enter them into my Position Sizing Tool, which is also in Excel. This tool will allow me to make a decision on which stocks are more suitable for trading based on Risk X Reward comparison.
Stocks Selection based on Fundamentals - I am currently refining my trading plan and one of the areas I want to improve is my screening process for fundamentally sound TSX stocks. I want to find a tool that I can run regularly just so become brainless to maintain what I call a "stocks universe" — this is essentially my list of fundamentally strong candidates. I normally do nightly visual inspection of these stocks looking for chart patterns.
The steps in creating and maintaining my "Universe-TSX" watch list because I will have an "Universe-US" will be as follow:
Some of the screening options for TSX stocks are:
*TSX Stocks only
*Price/ Earnings (Last 12 Months) >= 1.0
*Return On Equity >= 15.0
*Profit Margin >= 1.0
*Operating Margin >= 1.0
*Current Stock Price ($) >= 8.0
*Out-Performed Sector - 4 weeks
For US stocks my current options and preferences are (in order):
Watch Lists Maintenance - These is the next step after the stocks screening. So far I have the following lists:
Every night I will visually scan all the stocks in these lists and if I see anything good I will put it under close watch by adding it to my "Hot" watch list. This is the list I will watch during the day.
I will also have other watch lists in addition to the ones already mentioned. Here’s my complete list of "watch lists":
| List Name | Holds | Update Frequency |
| Universe-TSX | tradeable TSX stocks | Weekly |
| Universe-US | tradeable US stocks | Weekly |
| Hot | stocks to be watched during the day, ready to trade | Daily |
| TSX 60 | tsx 60 stocks | Quarterly |
| Dow Jones | Dow Jones components | Quarterly |
| Indices | list of indices and sector ets | Quarterly |
| ETF-All | complete list of ETFs | Quarterly |
How will I select my trading candidates:
How will I filter them:
When will I enter:
Where will my stop be:
How many shares will I trade:
How will I take profits or exit:
Well, that’s my basic trading plan for stocks. Wish me good luck.