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 [url removed, login to view]
I have also uploaded an Excel file that contains historical [url removed, login to view] 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 [url removed, login to view] 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.