Timing Solution Scanner v.2

First Run

Updating the Data

Prepare to Trade

Troubleshooting

 

Scanning the stock is a very popular feature used by many traders. The general idea of all scanners is simple: sorting a group of stocks in regards to certain criteria and picking up the stocks that fit those criteria in a best way. Criteria (or filters) used for rating the stocks are very different. Volume and the stock price as well as the price change are among the most popular.

Timing Solution Scanner (TS Scanner, TSS) is a new level of the stock scanning.  Together with standard parameters used in technical and fundamental analysis of stocks, TS Scanner provides an additional information regarding the stock's future moves. The program takes some group of stocks, performs a cyclical analysis for each item in the group and provides a list of stocks that you may consider suitable for your trading, with possible entry/exit dates. Standard parameters say about the stock's current "health", TS Scanner adds to that a "time" dimension.

TS Scanner is a stand-alone program.  It is able to work with equities and some other financial instruments. TS Scanner Version 2 has a modified tool for downloading multi stocks from public sources (Yahoo) and improved features of the program itself.

 (Disclaimer: Timing Solution Scanner does not provide any trading advice; it gives only some information to consider. It is totally up to you - what to trade and when to trade; the responsibility for the results of your trading decisions is yours, and yours only. Also, please note that TS Scanner works with the data provided by a third party (Yahoo Finance). Therefore, the responsibility for the amount and quality of the initial data is on that third party. ).

 

Video explanation: how to install TS Scanner



Video explanation: how to use TS Scanner




In brief, the process of working with TS Scanner is simple and consists of two major parts: a) feed the program with proper data; b) run the program to get a list of trading possibilities for a certain period of time and then monitor possible trades.

 Let us look at it in details.

A. Feeding the data

The data source for TS Scanner v.2 is Yahoo Finance. As of May 2020, it works with stock data only, Stock symbols are the same ones provided by Yahoo Finance: https://finance.yahoo.com/

To load the data, the open source software, Yloader, is used. You will use this program only when you run TS Scanner the very first time on your computer and every time you use a new template (see below).

First Run

1) Install YLoader program on your computer. This is the website to download this program:: https://yloader.com/ (The video above shows how to do that, the very first 50 secs ).

When installing YLoader, please pay attenttion to the folder where this program is installed. By default it should be this:

 

 

2) Run Timing Solution Scanner (TSS); it should be already installed on your computer.

 Here it is:

There are three panels there: the top one is the program itself (TS Scanner), the middle one serves for data feed; "Help" section contains this tutorial. We recommend to watch the video above that illustrates how to work with TS Scanner.

3) Start with running Yahoo Sectors Processor.  You will get this window:

 

4) Only one option in this window is filled. Please make sure that the location of YLoader program is defined correctly; it is here:

 

It should be the same "YLoader path" as the name of Destination Folder used when you installed YLoader program.

Click "Check" button. This prompt is displayed:

 

5)  Yahoo Sectors Processor prepares inputs for TS Scanner. Yahoo Finance has thousands and thousands of tradables. Considering just stocks, there are stocks traded on American exchanges, on exchanges of different countries and regions, stocks belonging to different sectors of economy, with multiple industry divisions inside each sector. Add to that Small. Medium, Large Caps. And mutual funds, currencies, ETFs, commodities. This is a lot of tradables to choose from! That is why you need to work with Yahoo Sector Processor - to select groups of stocks for the analysis. For that purpose, TS Scanner has templates.

On  Yahoo Sectors Processor, click button.

TS Scanner has provided several templates for your convenience. For a start, there are country-based lists of stocks. They are organized by sectors and industries as seen on Yahoo Finance website. You may download a template for a certain country (pay attention: some countries have several exchanges; though all stocks are in one list). Or you may work with templates for two or more countries at the same time. When using several templates at once, please remember that: a) you increase the processing time; and b) the stocks suggested for trading are traded on different stock exchanges. (More templates will be added. You will be notified by email when a new template is available.)

