Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Price percent change today and Price history Net between Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dipanpatel1984
Posted : Thursday, October 18, 2018 2:31:51 PM
Gold Customer Gold Customer

Joined: 3/8/2018
Posts: 30

How would i write a one line formula for multiline formula without using the build in ones

for- Price percent change today and Price history Net between

example

Price percent change today betweeen (min -0.40 and max 0.40)

Price history Net change between (min -0.20 and max 0.20)

Thanks

Dipan

 

 

 

StockGuy
Posted : Thursday, October 18, 2018 2:54:52 PM

Administration

Joined: 9/30/2004
Posts: 9,187

ABS((C-C1)/C1) * 100 < .4  AND ABS(C-C1) <= .2

dipanpatel1984
Posted : Friday, October 19, 2018 10:10:14 AM
Gold Customer Gold Customer

Joined: 3/8/2018
Posts: 30

When i  use the following formula, i see a unique issue

The editior shows Formula Error .. View Details shows

Error in Formula - Expected ( At Position 33.

 

- if i run my scan , it does work , so i am confused as to why it shows the error.

 

Thanks

Dipan

Bruce_L
Posted : Monday, October 22, 2018 9:33:05 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Could you have re-typed it with a space in ABS ( instead of writing ABS(?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dipanpatel1984
Posted : Tuesday, October 23, 2018 6:07:31 PM
Gold Customer Gold Customer

Joined: 3/8/2018
Posts: 30

QUOTE (Bruce_L)

Could you have re-typed it with a space in ABS ( instead of writing ABS(?

it looks good now. Thanks

Bruce_L
Posted : Wednesday, October 24, 2018 8:45:01 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.