[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Clean up zero price quotes



PureBytes Links

Trading Reference Links

You could try this for each price (OHLC)

O = iif(V==0, valuewhen(V>0,C), O);


-- 
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://www.aflwriting.com

On 11/02/07, Prashanth <prash454.ta@xxxxxxxxx> wrote:
>
>  Why not delete the offending quotes since these are a waste anyway?
>
> Cheers
>
> Prashanth
>
>
> ----- Original Message -----
> *From:* datamanoz <datamanoz@xxxxxxxxxxxx>
> *To:* amibroker@xxxxxxxxxxxxxxx
> *Sent:* Sunday, February 11, 2007 10:45 AM
> *Subject:* [amibroker] Clean up zero price quotes
>
>  I have a significant amount of historical data which has zero values
> for OHLC. This was present in the source data that zeroed prices when
> volume was zero.
>
> I would like to set these zero OHLC quotes to the previous non-zero
> values. I'm sure it can be done in AFL but can't quite figure it out
> and would appreciate any help.
>
> 
>

Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.17.35/680 - Release Date: 2/10/2007 9:15 PM