MACD, Parabolic SAR, and Awesome Oscillator

I am still new to Mql and trying to get a hold of how the bars system work? I have a question about these indicators of MACD, Parabolic SAR, and Awesome Oscillator.

How do I tell when the last bar i.e. iBars[1] for the Parabolic SAR or MACD was red or green (above or below in case of Parabolic SAR)?

Also, does anyone know of a method or can anyone point me to a link of how I can export my data/executed trades into excel from MT4?

Thanks in advance for all your help.

Kindest Regards

SVM

if the value of psar is above the price of the candle then it is higher. Psar will return a value equal to the price the psar is at then.

awesome oscillator you will need to look at the previous two candles if the value of AO for [1] > than for [2] then ao is green

macd just depends on the version you are using. Do not use the one built into MT4 it is wrong.

as far as exporting trades and data, just write a script to export the values to a comma delimited file and then import into excel.

So I guess I can get the Awesome Oscillator like the following.

double AW_Oscillator=iAO(NULL, 0, 1) - iAO(NULL, 0, 2);

So if AW_Oscillator is > 0, its a positive candle. Otherwise its negative.

Similarly, for Parabolic SAR

if (iSAR(NULL,0,0.02,0.2,1)>Close[1]) then last Parabolic SAR was above the bars.

Is that right?


Also, which MACD should I be using if the one in MT 4 is wrong.

there are several good macd indicators out there. The one I use isn't available to give away, sorry.

And yes you are correct on the other things.