Support Board
Date/Time: Mon, 21 Apr 2025 23:48:06 +0000
Inquiry About Discrepancy Between Formula Evaluation and Displayed Result in Spreadsheet
View Count: 158
| [2025-02-22 07:32:17] |
| zenhunter - Posts: 2 |
|
Dear Sierra Chart Engineers, First of all, I would like to express my appreciation for the incredible work you've done with Sierra Chart. The platform is exceptionally powerful, reliable, and highly customizable, making it one of the most versatile tools available for traders. Thank you for your continuous efforts in improving it! I’m reaching out regarding an issue I encountered in the Sierra Chart Spreadsheet. I have an IF formula that evaluates correctly in the Formula Debugger (Details) (it returns 1 (True)), but the actual cell where the formula is applied displays a result of 0 (False). Based on the logic, all conditions seem to be met, yet the displayed value doesn’t match the evaluated one. My question is: Is there any known situation or specific setting in Sierra Chart Spreadsheet that could cause a discrepancy between the formula's evaluated result and the value shown in the cell? I have already checked the following: Cell formatting Formula recalculation Cell references involved in the formula. Despite these checks, the issue persists. Search on support board Please see attached a screenshot. Sierra Version: 2720 64-bit revision 51974 Any guidance or recommendations you could provide would be greatly appreciated. Thank you very much for your time and support! Adrian |
 Screenshot_345.png / V - Attached On 2025-02-22 07:19:56 UTC - Size: 159.93 KB - 32 views |
| [2025-02-24 08:00:31] |
| Sierra_Chart Engineering - Posts: 19290 |
|
We need you to attach that spreadsheet, at a time when this particular discrepancy is occurring. Save the spreadsheet file and attach it following these instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile And tell us what particular cell to look at. 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, 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: