MT4 to Excel through Excel RTD (Finally!) | Page 12 | Forex Factory

Options

Go to
Permalinks
Print Thread

Related Instruments

EUR/USD, EUR/JPY, GBP/USD

Similar Threads

Calculating EMA strength like RTD on break free trading 0 replies

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

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!)

  • #221
  • Jan 12, 2021 6:18am Jan 12, 2021 6:18am
@ Garfield75

Is this screenshot for CSM the one you want in RTD ?

Or attach the DDE excel template if it is different.
Attached Image (click to enlarge)
Click to Enlarge Name: 06393B00-6735-45B2-80EC-1F33269BEF11.png Size: 68 KB
  • #222
  • Jan 12, 2021 7:25am Jan 12, 2021 7:25am
Quoting mtharwat
@ Garfield75 Is this screenshot for CSM the one you want in RTD ? Or attach the DDE excel template if it is different. {image}
Yes. That is the one.
Trading is SIMPLE not EASY.
  • #223
  • Jan 12, 2021 7:49am Jan 12, 2021 7:49am
Quoting JibalaPasan
{quote} It is very logical that a macro that checks a cell if its value is >10 will permanently execute its command as long as the value is >10! You now have different ways on how to solve that problem. A very simple solution could be: Put a switch on another cell which will be set from 0 to 1. Your macro then will check both cells (if a1 > 10 and a2 = 0 then...) Don't forget to set your switch to "a2 = 1" otherwise the macro will continue to execute. Best of luck and stay green always! Jibala
THANK YOU
  • #224
  • Jan 12, 2021 12:28pm Jan 12, 2021 12:28pm
Quoting antariks
{quote} We are pending on this for a long time and no one seems to have a solution Automation is out of question without this This is the original code. An additional condition need to be inserted, something like "If A1>0.001" ' Create the FXBlueLabs.ExcelCommand object and send the command Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.sendCommand(strAccount, strCommand, strParameters, lTimeoutSeconds)
It can be done. I have a solution.
everything on the internet about forex is garbage
  • #225
  • Jan 14, 2021 2:11am Jan 14, 2021 2:11am
Quoting sasschrist
{quote} It can be done. I have a solution.
Hi Sasschrist

Please elaborate on your solution with some examples shared here.

Cheers
Trading is SIMPLE not EASY.
  • #226
  • Jan 14, 2021 3:49am Jan 14, 2021 3:49am
Quoting JibalaPasan
{quote} Did you hack my account? All over strength is something I'm looking into already. {image} {image} Actually, I don't trade it because I'm too much focused on the German DAX / GER30 where I gain the most of my profits. Best of luck and stay green always! Jibala

It will be a better idea if you share your template here. I can easily do it myself but I will be back in few days. Garfiled asked for it...
  • #227
  • Jan 14, 2021 3:50am Jan 14, 2021 3:50am
Quoting sasschrist
{quote} It can be done. I have a solution.
It will be more helpful and more beneficial if you share your template..
  • #228
  • Jan 14, 2021 4:15am Jan 14, 2021 4:15am
A message to every one:

This thread is for all traders to unlock the potentials of Excel. Every help possible will be provided regardless of the knowledge or level of the trader.

Any poster should fall within two groups. The first group is the trader who either needs Some help or is finding the whole Excel experience to be challenging. This thread is the right place for this group of traders. They are more than welcome to ask for anything they need. They should not be shy of asking.

The second group are those who have some knowledge and share it with others.

The third group is the non-welcomed group. They tease others by their screenshots or by their knowledge without sharing anything.
No one benefits from them.

Since I created this thread, I am giving myself the right to state the rules here. In short: Either you share a template or refrain from posting.

I think many would agree with me.
  • #229
  • Jan 14, 2021 4:54am Jan 14, 2021 4:54am
Quoting mtharwat
A message to every one: This thread is for all traders to unlock the potentials of Excel. Every help possible will be provided regardless of the knowledge or level of the trader. Any poster should fall within two groups. The first group is the trader who either needs Some help or is finding the whole Excel experience to be challenging. This thread is the right place for this group of traders. They are more than welcome to ask for anything they need. They should not be shy of asking. The second group are those who have some knowledge and share it...
Excellent .
Practice makes a person perfect
  • #230
  • Edited 5:44am Jan 14, 2021 5:10am | Edited 5:44am
Is anybody keenly interested in developing a backtester without using any indicator, but using a logic involving only Pips (numbers), Minutes (time) and Percentages.

With this kind of tool, anybody can immediately assess the feasibility and probable profitability of the trade just by pushing a few buttons.

Essentially, the job will involve using MT4 scripts or (preferably an indicator) to generate database on demand without resorting to downloading Excel data.

A dashboard is required for user like me , an Excel-challenged person. It is not to have a mere colourful interface, but to use it as a user-friendly input machine to input dates, percentage levels, numbers, symbols, data options and above all filters that can really put some meaning to database generated.

For producing backtester, all the indicators that can be quantified , measured and have defined constant values will be used.

I just use two information indicators to assess trading changes as well as plot TP, SL and Entry for systematic trading.
Hassle-free plotting of trades always generated good profit factor.

I am sure a few more indicators fulfilling the stated criteria can be found.

Example:

ADR has known average value based on previous days
Yesterday High Low medium has known constant values.

Garfield75 has already demonstrated his Excel skills and I am sure others willl help themselves as well as Excel-challenged persons like me.

I don't know much about indicators that can have defined constant values for use as a trading plot that involves just the use of numbers, minutes and percentages.

I am zero in Excel and willing to share my ideas based on my extensive real trading experience. I have no agenda and I strongly believe in destiny and so I don't believe in keeping even my business strategies that can be used by competitors.

And as far as financial trading is concerned, there are no secrets as much as you pretend to have and want to sell to gullible greedy people.
Practice makes a person perfect
  • #231
  • Jan 14, 2021 5:36am Jan 14, 2021 5:36am
Quoting garfield75
{quote} Hi Sasschrist Please elaborate on your solution with some examples shared here. Cheers
Thank you Garfield for your initiative . Highly appreciated.
I have provided the framework and tools for elderlies to do demo or cent contract trading to keep their brain active.
Trading is an individual sports and you should get involved only if you believe it is an activity of pleasure and passive income.
Money will follow but only for those who believe in enjoying it.
Trading without pressure is essential if you want to be a consistent money maker.

For the benefit of members of this forum, the link of probability study done by you is provided here.
Thank you again.

https://www.forexfactory.com/thread/...7#post13358237
Practice makes a person perfect
  • #232
  • Edited 10:06pm Jan 14, 2021 10:26am | Edited 10:06pm
I have been a customer of Interactive Brokers since 2004. I use Metatrader 4 for demo trading and seeking statistics through nformation indicators but actual trading is carried out on IB platform TWS Trader.

I will be glad to guide if anyone with Excel skills want to develop Dashboard for Currency Future Options. I have a paper trading account that can be used to pull down the live data. An IB customer can use CME data only on live or paper trading account.

By interacting with me, the programmer will be able to gain knowledge of Future Options trading.

Attached Image (click to enlarge)
Click to Enlarge Name: 2021-01-15_00h24_21.jpg Size: 198 KB
Practice makes a person perfect
  • #233
  • Jan 15, 2021 11:01pm Jan 15, 2021 11:01pm
Quoting simnz
I have been a customer of Interactive Brokers since 2004. I use Metatrader 4 for demo trading and seeking statistics through nformation indicators but actual trading is carried out on IB platform TWS Trader. I will be glad to guide if anyone with Excel skills want to develop Dashboard for Currency Future Options. I have a paper trading account that can be used to pull down the live data. An IB customer can use CME data only on live or paper trading account. By interacting with me, the programmer will be able to gain knowledge of Future Options trading....
Weekend Project taking shape using Excel RTD data, will post it after initial testing.
Attached Image (click to enlarge)
Click to Enlarge Name: d0d27dfd6d31c39169fbb06e9ab45c97.png Size: 44 KB
Trading is SIMPLE not EASY.
  • #234
  • Jan 16, 2021 3:56am Jan 16, 2021 3:56am
Quoting garfield75
{quote} Weekend Project taking shape using Excel RTD data, will post it after initial testing. {image}
Hi Garfield,

I just came back home a few hours ago.. I was planning on doing the MTF version of it tomorrow. I see you have already started.

I can work on it if you need me to. I may start tonight or tomorrow. No issue at all.

Cheers,
  • #235
  • Jan 16, 2021 4:26am Jan 16, 2021 4:26am
Quoting mtharwat
{quote} Hi Garfield, I just came back home a few hours ago.. I was planning on doing the MTF version of it tomorrow. I see you have already started. I can work on it if you need me to. I may start tonight or tomorrow. No issue at all. Cheers,
Hey Mtharwat,

