MetaTrader and Excel

aparsai · Apr 15, 2009

I have developed an Excel workbook that if you enable DDE server provides you with live information about Bid, Ask, and Pip Dollar value of of 15 currency pairs.

Visit Free Forex MQL Training - Live Data Feed to Excel via MetaTrader 4 to watch a video about this spreadsheet and download a copy.

Your comments are welcome.

wrm · Apr 21, 2009

I once wrote an EA that updates price for any number of currency pairs. The price is stored in the MySQL or PostgreSQL database.

But i like your idea too. Good work.

aparsai · Apr 21, 2009

wrm said:
I once wrote an EA that updates price for any number of currency pairs. The price is stored in the MySQL or PostgreSQL database.

But i like your idea too. Good work.

Thanks buddy.

Magos · Apr 30, 2009

I think you can do better than that!

aparsai · Apr 30, 2009

Magos said:
I think you can do better than that!

Thanks for the feedback. Is there anything specific that you have in mind?

Magos · May 1, 2009

aparsai said:
Thanks for the feedback. Is there anything specific that you have in mind?

what about VB and Excel together to monitor risk ratios! correlations and also exposure of your portfolio

aparsai · May 1, 2009

Magos said:
what about VB and Excel together to monitor risk ratios! correlations and also exposure of your portfolio

This is something that I'm currently working on. I'll update you about it if I manage to offer something more sophisticated.

AcuteAngle · May 3, 2009

Very useful indeed, thank you aparsai.

aparsai · May 4, 2009

AcuteAngle said:
Very useful indeed, thank you aparsai.

Thanks.

Roddo · May 31, 2009

Great Work

aparsai said:
Thanks.

I have a spread sheet open when trading to add data as it happens, your spread sheet really helps.... What other info can be added from MT4... I am thinking account balance would be handy...

Also is there a list of tags that can be used.

Regards
Rod

aparsai · May 31, 2009

Roddo said:
I have a spread sheet open when trading to add data as it happens, your spread sheet really helps.... What other info can be added from MT4... I am thinking account balance would be handy...

Also is there a list of tags that can be used.

Regards
Rod

Hi Rod

As far as I know you cannot add account balance with this method to your spreadsheet.

ExpertTradingAdvisor · Jun 17, 2009

For some reason my DDE server does not want to work. I have it enabled in the tools/options, but it doesn't update the spread sheet.

soniabvc · Jun 18, 2009

There is a way to integrate Excel into MT4 so that you can open positions and market orders directly from excel and have MT4 indicators update LIVE in your spreadsheet.

Roddo · Jul 24, 2009

Thanks soniabvc I tried that url and nothing came up (I replaced * with .) Do you have a working link

Roddo

kenb · Jul 24, 2009

Can anybody help me with an excel spreadsheet that I can log trades produced on a metatrader platform.?
I need to be able to log :
Profit/loss
date
cumulative total.
I would like the spreadsheet to produce a chart showing equity if possible.
I am really hopeless with computers so any help would be really gratefully received!
Ken.

fxalgotrader · Aug 25, 2009

Hi guys,

I took the Excel/Metatrader a few stages further and developed an Excel dashboard which can control custom indicators and EAs in MT4. The excel dashboard provides very granular control over any indicator or EA and is also very quick to modify the underlying parameters.

Essentially the Excel files have a load of embedded macros which write parameters to external files which are read by an underlying *.ex4 handler EA. This then calls external functions to control the various custom indicators and autotrade modules.

The real coup with this approach is it allows a trader to run any number of EAs and indicators on one chart - so you could have automated trendline trading, statisitical arbitrage, news spike auto detection, automated economic news release detection and display, Daily, weekly and Monthly pivots, historical pivots. Price/Proximity audible alerts (configurable) etc etc. I would like to include a risk management module which could allow precision control over max risk per trade etc.

If anyone would like to look at this in more detail. Check FX Algotrader - FX Trading Tools or email me [email protected]

I can do custom code work too if anyone wants it.

Hope the Excel route may be of interest to people.

aparsai · Aug 25, 2009

fxalgotrader said:
Hi guys,

I took the Excel/Metatrader a few stages further and developed an Excel dashboard which can control custom indicators and EAs in MT4. The excel dashboard provides very granular control over any indicator or EA and is also very quick to modify the underlying parameters.

Essentially the Excel files have a load of embedded macros which write parameters to external files which are read by an underlying *.ex4 handler EA. This then calls external functions to control the various custom indicators and autotrade modules.

The real coup with this approach is it allows a trader to run any number of EAs and indicators on one chart - so you could have automated trendline trading, statisitical arbitrage, news spike auto detection, automated economic news release detection and display, Daily, weekly and Monthly pivots, historical pivots. Price/Proximity audible alerts (configurable) etc etc. I would like to include a risk management module which could allow precision control over max risk per trade etc.

If anyone would like to look at this in more detail. Check FX Algotrader - FX Trading Tools or email me [email protected]

I can do custom code work too if anyone wants it.

Hope the Excel route may be of interest to people.

Quite interesting.

forexrookie · Dec 1, 2009

MQL4 or Excel for building strategies

Hi,

I am a newbie on the FX market and my broker offers the widely popular Meta Trader platform. Now I have come to understand that building your own strategies is the preferred way to go - as opposed to using Expert Advisers created by someone else. However learning MQL4 (Meta Trader 4 programming language) from scratch is not exactly my cup of tea. There are add-in solutions for Meta Trader 4 that allow the trader to use excel (I feel more comfy in Excel) to build strategies.

I wonder however whether an excel based solution for building strategies is as effective?

duderotiy · Dec 20, 2009

Effective?!

Excel is far more flexible and sophisticated strategy builder than any EA can ever be. Too bad you need plenty of $$$ to have access to one. But you are on the right path Jedi

aj2121 · Jan 10, 2010

Its very good keep it up and try to upgrade ur work time to time.

MetaTrader and Excel

Junior member

Junior member

Junior member

Established member

Junior member

Established member

Junior member

Junior member

Junior member

Newbie

Junior member

Junior member

Newbie

Newbie

Junior member

Newbie

Junior member

Newbie

Newbie

Newbie

Similar threads