Here's a spreadsheet that I developed a while back for doing the same thing. It is everything you want plus many more handy features. Any questions just let me know.

Cheers,
Hiachiever

Attached Files

ForexTradeManager.zip (255.0 KB, 243 views)

Well, Excel is a damn good application from Microsoft Office.

But how much cost? near 600 USD.

Don't worry almost every spreadsheet made with excel and for excel could run with other very good products as Open Office or Star Office, just to mention two. Both have none cost. Open Office is a free project and Star Office is free now thanks to Google.

This picture is from StarCalc running a spreadsheet with DDE embedded.

Attached Images

ddestar.jpg (170.9 KB, 504 views)

__________________

Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum

Just found one website with a lot of everything for excel Index of /Excel

Hi,

I've been trying to get the parabolic sar to work using TA_LIB.
It always returns an N/A for the first range of prices (Lows) so does not work. Any idea how to fix this?

Thanks

Hi everyone,

This is my first post. Through this terrific forum I have managed to export some information from MT4 into excel. However, I can't find how to export specific data - for example I would like the Highs, Lows and Closes for different time periods to autocalculate pivots. It's the specifying time frame I can't find.

Once it's sorted if anyone's interested I'll happily post my spreadsheet which has conditionally formatted cells which change colour as key levels approach - probably very simple for you all!

Any ideas?

Many thanks,

Dave

Easy, just go to the history center and click into the period you want to export.

In the picture below I've selected EURUSD H1. then export as CSV. Repeat the process for every pair.

The just import into you spreadsheet. By using HLC of h1 you would have hourly pivots, using HLC of h4 you would have h4 hourly pivots.

Now if you want to calculate pivots in real time for let´s say hourlies you need to use DDE function. For more info see: Help (F1) -- Tools -- Export quotes.

Attached Images

2008-04-10_002704.jpg (40.2 KB, 317 views)

__________________

Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum

With all of the conversation on backtesting and forward testing has anyone put together an Excel spreadsheet that compares new, forward trades with older ones or backtest results to determine if the new trades are falling within reasonable bounds? We have a fair amount of backtest results and a few weeks of forward testing that seems to match but, how can we measure how accurate these new results are compared to the others?
Thanks for any help or direction
DeadEye96

Many thanks for this. Right I can now import the required manually!

However, I'm struggling with automatically importing the data. I can import (via DDE) current price, and I've read what the MT4 help file says, but there's nothing about importing a close price automatically on the completion of a candle. Nor is there anything about specifying the High Low period, it just mentions the TIME function is something that you can use.

Really appreciate the help.

Dave

Try the script and the excel . It is currently setup for Interbank FX. Run the script. Have the Interbank MT4 open before opening the Excel(extract the excel straight into th C: drive and open it from there no folder or subfolders). Click the Update button H1 and D1 and you are on your way. Don't think the import of csv files can be fully automated.

Attached Files

	D_H_QuoteToExcel_MultiPair.mq4 (5.2 KB, 52 views)
	EXCELcsv.zip (21.7 KB, 74 views)

Great thanks. Looks like I'm getting closer and closer. Forgive my stupidity, but I run the script in Metaeditor, compile it, save it in the Indicators folder but then it doesn't appear. I'm pretty new at this, any help very much appreciated.

Dave