Login Page - Create Account

Support Board


Date/Time: Wed, 03 Jul 2024 01:52:22 +0000



Post From: How to measure current Trade time Duration via simple alert formula?

[2023-01-12 13:16:47]
Sawtooth - Posts: 4036
The Trading:Profig/Loss Text study does not output any of its values to subgraphs, where they could be used for alerts or analysis.

The Spreadsheet System for Trading study shows the timestamp of the latest trade entry, in cell J42.
You could compare this to the Last Bar End DateTime in cell J41, by subtracting J42 from J41.

J41 and J42 update, even with manual entries.
You could use cell J29 to flatten a position after 5 minutes, even a manually entered one, with a formula like this:
=AND(J8<>0,J41-J42 >= 5/1440)
(there are 1440 minutes in 24hrs)

You could display the value in seconds or minutes with the Text Display for Study study, using a formula in a Formula Column.
Date Time Of Last Edit: 2024-05-31 13:05:55