Support Board
Date/Time: Fri, 14 Mar 2025 22:36:46 +0000
[Programming Help] - Spreadsheet Study trigger based on time (last 30 minutes)
View Count: 424
| [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! |
| [2022-06-27 20:14:16] |
| ForgivingComputers.com - Posts: 1028 |
|
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 to the value of cell E20 for instance.
You could add a chart that is time-based, look back 30 minutes on it, and overlay that value to your trading chart. If the time-based chart is 1-minute bars, then you would look back to E33. |
To post a message in this thread, you need to log in with your Sierra Chart account: