Support Board
Date/Time: Thu, 13 Feb 2025 17:16:35 +0000
Post From: Spreadsheet programming question
| [2020-12-08 19:58:10] |
| John - SC Support - Posts: 37934 |
|
It represents the Date and Time in a decimal format by specifying the number of days since December 30, 1899. This is specified here: Spreadsheet Functions: Serial DateTime Values Since you are subtracting the start of the bar from the current time, you should only have the number of seconds since the open of the bar. What cell are you entering the information into? We are expecting that you would be entering the formula into K3. Then K3 will continuously update to give you the time since the beginning of the bar. The rest of the K column can be ignored. If the issue isn't about the cell you are entering the values into, then just try putting in the following formula and make sure you are just getting back the numbers after the decimal: = NOW() - A3 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |