Ask Colin

How do I plot the Insight Trader data files from your web site?

When you download the files from the Data Files page on the web site, you must put then in the correct folders. Which folders you put them in will depend on your set-up.

In a typical set-up you will have a Winit folder on your C drive.

If you do not have your folders (directories) split (see the manual) all your data files will be in a folder called Data. So, you would put the files from the web site into C:Winit\Data.

However, much more commonly, you will have spilt folders (directories). You can tell whether you have this set-up in Windows Explorer (My Computer) by looking for folders called C:Winit\#, C:Winit\A, C:Winit\B etc. In this case, you copy the files into the folder with the letter that starts the file name. So:

Into C:Winit/A you put ASXAD and AUSYIELDAFR

Into C:Winit/N you put NEWFLOATS and NYSEAD

Then open Insight Trader and plot the filename you want:

ASXAD is ASX Advance - Decline line. The default field in this file is the cumulative difference between advances and declines and should be displayed as a line chart.

NYSEAD is New York Stock Exchange Advance-Decline line. The default field in this file is the cumulative difference between advances and declines and should be displayed as a line chart. 

NEWFLOATS is the monthly number of new floats on the ASX. There is only one data field in this file, which is the default. It is the monthly number of new floats on the ASX. The new floats data is seasonal with a peak at the end of the calendar year. I get around this by suppressing the plot of the default field (Ctrl+H). I then plot a 12 month simple moving average, which eliminates the seasonality. The key strokes to do this are: A, Tab, 12, Enter. If your default plot was semi-log, change it to linear by pressing F. Then rescale the Y axis with the keystrokes Y, S, 0 (the number zero), Tab, 30, Enter. If the line goes above 30 in the future, use a larger number than 30 as is appropriate.

AUSYIELDAFR contains various monthly yield and PE ratio data.

The fields in this file are:

Field No 2 10YBY - Australian monthly 10-year bond yield.
Field No 3 90DBY - Australian monthly 90-day bill yield.
Field No 4 ORDSDY - ASX monthly All Ordinaries dividend yield.
Field No 5 ORDSPE - ASX monthly Price Earnings (PE) ratio.
Field No 6 ORDSEY - ASX Monthly earnings yield (100/Field No 5)

Field No 2 is the default field in this file, so it will be plotted automatically. It is best displayed as a line chart (press L) and on a linear scale (if displayed as a semi-log chart, press F).

To plot the other fields the keystrokes are Alt+V, C, Tab, (number of the field you want to plot), Enter, Enter.  

In Ask Colin\Insight Trader (click here) are instructions for overlaying the lines on a bar chart of the index.

 

Keywords: