Hi, Let me first congratulate the team for the latest version of KiteXL. Everything is working great
My query is related to the processor clock speed. I have built a trading strategy using resistance levels.... when the price is greater than the resistance price a sell order will be executed and vice versa. In order to avoid the order getting executed multiple times, I have used the following VBA code: Private Sub Worksheet_Calculate() Dim A As Range, r As Range Set A = Range("F8:F200") Set B = Range("G8:G200") Set C = Range("J8:J200") Set D = Range("C8:C200")
For Each m In D If m.HasFormula And m.Value > 0 Then m.Value = m.Value Call GetPositions End If Next m
For Each x In A If x.HasFormula And x.Value > 0 Then x.Value = x.Value Call GetPositions End If Next x
For Each y In B If y.HasFormula And y.Value > 0 Then y.Value = y.Value
End If Next y
For Each Z In C If Z.HasFormula And Z.Value > 0 Then Z.Value = Z.Value
End If Next Z
Also I am calling the function getpositions in order to fetch the price.
I have observed excel hanging and few orders not getting executed.
I have 30-50 stocks in the watchlist. My laptop has AMD A8 processor with a clock speed of 1.9 GHZ and 5 years old. Running Excel 2013.
So my question: Is it the processor or there is a better VBA code