matthewlouis
Active Member
- Joined
- Mar 28, 2014
- Messages
- 374
- Office Version
- 365
- 2019
- Platform
- Windows
I have 3 columns of stock prices – the date, the low, the high, and the close. I am trying to build a formula (may have to be in multiple columns with each column having its own formula) that returns the A point price, B point price, and C point price of something called the ABCD pattern -- D is the calculated projection of price based on the price of A, B, and C. Very accurate and time tested way to project prices. I need to an algoto calculate this everyday without having to look at a chart.
A bullish pattern is when the price starts off at a low point – Point A of the ABCD pattern. As price rises, the B point is formed once you get a lower high and lower low. Then when you get a higher high and higher low, the price previous to that bar is the C point. This may be multiples formulas (I think) that will identify the A, B, and C points given the higher highs, higher lows, lower highs, and lower lows. It has to be looked day-by-day to see if any of these A, B, or C price points have been created.
NOTE: The pattern is broken IF the price forms the ABC part of the pattern and then price CLOSES below A. That’s a failed pattern.
I don’t know how to do VBA – which I think would work best – so can anyone help me do this in columns with formulas for each column?
Thanks in advance!
<tbody>
</tbody>
A bullish pattern is when the price starts off at a low point – Point A of the ABCD pattern. As price rises, the B point is formed once you get a lower high and lower low. Then when you get a higher high and higher low, the price previous to that bar is the C point. This may be multiples formulas (I think) that will identify the A, B, and C points given the higher highs, higher lows, lower highs, and lower lows. It has to be looked day-by-day to see if any of these A, B, or C price points have been created.
NOTE: The pattern is broken IF the price forms the ABC part of the pattern and then price CLOSES below A. That’s a failed pattern.
I don’t know how to do VBA – which I think would work best – so can anyone help me do this in columns with formulas for each column?
Thanks in advance!
HIGH | LOW | CLOSE | |
4/6/2018 | 2,656.88 | 2,586.27 | 2,604.47 |
4/9/2018 | 2,653.55 | 2,610.79 | 2,613.16 |
4/10/2018 | 2,665.45 | 2,635.78 | 2,656.87 |
4/11/2018 | 2,661.43 | 2,639.25 | 2,642.19 |
4/12/2018 | 2,674.72 | 2,653.83 | 2,663.99 |
4/13/2018 | 2,680.26 | 2,645.05 | 2,656.30 |
4/16/2018 | 2,686.49 | 2,665.16 | 2,677.84 |
4/17/2018 | 2,713.34 | 2,692.05 | 2,706.39 |
4/18/2018 | 2,717.49 | 2,703.63 | 2,708.64 |
4/19/2018 | 2,702.84 | 2,681.90 | 2,693.13 |
4/20/2018 | 2,693.94 | 2,660.61 | 2,670.14 |
4/23/2018 | 2,682.86 | 2,657.99 | 2,670.29 |
4/24/2018 | 2,683.55 | 2,617.32 | 2,634.56 |
4/25/2018 | 2,645.30 | 2,612.67 | 2,639.40 |
4/26/2018 | 2,676.48 | 2,647.16 | 2,666.95 The A point is the low on April 6 of 2656.88. The B point is April 18 at 2717.49 because April 19 had a lower low and lower high than APril18. The C point low is April 25 at 2612.67 because April 26 had a higher high and a higher low than April 25. |
<tbody>
</tbody>
Last edited by a moderator: