Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 13:52:22 +0000

How to Post a Message for Support

[User Discussion] - function

View Count: 1424

[2014-10-06 03:50:28] #1 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
vegasfoster - Posts: 444
in m3, =if(l3>m4, k3, m4)

[2014-10-06 13:49:11] #3 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
julian pineda - Posts: 60
what about this?: http://screencast.com/t/4wIeyId0fAa

[2014-10-06 17:42:46] #5 [Go To First Post]
vegasfoster - Posts: 444
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 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
vegasfoster - Posts: 444
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 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
vegasfoster - Posts: 444
if always evaluating against 40%, then in m3, =if(AND(l4<.4, l3>.4), k3, m4)

[2014-10-07 15:25:58] #10 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
julian pineda - Posts: 60
???????

[2014-10-09 23:22:44] #12 [Go To First Post]
vegasfoster - Posts: 444
Maybe someone else can help you.

[2014-10-09 23:42:21] #13 [Go To First Post]
Sawtooth - Posts: 3976
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 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
julian pineda - Posts: 60
intrabar value is impossible?

[2014-10-10 14:31:34] #16 [Go To First Post]
julian pineda - Posts: 60
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 [Go To First Post]
julian pineda - Posts: 60
or a function that returns me the variation % from the open ?

[2014-10-10 15:59:27] #18 [Go To First Post]
Sawtooth - Posts: 3976
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

To post a message in this thread, you need to log in with your Sierra Chart account: