ok heres the new spreadsheet i promised thanks to who posted it for the design i used i jsut modified it... also attached is a trade i made using the chart.... ill explain some things the x represents the newest bar updated which would be the new one bar and the bar marked as one would now be bar 2 and so forth... i chose a 80 level rate not 90 like that time because at 90% successful trades were not profitable 80% is the lowest i go. 80% lets us drop 4 extremes the 10,11,12,13 leaving 8 the LSD and 14 the SLD 15 was the highest so all short side trades that were > 15 were placed as long side 15-1 pip was 14 so 14's were moved over as well as they equalled the modified SLD leaving 8 as the entrance distance and 14 as target. any questions on this calculation....? next is the trade we used using the chart.....
the chart this is a pending trade i placed using the table listed ... note 20 ema was plotted bias was decided to be upwards pending was set at 8 and take at 14 from open it pushed up after open stopped 2 pip away from 8 reversed and went down never entering trade .... the two vert. lines plotted are the start of the calculation bars and stop of calculation bars with the closest bar to moving price bar 1 and furthest bar 21. edit: lets also note that the summation of this bar and last bar moved down > 35 pips on the 3 hr so we can expect the next bar to move downward as well with 90% accuracy because of the 3 hour being calculated like the one hour. ill post a chart to show next bar well see if we are right.
youve never heard of these terms as they are made up.... take a candle lets say it has parameters: Open: 100 High: 110 Low:80 the shortest distance is High-Open the longest distance is Open-Low LSD is the longest distance of all the shortest distances SLD is the shortest of all the longest distances. hope that answers it.
ok now that weve established an excel thats up to date we can easily modify for next bar not the modification new bar one came in we replaced bar 21 with the new bar updated the excel this dropped our LSD to 7 with SLD still being 14. attached update next post ill attach chart with moved lines and trade lines.
ok note how when i said it had 90% chance of bar being down.... cause of the 3 hr prob we placed our trade down 7 entrance 7 stop 14 take chart attached trade creamed the take profit without looking back. 1399.82 buck trade for me
The formula for LSD says "=MAX(B2:B29)" but the data table is actually in rows 2 through 30. So you're ignoring the data in row 30. Same for the SLD MIN functin.
I hope I got it. Let me guess ... In this example the shortest distance is 110-100=10 and the longest is 100-80=20. If the open was nearer to low (instead of high) the computation were done reversely (Open-Low for the shortest and so on). In other words, you measure open to high and open to low distances. The bigger one is longest, the second one is shortest. Right? Now on LSD, SLD. You collect all these shortest and longest values over 21 (for example) bars. Then you take the biggest one from the group of shortest values and it is LSD. Vice versa for SLD. Right? Sorry, I am trying to get it perfectly right. I like your style that much that I had to register here on ET. Thank you again!