message alert when value is at 10% loss

[mozart11]

I trying to make a db for stock tracking. I want to have a text field display "sell" when I hit a loss if it's 10% of my purchase. I have defined shares bought, price bought, todays going price, what it's worth now. I can't see to figure out percentages. I do worth now times .010. but I can't figure out how to do the if statement to figure out to display a message that I'm at my 10% threshold to sell. Hope this makes sense.

Thanks

[kenneth2k1]

Hi:

You'll have to be a bit more clear for us non-market people.

Are you saying that you want a "Sell" warning when 10% of what it's worth now is less than or equal to 10% of your purchase?

If so, your calc can look like this:

Case - or If - [Worth now * .1 <= Purchase * .1 , "Sell" , "Normal"]

You said 10%, but your calc that you gave was "worth now times .010." I'm pretty sure .01 is 1%, not 10%. So you'll have to be more specific.

Hope this gets you on the right track

Ken

[BobWeaver]

If(Today's price <= (PurchasePrice * 0.9), "Sell","Hold")