Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

Similar Threads

MT4 RTD API 0 replies

MT4 export to Excel? 8 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Has anyone made an Excel spreadsheet to analyze your MT4 trades? 0 replies

Integration between excel and MT4 prices 3 replies

Attachments: MT4 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

Quoting simnz
{quote} I have found some indicators for you. Not sure useful or not. I never tested them {file} {image}
Thank you
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Step by step instruction on how to make excel RTD faster

https://tradingtechnologies.atlassia...pdate+Interval
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Quoting garfield75
Does anyone know/suggest a simple trade manager EA set SL/TP for trades. I can execute trades from Excel RTD once all the conditions are met, then want the EA to take over to manage the trades.
Either way, the MT4 EA or EXCEL RTD would manage the trade on a virtual server. Have you considered Excel RTD to manage the trades on a virtual server?
Quoting mtharwat
{quote} Either way, the MT4 EA or EXCEL RTD would manage the trade on a virtual server. Have you considered Excel RTD to manage the trades on a virtual server?
I got 5 servers on AWS which I use as required. Managing trades in excel gets very heavy/bloated.
Managing trades SL/TP and trailing SL using the Swiss EA is working lot faster.
Attached Image (click to enlarge)
Click to Enlarge Name: 2d16e2d6490ca07a69149990ad7e9da5.png Size: 37 KB
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Hey Guys
Just interested to try to understand ... do you a) have a successful strategy that your are planning to convert from MT4/MT5 or whatever to Excel RTD or b) are you working your way through Excel RTD and then going to test/develop a strategy.
If a) would you expand on the strategy (no secrets) just theory behind the strategy; if b) can you elaborate the plan please.
Thanks appreciated
When you are successful perhaps give a thought to others ... Kiva dot org
  • Post #286
  • Quote
  • Edited at 7:36pm Jan 26, 2021 7:18pm | Edited at 7:36pm
Quoting PayItForward
Hey Guys Just interested to try to understand ... do you a) have a successful strategy that your are planning to convert from MT4/MT5 or whatever to Excel RTD or b) are you working your way through Excel RTD and then going to test/develop a strategy. If a) would you expand on the strategy (no secrets) just theory behind the strategy; if b) can you elaborate the plan please. Thanks appreciated
Hi PayItForward,

I will talk and elaborate more about the reason for this thread as this question might be asked by others. This post is more general and is meant to address other visitors of this thread. Your question is a good one and wanted to cover it thoroughly and clear the confusion others may have.

This thread is meant to help others unlock the potentials of Excel and break this "psychological barrier". And also to pull data into Excel through one of the many ways. In our case here, it is FXBLue Labs Excel RTD.
When I started, I spent a countless number of hours/days/weeks to know how to pull data and design dashboards.

So far, the thread has provided invaluable templates that will never be found anywhere on the web. I know what I am talking about because I have searched.. Those templates could be sold for a real buck per template and they are all provided for free. I am very proud of it and wish others either now or in many years to come find it useful.
In all my posts for dashboards, I intended to talk specifically about the math or formulas behind the dashboards. The reason is to open others' eyes that it is superior and very important that the trader creates and tests his own formulas rather than relying on others' formulas. Any of the templates in this thread can be easily used for any combinations or algorithms the trader wants to design. They would just change the formula/math and results show in milliseconds.
There is a learning curve when it comes to math formulas. Take for example the Currency strength. Should we take the average or the harmonic mean or the geometric mean of currency scores? What is the best formula for each currency score?

The last bit I am working on now is how to test strategies on .CSV history data and I will soon finish it.

Anyway, answering your question:
I think it will be better to open a new thread if traders want to talk about testing strategies and how to optimize them in Excel. I may open one in the future dedicated to testing models and optimization. It is still up to anyone if he/she wishes to discuss a strategy in this thread.

Regards,
Quoting garfield75
{quote} I got 5 servers on AWS which I use as required. Managing trades in excel gets very heavy/bloated. Managing trades SL/TP and trailing SL using the Swiss EA is working lot faster. {image}

