tag:blogger.com,1999:blog-85374109649446414752016-12-16T16:08:47.701+05:30How to do RSI Calculation in ExcelStep by step method to calculate RSI for Nifty illustrated in excel with dataPinoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8537410964944641475.post-14365372205228686742009-04-29T00:15:00.004+05:302009-04-29T01:18:24.682+05:30Calculating RSI 2 in excelOkay so here's a post on RSI on request left by an anonymous user in comments to my post on RSI calculation. He was facing an issue with the calculation of RSI 2. First What is RSI 2 ? In normal RSI (Wilder's RSI) we use data from past 14 days to calculate RSI. In RSI 2 we use just the data for past 2 days to calculate RSI. So now the issue is with the computation of RSI 2 in Excel. The Average <img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/mhk58RpZOgw" height="1" width="1" alt=""/>Pinoreply@blogger.com10http://niftyrsi.blogspot.com/2009/04/rsi-2.htmltag:blogger.com,1999:blog-8537410964944641475.post-76567388177446441082009-04-17T01:55:00.003+05:302009-04-17T08:37:59.025+05:30Dow Jones RSI Calculation in ExcelI have done the RSI calculation for Dow Jones in excel so that any anyone can see and learn from it how to calculate RSI in excel for any stock or indice. You can download the excel spreadsheet from here<img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/N8PgyFpt5SM" height="1" width="1" alt=""/>pinoreply@blogger.com3http://niftyrsi.blogspot.com/2009/04/dow-jones-rsi-calculation-in-excel.htmltag:blogger.com,1999:blog-8537410964944641475.post-26868322698266048722009-03-31T23:30:00.002+05:302009-04-14T08:13:34.952+05:30Nifty RSI Calculation in excelHere's an example of RSI calculation done in excel spreadsheet with real life data of Nifty index. You can download that from here - http://www.ziddu.com/download/3972372/NiftyRSICalculation.xls.htmIn fact you can understand from the excel sheet how exactly to compute RSI and then you can apply the formulas to data of any stock or indices. Remember each value of RSI takes in an unlimited number <img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/oDse6QIAhAw" height="1" width="1" alt=""/>Pinoreply@blogger.com0http://niftyrsi.blogspot.com/2009/03/nifty-rsi-calculation-in-excel.htmltag:blogger.com,1999:blog-8537410964944641475.post-21089260806627586632009-03-29T23:35:00.007+05:302009-04-11T18:42:29.225+05:30RSI CalculationI guess many of you have come here searching for how to calculate RSI. Given below is the process of how to calculate RSI for any stock or index.1. First calculate average gain & average loss of past 14 daysAverage Gain = [(previous Average Gain) x 13 + current Gain] / 14Average Loss = [(previous Average Loss) x 13 + current Loss] / 14First Average Gain = Total of Gains during past 14 periods / <img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/K59YzsZ9x4Y" height="1" width="1" alt=""/>Pinoreply@blogger.com0http://niftyrsi.blogspot.com/2009/03/nifty-rsi-calculation.htmltag:blogger.com,1999:blog-8537410964944641475.post-79220474181673876072009-03-25T09:23:00.001+05:302009-04-09T14:20:42.283+05:30How much data should I have to accurately calculate RSI ?How much data should I have to accurately calculate RSI ?That's a valid question. Because, in theory, the RSI value for any day takes into account all the previous values before it, therefore incorporating in it even the effect of the earliest available value. This happens in a EMA based system. Ofcourse the effects of previous data points keeps on getting diminished as one moves forward in time.<img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/nhJBPZLo2-4" height="1" width="1" alt=""/>Pinoreply@blogger.com0http://niftyrsi.blogspot.com/2009/03/how-much-data-should-i-have-to.htmltag:blogger.com,1999:blog-8537410964944641475.post-46274623913075466412009-03-24T13:50:00.000+05:302009-04-14T21:17:43.210+05:30Nifty historical chart from 1990 to 2009For those of you looking for Nifty chart from as far back as possible - here it is.First is the chart on normal scale -Next is the same chart, but this time on log scale -You can download the files from these links -http://www.ziddu.com/download/4014920/niftydailychartsince1990normalscale.jpg.htmlhttp://www.ziddu.com/download/4014984/niftydailychartsince1990logscale.jpg.html<img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/aJ2C781VEuk" height="1" width="1" alt=""/>Pinoreply@blogger.com0http://niftyrsi.blogspot.com/2009/03/nifty-chart-from-1990-to-2009.htmltag:blogger.com,1999:blog-8537410964944641475.post-79234402904511323962009-03-24T08:56:00.003+05:302009-04-09T14:29:13.370+05:30Where can I find historical price data of Nifty and Indian stocks?Right here is the answer !!!!I know I spent a lot of time trying to find data so that I could do various technical analysis calculation and see how things were and also to form charts & have a look. I mean I was looking for data for a long period, not just past 2-3 years. Then i could see how markets have moved over various time and market cycles.The excel sheet below has data on Nifty since 1990<img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/AsgNC_KlL6U" height="1" width="1" alt=""/>Pinoreply@blogger.com0http://niftyrsi.blogspot.com/2009/03/where-can-i-get-price-data-on-nifty-and.htmltag:blogger.com,1999:blog-8537410964944641475.post-20100647742035555752009-03-20T04:07:00.000+05:302009-04-09T14:30:08.615+05:30Nifty/Sensex data before 1990?So you've got data since 1990. But what about data from before that period. How does one get hold of that data ? From where ? You might be interested to know more of Indian markets historical price movements, or do calculations or technical studies on longer periods. Well, I have both good news & bad news. Bad news first - Nifty data is not available before 1990, simply because it didnt exist. <img src="http://feeds.feedburner.com/~r/blogspot/Gxiw/~4/yepr6MMWeeI" height="1" width="1" alt=""/>Pinoreply@blogger.com5http://niftyrsi.blogspot.com/2009/03/niftysensex-data-before-1990.html