To download a template, highlight it by a mouse-click and then click "Open" button. To download two or more templates, highlight the first one, press Ctrl key and keep it pressed, then highlight other templates of your interest:

 

 

6) You may work with all stocks availble in the template/templates. Also, you can select the stocks of a certain price range. Do that here:

 

and click this button:

 

7) Click button to run YLoader program

 

8) You are redirected to YLoader program. Define "Symbols file" and "Download directory" options here:

 

Make sure that they are the same as in Yahoo Sectors Processor. You can type the names of the file and directory by yourself. Or, while you are still in Yahoo Sectors Processors, to speed up this procedure, you may copy them into clipboard using these buttons:,

and paste these values into YLoader.

9) Now we work with YLoader.  Make sure that the Data Source is Yahoo (do not try other sources yet; you will be notify if and when other sources are available):

 

10) Download Yahoo symbols by clicking this button:

A reminder: Internet should be available on your computer.

You are all set to work with your data in TS Scanner.

Updating the Industries

 

You have to use First Run procedure only when running TS Scanner the very first time and then every time when you use a new template. You have no need to repeat all those steps 1 - 10 when you want to have the most recent quotes. You will update the data directly from TS Scanner (TSS).

 

 

Working with TSS

 

TS Scanner performs stocks scanning to recommend the stocks that are suitable for trading within a certain time period. Version 2 (April 2020) works pretty much the same as the Version 1 (2015-2016). One of the differentces is in the part of downloading Yahoo data for analysis (see "Feeding the Data").

Here is the opening window of TS Scanner v.2:

You are already familiar with Yahoo Sectors Processor. Using its templates, you have downloaded some data to YLoader.

Let us work now with the top button, TS Scanner.

Click on it to open the main window of the program. 

There are four tabs there related to stages of your activity: Trade Planner; Prepare to Trade; Performed Trades and Statistics; and Options:

 

 When you get used to working with TS Scanner and have some open trading positions, - the first tab, Trade Planner, has the list of trades that you have selected previously. It will be described further down.

If there is no open position and you look for new opportunities to trade, start with the second tab, Prepare to Trade. It opens automatically when you click "TS Scanner"

 

Prepare to Trade

 

Here you perform a preliminary analysis to get candidates for your possible trades.

 At the start, it is empty, except of the name of the YLoader path and the sector's list to be analyzed.

Below are the steps to work with it:

Step #1. Update price history

Your trading day begins with updating price history. It is recommended to do every day, to confirm the trades that you have already planned as well as to find new possibilities. How to do that?

2) Click this button:

 

Check the option "Update" and then click "Download" button:

If the "Update" option is not activated, the program will download all available price history. That would be a waste of time as historical data are already there.

 

 

Step #2. Download price history and into program

Choose  the stocks you want to analyze. You may want to download all stocks from the file or just the stocks included into some sector of the economy or an industry inside the chosen sector. (A note: The program will show the sector and industry, only in case there are any stocks of the price range defined in Yahoo Sector Processor; it is in the Step 6, First Run section. If you are interested in stocks of some industry and have chosen a price range "Higher than $50", there might be no stocks of that industry and that price level. traded in the chosen region. It means that you will not see any positions in the screen.)

In the example below all available stocks are chosen (American stocks); there are 3279 stocks to anayze  (change this picture and correct the phrase):

Another example shows downloaded Basic Materials sector. Compared to the previous example, the program will analyze 137 stocks instead of 3279 (change this picture and correct the phrase):

The video above (the first one) shows 764 stocks, It is the amount of stocks to apply cyclical analysis filters.

As soon as the stocks are defined, click "Download" button. The program begins downloading the stocks information. The amount of stocks being downloaded is shown here, in the left bottom corner. It is changing till all stocks of this sector/industry are downloaded:

 

 

 

Step #3. Trading Schedule

All downloaded stocks are shown in the Main window of the program, right under the Calendar.

Now, the real job is starting. Please see Video 2; it shows how to perform the scanning of all these stocks.

