11 Messages
Digest #4106
1b
Re: alternative to Forecast earnings element # 559 which no longer w by "Randy Harmelink" rharmelink
1d
Re: alternative to Forecast earnings element # 559 which no longer w by "Randy Harmelink" rharmelink
1f
Re: alternative to Forecast earnings element # 559 which no longer w by "Randy Harmelink" rharmelink
1h
Re: alternative to Forecast earnings element # 559 which no longer w by "Randy Harmelink" rharmelink
Messages
Sat Jul 29, 2017 8:08 pm (PDT) . Posted by:
mokwit
Stock Market Functions add-in, Version 2.1.2017.05.18 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; www; Local; 1)
Sat Jul 29, 2017 8:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Sat, Jul 29, 2017 at 8:04 PM, pmanz@... wrote:
>
> Stock Market Functions add-in, Version 2.1.2017.05.18 (C:\Program
> Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; www; Local; 1)
>
>
Th
at should work. What do you get with:
=RCHGetElementNumber("Definition",559)
=RCHGetElementNumber("CATO",559)
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO",3,">EPS
Trend","CURRENT ESTIMATE")
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO",0,">EPS
Trend","CURRENT ESTIMATE")
=RCHGetWebData("https://finance.yahoo.com/q/ae?s=CATO","Current Estimate")
>
> Stock Market Functions add-in, Version 2.1.2017.05.18 (C:\Program
> Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; www; Local; 1)
>
>
Th
at should work. What do you get with:
=RCHGetElementNumber("Definition",559)
=RCHGetElementNumber("CATO",559)
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO",3,">EPS
Trend","CURRENT ESTIMATE")
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO",0,">EPS
Trend","CURRENT ESTIMATE")
=RCHGetWebData("https://finance.yahoo.com/q/ae?s=CATO","
Sat Jul 29, 2017 8:36 pm (PDT) . Posted by:
mokwit
YahooAE;Consensus EPS Trend -- Current Estimate -- FY1;http://finance.yahoo.com/q/ae?s=~~~~~;3;>EPS TRENDS;CURRENT ESTIMATE; ; ;0;0;0;0
And Error for second one as I do with the ones I posted
How do I check my definitions are up to date assuming that is the cause?
And Error for second one as I do with the ones I posted
How do I check my definitions are up to date assuming that is the cause?
Sat Jul 29, 2017 9:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just check the file dates to see how current they are. If you dates are
prior to those on the website, they're probably out of date.
You didn't say what you got for results on the 3rd thru 5th formulas I
asked you to try...
On Sat, Jul 29, 2017 at 8:36 PM, pmanz@
...
wrote:
>
> YahooAE;Consensus EPS Trend -- Current Estimate -- FY1;
> http://finance.yahoo.com/q/ae?s=~~~~~;3;>EPS TRENDS;CURRENT ESTIMATE; ;
> ;0;0;0;0
>
>
> And Error for second one as I do with the ones I posted
>
> How do I check my definitions are up to date assuming that is the cause?
>
>
prior to those on the website, they're probably out of date.
You didn't say what you got for results on the 3rd thru 5th formulas I
asked you to try...
On Sat, Jul 29, 2017 at 8:36 PM, pmanz@
...
wrote:
>
> YahooAE;Consensus EPS Trend -- Current Estimate -- FY1;
> http://finance.yahoo.com/q/ae?s=~~~~~;3;>EPS TRENDS;CURRENT ESTIMATE; ;
> ;0;0;0;0
>
>
> And Error for second one as I do with the ones I posted
>
> How do I check my definitions are up to date assuming that is the cause?
>
>
Sat Jul 29, 2017 10:00 pm (PDT) . Posted by:
mokwit
There is no text in the message - just a blank - I used the two formulas visible in the title and could not see a 3rd thru 5th
Sat Jul 29, 2017 10:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, I posted them at the bottom. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32892
On Sat, Jul 29, 2017 at 10:00 PM, pmanz@
...
wrote:
>
>
> There is no text in the message - just a blank - I used the two formulas
> visible in the title and could not see a 3rd thru 5th
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32892
On Sat, Jul 29, 2017 at 10:00 PM, pmanz@
...
wrote:
>
>
> There is no text in the message - just a blank - I used the two formulas
> visible in the title and could not see a 3rd thru 5th
>
Sat Jul 29, 2017 10:42 pm (PDT) . Posted by:
mokwit
Ok my bad - all but options expense have been restored after I updated my definitions files - were 2016 - updated with '17 files from latest beta,
SO: that leaves line item Also 'Adjustments to Net Income' which I was using as a dirty proxy forOption Expense still not working - any suggestions on that one?
For the sake of completeness:
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO",3,">EPS Trend","CURRENT ESTIMATE")
Excel says Error in formula
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO",0,">EPS Trend","CURRENT ESTIMATE")
returns: current estimate
=RCHGetWebData("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO","Current Estimate")
returns
Current Estimate</span></td><td class="Ta(end)" data-reactid="267"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="268">0.11</span></td><td class="Ta(end)" data-reactid="269"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="270">0.08</span></td><td class="Ta(end)" data-reactid="271"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="272">1.35</span></td><td class="Ta(end)" data-reactid="273"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="274">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="275"><td class="Py(10px) Ta(start)" data-reactid="276"><span data-reactid="277">7 Days Ago</span></td><td class="Ta(end)" data-reactid="278"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="279">0.11</span></td><td class="Ta(end)" data-reactid="280"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="281">0.08</span></td><td class="Ta(end)" data-reactid="282"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="283">1.35</span></td><td class="Ta(end)" data-reactid="284"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="285">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="286"><td class="Py(10px) Ta(start)" data-reactid="287"><span data-reactid="288">30 Days Ago</span></td><td class="Ta(end)" data-reactid="289"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="290">0.11</span></td><td class="Ta(end)" data-reactid="291"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="292">0.08</span></td><td class="Ta(end)" data-reactid="293"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="294">1.35</span></td><td class="Ta(end)" data-reactid="295"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="296">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="297"><td class="Py(10px) Ta(start)" data-reactid="298"><span data-reactid="299">60 Days Ago</span></td><td class="Ta(end)" data-reactid="300"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="301">0.3</span></td><td class="Ta(end)" data-reactid="302"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="303">0.09</span></td><td class="Ta(end)" data-reactid="304"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="305">1.57</span></td><td class="Ta(end)" data-reactid="306"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="307">1.69</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="308"><td class="Py(10px) Ta(start)" data-reactid="309"><span data-reactid="310">90 Days Ago</span></td><td class="Ta(end)" data-reactid="311"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="312">0.38</span></td><td class="Ta(end)" data-reactid="313"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="314">0.19</span></td><td class="Ta(end)" data-reactid="315"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="316">1.5</span></td><td class="Ta(end)" data-reactid="317"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="318">1.6</span></td></tr></tbody></table><table class="W(100%) M(0) BdB Bdc($lightGray) Mb(25px)" data-reactid="319"><tdead data-reactid="320"><tr class="Ta(start)" data-reactid="321"><td class="Fw(b) Fw(s) W(20%) Py(10px) C($finDarkLink)" data-reactid="322"><span data-reactid="323">EPS Revisions</span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="324"><span data-reactid="325"><span data-reactid="326">Current Qtr.</span><!-- react-text: 327 --> (<!-- /react-text --><span data-reactid="328">Jul</span><!-- react-text: 329 --> 2017)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="330"><span data-reactid="331"><span data-reactid="332">Next Qtr.</span><!-- react-text: 333 --> (<!-- /react-text --><span data-reactid="334">Oct</span><!-- react-text: 335 --> 2017)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="336"><span data-reactid="337"><span data-reactid="338">Current Year</span><!-- react-text: 339 --> (2018)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="340"><span data-reactid="341"><span data-reactid="342">Next Year</span><!-- react-text: 343 --> (2019)<!-- /react-text --></span></td></tr></tdead><tbody data-reactid="344"><tr class="BdT Bdc($lightGray)" data-reactid="345"><td class="Py(10px) Ta(start)" data-reactid="346"><span data-reactid="347">Up Last 7 Days</span></td><td class="Ta(end)" data-reactid="348"><span data-reactid="349">N/A</span></td><td class="Ta(end)" data-reactid="350"><span data-reactid="351">N/A</span></td><td class="Ta(end)" data-reactid="352"><span data-reactid="353">N/A</span></td><td class="Ta(end)" data-reactid="354"><span data-reactid="355">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="356"><td class="Py(10px) Ta(start)" data-reactid="357"><span data-reactid="358">Up Last 30 Days</span></td><td class="Ta(end)" data-reactid="359"><span data-reactid="360">N/A</span></td><td class="Ta(end)" data-reactid="361"><span data-reactid="362">N/A</span></td><td class="Ta(end)" data-reactid="363"><span data-reactid="364">N/A</span></td><td class="Ta(end)" data-reactid="365"><span data-reactid="366">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="367"><td class="Py(10px) Ta(start)" data-reactid="368"><span data-reactid="369">Down Last 30 Days</span></td><td class="Ta(end)" data-reactid="370"><span data-reactid="371">N/A</span></td><td class="Ta(end)" data-reactid="372"><span data-reactid="373">N/A</span></td><td class="Ta(end)" data-reactid="374"><span data-reactid="375">N/A</span></td><td class="Ta(end)" data-reactid="376"><span data-reactid="377">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="378"><td class="Py(10px) Ta(start)" data-reactid="379"><span data-reactid="380">Down Last 90 Days</span></td><td class="Ta(end)" data-reactid="381"><span data-reactid="382">N/A</span></td><td class="Ta(end)" data-reactid="383"><span data-reactid="384">N/A</span></td><td class="Ta(end)" data-reactid="385"><span data-reactid="386">N/A</span></td><td class="Ta(end)" data-reactid="387"><span data-reactid="388">N/A</span></td></tr></tbody></table><table class="W(100%) M(0) BdB Bdc($lightGray) Mb(25px)" data-reactid="389"><tdead data-reactid="390"><tr class="Ta(start)" data-reactid="391"><td class="W(20%) Fz(s) Fw(b) C($finDarkLink) Py(10px) Ta(start)" data-reactid="392">Growth Estimates</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="393">CATO</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="394">Industry</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="395">Sector</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="396">S&P 500</td></tr></tdead><tbody data-reactid="397"><tr class="BdT Bdc($lightGray)" data-reactid="398"><td class="Ta(start) Py(10px)" data-reactid="399"><span data-reactid="400">Current Qtr.</span></td><td class="Ta(end) Py(10px)" data-reactid="401">-80.70%</td><td class="Ta(end) Py(10px)" data-reactid="402">N/A</td><td class="Ta(end) Py(10px)" data-reactid="403">N/A</td><td class="Ta(end) Py(10px)" data-reactid="404">0.18</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="405"><td class="Ta(start) Py(10px)" data-reactid="406"><span data-reactid="407">Next Qtr.</span></td><td class="Ta(end) Py(10px)" data-reactid="408">-73.30%</td><td class="Ta(end) Py(10px)" data-reactid="409">N/A</td><td class="Ta(end) Py(10px)" data-reactid="410">N/A</td><td class="Ta(end) Py(10px)" data-reactid="411">0.23</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="412"><td class="Ta(start) Py(10px)" data-reactid="413"><span data-reactid="414">Current Year</span></td><td class="Ta(end) Py(10px)" data-reactid="415">-21.50%</td><td class="Ta(end) Py(10px)" data-reactid="416">N/A</td><td class="Ta(end) Py(10px)" data-reactid="417">N/A</td><td class="Ta(end) Py(10px)" data-reactid="418">0.08</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="419"><td class="Ta(start) Py(10px)" data-reactid="420"><span data-reactid="421">Next Year</span></td><td class="Ta(end) Py(10px)" data-reactid="422">7.40%</td><td class="Ta(end) Py(10px)" data-reactid="423">N/A</td><td class="Ta(end) Py(10px)" data-reactid="424">N/A</td><td class="Ta(end) Py(10px)" data-reactid="425">0.11</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="426"><td class="Ta(start) Py(10px)" data-reactid="427"><span data-reactid="428">Next 5 Years (per annum)</span></td><td class="Ta(end) Py(10px)" data-reactid="429">10.00%</td><td class="Ta(end) Py(10px)" data-reactid="430">N/A</td><td class="Ta(end) Py(10px)" data-reactid="431">N/A</td><td class="Ta(end) Py(10px)" data-reactid="432">0.10</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="433"><td class="Ta(start) Py(10px)" data-reactid="434"><span data-reactid="435">Past 5 Years (per annum)</span></td><td class="Ta(end) Py(10px)" data-reactid="436">7.30%</td><td class="Ta(end) Py(10px)" data-reactid="437">N/A</td><td class="Ta(end) Py(10px)" data-reactid="438">N/A</td><td class="Ta(end) Py(10px)" data-reactid="439">N/A</td></tr></tbody></table></section></div></section></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-0-QuoteLeaf');window.performance.measure && window.performance.measure('Col1-0-QuoteLeafDone','PageStart','Col1-0-QuoteLeaf');}</script></div><div data-reactid="31"><div id="mrt-node-Col1-1-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col1-1-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-943875508"><div class="ad-foot" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultFOOT-sizer" class="darla-container Pos-r Z-0 Pos(r) Ov(a) Z(0)" style="height:0;width:0;" data-reactid="5"><div id="defaultFOOT-wrapper" class="Pos-a T-0 B-0 Start-0 End-0 Ov-h Pos(a) T(0) B(0) Start(0) End(0) Ov(h)" data-reactid="6"><div id="defaultdestFOOT" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-1-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col1-1-AdUnitWithTdAdsDone','PageStart','Col1-1-AdUnitWithTdAds');}</script></div><div data-reactid="32"><div id="mrt-node-Col1-2-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col1-2-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1427268619"><div class="ad-fsrvy" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultFSRVY-sizer" class="darla-container Pos-r Z-0 Pos(r) Ov(a) Z(0)" style="height:0;width:0;" data-reactid="5"><div id="defaultFSRVY-wrapper" class="Pos-a T-0 B-0 Start-0 End-0 Ov-h Pos(a) T(0) B(0) Start(0) End(0) Ov(h)" data-reactid="6"><div id="defaultdestFSRVY" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-2-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col1-2-AdUnitWithTdAdsDone','PageStart','Col1-2-AdUnitWithTdAds');}</script></div></div></div><div class="Pos(a) W(300px) End(0) T(0) tablet_D(n)--noRightRail" data-reactid="33"><!-- react-empty: 34 --><div id="YDC-Col2" class="YDC-Col2" data-reactid="35"><div class="sticky-outer-wrapper" data-reactid="36"><div class="sticky-inner-wrapper" style="position:relative;top:0px;" data-reactid="37"><div id="YDC-Col2-Stack" class="YDC-Col2-Stack Pos(r) W(300px)" data-reactid="38"><div id="Aside" role="complementary" tabindex="-1" data-reactid="39"><div data-reactid="40"><div id="mrt-node-Col2-0-QuoteModule" data-locator="subtree-root"><div id="Col2-0-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1807209916"><div data-test="quote-mdl" data-reactid="2"></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-0-QuoteModule');window.performance.measure && window.performance.measure('Col2-0-QuoteModuleDone','PageStart','Col2-0-QuoteModule');}</script></div><div data-reactid="41"><div id="mrt-node-Col2-1-ComboAd" data-locator="subtree-root"><div id="Col2-1-ComboAd-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="1006025186"><div class="" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultLREC-sizer" class="darla-container D-n D(n)" data-reactid="5"><div id="defaultLREC-wrapper" class="" data-reactid="6"><div id="defaultdestLREC" style=""></div></div></div></div><div data-reactid="7"><div id="defaultMON-sizer" class="darla-container D-n D(n)" data-reactid="8"><div id="defaultMON-wrapper" class="" data-reactid="9"><div id="defaultdestMON" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-1-ComboAd');window.performance.measure && window.performance.measure('Col2-1-ComboAdDone','PageStart','Col2-1-ComboAd');}</script></div><div data-reactid="42"><div id="mrt-node-Col2-2-QuoteModule" data-locator="subtree-root"><div id="Col2-2-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2031559524"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-2-QuoteModule');window.performance.measure && window.performance.measure('Col2-2-QuoteModuleDone','PageStart','Col2-2-QuoteModule');}</script></div><div data-reactid="43"><div id="mrt-node-Col2-3-QuoteModule" data-locator="subtree-root"><div id="Col2-3-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2037588837"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-3-QuoteModule');window.performance.measure && window.performance.measure('Col2-3-QuoteModuleDone','PageStart','Col2-3-QuoteModule');}</script></div><div data-reactid="44"><div id="mrt-node-Col2-4-QuoteModule" data-locator="subtree-root"><div id="Col2-4-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2043618150"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-4-QuoteModule');window.performance.measure && window.performance.measure('Col2-4-QuoteModuleDone','PageStart','Col2-4-QuoteModule');}</script></div><div data-reactid="45"><div id="mrt-node-Col2-5-QuoteModule" data-locator="subtree-root"><div id="Col2-5-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2049647463"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-5-QuoteModule');window.performance.measure && window.performance.measure('Col2-5-QuoteModuleDone','PageStart','Col2-5-QuoteModule');}</script></div><div data-reactid="46"><div id="mrt-node-Col2-6-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col2-6-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="1411938822"><div class="ad-lrec2" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultLREC2-sizer" class="darla-container D-n D(n)" data-reactid="5"><div id="defaultLREC2-wrapper" class="" data-reactid="6"><div id="defaultdestLREC2" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-6-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col2-6-AdUnitWithTdAdsDone','PageStart','Col2-6-AdUnitWithTdAds');}</script></div><div data-reactid="47"><div id="mrt-node-Col2-7-IFrame" data-locator="subtree-root"><div id="Col2-7-IFrame-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1545003598"><!-- react-empty: 2 --></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-7-IFrame');window.performance.measure && window.performance.measure('Col2-7-IFrameDone','PageStart','Col2-7-IFrame');}</script></div><div data-reactid="48"><div id="mrt-node-Col2-8-LinkOut" data-locator="subtree-root"><div id="Col2-8-LinkOut-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="63982622"><a class="Mt(20px) Ta(c) btn btn-white W(100%)" href="https://smallbusiness.yahoo.com" data-reactid="2"><span data-reactid="3">Yahoo Small Business</span></a></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-8-LinkOut');window.performance.measure && window.performance.measure('Col2-8-LinkOutDone','PageStart','Col2-8-LinkOut');}</script></div><div data-reactid="49"><div id="mrt-node-Col2-9-Footer" data-locator="subtree-root"><div id="Col2-9-Footer-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="456383766"><div id="Col2-9-Footer" class="footer Ta(c) Bgc(#fff) Pb(15px) Pt(25px)" data-test="finance-footer" data-reactid="2"><div class="Fz(s) D(ib) Pb(10px) Pt(2px)" data-reactid="3"><div class="Pb(5px) D(b)" data-reactid="4"><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://help.yahoo.com/kb/index?page=content&y=PROD_FIN_DESK&locale=en_US&id=SLN2310" rel="nofollow" data-reactid="5"><span data-reactid="6">Data Disclaimer</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://help.yahoo.com/kb/index?page=content&y=PROD_FIN_DESK&locale=en_US" rel="nofollow" data-reactid="7"><span data-reactid="8">Help</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://yahoo.uservoice.com/forums/382977" rel="nofollow" data-reactid="9"><span data-reactid="10">Suggestions</span></a></div><div class="Pb(10px) D(b)" data-reactid="11"><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/privacy/us/yahoo/" rel="nofollow" data-reactid="12"><span data-reactid="13">Privacy</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/relevantads/" rel="nofollow" data-reactid="14"><span data-reactid="15">About Our Ads</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/legal/us/yahoo/utos/utos-173.html" rel="nofollow" data-reactid="16"><span data-reactid="17">Terms (Updated)</span></a></div></div><div class="D(b)" data-reactid="18"><img src="https://s.yimg.com/os/finance/dd-site/img/Oath_YFin_Logo_EN.svg" alt="Oath: Yahoo Finance" class="Pend(20px) W(120px)" data-reactid="19"/><ul class="follow-button-group M(0) Va(m) D(ib) Ta(c)" data-reactid="20"><li class="D(ib) M(0) Cur(p) twitter" style="width:34px;height:34px;line-height:34px;" title="Follow on Twitter" data-reactid="21"><a class="Td(n) C(#000)" href="https://twitter.com/YahooFinance" target="_blank" data-reactid="22"><svg class="Va(m)! Cur(p)" width="18" style="fill:black;stroke:black;stroke-width:0;vertical-align:bottom;" height="18" viewBox="0 0 32 32" data-icon="LogoTwitter" data-reactid="23"><path d="M30.402 7.094c-1.058.47-2.198.782-3.392.928 1.218-.725 2.154-1.885 2.595-3.256-1.134.674-2.405 1.165-3.75 1.43-1.077-1.148-2.612-1.862-4.31-1.862-3.268 0-5.915 2.635-5.915 5.893 0 .464.056.91.155 1.34-4.915-.244-9.266-2.59-12.18-6.158-.51.87-.806 1.885-.806 2.96 0 2.044 1.045 3.847 2.633 4.905-.974-.032-1.883-.3-2.68-.736v.07c0 2.857 2.034 5.236 4.742 5.773-.498.138-1.022.21-1.56.21-.38 0-.75-.034-1.11-.103.75 2.344 2.93 4.042 5.518 4.09-2.024 1.58-4.57 2.523-7.333 2.523-.478 0-.952-.032-1.41-.085 2.613 1.674 5.72 2.65 9.054 2.65 10.872 0 16.814-8.976 16.814-16.765 0-.254-.008-.507-.018-.762 1.155-.83 2.155-1.868 2.95-3.047z" data-reactid="24"></path></svg></a></li><li class="D(ib) M(0) Cur(p) facebook" style="width:34px;height:34px;line-height:34px;" title="Follow on Facebook" data-reactid="25"><a class="Td(n) C(#000)" href="https://facebook.com/yahoofinance" target="_blank" data-reactid="26"><svg class="Va(m)! Cur(p)" width="18" style="fill:black;stroke:black;stroke-width:0;vertical-align:bottom;" height="18" viewBox="0 0 32 32" data-icon="LogoFacebook" data-reactid="27"><path d="M12.752 30.4V16.888H9.365V12.02h3.387V7.865c0-3.264 2.002-6.264 6.613-6.264 1.866 0 3.248.19 3.248.19l-.11 4.54s-1.404-.013-2.943-.013c-1.66 0-1.93.81-1.93 2.152v3.553h5.008l-.22 4.867h-4.786V30.4h-4.88z" data-reactid="28"></path></svg></a></li><li class="D(ib) M(0) Cur(p) tumblr" style="width:34px;height:34px;line-height:34px;" title="Follow on Tumblr" data-reactid="29"><a class="Td(n) C(#000)" href="http://yahoofinance.tumblr.com" target="_blank" data-reactid="30"><svg class="Va(m)! Cur(p)" width="17" style="fill:black;stroke:black;stroke-width:0;vertical-align:bottom;" height="17" viewBox="0 0 24 24" data-icon="LogoTumblr" data-reactid="31"><path d="M15.4 19.1c-1.1 0-2.5-.7-2.5-1.1v-7.8h4.9V6.8h-4.9V1.7H10C9.9 3 9.5 4.1 8.9 5c-.2.5-.5.8-.9 1.1-.6.4-1.2.7-1.9.7h-.5v3.4H8v8.4c0 3.2 2.9 3.7 4.8 3.7h1.3c3 0 3.6-.3 4.3-.6V18c-.9.6-2 1.1-3 1.1z" data-reactid="32"></path></svg></a></li></ul></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-9-Footer39;);window.performance.measure && window.performance.measure(39;Col2-9-FooterDone39;,'PageStart39;,'Col2-9-Footer39;);}</script></div></div></div></div></div></div></div></div><div id="YDC-Overlay" class="YDC-Overlay" data-reactid="50"><div id="YDC-Overlay-Stack" class="YDC-Overlay-Stack Z(11) End(0) Pos(f) Start(0) lw-nav-open_Pos(r) lw-nav-open_Z(10) T(0)" data-reactid="51"><div data-reactid="52"><div data-reactid="53"><div id="mrt-node-Overlay-0-Lightbox" data-locator="subtree-root"><div id="Overlay-0-Lightbox-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1142446977"><div id="Overlay-0-Lightbox" class="lightbox" data-reactid="2"><div tabindex="-1" class="lightbox-wrapper Ta(c) Pos(f) T(0) Start(0) H(100%) W(100%) D(n)! Op(0)" data-reactid="3"><div id="myLightboxContainer" class="Ta(start) Pos(r) Z(1) T(0) Maw(100%) P(0) D(n)!" aria-describedby="lightbox-container" role="alertdialog" data-reactid="4"></div><b class="ModalShim" data-reactid="5"></b><b class="IEShim" data-reactid="6"></b></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Overlay-0-Lightbox39;);window.performance.measure && window.performance.measure(39;Overlay-0-LightboxDone39;,'PageStart39;,'Overlay-0-Lightbox39;);}</script></div><div data-reactid="54"><div id="mrt-node-Overlay-1-ChartToolTip" data-locator="subtree-root"><div id="Overlay-1-ChartToolTip-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-566015715"><div id="quote-chart-tooltip" class="chart-tooltip Bgc(white) Bd Bdc($lightGrayBorder) Bdrs(5px) Fz(12px) Pos(f)" data-reactid="2"></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Overlay-1-ChartToolTip39;);window.performance.measure && window.performance.measure(39;Overlay-1-ChartToolTipDone',39;PageStart39;,'Overlay-1-ChartToolTip39;);}</script></div></div></div></div></div></div><div class="render-target-modal D(n) modal-open_D(b) modal-postopen_D(b) H(100%) Pos(a) W(100%) Z(9) O(n)!:f" id="render-target-modal" data-reactid="55"><span data-reactid="56"></span></div><div class="render-target-viewer D(n) viewer-open_D(b) viewer-postopen_D(b) H(100%) Pos(a) W(100%) Z(10)" id="render-target-viewer" data-reactid="57"><span data-reactid="58"></span></div></div></div></div><div><script type="text/javascript">window._loadEvt = false; window._adPerfData = []; window._adPosMsg = []; window._perfMark = function _perfMark (name) {if (window.performance && window.performance.mark){try {if (window.performance.getEntriesByName("NAVIGATE_START") && window.performance.getEntriesByName("NAVIGATE_START")[0]) { name = "CL_" + name ;}window.performance.mark(name)
SO: that leaves line item Also 'Adjustments to Net Income' which I was using as a dirty proxy forOption Expense still not working - any suggestions on that one?
For the sake of completeness:
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO",3,">EPS Trend","CURRENT ESTIMATE")
Excel says Error in formula
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO",0,">EPS Trend","CURRENT ESTIMATE")
returns: current estimate
=RCHGetWebData("https://finance.yahoo.com/q/ae?s=CATO https://finance.yahoo.com/q/ae?s=CATO","Current Estimate")
returns
Current Estimate</span></td><td class="Ta(end)" data-reactid="267"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="268">0.11</span></td><td class="Ta(end)" data-reactid="269"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="270">0.08</span></td><td class="Ta(end)" data-reactid="271"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="272">1.35</span></td><td class="Ta(end)" data-reactid="273"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="274">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="275"><td class="Py(10px) Ta(start)" data-reactid="276"><span data-reactid="277">7 Days Ago</span></td><td class="Ta(end)" data-reactid="278"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="279">0.11</span></td><td class="Ta(end)" data-reactid="280"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="281">0.08</span></td><td class="Ta(end)" data-reactid="282"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="283">1.35</span></td><td class="Ta(end)" data-reactid="284"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="285">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="286"><td class="Py(10px) Ta(start)" data-reactid="287"><span data-reactid="288">30 Days Ago</span></td><td class="Ta(end)" data-reactid="289"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="290">0.11</span></td><td class="Ta(end)" data-reactid="291"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="292">0.08</span></td><td class="Ta(end)" data-reactid="293"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="294">1.35</span></td><td class="Ta(end)" data-reactid="295"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="296">1.45</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="297"><td class="Py(10px) Ta(start)" data-reactid="298"><span data-reactid="299">60 Days Ago</span></td><td class="Ta(end)" data-reactid="300"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="301">0.3</span></td><td class="Ta(end)" data-reactid="302"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="303">0.09</span></td><td class="Ta(end)" data-reactid="304"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="305">1.57</span></td><td class="Ta(end)" data-reactid="306"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="307">1.69</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="308"><td class="Py(10px) Ta(start)" data-reactid="309"><span data-reactid="310">90 Days Ago</span></td><td class="Ta(end)" data-reactid="311"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="312">0.38</span></td><td class="Ta(end)" data-reactid="313"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="314">0.19</span></td><td class="Ta(end)" data-reactid="315"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="316">1.5</span></td><td class="Ta(end)" data-reactid="317"><span class="Trsdu(0.3s) C($dataGreen)" data-reactid="318">1.6</span></td></tr></tbody></table><table class="W(100%) M(0) BdB Bdc($lightGray) Mb(25px)" data-reactid="319"><tdead data-reactid="320"><tr class="Ta(start)" data-reactid="321"><td class="Fw(b) Fw(s) W(20%) Py(10px) C($finDarkLink)" data-reactid="322"><span data-reactid="323">EPS Revisions</span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="324"><span data-reactid="325"><span data-reactid="326">Current Qtr.</span><!-- react-text: 327 --> (<!-- /react-text --><span data-reactid="328">Jul</span><!-- react-text: 329 --> 2017)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="330"><span data-reactid="331"><span data-reactid="332">Next Qtr.</span><!-- react-text: 333 --> (<!-- /react-text --><span data-reactid="334">Oct</span><!-- react-text: 335 --> 2017)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="336"><span data-reactid="337"><span data-reactid="338">Current Year</span><!-- react-text: 339 --> (2018)<!-- /react-text --></span></td><td class="Fw(400) W(20%) Fz(xs) C($finDarkGray) Ta(end)" data-reactid="340"><span data-reactid="341"><span data-reactid="342">Next Year</span><!-- react-text: 343 --> (2019)<!-- /react-text --></span></td></tr></tdead><tbody data-reactid="344"><tr class="BdT Bdc($lightGray)" data-reactid="345"><td class="Py(10px) Ta(start)" data-reactid="346"><span data-reactid="347">Up Last 7 Days</span></td><td class="Ta(end)" data-reactid="348"><span data-reactid="349">N/A</span></td><td class="Ta(end)" data-reactid="350"><span data-reactid="351">N/A</span></td><td class="Ta(end)" data-reactid="352"><span data-reactid="353">N/A</span></td><td class="Ta(end)" data-reactid="354"><span data-reactid="355">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="356"><td class="Py(10px) Ta(start)" data-reactid="357"><span data-reactid="358">Up Last 30 Days</span></td><td class="Ta(end)" data-reactid="359"><span data-reactid="360">N/A</span></td><td class="Ta(end)" data-reactid="361"><span data-reactid="362">N/A</span></td><td class="Ta(end)" data-reactid="363"><span data-reactid="364">N/A</span></td><td class="Ta(end)" data-reactid="365"><span data-reactid="366">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="367"><td class="Py(10px) Ta(start)" data-reactid="368"><span data-reactid="369">Down Last 30 Days</span></td><td class="Ta(end)" data-reactid="370"><span data-reactid="371">N/A</span></td><td class="Ta(end)" data-reactid="372"><span data-reactid="373">N/A</span></td><td class="Ta(end)" data-reactid="374"><span data-reactid="375">N/A</span></td><td class="Ta(end)" data-reactid="376"><span data-reactid="377">N/A</span></td></tr><tr class="BdT Bdc($lightGray)" data-reactid="378"><td class="Py(10px) Ta(start)" data-reactid="379"><span data-reactid="380">Down Last 90 Days</span></td><td class="Ta(end)" data-reactid="381"><span data-reactid="382">N/A</span></td><td class="Ta(end)" data-reactid="383"><span data-reactid="384">N/A</span></td><td class="Ta(end)" data-reactid="385"><span data-reactid="386">N/A</span></td><td class="Ta(end)" data-reactid="387"><span data-reactid="388">N/A</span></td></tr></tbody></table><table class="W(100%) M(0) BdB Bdc($lightGray) Mb(25px)" data-reactid="389"><tdead data-reactid="390"><tr class="Ta(start)" data-reactid="391"><td class="W(20%) Fz(s) Fw(b) C($finDarkLink) Py(10px) Ta(start)" data-reactid="392">Growth Estimates</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="393">CATO</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="394">Industry</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="395">Sector</td><td class="W(20%) Fz(xs) C($finDarkGray) Py(10px) Fw(400) Ta(end)" data-reactid="396">S&P 500</td></tr></tdead><tbody data-reactid="397"><tr class="BdT Bdc($lightGray)" data-reactid="398"><td class="Ta(start) Py(10px)" data-reactid="399"><span data-reactid="400">Current Qtr.</span></td><td class="Ta(end) Py(10px)" data-reactid="401">-80.70%</td><td class="Ta(end) Py(10px)" data-reactid="402">N/A</td><td class="Ta(end) Py(10px)" data-reactid="403">N/A</td><td class="Ta(end) Py(10px)" data-reactid="404">0.18</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="405"><td class="Ta(start) Py(10px)" data-reactid="406"><span data-reactid="407">Next Qtr.</span></td><td class="Ta(end) Py(10px)" data-reactid="408">-73.30%</td><td class="Ta(end) Py(10px)" data-reactid="409">N/A</td><td class="Ta(end) Py(10px)" data-reactid="410">N/A</td><td class="Ta(end) Py(10px)" data-reactid="411">0.23</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="412"><td class="Ta(start) Py(10px)" data-reactid="413"><span data-reactid="414">Current Year</span></td><td class="Ta(end) Py(10px)" data-reactid="415">-21.50%</td><td class="Ta(end) Py(10px)" data-reactid="416">N/A</td><td class="Ta(end) Py(10px)" data-reactid="417">N/A</td><td class="Ta(end) Py(10px)" data-reactid="418">0.08</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="419"><td class="Ta(start) Py(10px)" data-reactid="420"><span data-reactid="421">Next Year</span></td><td class="Ta(end) Py(10px)" data-reactid="422">7.40%</td><td class="Ta(end) Py(10px)" data-reactid="423">N/A</td><td class="Ta(end) Py(10px)" data-reactid="424">N/A</td><td class="Ta(end) Py(10px)" data-reactid="425">0.11</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="426"><td class="Ta(start) Py(10px)" data-reactid="427"><span data-reactid="428">Next 5 Years (per annum)</span></td><td class="Ta(end) Py(10px)" data-reactid="429">10.00%</td><td class="Ta(end) Py(10px)" data-reactid="430">N/A</td><td class="Ta(end) Py(10px)" data-reactid="431">N/A</td><td class="Ta(end) Py(10px)" data-reactid="432">0.10</td></tr><tr class="BdT Bdc($lightGray)" data-reactid="433"><td class="Ta(start) Py(10px)" data-reactid="434"><span data-reactid="435">Past 5 Years (per annum)</span></td><td class="Ta(end) Py(10px)" data-reactid="436">7.30%</td><td class="Ta(end) Py(10px)" data-reactid="437">N/A</td><td class="Ta(end) Py(10px)" data-reactid="438">N/A</td><td class="Ta(end) Py(10px)" data-reactid="439">N/A</td></tr></tbody></table></section></div></section></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-0-QuoteLeaf');window.performance.measure && window.performance.measure('Col1-0-QuoteLeafDone','PageStart','Col1-0-QuoteLeaf');}</script></div><div data-reactid="31"><div id="mrt-node-Col1-1-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col1-1-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-943875508"><div class="ad-foot" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultFOOT-sizer" class="darla-container Pos-r Z-0 Pos(r) Ov(a) Z(0)" style="height:0;width:0;" data-reactid="5"><div id="defaultFOOT-wrapper" class="Pos-a T-0 B-0 Start-0 End-0 Ov-h Pos(a) T(0) B(0) Start(0) End(0) Ov(h)" data-reactid="6"><div id="defaultdestFOOT" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-1-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col1-1-AdUnitWithTdAdsDone','PageStart','Col1-1-AdUnitWithTdAds');}</script></div><div data-reactid="32"><div id="mrt-node-Col1-2-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col1-2-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1427268619"><div class="ad-fsrvy" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultFSRVY-sizer" class="darla-container Pos-r Z-0 Pos(r) Ov(a) Z(0)" style="height:0;width:0;" data-reactid="5"><div id="defaultFSRVY-wrapper" class="Pos-a T-0 B-0 Start-0 End-0 Ov-h Pos(a) T(0) B(0) Start(0) End(0) Ov(h)" data-reactid="6"><div id="defaultdestFSRVY" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col1-2-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col1-2-AdUnitWithTdAdsDone','PageStart','Col1-2-AdUnitWithTdAds');}</script></div></div></div><div class="Pos(a) W(300px) End(0) T(0) tablet_D(n)--noRightRail" data-reactid="33"><!-- react-empty: 34 --><div id="YDC-Col2" class="YDC-Col2" data-reactid="35"><div class="sticky-outer-wrapper" data-reactid="36"><div class="sticky-inner-wrapper" style="position:relative;top:0px;" data-reactid="37"><div id="YDC-Col2-Stack" class="YDC-Col2-Stack Pos(r) W(300px)" data-reactid="38"><div id="Aside" role="complementary" tabindex="-1" data-reactid="39"><div data-reactid="40"><div id="mrt-node-Col2-0-QuoteModule" data-locator="subtree-root"><div id="Col2-0-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1807209916"><div data-test="quote-mdl" data-reactid="2"></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-0-QuoteModule');window.performance.measure && window.performance.measure('Col2-0-QuoteModuleDone','PageStart','Col2-0-QuoteModule');}</script></div><div data-reactid="41"><div id="mrt-node-Col2-1-ComboAd" data-locator="subtree-root"><div id="Col2-1-ComboAd-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="1006025186"><div class="" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultLREC-sizer" class="darla-container D-n D(n)" data-reactid="5"><div id="defaultLREC-wrapper" class="" data-reactid="6"><div id="defaultdestLREC" style=""></div></div></div></div><div data-reactid="7"><div id="defaultMON-sizer" class="darla-container D-n D(n)" data-reactid="8"><div id="defaultMON-wrapper" class="" data-reactid="9"><div id="defaultdestMON" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-1-ComboAd');window.performance.measure && window.performance.measure('Col2-1-ComboAdDone','PageStart','Col2-1-ComboAd');}</script></div><div data-reactid="42"><div id="mrt-node-Col2-2-QuoteModule" data-locator="subtree-root"><div id="Col2-2-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2031559524"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-2-QuoteModule');window.performance.measure && window.performance.measure('Col2-2-QuoteModuleDone','PageStart','Col2-2-QuoteModule');}</script></div><div data-reactid="43"><div id="mrt-node-Col2-3-QuoteModule" data-locator="subtree-root"><div id="Col2-3-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2037588837"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-3-QuoteModule');window.performance.measure && window.performance.measure('Col2-3-QuoteModuleDone','PageStart','Col2-3-QuoteModule');}</script></div><div data-reactid="44"><div id="mrt-node-Col2-4-QuoteModule" data-locator="subtree-root"><div id="Col2-4-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2043618150"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-4-QuoteModule');window.performance.measure && window.performance.measure('Col2-4-QuoteModuleDone','PageStart','Col2-4-QuoteModule');}</script></div><div data-reactid="45"><div id="mrt-node-Col2-5-QuoteModule" data-locator="subtree-root"><div id="Col2-5-QuoteModule-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="2049647463"><span data-reactid="2"></span></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-5-QuoteModule');window.performance.measure && window.performance.measure('Col2-5-QuoteModuleDone','PageStart','Col2-5-QuoteModule');}</script></div><div data-reactid="46"><div id="mrt-node-Col2-6-AdUnitWithTdAds" data-locator="subtree-root"><div id="Col2-6-AdUnitWithTdAds-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="1411938822"><div class="ad-lrec2" data-reactid="2"><div data-reactid="3"><div data-reactid="4"><div id="defaultLREC2-sizer" class="darla-container D-n D(n)" data-reactid="5"><div id="defaultLREC2-wrapper" class="" data-reactid="6"><div id="defaultdestLREC2" style=""></div></div></div></div></div></div></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-6-AdUnitWithTdAds');window.performance.measure && window.performance.measure('Col2-6-AdUnitWithTdAdsDone','PageStart','Col2-6-AdUnitWithTdAds');}</script></div><div data-reactid="47"><div id="mrt-node-Col2-7-IFrame" data-locator="subtree-root"><div id="Col2-7-IFrame-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-1545003598"><!-- react-empty: 2 --></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-7-IFrame');window.performance.measure && window.performance.measure('Col2-7-IFrameDone','PageStart','Col2-7-IFrame');}</script></div><div data-reactid="48"><div id="mrt-node-Col2-8-LinkOut" data-locator="subtree-root"><div id="Col2-8-LinkOut-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="63982622"><a class="Mt(20px) Ta(c) btn btn-white W(100%)" href="https://smallbusiness.yahoo.com" data-reactid="2"><span data-reactid="3">Yahoo Small Business</span></a></div></div><script>if (window.performance) {window.performance.mark && window.performance.mark('Col2-8-LinkOut');window.performance.measure && window.performance.measure('Col2-8-LinkOutDone','PageStart','Col2-8-LinkOut');}</script></div><div data-reactid="49"><div id="mrt-node-Col2-9-Footer" data-locator="subtree-root"><div id="Col2-9-Footer-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="456383766"><div id="Col2-9-Footer" class="footer Ta(c) Bgc(#fff) Pb(15px) Pt(25px)" data-test="finance-footer" data-reactid="2"><div class="Fz(s) D(ib) Pb(10px) Pt(2px)" data-reactid="3"><div class="Pb(5px) D(b)" data-reactid="4"><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://help.yahoo.com/kb/index?page=content&y=PROD_FIN_DESK&locale=en_US&id=SLN2310" rel="nofollow" data-reactid="5"><span data-reactid="6">Data Disclaimer</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://help.yahoo.com/kb/index?page=content&y=PROD_FIN_DESK&locale=en_US" rel="nofollow" data-reactid="7"><span data-reactid="8">Help</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="https://yahoo.uservoice.com/forums/382977" rel="nofollow" data-reactid="9"><span data-reactid="10">Suggestions</span></a></div><div class="Pb(10px) D(b)" data-reactid="11"><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/privacy/us/yahoo/" rel="nofollow" data-reactid="12"><span data-reactid="13">Privacy</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/relevantads/" rel="nofollow" data-reactid="14"><span data-reactid="15">About Our Ads</span></a><a class="Mend(10px) C($grey6) C($c-fuji-blue-1-b):h" href="http://info.yahoo.com/legal/us/yahoo/utos/utos-173.html" rel="nofollow" data-reactid="16"><span data-reactid="17">Terms (Updated)</span></a></div></div><div class="D(b)" data-reactid="18"><img src="https://s.yimg.com/os/finance/dd-site/img/Oath_YFin_Logo_EN.svg" alt="Oath: Yahoo Finance" class="Pend(20px) W(120px)" data-reactid="19"/><ul class="follow-button-group M(0) Va(m) D(ib) Ta(c)" data-reactid="20"><li class="D(ib) M(0) Cur(p) twitter" style="width:34px;height:34px;line-height:34px;" title="Follow on Twitter" data-reactid="21"><a class="Td(n) C(#000)" href="https://twitter.com/YahooFinance" target="_blank" data-reactid="22"><svg class="Va(m)! Cur(p)" width="18" style="fill:black;stroke:black;stroke-width:0;vertical-align:bottom;" height="18" viewBox="0 0 32 32" data-icon="LogoTwitter" data-reactid="23"><path d="M30.402 7.094c-1.058.47-2.198.782-3.392.928 1.218-.725 2.154-1.885 2.595-3.256-1.134.674-2.405 1.165-3.75 1.43-1.077-1.148-2.612-1.862-4.31-1.862-3.268 0-5.915 2.635-5.915 5.893 0 .464.056.91.155 1.34-4.915-.244-9.266-2.59-12.18-6.158-.51.87-.806 1.885-.806 2.96 0 2.044 1.045 3.847 2.633 4.905-.974-.032-1.883-.3-2.68-.736v.07c0 2.857 2.034 5.236 4.742 5.773-.498.138-1.022.21-1.56.21-.38 0-.75-.034-1.11-.103.75 2.344 2.93 4.042 5.518 4.09-2.024 1.58-4.57 2.523-7.333 2.523-.478 0-.952-.032-1.41-.085 2.613 1.674 5.72 2.65 9.054 2.65 10.872 0 16.814-8.976 16.814-16.765 0-.254-.008-.507-.018-.762 1.155-.83 2.155-1.868 2.95-3.047z" data-reactid="24"></path></svg></a></li><li class="D(ib) M(0) Cur(p) facebook" style="width:34px;height:34px;line-height:34px;" title="Follow on Facebook" data-reactid="25"><a class="Td(n) C(#000)" href="https://facebook.com/yahoofinance" target="_blank" data-reactid="26"><svg class="Va(m)! Cur(p)" width="18" style="fill:black;stroke:black;stroke-width:0;vertical-align:bottom;" height="18" viewBox="0 0 32 32" data-icon="LogoFacebook" data-reactid="27"><path d="M12.752 30.4V16.888H9.365V12.02h3.387V7.865c0-3.264 2.002-6.264 6.613-6.264 1.866 0 3.248.19 3.248.19l-.11 4.54s-1.404-.013-2.943-.013c-1.66 0-1.93.81-1.93 2.152v3.553h5.008l-.22 4.867h-4.786V30.4h-4.88z" data-reactid="28"></path></svg></a></li><li class="D(ib) M(0) Cur(p) tumblr" style="width:34px;height:34px;line-height:34px;" title="Follow on Tumblr" data-reactid="29"><a class="Td(n) C(#000)" href="http://yahoofinance.tumblr.com" target="