Question

FIGURE 9.7 Market diary Source: The Wall Street Journal Online, May 25, 2017 4:06 PM EDT 5/25/2017 Markets Diary Issues NYSE NASDAQ NYSE MKT 130 165 Advancing Declining Unchanged Total 1,569 1,423 124 3,116 1,531 1,324 162 3,017 329 Issues at 238 222 New 52 Week High New 52 Week Low 42 64 Share Volume Total 3,537,923,017 Advancing 1,513,206,869 Declining 1,999,419,305 Unchanged 25,296,843 See 4 p.m. Closing Diaries. Volume updates until 8 p.m. 1,777,718,240 92,408,271 1,135,738,916 37,411,984 610,544,842 47,595,937 31,434,482 7,400,350 Get Markets Diary by Email

a. Calculate the trin ratio for NASDAQ

B. Calculate breadth for NASDAQ using the data in Advances, Declines, and Net Advancing

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

NPV, IRR, PBP,OCFINDEX - Microsoft Excel (Product Activation Failed) View Add-Ins Formulas Data Review - 2x Σ AutoSum : A 11 A = = = V General A A Wrap Text FMerce Merge & Center Center E E E s 4.0 .00 8.9 Insert Delete Format $ - % % Number Conditional Format Formatting as Table Styles Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Alignment Cells L BS BT BU B V BW BX BY BZ File Home Insert Page Layout % Cut Calibri Ea Copy Paste Format Painter B I U - D Clipboard Font BR169 for BP BQ BR 168 169 170 171 172 173 174 175 176 177 TRIN = (DECLINING VOLUME/DECLINING ISSUES)/(ADVANCING VOLUME/ADVANCING ISSUES) TRIN STATISTIC FOR NASDAQ = TRIN STATISTIC FOR NASDAQ = TRIN STATISTIC FOR NASDAQ = (610544842/1324)/(1135738916/1531) 0.621622 0.6216 [ROUNDED TILL 4 DECIMALS] 178 FOR NASDAQ ADVANCES DECLINES B NET ADVANCING A-B 179 180 181 182 183 184 185 186 BREADTH 1531 1324 1324 207 H O FCFARM, MSI,confidenceINDEX CURRENCY LOAN CROSS OVER HEDGING MONEY MARKET GM HPR AM TAX GROWTH SUST CF CASH FLOW STATW ferences PREF AND DIV POLICY I BOJ 130% - Red 0 _+ 1 @ e 9 E AS WA LLPA PER HENG 11:12 22-11-2019