Hi,

Is there any way of easily writing Close today not equal to Close of any bar over the previous 70 days?

I wrote it out like this. Didn't work.

C <> C1 AND C <> C2 AND C <> C3 AND C <> C4 AND C <> C5 AND C <> C6 AND C <> C7 AND............. C <> C70

Can you help, please?

James

Assuming I'm understand what you are trying to create (which is not guaranteed), there is nothing wrong with the formula as written:

C <> C1 AND C <> C2 AND C <> C3 AND C <> C4 AND C <> C5 AND C <> C6 AND C <> C7 AND C <> C8 AND C <> C9 AND C <> C10 AND C <> C11 AND C <> C12 AND C <> C13 AND C <> C14 AND C <> C15 AND C <> C16 AND C <> C17 AND C <> C18 AND C <> C19 AND C <> C20 AND C <> C21 AND C <> C22 AND C <> C23 AND C <> C24 AND C <> C25 AND C <> C26 AND C <> C27 AND C <> C28 AND C <> C29 AND C <> C30 AND C <> C31 AND C <> C32 AND C <> C33 AND C <> C34 AND C <> C35 AND C <> C36 AND C <> C37 AND C <> C38 AND C <> C39 AND C <> C40 AND C <> C41 AND C <> C42 AND C <> C43 AND C <> C44 AND C <> C45 AND C <> C46 AND C <> C47 AND C <> C48 AND C <> C49 AND C <> C50 AND C <> C51 AND C <> C52 AND C <> C53 AND C <> C54 AND C <> C55 AND C <> C56 AND C <> C57 AND C <> C58 AND C <> C59 AND C <> C60 AND C <> C61 AND C <> C62 AND C <> C63 AND C <> C64 AND C <> C65 AND C <> C66 AND C <> C67 AND C <> C68 AND C <> C69 AND C <> C70

That said, it would not currently work for US stocks because there is a fake bar for Thanksgiving which displays Wednesday's close as a flatlined bar (meaning the fake Thursday bar is equal to the close of the real Wednesday bar). Once this is resolved (or the market opens), the formula should work as expected.

Hi,

Thank you, the formula seems to work today.

I also do not want the close equal to a round number. Is there a function for "round number" or "whole number"?

James

You could use:

C MOD 1 <> 0

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!