Support Board
Date/Time: Sat, 23 Nov 2024 12:25:34 +0000
spreadsheet j41 time update
View Count: 94
| [2024-08-26 04:01:19] |
| User251851 - Posts: 2 |
|
hello, i 'm using the j41 to enable the k3 for only the first second of a new candle (SECOND(FRACTIME($J$41))-SECOND(FRACTIME(A3))>=0.1,SECOND(FRACTIME($J$41))-SECOND(FRACTIME(A3))<=1))to be able to turn off k3 for other conditions to place other buy limits ,but since j41 is only updated if a trade happens in the market so it's not very accurate (if low volatility). i finded clock realtime study more precise updating everytime but the clock subgraph sg1 gives always 0 value so i couldn't use it is it possible to have the time every second updating without skipping any sec to use it in alert formula or in the spreadsheet? thank you very much |
| [2024-08-26 18:46:27] |
| John - SC Support - Posts: 36238 |
|
There really is not an option that does what you want. And even if there was, the issue is that the Spreadsheet System for Trading would not be processed anyway, as the updates to the charts and the studies happens when trading is occurring. So a low volatility market would require a change in how you are approaching this problem.
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: