Stream MT4 data into excel - Page 2

marcelcorzo · #11 (**permalink**) 09-04-2009, 05:27 AM

Sorry to bother you, two questions:
1. How can I differ between (for example) low of 1h, 15 m, 1m. etc.?
2. I get error with open and close.

To takechance: Help in Metatrader states that:
"Attention: History Data cannot be exported through DDE protocol. The current quotes are exported only when the client terminal is online."

takechance · #12 (**permalink**) 09-04-2009, 05:59 AM

Quote:

Originally Posted by takechance

well, using the =mt4|bid!eurusd command and enabling the dde function we can receive the data in real time.

But is it possible to retrieve the historical data (ohlc) plus the corresponding indicator (any) value also in a spreadsheet?

The history centre of mt4 will give us the ohlc and the volume figures on a daily chart. But is it possible to exclude the volume and replace it with any indicator of our choice?

Thanks.

any answer for my question?

marcelcorzo · #13 (**permalink**) 09-04-2009, 06:28 AM

Quote:

Originally Posted by takechance

any answer for my question?

I found this:
Untitled Page

there is a tickcollector to download , but it didn't work for me, it closes with error my excel application. Try it you, please.

In that site they sell an application that work with indicators. If anybody have try it, tell us how is it. I saw the video and it has interesting things, like sending orders from excel to Mt4, downloading economic reports, etc.

There will be anything like that on the web for free?

marcelcorzo · #14 (**permalink**) 09-04-2009, 06:51 AM

I also found this spreadsheet in forexbrace.com
Let's play with it. I'm gonna add a column to calculate spread.
I had to compress it because the attachments manager doesn't support xls files.

marcelcorzo · #15 (**permalink**) 09-10-2009, 04:56 AM

I made an excel sheet to spread analysis of various pairs.
I posted here:
Marcel managed accounts
Included some pairs and graphics.

If anybody have some excel sheets that could obtain more info or analysis, please attach here.

robert.neil · #16 (**permalink**) 11-12-2009, 07:31 PM

Here you can see added RSS feed into Excel just below the trading dashboard.
I follow the news from all over the net while using the dashboard to trade.

marcelcorzo · #17 (**permalink**) 11-13-2009, 01:14 AM

Quote:

Originally Posted by robert.neil

Here you can see added RSS feed into Excel just below the trading dashboard.
I follow the news from all over the net while using the dashboard to trade.

Is it a commercial or free worksheet? where did you get it?