MT4 Trading the GAP With Excel

Quoting Opemipo

Disliked

{quote} Great my brother! I m doing the same too. Olufemi

Ignored

Quoting xaem

Disliked

{quote} Ok i edit Code Auto update address install Speedometer_v4c.xlsm in folder name MQL4\FILE {file}

Ignored

Quoting PayItForward

Disliked

Does anyone know where the following data originates or is calculated: Speedometer v4c Sheet: GAP_test Cells F8..F35 Advice appreciated. Thank you. {image}

Ignored

Quoting the bourne

Disliked

{quote} Hi in F Column you have the previous BSRatio,saved and updated by the excel each XX minutes interval XX minutes depend from the update interval selected by the user pushing one of the Buttons to the right,around S16:T22 area hope it helps

Ignored

Quoting JamesCaror

Disliked

Dear Hotpotato , See in picture... there are sell signals.. but no buy signals,, James

Ignored

Quoting the bourne

Disliked

Hi all automated trades Today trades TOTAL TRADES 9 WINNING TRADES 9 HIT RATIO 100% Best pair of the day, USDJPY EA didn't open any trade during my NewYork trading time zone, but Tokyo and London made my day my 2 Algorithms are workin' well together,but I want to remove ALL wrong signals {image} {image}

Ignored

Quoting Hotpotato

Disliked

{quote} Yea thanks, that was the question..... But never mind i found it. Fully automatic but i know to little of the workings of Speedometer to know when to generate the correct signals. It is now just following the signals in the first column. But it works and i just wanted to check that. {image}

Ignored

Quoting LFN

Disliked

{quote} Interesting as always Only to be used with EAX in BDM?

Ignored

Quoting Hotpotato

Disliked

{quote} Yes. Communication between MT4 and Excel goes through a bidirectional "pipe" and BDM creates the pipe and acts as the pipe server.

Ignored

Quoting LFN

Disliked

{quote} Looking forward to this. I hope you will get the support you need from the Excel professionals here.

Ignored

Option Explicit
      Dim olvalbuy(28) As Long
      Dim olvalsell(28) As Long
      Dim i As Long
      
Private Sub Worksheet_Calculate()
    For i = 0 To 27
        If Cells(10 + i, 7).Interior.ColorIndex <> olvalbuy(i) Then
            If Cells(10 + i, 7).Interior.ColorIndex > 1 Then
                Send_Pipe ("BUY " & Cells(10 + i, 6).Value)
                olvalbuy(i) = Cells(10 + i, 7).Interior.ColorIndex
            Else
                Send_Pipe ("WAIT " & Cells(10 + i, 6).Value)
                olvalbuy(i) = Cells(10 + i, 7).Interior.ColorIndex
            End If
        End If
        If Cells(10 + i, 8).Interior.ColorIndex <> olvalsell(i) Then
            If Cells(10 + i, 8).Interior.ColorIndex > 1 Then
                Send_Pipe ("SELL " & Cells(10 + i, 6).Value)
                olvalsell(i) = Cells(10 + i, 8).Interior.ColorIndex
            Else
                Send_Pipe ("WAIT " & Cells(10 + i, 6).Value)
                olvalsell(i) = Cells(10 + i, 8).Interior.ColorIndex
            End If
        End If
    Next i
End Sub

Quoting Opemipo

Disliked

14 trades so far 100%.{image} Thanks Jabala and Project. Olufemi

Ignored

Quoting Hotpotato

Disliked

Gone need the help from a VB/Excel guru. Trying to catch a change in the (buy/sell) cells background color and call Send_Pipe() on worksheet recalculate I thought that the Interior.ColorIndex 0 and 1 where color none and color black. It is really simple code but i know nothing of VB in combination with Excel. Someone ? Option Explicit Dim olvalbuy(28) As Long Dim olvalsell(28) As Long Dim i As Long Private Sub Worksheet_Calculate() For i = 0 To 27 If Cells(10 + i, 7).Interior.ColorIndex <> olvalbuy(i) Then If Cells(10 + i, 7).Interior.ColorIndex...

Ignored