Hi guys,
I am trying to add OHLC chart to my excel sheet with some indicators (for now just EMA)
once I create an OHLC chart, everything works fine, chart gets updated on every refresh and looks just like on any forex trading platform. The problem is when I add EMA it draws the line perfectly but it considers the EMA line as closing price for the ohlc sticks. I am quiet there is a way to do this but I am not lucky with google.
can anyone help please?
http://imageshack.us/f/146/beforeema.png/
http://imageshack.us/f/696/afteraddingema.png/
[/img]