TC2000.com• Download software • Tutorial videos • Subscription & data-feed pricing • Class schedule
TC2000Brokerage.com• New account application • Trading resources • Margin rates • Stock & option commissions
Worden Discussion Forum
And another oddity. I created a simple static IIF
IIF ((20>10), (3),(4) )
This returns 4 and I also had to surround all of the values with () in order for syntax checker to clear it.
Understood but the formula is not doing that. I suspect that the IFF function is not working correctly. If you look at the results it does not return the value it should.
IIF( (236.81 = 236.81 AND 237.98 = 237.98 AND 234.71 = 234.71 AND 235.54 = 235.54 AND 49400.00 = 49400.00) ,(236.71) ,IIF( (236.81 = 239.55 AND 237.98 = 239.65 AND 234.71 = 238.10 AND 235.54 = 238.95 AND 49400.00 = 157500.00) ,(237.98) ,IIF(....
I should have gotten 237.98 returned but I didn't, i got -1 (which is what I replaced 1/0 with at the end of the nested IIF statements. the if clause was true so the true condition of the IIF should have returned 237.98 but it instead fired the false condition and continued with the other nested IIF's
Another test I did was remove the IIF and just did a boolean eval and it appears to be working:
(O'10/18/18' = O1 AND H'10/18/18' = H1 AND L'10/18/18' = L1 AND C'10/18/18' = C1 AND V'10/18/18' = V1)
This evaluated to true:
Well appears that the forumula is not working this morning. (bumz).
TY Sir! I did have to tweak the syntax a bit as the code as posted would not pass. Here is the final PCF for this. For some reason on my system, I had to add a lot of surrounding quotes to make it pass the syntax checker.
Hello, when using platinum I am struggling to figure out a PCF that will allow me to look at the first half hour and/or first hour ranges in a PCF. Some of my trading evolves around breeches of these ranges?