MT4 RSI indicator calculation question

I decided that i would try and calculate a bunch of stuff in excel based on EURUSD hourly closes to run some statistics based on tendencies of prices at different RSI levels. I used 14 previous closes in my calculation. I went back to my OANDA MT4 practice account to see what the indicator give me to make sure im comparing apples to apples and i found that the indicator that came with MT4 is giving me a different result.

To save some questions. I pulled the hourly history from Oandas feed of MT4
The calculation that i used in excel is RSI = 100- 100/(1+RS)

Below is an image of what is going on. Notice that the RSI doesnt match with the RSI from my excel sheet(the number calculated on the bottom right). It clearly hits 70 but on the MT4 feed the RSS never hits 70. Any advice? Maybe the indicator uses a different calculation based on the RSI calculation above?

http://i47.tinypic.com/25ppund.png

Anyone come up with anything? or is there a way to find out how MT4 calculates RSI so maybe i can work with that rather than the formula i was using?

Liquid11-
All the mql4 formulas can be found on mql4.com.

http://codebase.mql4.com/263

RSI = 100-(100/(1+U/D))
Where:
U — is the average number of positive price changes;
D — is the average number of negative price changes.

Thanks Cyber for your response. I went back and looked at my formula and unless i did something wrong, i should come up with the same number as MT4. If you find some time do you think you can take a look at my excel book to see why i come up with a different RSI then MT4? I attached a copy of my spread sheet.

How is the RSI on your chart setup ? I can see it is 14 periods but what applied price are you using ?

I have it applied to the closing price. That's what I used in excel too

Try Averaging the Gains and Losses dividing by n-1 (in this case 14-1=13 and add on the the last price diferrence