You should define the period when you plan to trade, your trading schedule. These are potential dates when you may decide to open your trading positions.

To do that, put the mouse coursor to the first day when you plan to trade and drag it to the date when you want all these trades be over.

When that is done, click the button "Step#3. Your trading schedule":

 

Step #4. Calculation

Click "Calculate" button:

 

 

The program conducts cyclical analysis trying to find the best predictable zones for each stock inside the chosen trading interval.  For each stock, the program finds the best dates for trades based on seasonal pattern. This is how the output looks:

 

If some cell in a row/column is empty, it means that there is not enough data for that item. The stock may be recently listed and not having enough price history; the certain industry may be not presented in some exchange, etc. Please remember that TS Scanner is able to work with the data provided by a third party (Yahoo Finance), and that third party is responsible for the amount and quality of the initial data.

You can click on any row, to highlight it and to consider its fitness for your trading

 

Let's look at one of these record in details:

 

Stock

First column

 

says this is Financial 15 Split Corp. company, Yahoo ticker FTN-PA.TO (traded at Toronto Stock Exchange)

The price history is available since August 29, 2007 till now.

Price, Volume

The second column shows the latest price and volume (provided by Yahoo; check with Yahoo Finance what it actually means). It is suggested to use these values as a start for your decision making.

 

Chart

Third column shows a piece of the price chart for that particular stock, FTN-PA.TO. By default, it is the last 20 bars. You can vary it:

 

Annual Q-Cycle

The fourth record is the most interesting for us:

 

The information here is about the trading opportunity for this stock. The program suggests to buy this stock on May 18, 2020 and sell it on June 29, 2020 (as this is a period of the expected price increase for this stock).

The analysis shows that within last 12 years the price for this stock went up all 12 years within this period, since May 18 till June 29. Twelve light green bars indicate this fact.

As an example, consider the record for another stock, PWF-PH.TO:

The program has found that since May 15 till May 29 the stock price went up 11 times versus 1 time down.  You may read this colored bars information this way:

For the same period, May 15 till May 29,  the price for PWF-PH.TO went up - a green bar - in 2019;

in 2018 - the price went up;

in 2017 - the price went down (a red bar):

all previous years - the price went up.

Thus you can easily see what year this strategy worked/did not work.

For the initial example, our stock FTN-PA.TO, the price went up all 12 years.

Comparing these two, you may conclude that the expectation for the price of FTN-PA.TO going up again this year for that same period is higher, so it is worth to try trading this stock.

