Data imported into Globalserver completely wrong

[mokwit]

How come golobalserver is loading from an EoD ASCII file with this data
Date O H L C V
03/17/2006,1.21,1.39,1.21,1.29,43402500

and importing it as
Date O H L C V
03/17/2006,1,1,1,1,43402500
ie it is rounding it off to a whole number or with another stock it it is loaded e.g. as 11.6 or something when the value in export file is 12.7 i.e it is not a multiple or a digit short, seems almost random.

It happens with all files (ASCII and Metastock from different sources) and is not caused by wrong times and the Date O H L C V is correct as is the MMDDYYYY. The only thing I can think of is that I have set the "price scale' or 'minimum movement' incorrectly. I have set them as either 1/10 or 'as is'
to reflect the fact that the decimals change with different values of the stock e.g at 1 it is a 0.01 integer, but at 5 it is a 0.05 and I thought i could handle this by using 0.01.....any insights on what the problem is, if it is this or something else, much appreciated.

 

[Trader333]

This looks like a scaling issue, have you tried looking at the actual data imported by double clicking on the name of the instrument in "Symbol Portfolio" screen and then selecting the "Edit Data" tab then loading the data that you have imported. This will show if the data has been imported correctly or if there is an error.


Paul

 

[mokwit]

Paul, It is not being imported correctly, e.g something with

OHLC
16.40, 17.30,16.40, 17.00

is imported as:
OHLC
16,17,16,17, with vol OK.

WRT to scaling, is this happening because I am not setting the spread for each stock price range? seems a possible cause but 1/10 is right for value up to 2 and as in original post, 1.21 is being distorted into 1.

 

[Trader333]

Can you post the ascii file on this forum and I will see what happens when I try and load it myself ?


Paul

 

[mokwit]

Paul, thanks for your offer of help, it does seem to be the price scale but I don't know how to accommodate all price scales in Thai market e.g spreads are

Less than 2 0.01
2 up to less than 5 0.02
5 up to less than 10 0.05
10 up to less than 25 0.10
25 up to less than 50 0.25
50 up to less than 100 0.50
100 up to less than 200 1.00
200 up to less than 400 2.00
400 up to less than 800 4.00
800 up 6.00

0.01 translates to 1/100 price scale in globalserver and 0.1 translates to 1/10 but there is no 1/50 selectable that would accommodate a 0.02 spread.......

Also there is still the problem of a stock going from THB1 to THB 10 (which they do ) and the scales then having to be manually altered presumably.

Any workarounds?

 

[Trader333]

Hmm, I have not encountered Thai exchanges so I am not too sure how this can be addressed at the moment but I will think about it.


Paul