Streaming Data to Excel

Hello

I've been searching the net all night to try and find a way I can automatically stream MT4 history into an Excel sheet but have come up with nothing.

I mean it couldn't be that hard could it?

I know of a formula you can paste into an excel cell that will show the live Bid Ask High and Low but this isn't what I'm aiming for

What I want is to simlply import the data of a timieframe after it has closed (Open, High, low, Close, Volume) straight into Excel.

Doing this manually takes too much time.

Does anyone know if this can be done.?

Thanks

Better to stream it to a database, then you can use any front end to view the data.

Thanks for the reply - Forgive me but I have no clue what you're saying

Have you looked at the DDE example that comes with MT4? That does exactly what you need.

Try this thread...

http://www.forexfactory.com/showthread.php?t=26089

Lux

Thanx Lux I'll Take a Look

Thanks Lux but I think thath thread was just about getting the live price feed.

What I am after is for example my excel sheet is open and the 15m bar closes.

The results of that 15m bar show up in the MT4 history as OPEN HIGH LOW CLOSE and VOLUME data.

I then just want it to automatically export those results to my Excel spreadsheet... and then keep adding the new data as each bar closes.

Maybe I'm asking too much I'm not sure - But we can go to the moon so there must be a way.

Back to the drawing board

thanks

Please read visit this threat and post a reply. I will answer your question in 2-3 days.

http://www.forexfactory.com/showthread.php?t=176668