Question:

How to define my own exchange location?

 

Answer:

 

When you download the price history, the program asks you the information about the exchange location. Here you should define the location of your stock exchange and enter the history of time zones changes:

 

 

This is especially important for intraday data. Clicking “Exchange Location” button:

 

 

 

you can choose one of the most popular exchange location.

 

You can also create your own exchange location. You may need if your exchange is not a traditional one. In the main program directory, look at files with the extension *.tz.

This is the content of one of these files, New_York.tz:

 

Location=40.25N;74.00W;5W

5,11,18,1883,2

4,3,31,1918,2

5,10,27,1918,2

4,3,30,1919,2

5,10,26,1919,2

4,3,28,1920,2

5,10,31,1920,2

4,4,24,1921,2

5,9,25,1921,2

4,4,30,1922,2

5,9,24,1922,2

4,4,29,1923,2

5,9,30,1923,2

 

The first string shows the coordinates of this exchange’s location: 40.25N;74.00W and time zone 5W :

Location=40.25N;74.00W;5W

 

You need to create something similar.

Suppose I decide to create this file for my native town (Yeisk, Russia). Though there is no stock exchange there yet, we can use this as an example.

 

I create the file Yeisk.tz using any text editor (like Notepad). The geographical coordinates of my native place are 46N42 38E16. The time zone of my native town is 3E

So the first string in this file will be

 

Location=46N42 38E16;3E

 

Next lines show how the difference between the local and Greenwich time has been changed and will change in the future:

 

5,11,18,1883,2

4,3,31,1918,2

5,10,27,1918,2

 

The first line 5,11,18,1883,2 means that November  18 1883 2hours am they started to use 5W difference between the local and Greenwich time.

This is format of this string

 

 Time Zone,MM,DD,YYYY,HH

 

In the year 1918, on March 31, they started to use 4W time difference.

This string 4,3,31,1918,2 reflects this fact. 

 

On March 3, 2006, at 2AM, the difference between Yeisk and Greenwich has been set on 3E (actually they mostly follow Moscow time there):

 

-3,3,26,2006,2

 

-3 means 3E.

 

after that on October 29, 2006 it became 4E:

 

-4,10,29,2006,2

 

etc.

 

So this is the content of the file Yeisk.tz

Location=46N42 38E16;3E

-3,3,26,2006,2

-4,10,29,2006,2

 

Save this file into a working directory and you click “Exchange Location” button. When you open it next time, you will find the new item there: Yeisk