Keywords

Main Window, Downloading data from some text fileDownloading data from Metastock files, Downloading data from Internet services, Yahoo financial service, Yahoo symbols, Yahoo and Quandl data fast access, Downloading data through Excel file, Define forecast horizon, Trading day starting time for daily data, Define exchange location, Trading hours for intraday data, Updating price history, Price chart manipulations, Top and Bottom Margins, Splits and corrupted records, Technical Analysis indicators, "Main Window view" module, Charting tools in general, Timing Solution worksheet, Updating price history through TS worksheet, Special cases of data formats, Use of fast ephemeris to speed up calculations, Use of Unmagnify feature to return to the previous view, Daylight savings marker, Downloading a portion of price history data, Instructions for MAC users

Timing Solution Basics

Downloading price chart, screen manipulations, worksheets, updating price history, basic technical analysis indicators and charting tools, Main Window view, working with real time

 

When you work with Timing Solution software, all important things will be happening in the Main Window. This is how it usually looks, together with labels that show groups of buttons related to one theme:  

 

Click on any button opens a separate window dedicated to some specific task. You may want to try some charting tool (they are shown on the left panel), and for each one you may choose parameters that you like. You may try some Technical Analysis indicators (they are in the top right corner), with your choice of details. Or you may use Timing Solution techniques (the middle of the top panel) and Timing Solution forecast modules (they are on the right panel).

However, when you open the software the very first time, the main field is empty, and majority of buttons is not available.

You need to start with data download and necessary calculations. 

A. Getting the data

Timing Solution software is concentrated on market forecast. Before making any forecast, you need to decide what financial instrument you would like to work with. And you need to find the data for your financial instrument. It is your responsibility to find the data that will be used. Together with the program, you will get the price history files only for some financial instruments. They are helpful while you are learning to use the program. However, for a better forecast, you need a source of the most recent data. You may get this info as some file, or from some data feed source, or you may use Yahoo data.

The program supports more than 1000 different text formats, Metastock and CSI formats. Also you can download the price data from Yahoo financial service, e-Signal, Interactive Brokers, Ameritrade (you can do that if you are signed to those services)..

#1.To download the price history data, click this button:

 

And follow the steps shown below. They are slightly different, depending on the source of your data.

Downloading data from some text file

You may have data saved previously on your computer as a text file. If it is the case, follow these steps:

#2. Choose directory

#3.Choose file

 

You need to choose the directory where this file is located, highlight the file and click "Load" button. Do not forget to define the forecast horizon, i.e., the length of your forecast. This is the general procedure of downloading data.

Downloading data from Metastock files

To download Metastock data, use these tabs:

You have to chose the folder with Metastock files and click "MetaStock Format" tab after that:

 

Choose the security you plan to download and click "Load" button.

 

Downloading data from Internet (Yahoo financial service, eSignal, Quandl, Interactive Brokers, Ameritrade)

There are many sources of data on the web. Some of the services do not take any charge (Yahoo financial service and Quandl), at least for now. Other companies provide data for a fee (eSignal, Interactive Brokers and Ameritrade). Make sure that you are signed for their services. (Timing Solution does not provide any data feed; the software is focused on being able to work with many different data sources.)

Use "More" button to download the price history from eSignal, Yahoo and Quandl financial services, as well as Interactive Brokers and Ameritrade systems. You will get this menu:

Choose your item there and follow the screen prompts.

As an example, let us look at free Yahoo financial service. You need to follow these steps:

a) choose this option:

 

b) type Yahoo symbol of the financial instrument that you need to download and click "Download data" button:

 

Here ^GSPC - Yahoo symbol for S&P 500 index is used. Or you can input instead IBM Yahoo symbol for IBM corporation shares or MSFT for Microsoft shares and others. The list of symbols used by Yahoo service is on Yahoo website.

c) if everything is Ok, you will get the list of prices like the one below; click OK button to continue:

 

 

 

 

 

 

 

 

 

 

 

 

 

d) If you type incorrect symbol, you will get a prompt like this:

 

 

 

 

 

 

 

 

 

 

 

You can also download a lot of useful financial information using the service Quandl.com. 

More information regarding different data formats is here:  http://www.timingsolution.com/TS/Study/Formats/index.htm#A2

By the way, if you download the price history through Yahoo and/or Quandl, you may also use this fast access button:

Also, pay attention to our standard library of financial instruments. Use this button:

 

 

Downloading the price history data through Excel file

There are two possibilities to download the Excel file.

1) Save Excel worksheet into comma delimited *.csv file (follow File -> Save As ..) and download it as usually.

2) Open Excel file, highlight the table (Ctrl-A), copy this table into clipboard (right mouse click and highlight "Copy") and paste the content of clipboard to Timing Solution software following these steps:

 

 

and

 

#4. Do not forget to define the forecast horizon

 

#5 Click "Load" button to download the data.

This dialog box will appear:

 

If you are downloading daily data, it is necessary to input the time when trading begins

Also, for accuracy of astronomical calculations, you need to define the exchange location. To do that, click "Exchange location"  button. You will get the list of available exchanges:

 

 

If you are using intraday data, you need to set trading hours; this information is necessary to generate the projection line. In most cases the program specifies the type of downloaded price history data automatically; you will see this notification window with the information about your data:

 

You can set this data manually as well. Click on this button:

 

Choose the kind of intraday data (daily or weekly intraday):

And set trading hours here:

#6. When you did everything you should in the window with exchange location and trading days information, click "OK". 

#7. You will be redirected to the initial window where you defined data source for downloading. Click 'OK" to complete the process of downloading price history data.

Updating price history

If you work with some financial instrument constantly, you do need to repeat the process of downloading its history every time. You may just update the price history. To do that, use these buttons:

 

It is possible to update through some file, e-Signal, Interactive Brokers, Yahoo, AmeriTrade. The program simply adds new portion of price history data to the existing chart. Thus, you can combine the price history using several sources of data.

This feature works this way: suppose you have the file with some price history data (S&P 500 index in this example); it covers period up to July 2012. You need to update this price history till the latest date (December 2013) using Yahoo financial service as an example. 

What should you do? First, you have to download through Yahoo financial service the available price history for S&P 500. After that follow these steps:

 

and program will update the price history till the last available price bar. 

You can save this file with updated price history as a text file clicking the button shown below:

 

Splits and corrupted records

When downloading the price history, take care of the splits. They look like gaps on the price chart:

If the program recognizes the presence of splits in downloaded price data, it displays this alert: 

 

To handle all splits click "Auto Correct" button or remove them manually (clicking on "Remove Splits" button).

Look at this example. Here the gap in April 1968 corresponds to the split 2 for 1:

 

When you download the price history through Internet, you may get some data records corrupted. In this case the program displays this alert:

 

Look at the example of corrupted records below; they do not have "Open" field:

To fix this record, you have two options. You may input manually the Open value for this financial instrument (use "Edit" button; you can find this value in some other source of data) or you may click "Auto Correct" button. In this case the program will use Close value for missed records.

Special cases

Timing Solution allows to download a lot of text files with historical price data, plus its incorporated expert system allows to recognize the formats of these files automatically.    

For example, you are downloading the file like this one:

EURUSD 1 20060921 17:35 1.27420
EURUSD 1 20060921 17:36 1.27450
EURUSD 1 20060921 17:37 1.27450
EURUSD 1 20060921 17:38 1.27380
EURUSD 1 20060921 17:39 1.27380
EURUSD 1 20060921 17:40 1.27420

When you highlight this file's name (see below), the program automatically recognizes the format of this data file and sets the appropriate options in Formats, Date and Time controls: 

 

In this case Format is . It means that in the line like the one selected:

EURUSD 1 20060921 17:35 1.27420

first two objects in the record, EURUSD and 1, are not used as the important information to be stored starts with the third object of this record. This third object of the record, 20060921, this is DATE, and its format is  . After that follows 17:35;  this is TIME (for intraday), military format .

After that follows the standard OHLC information for price bars: Open, High, Low, Close, Volume (if exists) and Open Interest (if exists).

Sometimes the system cannot specify with certainty the format of your data automatically. In this case you should set these options manually.

Let's consider another special case. As an example, let us take LBMA gold fixing prices:

Date,USD,GBP,EUR
2013-11-22,1246.25,768.958,920.829
2013-11-21,1240.0,768.706,921.248
2013-11-20,1257.0,777.317,928.978
2013-11-19,1275.75,792.391,944.72
2013-11-18,1283.5,796.216,948.142

 

Here the first object of the record is DATE followed by gold price in USA Dollar (USD), then goes the price in Great Britain Pound (GBP), and the last object of the record is gold price in Euros (EUR).

Suppose we need to download the price history in GBP. In order to do that click this button:

 

and set these options there:

It means that program will download the second objects of the records (with gold prices in GBP) after the date's record. All other record objects are not used, we do  not need them.

 

Real Time streaming

This issue is explained here: http://www.timingsolution.com/TS/DF/

 

 

 

B. Calculation

After downloading the price history, click "Calculate" button:

 

The program performs all astronomical calculations saving your time in the nearest future, when you will look at different models - there will be no need to repeat the same calculations for every change in the model. 

When it is done, all modules of the software become ready to work with.

Pay attention to the numbers at the bottom of the Main Window:

 

They are important. The date related to a current position of the mouse cursor is changing when you move the mouse across the screen. Also, you can see the date of the position of Learning Border Cursor (LBC) and the date of the last price bar as well as available memory and number of the price bars used for training the model (price bars before Learning Border Cursor).

 

C. Price chart manipulations

When the price history is downloaded, you can do any screen manipulations with your price chart.

For example, you may need to view not all price chart but its small part with the details. Do this:

To move this interval to see the price history prior/after the selected interval, do this:

Also you can use these buttons to manipulate the viewed interval:

Move the mouse to any of these buttons. You will see there what any button is for.

Top and Bottom Margins

Sometimes while drawing a charting tool we need more room to display the price chart. As an example, look at the picture below. Here, to display this pitchfork, we need to display the price chart using the price range $20-$80 while the program automatically uses more tight range, $20-$70: 

In order to increase this range, use these buttons: 

 

 

D. Timing Solution worksheet

When working with Timing Solution, usually you apply many techniques. Look at the chart below. It represents the typical desktop window view with the price chart, two charting tools (Pitchfork and Fibonacci level), Annual cycle and Easy Expert module that shows the statistically verified effect of some astronomical phenomena:

If you do the same thing on your computer, you would spend some time organizing this worksheet. And what about next day or any other time when you would like to use the same set of techniques? Do you need to spend that same amount of time just restoring what you have done already? Timing Solution is able to help you here. Keep what you did in a worksheet.

You can save and restore your work later clicking these buttons:

 

Thus you do not need to repeat your actions when you run Timing Solution next time; you will be able to get back to your chart whenever you want to.

 

Updating price history through a worksheet

When you save your worksheet, do not forget to set the regime how the price history should be updated:

There are several possibilities there:

E. Main Window view

You can modify the way how the price chart and other objects are presented in the Main Window. For that purpose, use "Main Window view" module clicking this button:

 

The window has several tabs. Look at them. They are pretty obvious, and you can select there options that you prefer.

The very first tab, "Indicators" (shown above) works with Technical Analysis indicators (see the next item of this lesson).

Another tab, "View", gives you options to define such things as date and time format (which may not coincide with what Windows provides), a position of Learning Border Cursor at download (it can be set up to the last price bar automatically), margins (you can also set them right from the Main Window). You can define as well how you would like to see the time and price scales displayed: 

 

For example, sometimes the time scale may have too many dates shown; you can make them positioned inclined instead of being horizontal.

Play with other tabs options. You will find many useful small things there, like choosing colors for candle stick body, line thickness, etc :.

 

ALL ABOVE WAS REGARDING THE STEPS YOU MUST KNOW. YOU WILL USE THEM EVERYDAY. Now, when you have downloaded price history and know how to handle your data, after you hit the "Calculation" button, - you are ready to work with the software. 

 

You may want to start with the things that you are familiar with - some Technical Analysis indicators and some charting tools. Try them to feel yourself at ease with the software.

 

