Total Pageviews

Friday, May 29, 2015

How to create a Diverse Time Frame Chart : An Innovative Idea

Why  do one need  a "Diverse Time Frame"  ?

It is seen that for 'Elliot Wave Oscillator" to be studied properly , for high-low, number of candles in a chart should be in the range of 120-150 .

http://www.tradingfives.com/articles/elliott_oscillator.htm

For the instant case (UPL) from a low 101.55 (daily candle #267, date 13/11/12) to high 568.4 (daily candle #922, date 26/05/15) number of candles is found to be 655. From sourced (NSE) data , available since 24/10/2011, I decided to go for a  6 Days Cycle based on that.
   
The excel is being shared in group "Daily_Share" in Facebook platform :

Go to: (May consider "copy & paste in a browser" if it does not open here)

https://excel.office.live.com/x/ExcelView.aspx?FBsrc=https%3A%2F%2Fwww.facebook.com%2Fattachments%2Ffile_preview.php%3Fid%3D923353207710314%26time%3D1432954300%26metadata&access_token=1835286898%3AAVJnD-aryKilTCYqdi1HJyNmB5RJezY5Ng95Nlk6HIsAgQ&title=DS_UPL_TF_6DC.xlsxhttps://excel.office.live.com/x/ExcelView.aspx?

Step # 1 : First source OHLC data from any source ; copy relevant date in cells F,G, H , I (use function" Max")  ,J (use function" Min" ) & K from a set of data , e.g., 


Step # 2 : Write in formula for EMA_5 in Cell K in row 33, e.g.,


Step # 3 : Write in formula for EMA_34 in Cell L in row 207, e.g.,

Step # 4 : Write in formula for MACD  in Cell M in row 207, e.g.,


Step # 5 : Write in formula for MACD_Signal  in Cell N in row 231, e.g.


Step # 6 : Write in formula for MACD_Histogram  in Cell O in row 231, e.g.


Step # 7 :  Finally copy suitably full range inclusive BLANKS & paste to cover the full range of your Data Use excel to create your desired Chart , e.g., 

O(pen)H(igh)L(ow)C(lose)

Step # 8 :   Use excel to create your desired other Chart , e.g., 

MACD (5,34,5)


No comments:

Post a Comment