Support Board
Date/Time: Sat, 11 Jan 2025 14:52:44 +0000
spreadsheet study
View Count: 671
| [2016-12-12 23:29:38] |
| aydex - Posts: 110 |
|
Hi, Is there a way to have an Entry arrow only appearing at the current or most recent candle instead of all applicable candles pls |
 arrows.PNG / V - Attached On 2016-12-12 23:29:31 UTC - Size: 18.52 KB - 230 views |
| [2016-12-13 05:16:17] |
| |
|
You can reduce the Number of Rows Input setting with the Spreadsheet study to a much smaller number like 5 or lower if possible: Spreadsheet Study Inputs: Number of Rows Although this assumes that the necessary data for the calculations is still being outputted. So it may have to be higher than 5. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-12-13 05:17:39
|
| [2016-12-13 05:46:32] |
| aydex - Posts: 110 |
|
Cool thanks :) Should the attached formula work? I'm trying to have a set price 53.03 trigger Entry when two other conditions are true. The price is in cell H1, and using Last Price in cell E3. If not, is there a better way to trigger an Entry at a set price, pls. |
| [2016-12-13 08:31:57] |
| |
|
This question is not within the scope of our support. We hope to offer a service for an additional fee for helping with things like this but as of yet is not currently available.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-12-13 08:48:50] |
| User553714 - Posts: 184 |
|
=IF(AND(AA3>=AB3, AH3>=AJ3, $E3=$H$1)=1, 1, 0) This should work, replay the chart and test; it's important for the reference to H1 to be absolute as you want the same value used everytime it is calculated. |
| [2016-12-13 15:49:02] |
| Sawtooth - Posts: 4148 |
|
Here's another way: =IF(ROW()=3,AND(AA3>=AB3,AH3>=AJ3,E3=$H$1),0) Date Time Of Last Edit: 2016-12-13 16:44:39
|
To post a message in this thread, you need to log in with your Sierra Chart account: