Support Board
Date/Time: Tue, 04 Mar 2025 10:04:49 +0000
Post From: Inconsistent calculations with Spreadsheet study
| [2021-11-18 17:27:58] |
| Sawtooth - Posts: 4179 |
|
can I do something to resolve this?
You must round the timestamp to the millisecond (to remove any floating point imprecision) before you compare it to the millisecond.Try this formula: =MROUND(FRACTIME(A3),1/86400000)=TIME(09,30,00,000) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MROUND_Function Spreadsheet Example Formulas and Usage: Formula Equivalents of Serial Date Time Values Working with Spreadsheets: Floating-Point Values and Comparisons When Using the Spreadsheet Study Date Time Of Last Edit: 2021-11-18 17:36:01
|