[amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-21 Thread only_accept_the_real_thing
regards, Tomasz Janeczko amibroker.com - Original Message - From: only_accept_the_real_thing oman...@... To: amibroker@yahoogroups.com Sent: Tuesday, August 18, 2009 11:04 AM Subject: [amibroker] Re: Data cleansing / cleaning - removing bars O, H, L and C are succesfully being

Re: [amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-21 Thread Tomasz Janeczko
to NULL (unknown) and expect any results. Best regards, Tomasz Janeczko amibroker.com - Original Message - From: only_accept_the_real_thing oman...@... To: amibroker@yahoogroups.com Sent: Tuesday, August 18, 2009 11:04 AM Subject: [amibroker] Re: Data cleansing / cleaning - removing

[amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-18 Thread only_accept_the_real_thing
Thats also makes the code a lot more readable - thanks Mike. --- In amibroker@yahoogroups.com, Mike sfclimb...@... wrote: You could also have just captured the scenario in a variable and kept your original code, except operating on the variable instead of repeating the test over and over

[amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-18 Thread only_accept_the_real_thing
O, H, L and C are succesfully being set to Null, but it looks like the backtester doesn't like the Null. If I initiate a position on the bar before a BadBar, when the Backtester tries to evaluate the position on the BadBar it stops and prints a loss of $2.5 billion! Is this as expected, or is

[amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-16 Thread Mike
You could also have just captured the scenario in a variable and kept your original code, except operating on the variable instead of repeating the test over and over again. e.g. BadBar = (O == H AND O == L AND O == C AND O == Volume); Open = IIf(BadBar, Null, O); Close = IIf(BadBar, Null,

[amibroker] Re: Data cleansing / cleaning - removing bars

2009-08-15 Thread only_accept_the_real_thing
Thankyou Tomasz and Graham, that works! Because the Open has been changed to Null after the first statement (if O==H==L==C==Volume) then O == H will be false so I've had to check for this in subsequent statements. The working code is: Open = IIf(O == H AND O == L AND O == C AND O == Volume,