Google Sheet , Macro and Formulas

Building a sheet for Crypto/Stock Papertrade purpose , so if a Trade ( Short or Long Postion ) achieves its Take Profit or Stop loss)

Column K contains a price value that is refreshed every 5 Min .

FORMULAS


Column J .
If Column J filled then dont check
If column I empty dont check
If Column I filled and J Empty then :

If Column A = High, then , If Column K = (< or = Column I) then log Value of Column I in column J and Timestamp in column G or
If Column A = Low, then , If Column K = (> or = Column I) then log Value of Column I in column J and Timestamp in column G

-------------------------------------------------------------------------------------------------------------
Set 1

Column R :
IF Column F is Long then column R = J x (100% + R1 % or
IF Column F is Short then column R = J x (100% - R1 %)

Column S
IF Column F is Long then column S = J x (100% - S1 % or
IF Column F is Short then column S = J x (100% + S1 %)

Column T
If column T is Filled do nothing
If column T is empty then when Column F is LONG and if column K = > or = Column R, if yes log Timestamp in column T
If column T is empty then when Column F is SHORT and if column K = < or = Column R, if yes log Timestamp in column T

Column U
If column U is Filled do nothing
if column U is empty, then when Column F is LONG and if column K = < or = Column S, if yes log Timestamp in column U
If column U is empty, then when Column F is SHORT and if column K = > or = Column S, if yes log Timestamp in column U



Column V
If Column I Empty and column J Empty = Column V, Empty
If Column I filled and column J Empty = Column V, PENDING
If column J filled and Column T and U empty = Column V, IN TRADE
If column T is filled and Column U Empty = Column V, WIN
If column U is filled and Column T empty = Column V, LOSS


https://youtu.be/AsugPetlpaM