Support Board
Date/Time: Sat, 12 Jul 2025 01:58:22 +0000
Post From: Find time to certain Date
| [2022-06-17 14:36:21] |
| John - SC Support - Posts: 40857 |
|
You can do this using the Spreadsheet Study. The only trick is that how you enter the formula will depend on how the underlying data exists. For instance, in the Spreadsheet Study, you can find the time between any two bars just by subtracting them and multiplying by an appropriate factor (depending on what you want to get). For example, if you want the difference in seconds, then the formula would be: =(A10 - A5) * 86400 Times within Sierra Chart are stored such that the integer portion is days and the fractional portion is the fraction of a day. Therefore, there are 86400 seconds in one day which is why the above gives the number of seconds. Refer to the following: Spreadsheet Functions: Serial DateTime Values The other, for instance, is when the data is not already in a stored date format. In which case, you will first need to convert the value to the stored format. There are different spreadsheet functions to convert the information depending on what you need, but refer to the information for the TIMEVALUE() function at the following link which converts a text date and time to the internal information: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIMEVALUE_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |