Login Page - Create Account

Support Board


Date/Time: Fri, 14 Mar 2025 21:36:18 +0000



Post From: Spreadsheet Study trigger based on time (last 30 minutes)

[2022-06-25 12:12:50]
BRKTrading - Posts: 1
I have setup spreadsheet trading to trade based on vwap bands which works fine. I want to add a condition where the entry is also based on a price level between last price and the price level of 30 minutes ago. As I am not using time based charts I cannot simply refer tot the value of cell E20 for instance.

So to be clear, I want to only trigger a trade if a specific condition is met anywhere between now and 30 minutes ago. As I want to backtest adding TÏME(NOW) does not seem to be the solution if I read correctly.

Any help would be appreciated!