Exporting MT4 data to Excel | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Exporting data from Metatrader into Excel in real time 33 replies

Exporting indicators data in excel 8 replies

Simple way of exporting MT4 data from Data Window into Excel? 2 replies

Exporting data to Excel? 3 replies

Problems exporting price data to excel 3 replies

Attachments: Exporting MT4 data to Excel
Exit Attachments

Exporting MT4 data to Excel

  • #1
  • First Post: Jun 15, 2015 8:56am Jun 15, 2015 8:56am
Does anyone who know how to export Mt4 data to excel please help me to do that?
  • #2
  • Jun 15, 2015 9:13am Jun 15, 2015 9:13am
if possible could you please share your source? I would like to do analyze on data, but I cannot export data from Mt4, I try to search on the internet but I still cannot find out that
  • #3
  • Jun 18, 2015 9:35am Jun 18, 2015 9:35am
Quoting richer
if possible could you please share your source? I would like to do analyze on data, but I cannot export data from Mt4, I try to search on the internet but I still cannot find out that
You can receive prices in excel using formulas:

  1. To get bid ='MT4'|BID!EURUSD
  2. To get ask ='MT4'|ASK!EURUSD

For file operations kindly study http://book.mql4.com/functions/files

Jibala

PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #4
  • Jun 19, 2015 3:56pm Jun 19, 2015 3:56pm
hey guys if you import data into excel, can you then separate the bull candles data from the bears data? what i'm wanting to do is average Only the bull candles tick volume and compare to an average of only the bear candles tick volume? when they cross that would give a direction change signal and also whatever is larger would indicator the current direction on that time frame.... is there any way this is possible?
  • #5
  • Jun 19, 2015 6:55pm Jun 19, 2015 6:55pm
hi all, I'm also looking to exporting mt4 data into excel. Ideally, I am looking to download at one go quotes for several currencies at

0700 gmt
2200 gmt
High within that time range
Low within that time range

How can I do this?
  • #6
  • Jun 19, 2015 9:44pm Jun 19, 2015 9:44pm
Quoting dagoods
hey guys if you import data into excel, can you then separate the bull candles data from the bears data? what i'm wanting to do is average Only the bull candles tick volume and compare to an average of only the bear candles tick volume? when they cross that would give a direction change signal and also whatever is larger would indicator the current direction on that time frame.... is there any way this is possible?
This is how it might look like after import from csv to M$ Excel:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.06.20_10h27m59s_001_.png Size: 51 KB

You now must compare each close to its prior close! To not end up in endless work you should write some vba code.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #7
  • Jun 20, 2015 1:35am Jun 20, 2015 1:35am
Quoting dagoods
hey guys if you import data into excel, can you then separate the bull candles data from the bears data? what i'm wanting to do is average Only the bull candles tick volume and compare to an average of only the bear candles tick volume? when they cross that would give a direction change signal and also whatever is larger would indicator the current direction on that time frame.... is there any way this is possible?
http://www.forexfactory.com/showthre...08#post8251008

If you don't need live data and can export mt4 history, just work on this.
  • #8
  • Last Post: May 24, 2016 10:16am May 24, 2016 10:16am
Quoting JibalaPasan
{quote} This is how it might look like after import from csv to M$ Excel: {image} You now must compare each close to its prior close! To not end up in endless work you should write some vba code. Jibala
Hi JibalaPasan,


The data set and its format are exactly what i am looking for as i need a series of price with different date to do some statistical tests.

Do you mind to share the spreadsheet or show me how to pull them out from MT4?

Thank you.
0 traders viewing now