Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 15:19:42 +0000



Post From: Spreadsheet

[2019-09-25 22:13:13]
Sawtooth - Posts: 3976
In another Formula Column, create a persistent variable of the Buy Entry, then find the transitions in K3:

P3:
=IF(YourBuyEntryConditions,1,IF(YourSellEntryConditions,0,P4))
K3:
=AND(P4=0,P3)

This is the basic concept. You might need to modify for your needs.

There are examples of this here:
Spreadsheet Example Formulas and Usage