Support Board
Date/Time: Wed, 27 Nov 2024 20:45:10 +0000
[User Discussion] - function
View Count: 1507
| [2014-10-06 03:50:28] |
| 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] |
| vegasfoster - Posts: 444 |
|
in m3, =if(l3>m4, k3, m4)
|
| [2014-10-06 13:49:11] |
| 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] |
| julian pineda - Posts: 60 |
|
what about this?: http://screencast.com/t/4wIeyId0fAa |
| [2014-10-06 17:42:46] |
| 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] |
| 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] |
| 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] |
| 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] |
| 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] |
| 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] |
| julian pineda - Posts: 60 |
|
???????
|
| [2014-10-09 23:22:44] |
| vegasfoster - Posts: 444 |
|
Maybe someone else can help you.
|
| [2014-10-09 23:42:21] |
| Sawtooth - Posts: 4120 |
|
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] |
| 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] |
| julian pineda - Posts: 60 |
|
intrabar value is impossible?
|
| [2014-10-10 14:31:34] |
| 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] |
| julian pineda - Posts: 60 |
|
or a function that returns me the variation % from the open ?
|
| [2014-10-10 15:59:27] |
| Sawtooth - Posts: 4120 |
|
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?
There is a possible cumbersome workaround using the Study Overlay-OHLC study referencing a 1 second or 1 tick chart.or a function that returns me the variation % from the open ? 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: