Login Page - Create Account

Support Board


Date/Time: Wed, 29 Jun 2022 22:05:11 +0000



[User Discussion] - Spreadsheet question, Time values

View Count: 999

[2014-01-13 17:55:12]
sbsierra - Posts: 71
I wanted to disable Auto Trading via cell J28, when the last trade via cell J42 ist less than n-minutes ago. I donĀ“t know how to use a formula to convert time to absolute minutes.

Thanks for help.
[2014-01-13 18:27:36]
tomgilb - Posts: 3327
Try this:

=(J41-INT(J41))-(J42-INT(J42))<TIMEVALUE("00:05:00")

This removes the dates from the date-times, finds the difference, and compares it to the Excel timevalue of 5 minutes.
[2014-01-13 22:23:00]
sbsierra - Posts: 71
thank you. but this will only work if I the time of the last trade is bigger than the current time. is there any way to get the difference with the date?
[2014-01-13 23:11:26]
tomgilb - Posts: 3327
You're correct: The formula in post #2 assumes you do not cross midnight.

To include the dates, try this:

=J41-J42<TIMEVALUE("00:05:00")

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account