Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 27 Sep 2024 03:46:01 +0000
Post From: Using Spreadsheet System for Trading Study
| [2019-04-04 17:21:10] |
| TechTrader - Posts: 116 |
|
User 94606 Following is a simple example. Say you have two lines in columns P and Q. Buy entries when P crosses Q to the upside. Sell entries when P crosses Q to the downside. K3 Formula: =IF(AND(P4<=Q4,P3>Q3),1,0) M3 Formula: =IF(AND(P4>=Q4,P3<Q3),1,0) |