# Support Board

Date/Time: Thu, 09 Apr 2020 19:31:19 +0000

## [User Discussion] - function

 [2014-10-06 03:50:28] #1 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] hi, there is a function that i can use in the spreadsheet that show me the image of a number? for example: i have 3 columns K L M 30% 40% in the M column i want this: =if L => 40%, give me the K number. in this case M will be: 30% i need M column to be the number that k was in the moment L was => 40%. so i need de 30% and no more, no movement. just the number of that momentum.
 [2014-10-06 04:59:28] #2 vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired] in m3, =if(l3>m4, k3, m4)
 [2014-10-06 13:49:11] #3 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] no a need a exact number. In m3, =if(L>40%,give me the actual number, the number that was K when L touch 40%
 [2014-10-06 16:16:52] #4 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] what about this?: http://screencast.com/t/4wIeyId0fAa
 [2014-10-06 17:42:46] #5 vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired] Not 100% sure what you are asking then, but there is no way to capture intrabar data in spreadsheet, all data is bar close data. If you want to capture intrabar data, it's not possible, if you are asking something else then I still don't understand. Date Time Of Last Edit: 2014-10-06 17:43:50
 [2014-10-06 17:50:47] #6 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] i need the number of the column K, when the other one is > 40%, i mean this: K: 20% 21% 22% 23% 24% 25% 28% 30% L: 32% 34% 35% 38% 40% 41% 45% 46% so, in this example the time when L > 40% was when k was 25%. so i need that 25%. if a do any formula it will be moving and i dont need that, i just need the 25%. so what i im trying to said is if exists a way to spring me that number in the momentum just the 25%
 [2014-10-06 22:01:53] #7 vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired] I think I understand, but tell me this, do want it to stay 25% forever, i.e. rest of the day, or do you want it to update to the new number if it drops below 40% and then goes over 40% again?
 [2014-10-07 00:11:28] #8 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] my time frame is volume per bar 40.000 so that 25% will stay like that in that candle, in the nex one it will be change. so thats why it never drops down, ´cause in my formula the number only goes up
 [2014-10-07 04:59:01] #9 vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired] if always evaluating against 40%, then in m3, =if(AND(l4<.4, l3>.4), k3, m4)
 [2014-10-07 15:25:58] #10 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] look up the pic, just columns Q and R: http://screencast.com/t/M8CWpoi6 this is what i need: Step 1: when Q column touch 40% step 2: how much was R column when Q touch 40%, so in P column returns me the value of R when Q was > 40%. if i do this: =if(Q>0,40;R;"no") in P i will get a moving number, because the market flows. and i need just the number R was when Q > 40%. just that number, the frozen number, the exact number... Do i Explain my self better?
 [2014-10-09 14:43:54] #11 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] ???????
 [2014-10-09 23:22:44] #12 vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired] Maybe someone else can help you.
 [2014-10-09 23:42:21] #13 tomgilb - Posts: 2441 | Ending Date: 2020-04-30 Use a double IF statement, the first IF to turn on the latched value, the second to turn it off: Formula in P3: =IF(AND(Q3>=0,4;Q4<0,4);R3;IF(Q3<0,4;0;P4)) This will capture the first bar's value of Q that was >0,4 at the close of the bar (not the value it was intrabar), and it will repeat until the value of Q < 0,4 Date Time Of Last Edit: 2014-10-09 23:43:28
 [2014-10-10 13:56:39] #14 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] but im doing this analisis from the same candle. so i always see actual numbers, i mean line 3 not 4
 [2014-10-10 14:19:19] #15 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] intrabar value is impossible?
 [2014-10-10 14:31:34] #16 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] and other question, what function do i use that returns me the open value? or the lowest one?
 [2014-10-10 14:33:28] #17 julian pineda - Posts: 60 | Ending Date: 2016-07-10 [Expired] or a function that returns me the variation % from the open ?
 [2014-10-10 15:59:27] #18 tomgilb - Posts: 2441 | Ending Date: 2020-04-30 intrabar value is impossible? It is not possible with a spreadsheet study. It would require a custom .dll study using ACSIL. what function do i use that returns me the open value? or the lowest one? or a function that returns me the variation % from the open ? There is a possible cumbersome workaround using the Study Overlay-OHLC study referencing a 1 second or 1 tick chart. http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s149