Not able to calculate Stoch RSI and MACD

This is a discussion on Not able to calculate Stoch RSI and MACD within the Indices forums, part of the Markets category; Hi everyone, I am new to this forum, but I follow it since a while. I am working on an ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Jul 26, 2017, 5:52pm   #1
 
2 Posts
Joined Jul 2017
Not able to calculate Stoch RSI and MACD

Hi everyone, I am new to this forum, but I follow it since a while.
I am working on an excel spreadsheet which updates automatically with the stock data of several companies.
Apart from that I am calculating some indicators such as RSI, SMAs, Stoch RSI and MACD.
I am having some issues when calculating Stoch RSI and MACD. I think I am using the right formulas, and I have compared the close and RSI values and they are right.

The formulas I am using are the following:

- Stoch RSI (14 days): (current RSI - Lowest RSI in 14 days) / (Highest RSI in 14 days - Lowest RSI in 14 days) * 100
- MACD: EMA 12 - EMA 26

To calculate the EMAs I use this formula:
- EMA x = (Current close - Previous EMA x)*(2/(x + 1)) + Previous EMA x

Here you are the link to the spreadsheet I am using to calculate this indicators for the stock BCBA:AGRO.
https://drive.google.com/open?id=0B5...WZMclNsbGcwYU0

The Stoch RSI and MACD do not match to the values I see in other platforms such as Trading View.

Could you please help me to solve this issues?

Thanks in advance!
fergerm is offline   Reply With Quote
Old Jul 26, 2017, 7:29pm   #2
 
cbrads's Avatar
Joined Mar 2014
What value do you use as the first input when there is no 'previous EMA' ?
cbrads is offline   Reply With Quote
Old Jul 26, 2017, 7:36pm   #3
 
2 Posts
Joined Jul 2017
fergerm started this thread
Quote:
Originally Posted by cbrads View Post
What value do you use as the first input when there is no 'previous EMA' ?
Hey cbrads, for the first EMA result I use the average of the x previous close prices.
fergerm is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
RSI Vs MACD Question Catterpie90 Technical Analysis 3 May 22, 2017 7:17pm
Critique my technique - MACD, RSI, S/R vvidiu Forex 0 Mar 20, 2014 4:28pm
Critique my technique - MACD, RSI, S/R vvidiu Technical Analysis 0 Mar 20, 2014 4:17pm
Using MACD, Stoc, and RSI all together. monkey180 General Trading Chat 40 Oct 27, 2011 4:32pm
Simple RSI/Stoch Combo Strat johnnyonspot Forex 0 Nov 21, 2008 9:59am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)