Support Board
Date/Time: Wed, 27 Nov 2024 08:46:39 +0000
formula time
View Count: 310
| [2023-08-30 12:03:48] |
| User278398 - Posts: 291 |
|
hello, what is the formula that will work only between 30-50 sec? (i have spreadsheet study (in 1 sec chart) with equation that i built. i want that equation will work only when the second time is between 30-50 second. for exa: the equation will work at 9:30:30-9:30:50 and at 9:31:30-9:31:50 and.......) regards. |
| [2023-08-30 15:12:59] |
| John - SC Support - Posts: 36309 |
|
Within a Spreadsheet Study you would use the following formula to get the seconds as a single value based on the current time: =INT(FRACTIME(FRACTIME(FRACTIME(NOW()) * 24) * 60) * 60) Make sure your computer clock is synced with the data, as the above gives the time from your computer clock. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-09-03 15:17:20] |
| User278398 - Posts: 291 |
|
i understand the formula u wrote, but it is not what i wish for. i will be more specific: i have id1: spreadsheet formula study, and the formula i have in it: =1 also, i have id2: spreadsheet formula study, and the formula i have in it: =if(XXX,ID1.SG1,0) .... i want to get ID1.SG1, between 30-50 sec in every min. how "=INT(FRACTIME(FRACTIME(FRACTIME(NOW()) * 24) * 60) * 60)" can give me what i need !? can u help me with the specific formula (replace to "xxx") to get what i need? many thanks. |
| [2023-09-03 15:43:19] |
| Sawtooth - Posts: 4120 |
|
Try this: =AND(SECOND(BARTIME)>30,SECOND(BARTIME)<50) |
| [2023-09-04 08:31:09] |
| User278398 - Posts: 291 |
|
amazingggg, thank youuuuuu
|
To post a message in this thread, you need to log in with your Sierra Chart account: