MT4 to Excel through Excel RTD (Finally!)

1- Yes, EA has to be attached to every chart. With TFs, I can either condition the EA to trade based on the current or a specified TF. However, I have not yet tried to trade it with conditioned TF on another TF. For ex: condition it to trade in on M5 but place it on M15 chart. I have not tried this yet.
It can not monitor a list of pairs. It works independently.

2- Yesterday night I started experimenting with it and closed it before going to bed except for the last two trades closed this morning. So all the trades were mostly during the London session.
The net profit was USD 195.69 based on 0.1 lots. The total number of trades was 34.
I searched for trending pairs based on PA and traded accordingly. There two small profit USDJPY trades that I closed because they were executed a bit far from the MA20 so I closed them and readjusted the EA. GBPCHF trade was closed manually because I entered with a similar 0.1 lot size and stop loss was about 30 pips considering the volatility. I need to readjust EA on crosses and position sizing.
I closed also EURGBP for the same reason.

I may trade crosses based on Daily and H1 TFs and trade majors based on H4 M15 TFS.



-----------------------------

Can someone help me? I have a few formulate that works but other formula seems not working

Trading spot is full of risk and inflicts a lot of psychological pain. No harm in sharing my experience here. As a beginner I got into it and I felt it is affecting my psychology. On the suggestion of a friend (who later became my mentor), I moved to BUYING of options. Kept away from SELLING of options.

The friend told me you can learn trading by buying a lottery ticket or if you have deep pockets and mental agility to face loss of money or temporary loss (drawdown) then run a lottery business by selling options.

That happened more than 35 years ago.

Now I enjoy futures (spot) trading because I am able to assess the birth of momentum intuitively (using my brain signals) and exit within a few minutes most of the time or exit by day close.

However, I never keep any position open overnight. It has taken years of self-training to turn this kind of momentum trading into a habit. It is exactly like turning a fitness or sports exercise into a habit that sticks.

The exercise revolves around just four rules embedded in the mind:
when to trade,
when not to trade,
when to enter and
when to exit.

Rest is made up of how to of executing transactions in a cost-efficient manner.

I have studied hundreds of Finacial trading probability studies (with me knowing only the Excel basics) as part of the training to let my brain absorb unconsciously (be inputted with) the repeatable momentum patterns that occur. Outputs influence my discretionary momentum style of trading.



I shifted to trading spot after almost 7 years of BUYING options. 7 years in terms of 15 minutes a day. total 120 hours in 7 years.

Why buy options?

1. I enjoyed buying Options mainly for the reason that it was and is the only low-cost (in terms of investment and risk) self-training mode that could help me train by trial and error method on how to assess momentum and time the entry at a known defined risk cost.

2. Since I was quite busy with my business, I did not want to go through psychological pain of seeing drawdown nor attract any margin calls was another reason. I liked the suggestion given by the friend.

I could easily trade even with US$500 capital by buying an EU futures options contract outright for one-time investment of maximum of 40 pips (one pip tick value is US$12.5). I used to buy out-of-the-money options for 15 to 20 pips for short term momentum burst target of 20 to 50 pips. Sometimes I could make 5 times of the money and much of the time lose most of it.

At the end of the day , you were a nett winner if you continued to trade regularly. I traded just one of the two symbols only at a time. EU or UJ.
Expectancy = (Probability of Win * Average Win) - (Probability of Loss * Average Loss) is what matters really.

In Buying of Options, start of Momentum is important. Going past the winning post is not that important.


3. Options trading is a like a horse race when stakes are raised by both buyers and sellers based on the start taken by a horse irrespective of when winning post is hit or not.

A buyer has to raise betting amount while a seller is more than willing to accept higher priced bets.
As a buyer you should never wait for the finish line and must get out as quickly as possible with a reward (to augment winning kitty) or without reward (to save money for next try)

Unlike spot trading, you can't afford to wait for more time even when the direction of the trade is totally in your favour. You are up by 20% in terms of direction, but if you wait for another day, without the trend changing any direction, you might see 40% down next day.

It is the TIME value or implied volatility (market sentiment ) that counts. Not continuation of the direction. You are aiming to get out with maximum time value and volatility favouring your trade.

Hi Revsss,

I created that template and found unless you have a very high end laptop with high speed internet, it is not going to work well due to lag.
you can try to reduce the number of timeframes to see if that makes any difference.

Cheers

Hello,

The reason might be using more than 3/4 timeframes. The performance gets slower.

Can you please try three-time frames and let me know if this works for you.

Just saw your reply after posting mine.

You are right..

How did you go with the Greeks?
I have seen two extremes. A group adheres to their technical analysis and use options for leverage. Others refuse TA and only trade with the Greeks.
I myself do not like extremes or taking sides....

Generally happy with the way you are structuring your thoughts and psychology.

You are looking for quick money. There is no free lunch unless you use your time wisely and train like a sports person.
https://www.forexfactory.com/thread/...1#post13435191

From where did you get the impression I am looking for quick money?!.
Does my thread and my primary style of trading in https://www.forexfactory.com/thread/...s-and-entering? look like chasing quick money? By trading H4/Daily/Weekly?!

In this second thread (Trading through Excel RTD), it was meant for creating dashboards to assist with trading and my best dashboard is the Swing breakout (Price Action) and to assist traders who want to retrieve data in Excel. And currently making EAs for scalping on the side of the main trading of Higher Time Frames.

-----------------

I have traded options on stocks and I know options very well. You trade them so you should know what Greeks are. Don't you? I was opening a discussion with you to see your point of view of Greeks trading vs technical analysis. That's all. I have communicated with options traders before and asked them if they use TA. Some don't while others do.

Options get more complicated than purely buying or selling. There is straddle, butterfly, and more complex creation of options. Standard deviation and implied volatility and Greeks play an integral role in options trading. I can continue more but this is not the point.

You misinterpreted my post entirely..

It was a general comment aimed at a trader who is looking for quick results. Not at you.

Made a small adjustment to one of the 3 strategies in my Excel RTD to reduce the drawdown. Moving forward it should work well, need to make decision on trades opened in Feb, keep them going to see the outcome or close them out.

No Problem simnz...

there are 17 trades from Feb, which is the bulk of the drawdown. Next week I will be closing out these trades against generate profit to reduce the gap of floating DD.

Hi all.

I was hoping someone can assist me. I have built a robot based on my strategy. The robot has two triggers to to run being

1) All conditions met. Cell B2 equals 15. This is the sum total of all formulas that check conditions (I have attached a screenshot to kind of show what I mean, &
2) Cell B70 = "OK".

The code runs fine for a few trades then goes into a huge loop and runs trade after trade after trade without stopping.
The code I use to to trigger a trade is

Private Sub Worksheet_Calculate()
Dim calc As Long
Dim check As String
calc = Range("B2").Value
check = Range("B70").Value
On Error Resume Next
If calc = 15 And check = "OK" Then
Call ROBOT
Exit Sub
End If
End Sub
Public Sub ROBOT()

' Get the values from the named cells on the worksheet
strAccount = Range("AccountNumber").Value
strSymbol = Range("TradeSymbol").Value
strCommand = Range("TradeDirection").Value
vVolume = Range("TradeVolume").Value
StrStop = Range("StopLoss").Value
StrTp = Range("TakeProfit").Value
' Check that the values are valid
If Not IsNumeric(strAccount) Then
' MsgBox "Account number must be numeric!"
Exit Sub
End If
If strSymbol = "" Then
' MsgBox "Symbol to trade cannot be blank!"
Exit Sub
End If
If vVolume < 1 Then
'MsgBox "Volume is not valid (should be a trade size such as 10000, not a number of lots such as 0.10)"
End If
' Build the parameters which are sent for the trading command: symbol and volume
strParameters = "s=" & strSymbol & "|v=" & vVolume & "|sl=" & StrStop & "|tp=" & StrTp
' Timeout in seconds
lTimeoutSeconds = 5
' Create the FXBlueLabs.ExcelCommand object and send the command
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.SendCommand(strAccount, strCommand, strParameters, lTimeoutSeconds)
' STOP TRADES THIS CHANGES THE VALUE OF B7O TO NO OK TO TRADE
Range("B73").Select
Selection.Copy
Range("B73").Select
Application.CutCopyMode = False
Selection.Copy
Range("B70").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B75").Select


' Check the result
If InStr(strResult, "ERR:") = 1 Then
'MsgBox strResult

End If
Call Lasttrademade

End Sub
Public Sub Lasttrademade()
'
' Lasttrade Macro
'
'This copys the activity of the last trade taken
Range("$B$41").Select
Selection.Copy
Range("$B$29").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=-6
Range("$B$20").Select
Application.CutCopyMode = False
Selection.Copy
Range("$B$30").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

I was wondering if anyone can assist and let me know what I am doing wrong here,

Many thanks

Cam

The first strategy seems to be doing exceptionally well. Did the other two strategies start at the same time of the first one?

Hi all.

Still struggling with my question however I did come across this which I think will help people with speed issues.

Excel has a throttle that manages how often it updates. You can set this throttle to whatever update rate you want. From a Microsoft FAQ, here are the steps to set the throttle to continuously update.

To set the throttle interval higher using the Excel object model:

1. In Excel, go to the Visual Basic Editor by pressing ALT + F11.
2. On the Immediate Window at the bottom of the display, type this code:
   Application.RTD.ThrottleInterval=0
   (Note: If the Immediate Window is not open, press CTRL + G to display the window.)
3. Make sure your cursor is on the line that you just typed and then press ENTER.
4. To verify that it is set correctly, type this line of code on the Immediate Window:
   ? Application.RTD.ThrottleInterval
5. Make sure your cursor is at the end of this line and then press ENTER. The window should display 0; then you know that your throttle interval is set correctly.

Hope this helps with those speed issues

All started at the same time.
S-2 & S-3 combined has given 5% over 2/5 Weeks, It is a very good return by itself. S-1 is currently stealing the thunder.

Hi Cam,

At first glance, the code seems fines. Hard to tell where it is going wrong without running the scenario.
Do you run this 24x5 or only at a certain time.
Try to remove and attach Excel RTD to the chart again. I have noticed the excel RTD is not reliable in 24x7 operation, I manually remove and reattched it to the chart everyday once to make sure it is performing properly.



Cheers

HI Garfield.

Thanks for the reply.

I agree it can be hit and miss and yes I do run it 24/5. I think the issue is two fold being:
1) Excel RTD seems to clag out if the aggregate of the RTD data takes more than 2 milliseconds to calculate.
2) my model only really starts skipping a beat during the NY start when volume kicks in. The problem is that once it gets in the loop it won't stop. I took 816 trades in four hours on Friday lol.

In am attempt to remedy the situation I have
1) reduced the throttle time to 0.05% of the standard throttle.
2) put in the application wait code and

3) added an application.calculate function to the code.

I have put this in play in theory only as it's the weekend so may well happen again on Monday but will keep you posted to see if it resolves the issue.

Cheers