Support Board
Date/Time: Sat, 28 Dec 2024 04:24:32 +0000
Basic issue with Spreadsheet System for Trading
View Count: 828
| [2016-01-10 17:49:17] |
| rhovega - Posts: 279 |
|
I have very basic formula written in the Spreadsheet System for Trading: =AND($J$8>0,OR(ID0.SG3@$3<AP3,ID0.SG4@$3<AQ3)) You may ignore the OR condition. $J$8 refers to the Position Quantity, which, as shown on the screenshot, is 0. Nonetheless that formula is returning a TRUE condition. How is this possible? Thank you |
 upload.png / V - Attached On 2016-01-10 17:48:54 UTC - Size: 22.27 KB - 270 views |
| [2016-01-10 20:51:04] |
| |
|
Make sure that Spreadsheet >> Auto Calculate is checked. This is not relevant but you might also want to enable Global Settings >> Spreadsheet Settings >> Recalculate Chart on Formula Modify. 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-01-10 20:51:46
|
| [2016-01-11 01:10:33] |
| rhovega - Posts: 279 |
|
Well, don't know, it was checked. Doesn't seem very reliable unfort. Only simming automated trading. Will report back if it happens again. Now enabled "Recalculate Chart on Formula Modify." Txs. |
| [2016-01-11 01:16:20] |
| |
|
If there is a problem, we need to know the definite steps to reproduce. However, we had been doing some work on the New Spreadsheets. So update to the current version of Sierra Chart. It will make no sense to point out any problem with an older version with all of the changes that have been made recently. 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-01-11 01:16:59
|
| [2016-01-11 06:21:08] |
| |
|
The other question is are you still noticing this and what did you do to get the formula to display the correct result?
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: