Coding Parabolic SAR indicator into Excel

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.

Skills: Anything Goes, Excel, Financial Markets, Metatrader, Visual Basic

See more: parabolic sar excel, parabolic sar excel download, calculate parabolic sar excel, forex sar indicator excel, parabolic sar indicator, parabolic sar download excel, excel sar, parabolic sar indicator download excel, parabolic sar excel spreadsheet download, download accuracy parabolic sar, parabolic sar, sar indicator, www excel, www coding com, oil pro, get coding, Excel pro, excel malaysia, excel parabolic sar, indicator sar excel

About the Employer:
( 10 reviews ) Bayan Lepas, Malaysia

Project ID: #2626821

Awarded to:


HI, I have read your project description and watched your video, I understand what you want. I can work for you. Thanks, trivietsales

$150 USD in 5 days
(45 Reviews)

2 freelancers are bidding on average $150 for this job


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 satis More

$150 USD in 15 days
(0 Reviews)