It is preferable to consider first the stocks where the price bars are all of the same colour, or the most of them are the same color. (You may want to look at the company's profile and history, to find out what happened with the company when the price bars change the color. Such additional information may help you to make a better decision.)

 

Industry Annual Q-Cycle

Next record "Industry Annual Q" involves the analysis of the whole industry. In this particular example, the whole industry shows uptrend movement since May 18 till June25:9:

 

FTN-PA.TO belongs to "Asset-Management" industry that involves 124 stocks. Statistic shows that this industry's stocks tend to go up since May 18 till June25 as well (with accuracy 55.8%). That fact gives an additional confidence to the suggested strategy.

 

S&P500 confirmation

S&P500 indicates uptrend within this period as well:

RSI and MFI confirmation

Here you can find Technical Analysis confirmation as an additional tool to confirm your trade:

 

RSI (Relative Strength Index) shows the strength or weakness of the stock (RSI over 70 means that the stock is overbought, and its price may go down. RSI below 30 means that the stock is oversold, and its price is expected to go up. In the example RSI is 60.9).

MFI (Money Flow Index); it is pretty much the same as RSI, though the values are 80 and 20 instead of 70 and 30 respectfully; it seems that RSI is more reliable.

If RSI or MFI fall in overbought/oversold zone, the program shows an appropriate arrow:

 

In this example, the stock is oversold, and the up ward movement is expected.

Confirmation based on Moon Cycles

There are some additional tools to confirm your trades. One of them is using Moon-based cycles. (This feature is experimental, your decision should not be based on it only.).

Set the "Moon filter" option ON:

The suggested trades are confirmed by Moon movement like in this example:

 For the stock CLIQ.TO, the uptrend movement since May 18, 2020 till May 27, 2020 is confirmed by the Moon tropical cycle.

A reminder: The Moon cycles can be applied for trades that will last less than 14 days; the Moon cycles are not applicable for longer trades (such as being in trade for 30 days).

 

Price Chart view

After you have considered all options related to the stock you may want to trade, it is recommended to preview its price chart and the performance of the recommended strategy in the previous years. Please do that before starting a trade. Do it this way:

 

The price chart for the chosen financial instrument (FTN-PA.TO) appears. The arrow in the bottom shows a recommended trade (up arrow it means the expectation of the up movement):

 

The buttons in the top right corner help you to navigate through the price chart. This button allows to see how this strategy has worked a year ago (in 2019, two years ago, and so on:

 

Step #4. My analysis

What to do with all these stocks?

You may sort them:

- alphabetically;

- in regards to Annual or Industry Annual preformance;

- by RSI or MFI;

- in regards to price values (do not forget to set a limit to the price for short trades) or volume;

- using filter combinations;

- in regards to up or down moves tendency

- and other details. 

This is the recommendation when choosing the stocks for your possible trades:

1)  Start with the Price range. It helps to define how many shares of this stock you would like to trade;

2) Look at the volume. You do not want to buy a stock for a window of 1 week if it is just a hundred shares on the market. 1 M is preferable in this situation;

3) Look at colors. Chart picture, all cyclical analysis columns of the same color is an indication to a good trading opportunity;

4) Consider the information in the Annual Q column. You would prefer to see the bars of the same color (all green or all red, or the most bars are green or the most bars are red). If there is a mixture (as an example, of 12 bars 10 are green and 2 are red) consider the stock with more bars of the same color in the end (it is better if 2 red go first and then 10 green are go, it means that the latest tendency for the last 10 years is going up for this predictable zone);

5) Consider if the Annual Q and Industry Q (and Q SNP for American stocks) show the same tendency;

6) Check if this tendency is confirmed by RSI and MFI (mostly by RSI).

7) Now, you think that this stock is worth to trade. Look at its price chart, with a special attention to the stock's performance on that same predictable zones in the previous years. You may want to consider the company's information as well.

You may not find any stock that you would like to trade within your potential trading period. If it is the case, select another interval. Or try another industry, economy sector, stocks traded on another exchange. Or you may want to repeat the whole procedure for a new template.

If you decide that you want to trade this stock, send it to Trade Planner (click the button next to "Price Chart" (add the picture???).

 

Troubleshooting

When downloading a template by clicking this button in Yahoo Stocks Processor:  , you may get this message:

 

   

 

or another one (invalid class string):

It means that Excel is not installed on your computer or there might be some problem with your MS Office account.

Here is what the Internet says regarding this problem, it might help you:

  • a) "So you're suggesting that the exception is being raised because of unactivated and unlicensed Excel and that activating it would fix that issue. Sounds odd. Btw welcome to Stack Overflow. – Bleeding Fingers Feb 19 '14 at 21:55 ";
  • b) "I've been experiencing the same issue with an unactivated version of Excel. I think in general it's caused by Excel being busy at the time you invoke it - that could be because it's attempting to show a dialogue warning that you don't have a valid license, or maybe you're attempting to open a spreadsheet with links and the linked spreadsheet isn't available etc.";


    c) I was facing the same error and many solutions suggested were not working for me. I had an application running in windows 8 and I found that the problem was Excel always asking to choose default application for "xlsx" extensions. When executing the application no window dialog appeared, just the error was shown.

    I solved the problem going to Control Panel > Programs > Default Programs and setting Microsoft Office Excel 2016 as default program for xlsx files.

d) "The problem is fixed now, the reason is that I have a COM add-ins activated, after I disable it the problem is resolved, thank you."