NO EXTERNAL LINKS, SOURCE CODE REQUESTS OR MODIFICATION OF DECOMPILED INDICATORS. To avoid post deletion please follow the rules.

Excel Live Trading Data

#1
Excel Live Trading Data from MT4

Hey everyone!

Been looking for a way to contribute to this wonderful site, but since I don't make indicators I thought I could add in another way. I've been working on a large project recently that I decided to take this from it and share with you. Its an overview of the Major/Minor market pairs so you can see pricing, spread, and current price distance from high to low. Possibilities are limitless. This was a tool I always wanted when I first started trading but could never find so I hope this is helpful for you, especially new traders.

Note that this excel sheet has NO VBA. All cells are unlocked so you can modify, expand, make it your own.

Be sure to enable DDE server in MT4 under options. Also, open MT4 first before you open the excel sheet. See below for help guide.
---
Screenshot.PNG
---
MT4 Market Data.xlsm
(71.86 KiB) Downloaded 206 times
---
Help Guide:

Open MT4 and open options (ctrl O)
MT4 Options.PNG

Click OK
Capture.PNG

Click Continue
Capture 2.PNG

Click Options at the bottom
Capture 3.PNG

Click Trust Center
Capture 4.PNG

Click appropriate boxes
Capture 5.PNG


Re: Excel Live Trading Data

#2
Lumios wrote:
Tue May 26, 2020 8:30 am
Hey everyone!

Been looking for a way to contribute to this wonderful site, but since I don't make indicators I thought I could add in another way. I've been working on a large project recently that I decided to take this from it and share with you. Its an overview of the Major/Minor market pairs so you can see pricing, spread, and current price distance from high to low. Possibilities are limitless. This was a tool I always wanted when I first started trading but could never find so I hope this is helpful for you, especially new traders.
...
Hi Lumios
This is excellent work and thank you very much for making this public. Something that I always wanted, so another thanks. :clap:
It worked seamlessly.

If you have plans to add something more, these are my request for version 2.0;

1. PIP value based on the account currency. (one lot of base currency, what's the pip value)
2. once you enter the margin requirement (say 1% or 2% or 5%) , can you also calculate the margin requirement for 1 lot? (or part of, say 0.1)?

Another technical question, if I run two brokers (two MT4 terminals).. how to get the excel to connect to my prefered DDE server?
in another context, run two excel sheets at the same time for comparison.

Cheers
thiru

Re: Excel Live Trading Data

#3
Exceptional post my friend. We love this. Stickied this thread! :clap:
Looking for a Forex broker that puts you first? FBS are offering $100 to get you started! Find out more, here.

Re: Excel Live Trading Data

#4
thiru wrote:
Tue May 26, 2020 11:01 am
Lumios wrote:
Tue May 26, 2020 8:30 am
Hey everyone!

Been looking for a way to contribute to this wonderful site, but since I don't make indicators I thought I could add in another way. I've been working on a large project recently that I decided to take this from it and share with you. Its an overview of the Major/Minor market pairs so you can see pricing, spread, and current price distance from high to low. Possibilities are limitless. This was a tool I always wanted when I first started trading but could never find so I hope this is helpful for you, especially new traders.
...
Hi Lumios
This is excellent work and thank you very much for making this public. Something that I always wanted, so another thanks. :clap:
It worked seamlessly.

If you have plans to add something more, these are my request for version 2.0;

1. PIP value based on the account currency. (one lot of base currency, what's the pip value)
2. once you enter the margin requirement (say 1% or 2% or 5%) , can you also calculate the margin requirement for 1 lot? (or part of, say 0.1)?

Another technical question, if I run two brokers (two MT4 terminals).. how to get the excel to connect to my prefered DDE server?
in another context, run two excel sheets at the same time for comparison.

Cheers
thiru
Thiru,

Actually have both pip and margin calculator in the "larger project" haha. Ill work on an update and repost soon.

Honestly not sure about that one, that would be on the backend communication between MT4 and Excel. A possible workaround could be to do a data export on both terminals with a script (a pair specifications script), then connect them to a spreadsheet via a CSV import. It would be static data, but you could at least compare. An automated EA that exports both information at set intervals could work too?

Re: Excel Live Trading Data

#5
Lumios wrote:
Tue May 26, 2020 1:07 pm
Thiru,
Honestly not sure about that one, that would be on the backend communication between MT4 and Excel. A possible workaround could be to do a data export on both terminals with a script (a pair specifications script), then connect them to a spreadsheet via a CSV import. It would be static data, but you could at least compare. An automated EA that exports both information at set intervals could work too?
Thanks Lumios, really looking forward to the updated version. :D

If we cant programmatically decide which MT4 to use, then something that comes to my mind is to use multiple VirtualBox VM's in seamless mode.
Since the objective is just for comparison, then run a VM with MT4 and Excel. Then by running the VM in the seamless mode we can compare them side by side. Just an idea. Will try to read more on DDE.


Re: Excel Live Trading Data

#6
thiru wrote:
Tue May 26, 2020 3:40 pm
Lumios wrote:
Tue May 26, 2020 1:07 pm
Thiru,
Honestly not sure about that one, that would be on the backend communication between MT4 and Excel. A possible workaround could be to do a data export on both terminals with a script (a pair specifications script), then connect them to a spreadsheet via a CSV import. It would be static data, but you could at least compare. An automated EA that exports both information at set intervals could work too?
Thanks Lumios, really looking forward to the updated version. :D

If we cant programmatically decide which MT4 to use, then something that comes to my mind is to use multiple VirtualBox VM's in seamless mode.
Since the objective is just for comparison, then run a VM with MT4 and Excel. Then by running the VM in the seamless mode we can compare them side by side. Just an idea. Will try to read more on DDE.
Second tab is the calculator. Make sure to type in your brokers margin requirements on the first tab, data provided was just for testing purposes. Let me know if errors.
Capture.PNG
MT4 Market Data 1.01.xlsm
(86.62 KiB) Downloaded 34 times

Re: Excel Live Trading Data

#9
Lumios wrote:
Fri May 29, 2020 6:14 am
Fixed an error and a typo.
thiru wrote:
Mon Jun 01, 2020 7:49 pm
I made some changes to the file and will post it.
Super! Thanks Lumios :clap:

Looking forward to the changes Thiru! Can you post them bro?
Looking for a Forex broker that puts you first? FBS are offering $100 to get you started! Find out more, here.


Attachments 28
  1. Similar Topics

    1. 4 Replies
      706 Views
    2. Trading system idea with excel

      5 Replies 756 Views

      by lucmat, Thu May 21, 2020 5:15 pm in Trading Systems

      5 Replies
      756 Views

Return to “MT4 Indicators”