Dont worry, I just finished it. Will test it on Monday to make sure it works properly and then post it here.
Attached Image (click to enlarge)
Click to Enlarge Name: d07dd426884be852245e2ac817a67d0b.png Size: 94 KB
Trading is SIMPLE not EASY.
  • #236
  • Jan 16, 2021 4:30am Jan 16, 2021 4:30am
Quoting garfield75
{quote} Weekend Project taking shape using Excel RTD data, will post it after initial testing. {image}
Hi garfiled75,

If you are looking to pull live data through RTD server and spreadsheet provided by Interactive Brokers, I will be happy to lend you my Paper Trading account with no fee charged since I am already paying for data subscription for the account.

At the moment I have two accounts with Interactive Brokers. I can spare one for your project with no obligation.
Practice makes a person perfect
  • #237
  • Jan 16, 2021 4:34am Jan 16, 2021 4:34am
Quoting simnz
{quote} Hi garfiled75, If you are looking to pull live data through RTD server and spreadsheet provided by Interactive Brokers, I will be happy to lend you my Paper Trading account with no fee charged since I am already paying for data subscription for the account. At the moment I have two accounts with Interactive Brokers. I can spare one for your project with no obligation.
Thanks Simnz for the offer. All good, I have IG and Pepperstone live accounts to get data.
Trading is SIMPLE not EASY.
  • #238
  • Jan 16, 2021 5:17am Jan 16, 2021 5:17am
Do you intend to do live trading?

or use data only for analysis?

Excel has limited trading models but unlimited formulas that a skillful Excer user can utilise to analyse the past data and derive patterns to be profitably employed for designing four important elements of profitable trading. Take Profit and Stop Loss level , Time to open trading, Time to exit.

Excel gives a rich formula language to create and measure relationships between data inputs and outputs.

After extracting data and regular patterns of profitable trading, Excel can be used for backtesting .
Having done both exercises, it is easy to put together a trading plan for every day.

Excel does not possess speed fast enough to do algo trading.

I never use any technical indicators or signal generators. For me it is purely discretionary trading. I have already described what I do presently using MT4 indicators though Excel tools will be far superior .

Above all, trading needs financial resources and the resilience to conduct practice for at least 7 years before you can see consistent profits coming to you as a passive source of income. Like any other business venture, seeds have to be planted early. If you are well prepared with financial resources, you will grow like a tree. If you lack any one of money or resilience, you will grow like a climbing plant .
Practice makes a person perfect
  • #239
  • Jan 17, 2021 4:50am Jan 17, 2021 4:50am
Quoting simnz
Do you intend to do live trading? or use data only for analysis? Excel has limited trading models but unlimited formulas that a skillful Excer user can utilise to analyse the past data and derive patterns to be profitably employed for designing four important elements of profitable trading. Take Profit and Stop Loss level , Time to open trading, Time to exit. Excel gives a rich formula language to create and measure relationships between data inputs and outputs. After extracting data and regular patterns of profitable trading, Excel can be used...
Quote "Excel does not possess speed fast enough to do algo trading."
I think it comes down to what the algo is designed to do. I can code to push through 1000 trades in less than a minute in excel, the blocker is MT4 account with max of 100 trades.
if the algo is monitoring the market to take around 5 trade in 1/5/15/30/60 minute TF excel RTD would easily handle that without any hicupp.
Trading is SIMPLE not EASY.
  • #240
  • Jan 17, 2021 5:46am Jan 17, 2021 5:46am
Quoting garfield75
{quote} Quote "Excel does not possess speed fast enough to do algo trading." I think it comes down to what the algo is designed to do. I can code to push through 1000 trades in less than a minute in excel, the blocker is MT4 account with max of 100 trades. if the algo is monitoring the market to take around 5 trade in 1/5/15/30/60 minute TF excel RTD would easily handle that without any hicupp.
Appreciate your finding. I have shared the experience of a trader who has used Excel previously.

I am told Speed has a lot to do with the location of the trading client and server closer to the liquidity provider location.

I would advise anyone not to get affected my sharing of experience and knowledge and focus on your pursuits rather than challenging other people's opinions or experiences.

I am sure RTD is providing speed . Otherwise, why would Interactive Broker provide their server API and spreadsheet?
Practice makes a person perfect
0 traders viewing now