Support Board

Date/Time: Tue, 04 Nov 2025 08:39:19 +0000

Post From: Time Range Formula

[2018-05-05 12:48:35] Link To Thread - Link To Post [Go To First Post]
User172040 - Posts: 70
Hi, I want to test signals only on RTH in the spreadsheet for trading study. I copied your code at this link (Spreadsheet Systems, Alerts and Automated Trading: Limiting Trading to Certain Time Ranges) and dumped it in a open cell in the spreadsheet study (cell P). Please see 'Time Formula' attachment. The code is exactly the same as per link so why do I get a #NAME? error (I did look at the Spreadsheet errors section but in this instance I dont know what the issue is). Cell J41 is the relevant cell for date and time in my sheet. Then I reference cell P in my 'Buy Entry' (K) column as can be seen in attachment 'Buy Entry'. However, when I run a backtest with the reference to GETTIMEFROMDATETIMEVALUE, I get no signals although after manual inspections, there are clear instances where signals should be given. When I remove the GETTIMEFROMDATETIMEVALUE reference from my 'Buy Entry' column I get my signals again. Can you please provide some guidance?


Time Formula.PNG / V - Attached On 2018-05-05 12:41:22 UTC - Size: 55.01 KB - 469 views Buy Entry.PNG / V - Attached On 2018-05-05 12:41:29 UTC - Size: 65.62 KB - 423 views