Support Board
Date/Time: Sun, 24 Nov 2024 05:23:01 +0000
[User Discussion] - Excel Formula Problems
View Count: 2254
| [2013-09-21 19:32:33] |
| Richard Reyes - Posts: 98 |
|
I am running an Excel Spreadsheet trading system and lately I have been having problems in the execution of the formulas. I have linked (,) together various single formulas using "AND" with "OR". I am using maybe 4 to 8 distinct and separate formulas that make up my trading system. I have noticed lately that certain of the formulas fail to work and only when I "cut" and paste the formula to the beginning of the trading sequence will the formula once again trigger trades. Is there an inherent hierarchy to Excel formulas or do I have another problem type. Many Thanks
|
| [2013-09-21 21:05:02] |
| |
|
Make sure you do not have any circular references. Those inherently are not going to work properly. In the new spreadsheets we are developing, circular references are not allowed any longer. Otherwise, you need to provide us a simple example as possible which does not work. We need detailed step-by-step instructions and a spreadsheet file. However, it is very very doubtful there would be any problem with the evaluation of formulas and it is something we would not be able to solve anyway because the current spreadsheet component in the CLR version is not developed by us. We are working on new spreadsheet functionality that we do have control over which is becoming available in the non-CLR version. However, it is still new and under development. 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: 2013-09-21 21:06:18
|
| [2013-09-22 19:39:22] |
| Richard Reyes - Posts: 98 |
|
I used the formula you sent to me in an earlier "Answer" and it worked quite well to disable auto trading in the spreadsheet - Cell J28, Disable Auto Trading. My question now is that once Auto Trading is disabled, how do I flatten the current on-going Trade - Cell J29, Flatten and Cancel Working Order? Many Thanks
|
| [2013-09-23 17:17:00] |
| |
|
Once auto trading is disabled, it is not possible to flatten a position.
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 |
| [2013-09-24 02:10:58] |
| Sawtooth - Posts: 4118 |
|
These examples might be helpful: http://www.sawtoothtrade.com/example-4.html Date Time Of Last Edit: 2015-08-14 01:45:45
|
To post a message in this thread, you need to log in with your Sierra Chart account: