Excel Indicators (History to Excel)

New excel tool display live market data from MT4.

Inside this spreadsheet contain 9 tables :

1) Dashboard
2) DDE Live Data
3) Data Feed
4) Pip Values
5) Margin Requirements
6) Pip Calculator
7) Market Range
8) ADR(30)
9) World Timezone

Remember to enable DDE server in MT4 in order for the excel to work properly and enable excel to accept external update.

Some pictures of the excel tool

Live positions to csv - script for MetaTrader 5

The script creates a csv file ' File name ' in the 'Common Data Folder' and records information on positions. In the script parameters, you can choose which columns to write

Live positions to csv - script for MetaTrader 5

The script creates a csv file ' File name ' in the 'Common Data Folder' and records information on positions. In the script parameters, you can choose which columns to write

Introduction
Spreadsheets are a fairly old invention. Modern programs of this type have tremendous power and allow you to visually analyze data presented in tabular form. The analysis can be done from different angles and is performed quite quickly. It includes graphs, summary tables, what-if analysis, conditional cell formatting and much more.

I suggest testing some of this power to analyze custom strategies.

Personally, I use LibreOffice Calc because it is free and it works wherever I work :-) However, the same approach works for other spreadsheets: Microsoft Excel, Google Sheets, etc. Currently, they all allow converting into each other and feature the same principles of constructing equations.

So, I assume, you have some kind of spreadsheet program. You also have data in a text file format (*.txt or *.csv) you want to analyze. The article briefly describes how to import such files. I will use history from MetaTrader terminal, however, any other data will do, like Dukascopy or Finam. Obviously, you should have a strategy to configure signals. This is all that is required to apply article propositions in trading.
I hope, the article will be useful to different categories of traders, so I will try to write it so that it is understandable even for people who have never seen programs of this type before. At the same time, it will cover a range of issues even some experienced traders are not familiar with.

Read more...

OHLC and indicators to CSV Panel 2 - expert for MetaTrader 5

Saving OHLC bar values and the specified buffer of the selected indicator to a csv file