Tuesday, September 17, 2013

How to Calculate Traders Index (TRIN) Manually


           We recorded the daily data and calculated the Traders Index (TRIN) with the Excel spread sheet.  Here are TRIN readings from 7/11/2013 to 8/5/2013.  If you need to track trends, you can use this method.      

Date
 TRIN
Advancing Issue
Declining Issue
Advancing Volume
Declining Volume
7/11/2013
1.11
3513
593
3214
602
7/12/2013
0.75
1962
2029
1822
1417
7/15/2013
1.1
2634
1409
1771
1042
7/16/2013
0.94
1539
2446
1320
1966
7/17/2013
1.13
2668
1320
2172
1217
7/18/2013
0.93
2693
1317
2564
1171
7/19/2013
0.98
2103
1885
1855
1632
7/22/2013
0.85
2443
1575
1992
1090
7/23/2013
1
2301
1730
1906
1438
7/24/2013
0.8
957
3086
1015
2626
7/25/2013
0.94
2330
1691
2108
1445
7/26/2013
0.91
1870
2116
1486
1525
7/29/2013
0.73
1191
2826
1113
1921
7/30/2013
1.09
1958
2039
1590
1808
7/31/2013
1.37
2115
1898
1865
2285
8/1/2013
0.63
2551
1546
3024
1149
8/2/2013
1.09
2139
1874
1715
1642
8/5/2013
0.84
1227
1797
1003
1236

                The formula is

TRIN=(Advancing Issues/Declining Issues)/(Advancing Volume/Declining Volume)

The data of Advancing Issues, Declining Issues, Advancing Volume, and Declining Volume come from Yahoo Finance.

Here are the advances and declines data at the close of 8/5/2013.

 
NYSE
NASDAQ
Advances
1,227 (39%)
1,363 (55%)
Declines
1,797 (56%)
1,008 (40%)
Unchanged
158 (5%)
129 (5%)
Up Vol*
1,003 (44%)
604 (53%)
Down Vol*
1,236 (54%)
508 (44%)
Unch. Vol*
50 (2%)
37 (3%)
New Hi's
218
220
New Lo's
153
8
 

          Credited to http://www.investopedia.com/terms/a/arms.asp
 
Thanks for your reading!

No comments:

Post a Comment