Hi there, I am not sure if I am posting this in the right section but it is the first time around on a forum like this.
I am attempting to build a database for my trading activities. A trading journal basically.
Every trade has two possible outcomes, it's a winner or a loser. The way this can easily be seen is by looking at the Profit & loss field.
A negative amount is clearly not a winner.
What I would like to achieve is that there is a field in the database that automatically changes to a W for....you can see it coming...Winners and and L for...you know what I mean.
I looked at calculated fields but I have no clue how to do this....or even if it can be done at all.
Any help would be most appreciated
Henk