Support Board
Date/Time: Mon, 16 Jun 2025 08:38:59 +0000
very simple formula
View Count: 226
| [2025-05-14 15:39:48] |
| User546613 - Posts: 10 |
|
Hello, since 4 days i'am looking for a simple formula, just as exemple for a project. In the trading spreadsheet, I see that many fields are related to the charts, creating a close connection between this sheet and the chart. My idea is to be able to enter a formula in the trading spreadsheet that defines a condition, and as soon as this condition is met, it triggers a trade in the chart. For example: When the market reaches a price x, which I can enter as a variable in a field, a long-trade should be opened. May I kindly ask you to provide me with such a formula concerning the variable field? It would help me immensely. Thank you very much for your support. Markus Hirsbrunner |
| [2025-05-14 17:30:32] |
| John - SC Support - Posts: 40422 |
|
The current market price is the Close/Last of the current bar, so your entry formula would be the following: =E3 > 5000 Where E3 is the Last/Close price and 5000 is the price point you want to test against. Note that this only tests for a price going up and then above your value. You could reverse it to test above to below. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: