![]() ![]() VBA isn't that tricky and can really improve your life. Since you're new to VBA, I've added some comments to the first half of the code to help you figure out what it's doing. I made the VBA to highlight the 3 points with a red font color like your example, and a pop-up message appears to list points AB&C. Yes, the code found the lower point on 2/3/16 which had me confused for a bit. PointC_Value = Cells(curRow, LowValueCol).Value PointC_Date = Cells(curRow, DateCol).Value Range(Cells(FirstRow, HighValueCol), Cells(curRow, HighValueCol)).Font.ColorIndex = xlAutomaticĬells(curRow, HighValueCol).Font.ColorIndex = 3ĮlseIf PointC_Date = 0 Or Cells(curRow, LowValueCol).Value 0 Then Cells(PointC_Row, LowValueCol).Font.ColorIndex = xlAutomatic PointB_Value = Cells(curRow, HighValueCol).Value PointB_Date = Cells(curRow, DateCol).Value PointA_Value = Cells(curRow, LowValueCol).ValueĬells(curRow, LowValueCol).Font.ColorIndex = 3ĮlseIf PointC_Date = 0 And (PointB_Date = 0 Or Cells(curRow, HighValueCol).Value > PointB_Value) Then PointA_Date = Cells(curRow, DateCol).Value "Point C: " & PointC_Date & vbTab & PointC_Value & vbLf "Point B: " & PointB_Date & vbTab & PointB_Value & vbLf & _ MsgBox "Point A: " & PointA_Date & vbTab & PointA_Value & vbLf & _ If PointA_Date = 0 Or Cells(curRow, LowValueCol).Value 0 And PointB_Date 0 And PointC_Date 0 Then Range(Cells(FirstRow, LowValueCol), Cells(LastRow, HighValueCol)).Font.ColorIndex = xlAutomatic LastRow = Cells(65536, DateCol).End(xlUp).Row The pattern stays intact until a low BELOW 1,812.29 occurs - OR - the target (Point D) is reached which is 1,972.48 by the way.Ĭan anyone think of a formula in columns D, E, or F that would automatically identify the three prices cited here instead of me just eyeballing it? In the following table, I can eyeball it and create the ABCD through just looking at it. The one thing that will break the pattern is when Point C goes lower than Point A. ![]() Once you have the AB and BC legs, you can project the ending price (Point D of the CD leg). You then need to find the low (after the B point is established) to form the BC leg. That forms the AB leg of the ABCD structure. Once you get a low (Point A of the ABCD) you then look for the next high (Point B of the ABCD). The numbers in the table below update every day automatically. Once certain highs and lows are made, you can project Point D and trade off of it. I am looking for a formula that automatically displays prices A, B, and C for an ABCD pattern (stock market). ![]()
0 Comments
Leave a Reply. |