RSI caluculation

[724965ds]

I calculated RSI(14 SMMA) with a spread sheets.

But this RSI is different from the MT4 default indicator RSI(J.W.wilder).

RSI calculation is as follows.

Any help would be appreciated.

table.tableizer-table { font-size: 12px; border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC; } .tableizer-table th { background-color: #104E8B; color: #FFF; font-weight: bold; }

date(weekly)	close USD/JPY	RSI(14 SMMA)	up	down	up SMA	down SMA	up SMMA	down SMMA
2011/01/02	83.02
2011/01/09	82.97		0	0.05
2011/01/16	82.55		0	0.42
2011/01/23	82.12		0	0.43
2011/01/30	82.18		0.06	0
2011/02/06	83.44		1.26	0
2011/02/13	83.09		0	0.35
2011/02/20	81.64		0	1.45
2011/02/27	82.3		0.66	0
2011/03/06	81.88		0	0.42
2011/03/13	80.75		0	1.13
2011/03/20	81.47		0.72	0
2011/03/27	84.09		2.62	0
2011/04/03	84.83		0.74	0
2011/04/10	83.08	50.2	0	1.75	0.4329	0.4286	0.4329	0.4286
2011/04/17	81.9	45.5	0	1.18	0.4329	0.5093	0.4019	0.4822
2011/04/24	81.11	43.2	0	0.79	0.4329	0.5357	0.4019	0.5293
2011/05/01	80.54	42.8	0	0.57	0.4329	0.5457	0.4019	0.5382
2011/05/08	80.76	45.2	0.22	0	0.4443	0.5457	0.4177	0.5067
2011/05/15	81.67	48.5	0.91	0	0.4193	0.5457	0.4776	0.5067
2011/05/22	80.78	40.6	0	0.89	0.4193	0.5843	0.3893	0.5703
2011/05/29	80.27	40.2	0	0.51	0.4193	0.5171	0.3893	0.5790
2011/06/05	80.31	45	0.04	0	0.3750	0.5171	0.3922	0.4802
2011/06/12	80.02	41	0	0.29	0.3750	0.5079	0.3482	0.5009
2011/06/19	80.42	44.4	0.4	0	0.4036	0.4271	0.3768	0.4716
2011/06/26	80.81	50.4	0.39	0	0.3800	0.4271	0.4026	0.3966
2011/07/03	80.61	46.2	0	0.2	0.1929	0.4414	0.3529	0.4109
2011/07/10	79.12	25.8	0	1.49	0.1400	0.5479	0.1791	0.5163
2011/07/17	78.53	19.1	0	0.59	0.1400	0.4650	0.1300	0.5509
2011/07/24	76.77	18.9	0	1.76	0.1400	0.5064	0.1300	0.5575
2011/07/31	78.39	34.3	1.62	0	0.2557	0.4500	0.2457	0.4703
2011/08/07	76.7	30.6	0	1.69	0.2557	0.5300	0.2374	0.5386
2011/08/14	76.53	32	0	0.17	0.2400	0.5421	0.2374	0.5043
2011/08/21	76.66	31.6	0.13	0	0.1843	0.5421	0.2321	0.5034
2011/08/28	76.8	26.5	0.14	0	0.1943	0.4786	0.1811	0.5034
2011/09/04	77.58	34.7	0.78	0	0.2500	0.4421	0.2361	0.4444
2011/09/11	76.77	33.1	0	0.81	0.2471	0.5000	0.2321	0.4684
2011/09/18	76.59	32.5	0	0.18	0.2471	0.4921	0.2295	0.4771
2011/09/25	77.05	36.5	0.46	0	0.2514	0.4921	0.2623	0.4570
2011/10/02	76.71	32.7	0	0.34	0.2236	0.5164	0.2335	0.4813
2011/10/09	77.19	33.5	0.48	0	0.2579	0.5021	0.2419	0.4795
2011/10/16	76.27	31	0	0.92	0.2579	0.4614	0.2394	0.5320
2011/10/23	75.8	34.1	0	0.47	0.2579	0.4529	0.2394	0.4620
2011/10/30	78.22	49.5	2.42	0	0.4307	0.3271	0.4123	0.4205
2011/11/06	77.1	51	0	1.12	0.3150	0.4071	0.3999	0.3838
2011/11/13	76.86	42.5	0	0.24	0.3150	0.3036	0.2925	0.3952
2011/11/20	77.7	55.6	0.84	0	0.3750	0.2914	0.3525	0.2819
2011/11/27	77.96	57.5	0.26	0	0.3843	0.2914	0.3668	0.2706
2011/12/04	77.59	54.6	0	0.37	0.3743	0.3179	0.3568	0.2970
2011/12/11	77.75	54.9	0.16	0	0.3300	0.3179	0.3590	0.2952
2011/12/18	78.06	52.7	0.31	0	0.3521	0.2600	0.3286	0.2952
2011/12/25	76.86	50	0	1.2	0.3521	0.3329	0.3270	0.3271
2012/01/01	76.95	51.9	0.09	0	0.3257	0.3329	0.3334	0.3091
2012/01/08	76.95	49.5	0	0	0.3257	0.3086	0.3024	0.3091
2012/01/15	77.01	51.7	0.06	0	0.2957	0.3086	0.3067	0.2865
2012/01/22	76.66	46.8	0	0.35	0.2957	0.2679	0.2746	0.3115
2012/01/29	76.58	51.9	0	0.08	0.2957	0.2400	0.2746	0.2544
2012/02/05	77.59	60.9	1.01	0	0.1950	0.2400	0.3467	0.2229
2012/02/12	79.54	59	1.95	0	0.3343	0.1600	0.3204	0.2229
2012/02/19	81.19	74.2	1.65	0	0.4521	0.1429	0.4283	0.1486
2012/02/26	81.79	77.7	0.6	0	0.4350	0.1429	0.4627	0.1327
2012/03/04	82.46	77.3	0.67	0	0.4643	0.1429	0.4518	0.1327
2012/03/11	83.43	79	0.97	0	0.5336	0.1164	0.5004	0.1327
2012/03/18	82.32	72.6	0	1.11	0.5221	0.1957	0.4955	0.1874
2012/03/25	82.86	74.2	0.54	0	0.5386	0.1957	0.5234	0.1817
2012/04/01	81.63	65	0	1.23	0.5386	0.1979	0.5001	0.2696
2012/04/08	80.9	68	0	0.73	0.5321	0.2500	0.5001	0.2359
2012/04/15	81.5	69.8	0.6	0	0.5750	0.2500	0.5370	0.2321
2012/04/22	80.26	62.5	0	1.24	0.5707	0.3386	0.5339	0.3207
2012/04/29	79.84	60.6	0	0.42	0.5707	0.3436	0.5299	0.3444
2012/05/06	79.93	62.7	0.09	0	0.5771	0.3379	0.5364	0.3190
2012/05/13	79.01	58.5	0	0.92	0.5050	0.4036	0.5359	0.3794
2012/05/20	79.68	58	0.67	0	0.4136	0.4036	0.5168	0.3747
2012/05/27	78	43.7	0	1.68	0.2957	0.5236	0.3840	0.4947
2012/06/03	79.47	43.8	1.47	0	0.3579	0.5236	0.3796	0.4862
2012/06/10	78.7	38	0	0.77	0.3100	0.5786	0.3323	0.5412
2012/06/17	80.42	43.3	1.72	0	0.3636	0.5786	0.4107	0.5372
2012/06/24	79.78	36.7	0	0.64	0.3636	0.5450	0.3376	0.5830
2012/07/01	79.65	39.6	0	0.13	0.3250	0.5543	0.3376	0.5154
2012/07/08	79.17	35.5	0	0.48	0.3250	0.5007	0.3018	0.5490
2012/07/15	78.48	37	0	0.69	0.3250	0.4979	0.3018	0.5142
2012/07/22	78.45	39.4	0	0.03	0.2821	0.5000	0.3018	0.4644
2012/07/29	78.47	36.2	0.02	0	0.2836	0.4114	0.2634	0.4643
2012/08/05	78.26	39.9	0	0.21	0.2836	0.3964	0.2633	0.3970
2012/08/12	79.56	49.2	1.3	0	0.3700	0.3964	0.3562	0.3681
2012/08/19	78.67	44.3	0	0.89	0.3700	0.3943	0.3436	0.4317
2012/08/26	78.38	47	0	0.29	0.3221	0.4150	0.3436	0.3868
2012/09/02	78.24	43.1	0	0.14	0.3221	0.3050	0.2991	0.3954
2012/09/09	78.38	52.2	0.14	0	0.2271	0.3050	0.3091	0.2832
2012/09/16	78.13	41.2	0	0.25	0.2271	0.2679	0.2109	0.3011
2012/09/23	77.9	44.3	0	0.23	0.1043	0.2843	0.2109	0.2652
2012/09/30	78.66	36.4	0.76	0	0.1586	0.2386	0.1511	0.2640
2012/10/07	78.44	38.3	0	0.22	0.1586	0.2450	0.1472	0.2372
2012/10/14	79.29	47.8	0.85	0	0.2193	0.2107	0.2080	0.2275
2012/10/21	79.63	53.8	0.34	0	0.2436	0.1614	0.2279	0.1957
2012/10/28	80.41	65.3	0.78	0	0.2993	0.1593	0.2819	0.1499
2012/11/04	79.47	56.4	0	0.94	0.2979	0.2264	0.2779	0.2151
2012/11/11	81.31	66	1.84	0	0.4293	0.2114	0.4080	0.2103
2012/11/18	82.37	70.7	1.06	0	0.4121	0.2114	0.4743	0.1963
2012/11/25	82.46	66.5	0.09	0	0.4186	0.1479	0.3891	0.1963
2012/12/02	82.48	74	0.02	0	0.4200	0.1271	0.3901	0.1373
2012/12/09	83.51	79.7	1.03	0	0.4936	0.1171	0.4636	0.1181
2012/12/16	84.22	82.4	0.71	0	0.5343	0.1171	0.5090	0.1088
2012/12/23	85.9	85	1.68	0	0.6543	0.0993	0.6161	0.1088
2012/12/30	88.14	89.3	2.24	0	0.8143	0.0829	0.7676	0.0922
2013/01/06	89.18	91.5	1.04	0	0.8343	0.0829	0.8304	0.0769
2013/01/13	90.08	91.6	0.9	0	0.8986	0.0671	0.8390	0.0769
2013/01/20	90.86	93.5	0.78	0	0.8936	0.0671	0.8901	0.0623
2013/01/27	92.82	94	1.96	0	1.0093	0.0671	0.9697	0.0623
2013/02/03	92.66	92.7	0	0.16	0.9536	0.0786	0.9372	0.0738
2013/02/10	93.5	92.8	0.84	0	1.0136	0.0114	0.9455	0.0730
2013/02/17	93.38	98	0	0.12	0.8821	0.0200	0.9412	0.0192
2013/02/24	93.59	97.8	0.21	0	0.8214	0.0200	0.8341	0.0186
2013/03/03	96.02	98.1	2.43	0	0.9886	0.0200	0.9363	0.0186
2013/03/10	95.28	92.8	0	0.74	0.9871	0.0729	0.9180	0.0714
2013/03/17	94.49	88.1	0	0.79	0.9136	0.1293	0.9166	0.1241
2013/03/24	94.21	85.8	0	0.28	0.8629	0.1493	0.8483	0.1401
2013/03/31	97.52	88.2	3.31	0	0.9793	0.1493	1.0377	0.1386
2013/04/07	98.36	87.5	0.84	0	0.8793	0.1493	0.9693	0.1386
2013/04/14	99.5	86.6	1.14	0	0.8864	0.1493	0.8979	0.1386
2013/04/21	98.02	77.1	0	1.48	0.8221	0.2550	0.8231	0.2443
2013/04/28	98.97	77.8	0.95	0	0.8343	0.2550	0.8313	0.2368
2013/05/05	101.58	80.2	2.61	0	0.8807	0.2550	0.9611	0.2368
2013/05/12	103.19	79.8	1.61	0	0.9957	0.2436	0.9328	0.2368
2013/05/19	101.27	71.8	0	1.92	0.9357	0.3807	0.9246	0.3633
2013/05/26	100.46	67.9	0	0.81	0.9357	0.4300	0.8689	0.4114
2013/06/02	97.52	58.8	0	2.94	0.9207	0.6400	0.8689	0.6093
2013/06/09	94.09	50.5	0	3.43	0.7471	0.8850	0.8549	0.8393
2013/06/16	97.88	54	3.79	0	1.0179	0.8321	0.9645	0.8218
2013/06/23	99.12	57.2	1.24	0	1.1064	0.7757	1.0337	0.7727
2013/06/30	101.17	62	2.05	0	1.2529	0.7557	1.1738	0.7203
2013/07/07	99.19	58	0	1.98	1.0164	0.8971	1.1634	0.8432
2013/07/14	100.63	55.7	1.44	0	1.0593	0.8971	1.0467	0.8331
2013/07/21	98.28	49.6	0	2.35	0.9779	1.0650	0.9836	1.0009
2013/07/28	98.94	49.1	0.66	0	1.0250	0.9593	0.9552	0.9889
2013/08/04	96.21	46.7	0	2.73	0.9571	1.1543	0.9518	1.0858
2013/08/11	97.52	47.8	1.31	0	0.8643	1.1543	0.9823	1.0718
2013/08/18	98.7	45.3	1.18	0	0.8336	1.1543	0.8868	1.0718
2013/08/25	98.15	41.1	0	0.55	0.8336	1.0564	0.7740	1.1111

[Shino Unada]

RSIの計算にSMMAとは何？

[724965ds]

That's already been cleared up. 

I made a mistake.

I'm sorry for the inconvenience.