Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

Random Walk (The unbeatable!) 354 replies

Is random really random? 231 replies

Probabilities in a Random Walk (Question about one CP's post) 35 replies

Random Walk Theory applying in Expert Advisor 336 replies

Price action pattern, and random thoughts 6 replies

Attachments: Random walk and Pascals triangle
Exit Attachments

Random walk and Pascals triangle

Quoting sqrt(-1)
How will you be able to obtain P(stopped out) or P(take profit) without using historical data of walks for pinbars at a swing high? Mere deviation from a central price based on probabilities of random walks? I like the idea, but forex isn't random, it isn't like flipping a coin. GBP/USD has run up ~1500 pips from the low a few months ago. We can examine the random probability of it doing this, and the odds are very small by random (given p,q=50%), but as you know, historically the pair has moved this much and more in the past. This is how we know...
In practice the probabilities are, more than anything, dependent on your entry rules/technique. So the only way to get statistics useful for risk assessment/management is from you own trading record.
Homeruns and capital preservation.
Quoting Scotty2Cues
can you give some theory plz?
Theory for which part? I thought that is just an application of pascal triangle, nothing new.
Quoting medici
In practice the probabilities are, more than anything, dependent on your entry rules/technique. So the only way to get statistics useful for risk assessment/management is from you own trading record.
I agree, we can also apply back-tests to theoretical entries as well. For example, when an indicator reaches a certain level.
Quoting ForexQuant
Theory for which part? I thought that is just an application of pascal triangle, nothing new.
How did you come up with the figures; did you count paths or something else? I couldnt come up with a formula and as Medici stated, Pascals triangle may not be the best route
Quoting sqrt(-1)
How will you be able to obtain P(stopped out) or P(take profit) without using historical data of walks for pinbars at a swing high? Mere deviation from a central price based on probabilities of random walks? I like the idea, but forex isn't random, it isn't like flipping a coin. GBP/USD has run up ~1500 pips from the low a few months ago. We can examine the random probability of it doing this, and the odds are very small by random (given p,q=50%), but as you know, historically the pair has moved this much and more in the past. This is how we know...
I was going to get P(stopped out) or P(take profit) once I inputted the probabilities for a step to the left/right P(step right) = 1 - P(step left).

So if I got the direction of the trend correct P(step right) would not equal P(step left) and I was looking at how different values of SL/TP affects ev calculations. I was then going to include a move to breakeven after x amount of steps:

EV = -risk*P(Stopped out before moving SL to BE) + P(SL to BE after x steps)*P(TP)*reward

compared to not moving SL to BE:

EV = -risk*P(Stopped out) + reward*P(take profit)
Quoting Scotty2Cues
How did you come up with the figures; did you count paths or something else? I couldnt come up with a formula and as Medici stated, Pascals triangle may not be the best route
You can see the formula used by simply clicking on a cell or hit F2 to see the formula displayed in the cell.

I had a look at the spreadsheet and it simply calculates the proportion of all paths that end up at a certain level. It doesn't take the TP/SL into account, i.e. that some paths are not permissible, so the calculations don't seem related to your original question.
Homeruns and capital preservation.
Quoting medici
You can see the formula used by simply clicking on a cell or hit F2 to see the formula displayed in the cell.
DOH!

Quoting medici
I had a look at the spreadsheet and it simply calculates the proportion of all paths that end up at a certain level. It doesn't take the TP/SL into account, i.e. that some paths are not permissible, so the calculations don't seem related to your original question.
Agreed. FQ has just used thae standard random walk model. So the method allows the SL to be hit more than once in n steps which is what I tried to avoid
Quoting medici
You can see the formula used by simply clicking on a cell or hit F2 to see the formula displayed in the cell.

I had a look at the spreadsheet and it simply calculates the proportion of all paths that end up at a certain level. It doesn't take the TP/SL into account, i.e. that some paths are not permissible, so the calculations don't seem related to your original question.
Which paths are not permissible? if you dont mind pls let me know.
Quoting ForexQuant
Which paths are not permissible? if you dont mind pls let me know.
For example, in a triangle of size 20, if the SL is -6, then the path that first goes -12 and then +8 ends up at -4 but has actually hit the -6 level before arriving at -4.
Homeruns and capital preservation.
Quoting Scotty2Cues
DOH!



Agreed. FQ has just used thae standard random walk model. So the method allows the SL to be hit more than once in n steps which is what I tried to avoid
I sum it up does not mean my method allow SL to be hit more than once. In fact the SL can be only hit once.

For example,

Event A: Hit TP at Step 1
Event B: Hit TP at Step 2
Event n: Hit TP at Step n

All those events are mutually exclusive. So P(A or B or n) = P(A) + P(B) + P(n)

I may not understand your question properly but the pascal triangle managed to solve a similar problem in one of the thread here. This solution is proven by 2 other members by using a monte carlo simulation and brute force simulation.
Quoting medici
For example, in a triangle of size 20, if the SL is -6, then the path that first goes -12 and then +8 ends up at -4 but has actually hit the -6 level before arriving at -4.
No, if the TP is +6 and SL is -2 then my excel sheet does not allow it to touch -12 or +8. Any path above TP and below SL are not taken into consideration.
Quoting ForexQuant
No, if the TP is +6 and SL is -2 then my excel sheet does not allow it to touch -12 or +8. Any path above TP and below SL are not taken into consideration.
you have to do a new one each time you change sl/tp
Quoting ForexQuant
No, if the TP is +6 and SL is -2 then my excel sheet does not allow it to touch -12 or +8. Any path above TP and below SL are not taken into consideration.
Just had a closer look at your spreadsheet after solving the problem on my own and discovered that we ended up with the same solution!

So my earlier glance at your file was a bit too quick. Your spreadsheet does the trick. Apologies...
Homeruns and capital preservation.
Quoting Scotty2Cues
you have to do a new one each time you change sl/tp
just copy & paste. It is not a difficult job.
Quoting medici
Just had a closer look at your spreadsheet after solving the problem on my own and discovered that we ended up with the same solution!

So my earlier glance at your file was a bit too quick. Your spreadsheet does the trick. Apologies...
Apologies accepted.
Quoting Scotty2Cues
you have to do a new one each time you change sl/tp
Actually you don't. I modified the original spreadsheet to handle varying TPs and SLs as well as varying probabilities for an 'up' move.

The triangle is of size 8 only, for the sake of illustration. You get the probabilities of hitting SL/TP on the bottom line.

One could implement the same in VBA using objects and recursive functions, but I don't quite have the energy today.
Attached File(s)
File Type: xls Random walk and Pascals triangle R1 -modified.xls   24 KB | 234 downloads
Homeruns and capital preservation.
Many thanks people!
medici, if the initial condition is that the position moves "up", shouldn't step one be 100% for +1R, instead of 50%? Maybe I'm not understanding exactly what you're doing, but your excel spreadsheet is valid only for a trade where step 1 is "up", SL= -2R, and TP=+6R. A new one must be made or modified if SL/TP changes -right now, changing your TP to +7 means it would never be hit...but as we know there is one path after 8 iterations to achieve +7 and it is if there is no "down step", this would occur at step 7 and the probability is 0.5^7=0.0078=0.78%.

Note... If there confusion, try and think of a path where +7R is hit in 8 iterations or <7 iterations. You can't reach +7 with less than 7 steps, and 8 iterations would require a retrace, but then that gives you n-1 "up" steps and you would only reach +6, or if there is no retrace, you would achieve +8R, but the position would have been closed at +7.

Quote
you have to do a new one each time you change sl/tp
Quoting sqrt(-1)
medici, if the initial condition is that the position moves "up", shouldn't step one be 100% for +1R, instead of 50%? Maybe I'm not understanding exactly what you're doing, but your excel spreadsheet is valid only for a trade where step 1 is "up", SL= -2R, and TP=+6R. A new one must be made or modified if SL/TP changes -right now, changing your TP to +7 means it would never be hit...but as we know there is one path after 8 iterations to achieve +7 and it is if there is no "down step", this would occur at step 7 and the probability is...
Not sure I understand what you are trying to say. What do you mean by "initial condition" for example. And that the spreadsheet should be valid for 6/-2 only doesn't seem right, as it gives identical numbers as FQ's for 6/-6. Could you please clarify?
Homeruns and capital preservation.
Quoting medici
Not sure I understand what you are trying to say. What do you mean by "initial condition" for example. And that the spreadsheet should be valid for 6/-2 only doesn't seem right, as it gives identical numbers as FQ's for 6/-6. Could you please clarify?
What I mean by initial condition is that your first move must be "up". That is, you open a position and then the first step (1) is to the left. Is that what you meant by...

Quote
I modified the original spreadsheet to handle varying TPs and SLs as well as varying probabilities for an 'up' move.

...?

Otherwise, I'm unsure what your spreadsheet represents, could you please explain what you mean by that?

Probabilities should be the same for most, but think about this. If have a SL at -2R then there is less of a chance that the position may return to some arbitrary TP relative to a SL set at -5R. The position may run to -3R and back to your TP, that is one path that the condition where you're stopped out at SL=-2R doesn't have, and hence a greater probability should be accounted for.
0 traders viewing now