Topic: Errors when trying to add new instruments

Hello,
I was trying to add several instruments from csv file but having various errors:

Defective Bar number: 5471 - 03/22/2001 00:00:00

Here is my my line 5470 and 5471:
21/03/01    00:00    0.7765    0.7765    0.7765    0.7765    0
22/03/01    00:00    0.7749    0.7749    0.7749    0.7749    0

Re: Errors when trying to add new instruments

Change the defective bar to comply with OHLC: .7749 .7751 .7748 .7750

BTW, why volume is zero? What data are you using, the source?

Re: Errors when trying to add new instruments

Oh, and please stop making threads about the same question multiple times, you made 4 threads already, which were identical...

4 (edited by kazik1616 2012-10-18 14:55:37)

Re: Errors when trying to add new instruments

Hello Footon,
Thanks for your answer. I have corrected all 0.xxx to .xxx in my file but now I am having the issue that I am having another bar defective:

defective bar number 2233 - 11/18/1998 00:00:00.
Here are my lines 2232 and 2233:

29/07/88    00:00    .974    .974    .974    .974    0
01/08/88    00:00    .9674    .9674    .9674    .9674    0

What is amazing that the the date from error message does not match the date in my file.

The reason why I have volume set to 0 is that my provider did not provide the volume size from that period. The data comes from http://stooq.pl/q/d/?s=audcad

Attaching also my current csv file.

Also sorry for starting several threads for the same question. I do not know how they have been created sad

Post's attachments

audcad1440.csv 343.57 kb, 3 downloads since 2012-10-18 

You don't have the permssions to download the attachments of this post.

Re: Errors when trying to add new instruments

Also having another error message for another instrument:
Maximum days off 7.
What does this message mean? Does it mean, that there are 7 subsequent days without any bar?

Attaching also my csv file.

Post's attachments

$ndx1440.csv 358.2 kb, 1 downloads since 2012-10-18 

You don't have the permssions to download the attachments of this post.

Re: Errors when trying to add new instruments

You can leave zeros in place, I shortened the price and left out zero to type quicker wink Important stuff is the last number - OHLC means open, high,low,close, crucial thing is to have high and low prices correctly in place, high price needs to be the highest and low needs to be the lowest of the set.

I've experienced similar problems before, then I just modified the first line of data and it worked fine. I'll look at the data, and try to make it work.

Re: Errors when trying to add new instruments

Alright, I've corrected the data, works fine.

*I changed the first line to correspond to OHLC format, look at the first line of data if you don't understand;
*I made sure data is 4digit, edit this in excel;
*I changed the datetime format, again in excel.

Post's attachments

AUDCAD1440.csv 418.71 kb, 3 downloads since 2012-10-18 

You don't have the permssions to download the attachments of this post.

Re: Errors when trying to add new instruments

footon wrote:

Alright, I've corrected the data, works fine.

*I changed the first line to correspond to OHLC format, look at the first line of data if you don't understand;
*I made sure data is 4digit, edit this in excel;
*I changed the datetime format, again in excel.

Hi Footon,
Have you tried uploading your file to FSB? I am having error message from my first comment now.

Re: Errors when trying to add new instruments

My file gives error? It's working fine for me...

Re: Errors when trying to add new instruments

http://s18.postimage.org/6vu5x5kr9/data.jpg

Works like a charm!

Re: Errors when trying to add new instruments

Footon,
I am able to open the data and test strategy on it. The only issue I have is that when I select this instument, I am having popup message mentioned in first comment.

Re: Errors when trying to add new instruments

I made some back-to-back tests with a few FSB versions, I see now what's the problem. It says "defective till". On older versions no errors, newest gives the error. The reason is the data - there's no high,low prices until 2001, that's the problem. Nothing more I can do about it.

Re: Errors when trying to add new instruments

What do you mean by there's no high, low prices until 2001? Do you mean, that O=H=L=C for these periods? Is it an issue?

footon wrote:

I made some back-to-back tests with a few FSB versions, I see now what's the problem. It says "defective till". On older versions no errors, newest gives the error. The reason is the data - there's no high,low prices until 2001, that's the problem. Nothing more I can do about it.

Re: Errors when trying to add new instruments

Yes, that is the issue - the error message tells exactly that!