Basically, I'd like to have the spreadsheet that can calculate whether we should go Long or Short, based on the Parabolic SAR. In MT4, it's pretty straight forward. If the dash lines appear below price, that means Long. Conversely, if the dash lines appear above the price bars, it means we can go Short.
So I'd like to be able to have the capability to do it on Excel, too. Note that I'm not planning to import any of the MT4 data (price or Parabolic SAR values) into the Excel spreadsheet. It's going to be standalone - the Parabolic SAR computations are to be done based on OHLC (Open/High/Low/Close) data that are to be manually keyed into the spreadsheet.
To make sure that we're on the same page as far as data verification is concerned, we will use EUR/USD Daily on FX Pro MT4.
First, I made a short video where I explained a bit about the project. You can get the video at [login to view URL]
I have also uploaded an Excel file that contains historical [login to view URL] O/H/L/C data which I had pulled from FX Pro. It goes all the way back to 2005 - but for this purpose, we can just focus on the more recent 2012 data. You can put the coding in this file and compare your results with those from FX Pro.
If you don't have FX Pro MT4, I have also uploaded the setup file - alternatively, you could also download from FX Pro website at [login to view URL] if you so wish.
The idea to use FX Pro is so that we both would have a common platform to check and verify the accuracy of the Excel coding. My plan is actually to use this for Crude Palm Oil Futures market, but since you may not have the price information (it's only traded in Malaysia), we'll just have to use the FOREX data, which is freely available to everyone & everywhere.
Hi
Iam an excel expert with commerce background and hence understood your project very well. I have developed many applications using excel vba and forms feature to automate various function.
I assure to full satisfaction to the solution i develop and continuous support any time even after the development is complete.
G