I am trying to create a new column which will tell me if my trade on a stock will be a winning or losing trade, based on pre-defined stop loss price and take profit price (both prices are already calculated in advance in different columns).
Using Buying Opportunity Price and/or Close - which is the daily close price of the stock, I want to know if the price moves to my SL or TP first, to determine winning rate of trades taken eventually.
Appreciate any help and advice, newbie in Tableau.
*Edited to include the file as a Package Tableau one. Thanks Jim
6 answers
thanks for attaching the workbook - not certain I understand the goal ( not in the investment industry) could you explain on the image below what you want to achieve?
Jim
