#Abcd chart code
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).
#Abcd chart update
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 kommentar(er)
