Creating Oscillator and RSI indicator in Excel.

Hi, I am trying to replicate/create an oscillator in excel with data I have. From online sources, I found that the calculation -of k% - is as: ((Recent close-Lowest of lows(14) )/(Highest Highs(14)- Lowest of lows(14)))*100

When I use this method on my data however, I am not getting the same values as in what I am seeing in MT5. I would like a professional to check the attached data, make changes, and then let the values match what I see in MT5. I have also put an example of the value I am getting and a screenshot of what I see in MT5 for GBPCAD as an example. My hope is that your experience with MQL5 program will enable you to read the source code of the MT5 oscillator well in order to implement with the excel data. 

Secondly, I want to be able to create an RSI on the same data. For the RSI, it was giving me completely different results. I have also shown part of the calculation i tried to do, giving the information i gathered online.

Note also that in the excel, recent records are at the top (which i do not think should make any difference anyway)

Thank you and I look forward to working with you.