I wanted to try testing buying and selling simultaneous trades at once. For example, if a currency group goes up, then buy all the pairs and sell at X pips. Do you think FXBlue Labs RTD would manage such high frequency in (one account)?
I guess from your post, it might not work smoothly?
Quoting mtharwat
{quote} I will talk and elaborate more about the reason for this thread as this question might be asked by others. This post is more general and is meant to address other visitors of this thread.
Thanks for the clarification ... greatly appreciated.
When you are successful perhaps give a thought to others ... Kiva dot org
When things get out of control
Attached Image (click to enlarge)
Click to Enlarge Name: 2021-01-27.png Size: 72 KB
Quoting mtharwat
{quote} I wanted to try testing buying and selling simultaneous trades at once. For example, if a currency group goes up, then buy all the pairs and sell at X pips. Do you think FXBlue Labs RTD would manage such high frequency in (one account)? I guess from your post, it might not work smoothly?
The use case you have provided should will work with Excel RTD. MT4 has a limitation of 100 trades open in the terminal.
You have 28 pairs, single currency group = 7 pairs.
Sending a buy order x 7 times should be fine. Then monitor account P&L in excel once it reaches a $ or %. you should be able to send a Close all to square off all position.

In my excel I have 75 instruments that I am tracking across 7 timeframes for 3 MA and 4 Stoch setting and current price.
All consolidated into a dashboard and around 100 line of Marco code to monitor and trigger Telegram Chatbot alert and in some cases execute a trade.
I don't want to overload the excel to then have to monitor individual trade P&L and apply to trail SL. This part I moved to EA on MT4 for performance efficiency.

  1. Monitor price and execute trades in Excel.
  2. Monitor and manage trade in EA/MT4.

Screenshots of all trades executed automatically from Excel RTD in last 24 hours. All Stoploss were managed and auto trailed via EA.

Attached Image (click to enlarge)
Click to Enlarge Name: 03a7fa17e79d51bf2d0df0277355de9e.png Size: 292 KB
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Quoting PayItForward
Hey Guys Just interested to try to understand ... do you a) have a successful strategy that your are planning to convert from MT4/MT5 or whatever to Excel RTD or b) are you working your way through Excel RTD and then going to test/develop a strategy. If a) would you expand on the strategy (no secrets) just theory behind the strategy; if b) can you elaborate the plan please. Thanks appreciated
I am in your option a).
Have a strategy that I trade manually on 4 hr chart. using excel RTD to configure the same parameters and monitor that across multiple timeframe charts and when that confluence happen than trigger an alert to my mobile via Telegram to check the currency pair for trade setup. This is a lot more convenient for me than having to check charts at regular interval.

This week I started a new strategy to test out based on the hypothesis:-

  1. if Weekly and Daily trends are in the same direction then when price pulls back to 50 MA on 1 hour, enter a trade in the direction of the trend.
  2. if Daily and 4hr trend are in the same direction then when price pulls back to 50 MA on 30 min enter a trade in the direction of the trend.
  3. No profit target.
  4. No Stoploss initially. SL moves to breakeven when 10 pips in profit and trailing stop loss kicks in after 15 pips in profit. (Not in Excel RTD)
  5. Position size 0.03 lot for every 5K in the account. (low risk).

Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
@Garfield and @PayITForward

Would you like me to open a new thread for Testing strategies in Excel?

If the two of you are interested, then the three of us would be enough to start a thread.

In my head, the thread would cover the following:

1- Discussions of strategies. This includes fully automated ones and also semi-automated ( a heads up when conditions are met but without execution of a trade).
2-Forward testing. By using an EA or Excel RTD on a cloud server.
3-Backtesting: A-BAcktesting a whole strategy B- Backtesting a small combination of these elements (one or two) in order to assess the profitability of an indicator or two on the long run. For example, I read some time ago that the Ichimoku strategy came at the top strategies according to the author's analysis. We need to conduct this analysis/research ourselves.

NB: One important disclaimer. I myself trade Price Action in H4/Daily/Weekly. My preference would lie in PA consolidations like Darvas Box, Fractals, Candle Patterns, PA patterns, etc.. However, I am a very open-minded person and believe there are no absolutes in life and can change my mindset when I see a reason for it.
Anyway, I still trade my way but very happy to conduct analysis and research strategies in Excel. I have tons of ideas in my head.


Let me know gents and I will start the thread tomorrow.

Cheers,
Quoting mtharwat
@Garfield and @PayITForward Would you like me to open a new thread for Testing strategies in Excel? If the two of you are interested, then the three of us would be enough to start a thread. In my head, the thread would cover the following: 1- Discussions of strategies. This includes fully automated ones and also semi-automated ( a heads up when conditions are met but without execution of a trade). 2-Forward testing. By using an EA or Excel RTD on a cloud server. 3-Backtesting: A-BAcktesting a whole strategy B- Backtesting a small combination of...
I am easy either way.
There is only a handful of us contributing to this thread, IMHO if we include strategies built and testing using only "Excel RTD" then you can still keep it in this thread, then learning from strategy and excel RTD stays in the same area instead of splitting.

We can have an agreement - if a strategy is built then all rules of that must be kept in 1 single post and that post is a referenced whenever any testing results, question, clarification etc is requested.
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Quoting mtharwat
@Garfield and @PayITForward Would you like me to open a new thread for Testing strategies in Excel?
@mtharwat thanks for asking.
Like @Garfield easy either way, for those that follow may be easier in one thread, like Garfield, all rules in one post however I think with any of my strategies, in the past anyway and like FX they are dynamic so it would be difficult in one contributor's post, a referenced post/s yes, simply because as far as I know you can only edit a single post within 24 hours of posting, maybe successful strategies could all be in Post 1 & updated there if necessary (Post 1 always editable as far as I know by the thread started and maybe as .pdf attachments, easily updated).
Or perhaps hyperlinks Post 1 to a shared Google Drive ... just a thought.
As previously stated I am a novice in Excel so my input there is very limited but wanting to learn as much as possible.
When you are successful perhaps give a thought to others ... Kiva dot org
Many thanks to the thread starter and all the contributors.

Am sure many, like myself, are learning a lot, particularly those limited in coding languages as excel reduces some of those limitations. As the starter has said the library here will be very useful well into the future.
Quoting fxomo
Many thanks to the thread starter and all the contributors. Am sure many, like myself, are learning a lot, particularly those limited in coding languages as excel reduces some of those limitations. As the starter has said the library here will be very useful well into the future.
You are welcome fxomo.
@Garfield and @PayItForward

No Problem. We stay here then.
If a good strategy is voted on, then I can edit the first post and link it or write its description.
strresult = cmd.SendCommand("accountnumber", "CLOSEALL", "GBPUSD", 0) , does anyone know how to set , if i want close for gbpusd sell position only
  • Post #299
  • Quote
  • Edited at 3:28am Jan 28, 2021 3:03am | Edited at 3:28am
Quoting nicholas87
strresult = cmd.SendCommand("accountnumber", "CLOSEALL", "GBPUSD", 0) , does anyone know how to set , if i want close for gbpusd sell position only
strresult = cmd.SendCommand("xxxxxx", "CLOSESYMBOL", "s=GBPUSD", 0) <- will close all GBPUSD Position buy & sell.
Trading is SIMPLE not EASY.
ExcelRTD Return This Month: 11.3%
Quoting garfield75
{quote} strresult = cmd.SendCommand("xxxxxx", "CLOSESYMBOL", "s=GBPUSD", 0) <- will close all GBPUSD Position buy & sell.
if i want close only sell position how to set?

thank you for reply
2 traders viewing now, 1 is a member:
Camo