CultureMusicSportsFood&DrinkEntertainmentLifeHomesNewsWeatherShoppingJobsCarsHowtoMakeRSIinExcelSmallBusiness|Accounting&Bookkeeping|ExcelByScottShpakAccountingforanESOPHowtoKeepTrackofSalesforaSoleProprietorshipHowtoSetUpaDailyScheduleinExcelHowtoConvertaDatetoaMonth&YearHowtoIncrementtheMonthinanExcelSpreadsheetTheRelativeStrengthIndexisacalculationthatmeasuresoscillationsinthevalueofastockoveraperiodoftime.Publishedin1978,theRSIwasdevelopedbytechnicalanalystJ.WellesWilderJr.andlooksatastretchof14cycles,comparingaveragegainsandaveragelossestoestablisharatingforagivenstock.UsingaspreadsheetinExcelreducescalculatingRSItoasimplematterofenteringgainandlossdatadaily.1OpenanewspreadsheetinExcel.TitlethecolumnsA1toI1withtheseheaders:"Date,""Close,""Change,""Gain,""Loss,""AvgGain,""AvgLoss,""RS"and"RSI."Formatthecolumns"Loss"andAvgLoss"sothatthefontisred.2EnterthefirstdayofdataincellA2.IncellA3,entertheformula"=A2+1."AssumingthedateinA2isaMonday,copyandpastethisformulafromcellA4toA6.IncellA7,entertheformula"=A6+3"toaccountforweekendclosings.CopytherangeofcellsA3toA6andpastethisrangestartingatcellA8.CopytherangeofcellsA7toA11andpastethisrangestartingatcellA12andthenbelowforasmanyweeksasyouwishtotrack.3Entertheformula"=B3-B2"incellC3.CopycellC3andpasteitintherangeofcellsbeginningatC4andextendingtotheendofthedates.Thiscalculatesthedailychangeinclosingprice.4Entertheformula"=IF(C3<=0,0,C3)"incellD3andtheformula"=IF(C3>=0,0,-C3)"incellE3.CopytherangeofcellsD3andE3togetherandpasteintherangefromcellD4totheendofthedates.Theseformulascalculateandsegregategainsandlosses.5Entertheformula"=(SUM(D3:D16)/14)"incellF16.CopyitandpasteitincellG16.Entertheformula"=((F16*13)+D17)/14"incellF17.CopyitandpasteitincellG17.CopytherangeofcellsF17andG17togetherandpasteintherangefromcellF18totheendofthedates.Theseformulascalculatethe14-dayaveragegainsandlosses.6Entertheformula"=F16/G16"incellH16.CopycellH16andpasteintherangefromH17totheendofthedates.Thisformulacalculatestherelativestrengthofthestoc