Support Board
Date/Time: Fri, 29 Nov 2024 15:27:42 +0000
Post From: Spreadsheet Formula for average winning trade duration?
| [2023-02-06 01:45:42] |
| j4ytr4der_ - Posts: 938 |
|
This one is doing my head in. I feel like it's something related to time vs. duration, but not sure. I'd like to compute a realtime average of my time in winning trades. This seemed fairly simple but something isn't right: Formula for getting a running sum of duration in winning trades (Currently in M43, locking cell so that in cases where J41 - J42 is not returning a correct/valid value in any moment like when the trade closes, the value locks): =IF(
J10 > 0, MAX( M43, M43 + (J41 - J42) ), M43 ) Then I just take that result and divide by # of winning trades... right? =M43/J33
Sadly, not matching at all what I see in the TAL Statistics tab. I get a value, it's just way off. Does anyone know what I'm doing wrong, or another way to accomplish this? Date Time Of Last Edit: 2023-02-06 01:46:40
|