Support Board
Date/Time: Sat, 23 Nov 2024 15:10:18 +0000
Post From: spreadsheet j41 time update
| [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 |