Bruce, in v11, I get :

Error in formula

Argument missing near (

Cant get this to plot.

Thanks

It is a bug in the discontinued TC2000 version 11 beta (it will not be corrected as the TC2000 version 11 beta is unsupported). You can get around it by using TC2000 version 7, TC2000 version 12.1 or by working around the bug.

The part it doesn't seem to like is LOG(14), so if you change this to LOG(14 + 0), it should work.

100 * LOG((14 * (AVGH14 - AVGL14) + ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / (MAXH14 - MINL14 + ABS(MAXH14 - C14) + ABS(MINL14 - C14))) / LOG(14 + 0)

Bruce,

   I tried to shorten the above pcf to create one for 8 periods and keep getting an error.

The 14 period pcf above works great.

My pcf below does not work.

100 * LOG((8 * (AVGH8 - AVGL8) + ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7)) / (MAXH8 - MINL8 + ABS(MAXH8 - C8) + ABS(MINL8 - C8))) / LOG(8+0)

Please fix this and also provide a pcf for 5 periods.

Thank you,

Don

I wanted to continue on this thread even though I am not using v 7 but v 12.5

What error are you seeing?  I copied and pasted your formula and it worked for me.

Thank you Stockguy.

I have gotten the 8 period to work but now am consistently getting a syntax error for the 5 period with this pcf:

100 * LOG((5 * (AVGH5- AVGL5) + ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4)) / (MAXH5 - MINL5 + ABS(MAXH5 - C5) + ABS(MINL5 - C5))) / LOG(5+0)

Does the above 5 period work for you?

Thank you for your help.

Don

I'm not sure what the problem could be. I just copied and pasted into my TC2000 and it worked fine.  I tried it in version 12.5 and 17 and both worked.

Stockguy,

   I tried again with a blank pcf and it now works.

Many thanks,

Don

Glad you got it working.

Stockguy,

 Now same syntax error with 3 period:

100 * LOG((3 * (AVGH3- AVGL3) + ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2)) / (MAXH3 - MINL3 + ABS(MAXH3 - C3) + ABS(MINL3 - C3))) / LOG(3+0)

I still don't know how to prevent this and cannot get the above to work.

Thank you,

Don

Works fine here. Are you typing the formula in TC2000 or pasting it? If copy/paste, paste it into Notepad first, then copy/paste from there.  Sometimes copying from Word or other programs will pick up weird characters.

I have been copy/pasting directly from Word.

I then tried copy/paste from Word to Notepad to pcf and am still getting syntax error for 3 period pcf.

Very frustrating.

Don

Don't use Word. You need to use a text editor such as Notepad and not a word processor like Word.

The reason you are copying and pasting into a text editor and then copying and pasting from the text editor into the program is to eliminate any extra formatting introduced by the browser you are using (most frequently a Microsoft product such as IE or Edge) which was not actually part of the formula on the webpage.

Word processors can introduce their own formatting (and at the very least usually try to keep the original formatting from a paste), so you don't want to use a word processor for this.