F. Technical Analysis indicators and Main Window view

To create the classical indicators of Technical Analysis (like moving averages, RSI, MACD), use these buttons:

There you will find a list of available indicators. To modify the view of these indicators (like color, thickness) or to remove them, use "Main Window view" module clicking this button:

 

The very first tab, "Indicators" (shown above) gives you an opportunity to choose an indicator from the list or delete one or all selected earlier. You can choose there as well how the indicator should appear on the screen (its line color, width). You may want to see it together with the price chart or without it.

 

G. Charting tools in brief

You can start your analysis with simplest charting tools - such as trend lines, Andrews pitchfork, Fibonacci levels, Gann fans etc. Timing Solution gives you a great variety of charting tools. Moreover, we provide a bunch of new charting tools, or "smart" charting tools, that are quite simple in use while having complicated math behind. You can read more about this issue here: http://www.timingsolution.com/TS/Study/ts_charting_tools/index.htm

To draw any charting tool, follow these steps:

 

 

This is a sample of Andrews pitchfork:

Using LEFT mouse button you can move the anchors of this pitchfork this way:

 

In the example above, we moved one point (anchor) only. However, it might be necessary sometimes to move the whole figure, i.e. moving all points A, B and C.  
In order to do that, do the same as above for moving the point A, while keeping the Shift button on your keyboard pressed. Thus you can move the whole figure:

 

 

You can modify the parameters of  this pitchfork using RIGHT mouse button this way:

 

Deleting charting tools

To delete ALL charting tools, click this small button in the right bottom corner:

You can also delete any charting tool dragging it into the garbage bin in the left bottom corner of the price chart: 

Also all these manipulations with charting tools can be done through "Charting panel" window: 

 

H. Instructions for MAC users

1) Installation: The program is written for Windows operating system. Please make sure that it is possible to run Windows applications with your MAC. To run Windows applications under MAC, you need to install Windows emulator for MAC. The most used Windows emulators for MAC are:

Parallels

VWMware Fusion

CrossOver

 2) Right mouse button issue: One more issue with MAC is the usage of RIGHT mouse button. The issue appears due to the different logics of Mac system. To solve this problem, it is recommended to use "Shift" key on the keyboard. For example, you would like to magnify a piece of the price chart. The standard way is: move the cursor to the beginning of the interval, press the right mouse button, then drag the mouse cursor keeping the right mouse button pressed. The same operation for Mac users is: press Shift key on your keyboard and do the same, keeping the LEFT mouse button pressed. (Instead of right mouse button, you use the left mouse button and Shift key.)

Another issue appears when opening the pop-up menu. You would use the right mouse button clicking it on some spot of the price chart. Mac users would click left mouse button while Shift key is pressed.

 

 

Useful tips    

Tip #1: Fast ephemeris

To speed up calculations, you may set "Fast Ephemeris" option to ON:

 

 The program will create a big file with ephemeris data. The calculation takes some time, and there is a good part in it - this calculation has to be performed once only. If you have activated the fast ephemeris option, the program does the calculations much more faster.

 

Tip #2: Unmagnify feature

While doing  price charting, you often zoom/unzoom different parts of the price chart, shift them, etc.  And very often you need to be able to return to the previous (or some steps back) status (i.e. to restore the price chart displayed in the time diapason used several steps back). In order to do that, click the button above. This is especially important for precise charting when you must set the anchors for charting tools precisely. BTW, the same result (unmagnify) you may reach making double click over the price chart.

Tip #3: Daylight savings marker

This marker with watches shows the date when daylight saving time have changed:

 

Tip #4: Downloading a part of price history

If you need to download not all available price history but only some part of it, it is very simple to do. Just drag your mouse cursor from the start point to the end of the interval, and you will get your piece of price history downloaded. 

As an example, here is the price history data for DJIA since 1885 up to 2013. It is downloaded, but we need just a portion of it. (A portion can be enough for our purpose, and it reduces calculation as well).

So, we drag the mouse across the period that is needed: 

Now only a portion of data is downloaded, and we will work with it only.