MetaTrader and Excel

[aparsai]

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]

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]

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]

I think you can do better than that!

 

[aparsai]

I think you can do better than that!

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

 

[Magos]

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]

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]

Very useful indeed, thank you aparsai.

 

[aparsai]

Very useful indeed, thank you aparsai.

Thanks.

 

[Roddo]

Great Work

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]

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]

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]

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]

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

Roddo

 

[kenb]

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]

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]

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]

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]

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]

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