Minggu, 30 Juli 2017

[smf_addin] Digest Number 4106

11 Messages

Digest #4106
2b

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")

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?

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?
>
>

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
>

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-Footer&#39;);window.performance.measure && window.performance.measure(&#39;Col2-9-FooterDone&#39;,'PageStart&#39;,'Col2-9-Footer&#39;);}</script></div></div></div></div></div></div></div></div><div id="YDC-Overlay" class="YDC-Overlay"; data-reactid="50"><div id="YDC-Overlay-Stack&quot; 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-Lightbox&#39;);window.performance.measure && window.performance.measure(&#39;Overlay-0-LightboxDone&#39;,'PageStart&#39;,'Overlay-0-Lightbox&#39;);}</script></div><div data-reactid="54"><div id="mrt-node-Overlay-1-ChartToolTip&quot; data-locator="subtree-root"><div id="Overlay-1-ChartToolTip-Proxy" data-reactroot="" data-reactid="1" data-react-checksum="-566015715"><div id="quote-chart-tooltip&quot; 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-ChartToolTip&#39;);window.performance.measure && window.performance.measure(&#39;Overlay-1-ChartToolTipDone',&#39;PageStart&#39;,'Overlay-1-ChartToolTip&#39;);}</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&quot; 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&quot; 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);} catch (e) {console.warn(name + ' could not be marked:',e);}};};window._perfMeasure = function _perfMeasure (name, start, end) {if (window.performance && window.performance.measure){try {if (window.performance.getEntriesByName("NAVIGATE_START") && window.performance.getEntriesByName("NAVIGATE_START")[0]) { start = "CL_" + start ;end = "CL_" + end ;name = "CL_" + name ;}window.performance.measure(name, start, end);} catch (e) {console.warn(name + ' could not be added:',e);}};};window._pushAdPerfMetric = function _pushAdPerfMetric(key) {if (window.performance && window.performance.now) {_adPerfData.push([key, Math.round(window.performance.now())]);}};window._fireAdPerfBeacon = function _fireAdPerfBeacon(eventName) {try {if (window && window.rapidInstance && window.performance) {var navClickMark = window.performance.getEntriesByName('NAVIGATE_START') &&window.performance.getEntriesByName('NAVIGATE_START').pop();var navClickTime = navClickMark && navClickMark.startTime || 0;var userTime = {};window.performance.getEntries().forEach(function forEachPerfTime (item) {if (item.name.search('DARLA_') > -1) {if (item.entryType === "mark") {userTime[item.name] = Math.round(item.startTime) - navClickTime;window.performance.clearMarks(item.name);} else if (item.entryType === "measure") {userTime[item.name] = Math.round(item.duration);window.performance.clearMeasures(item.name);}}});var perfData = {perf_usertime: {utm: userTime}};window.rapidInstance.beaconPerformanceData(perfData);}} catch (e) {console.warn('Could not send the beacon:',e);}};window.DARLA_CONFIG = {"debug":false,"dm":1,"autoRotation":10000,"rotationTimingDisabled":true,"k2":{"res":{"rate&quot;:5,"pos":["BTN";,"BTN-1","BTN-2","BTN-3","BTN1","LREC";,"LREC2&quot;,"LREC3","LDRB";,"MAST&quot;]}},"positions":{"DEFAULT&quot;:{"name":"DEFAULT&quot;,"enable":true,"fallback":null,"metaSize":false,"staticLayout&quot;:false,"clean";:"defaultcleanDEFAULT";,"dest&quot;:"defaultdestDEFAULT","id":"DEFAULT&quot;},"BTN1":{"id":"BTN1";,"clean&quot;:"defaultcleanBTN1","dest":"defaultdestBTN1","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN1-1":{"id":"BTN1";,"clean&quot;:"defaultcleanBTN1-1","dest":"defaultdestBTN1-1","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN":{"id":"BTN","clean&quot;:"defaultcleanBTN&quot;,"dest":"defaultdestBTN","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-1":{"id":"BTN-1","clean":"defaultcleanBTN-1","dest";:"defaultdestBTN-1","w":120,"h":60,"enable&quot;:true,"fallback":null,"metaSize":false,"staticLayout&quot;:false},"BTN-2":{"id":"BTN-2","clean":"defaultcleanBTN-2","dest";:"defaultdestBTN-2","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-3":{"id":"BTN-3","clean":"defaultcleanBTN-3","dest";:"defaultdestBTN-3","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-5":{"id":"BTN-5","clean":"defaultcleanBTN-5","dest";:"defaultdestBTN-5","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-6":{"id":"BTN-6","clean":"defaultcleanBTN-6","dest";:"defaultdestBTN-6","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-7":{"id":"BTN-7","clean":"defaultcleanBTN-7","dest";:"defaultdestBTN-7","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"BTN-8":{"id":"BTN-8","clean":"defaultcleanBTN-8","dest";:"defaultdestBTN-8","metaSize&quot;:true,"w":120,"h":60,"enable&quot;:true,"fallback":null,"staticLayout&quot;:false},"FOOT";:{"id":"FOOT","clean&quot;:"defaultcleanFOOT","dest":"defaultdestFOOT","fr":"expIfr_exp","failed&quot;:true,"enable&quot;:true,"fallback":null,"metaSize":false,"staticLayout&quot;:false},"FSRVY&quot;:{"id":"FSRVY";,"clean&quot;:"defaultcleanFSRVY","dest":"defaultdestFSRVY","fr":"expIfr_exp","failed&quot;:true,"enable&quot;:true,"fallback":null,"metaSize":false,"staticLayout&quot;:false},"SCREC&quot;:{"id":"SCREC";,"clean&quot;:"defaultcleanSCREC","dest":"defaultdestSCREC","w":300,"h":65,"enable&quot;:true,"fallback":null,"metaSize":false,"staticLayout&quot;:false},"LREC";:{"id":"LREC","clean&quot;:"defaultcleanLREC","dest":"defaultdestLREC","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"failed":true,"enable":true,"fallback":null,"metaSize":false},"LREC-9":{"id":"LREC-9","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"clean":"defaultcleanLREC-9","dest";:"defaultdestLREC-9","enable&quot;:true,"fallback&quot;:null,"metaSize&quot;:false},"LREC2&quot;:{"id":"LREC2";,"clean&quot;:"defaultcleanLREC2","dest":"defaultdestLREC2","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"failed":true,"enable":true,"fallback":null,"metaSize":false},"LREC2-4":{"id":"LREC2-4","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC2-4","dest":"defaultdestLREC2-4","fallback&quot;:null,"metaSize&quot;:false},"LREC2-5":{"id":"LREC2-5","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC2-5","dest":"defaultdestLREC2-5","fallback&quot;:null,"metaSize&quot;:false},"LREC2-6":{"id":"LREC2-6","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC2-6","dest":"defaultdestLREC2-6","fallback&quot;:null,"metaSize&quot;:false},"LREC2-7":{"id":"LREC2-7","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC2-7","dest":"defaultdestLREC2-7","fallback&quot;:null,"metaSize&quot;:false},"LREC2-8":{"id":"LREC2-8","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC2-8","dest":"defaultdestLREC2-8","fallback&quot;:null,"metaSize&quot;:false},"LREC2-9":{"id":"LREC2-9","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"clean":"defaultcleanLREC2-9","dest":"defaultdestLREC2-9","enable&quot;:true,"fallback&quot;:null,"metaSize&quot;:false},"LREC3&quot;:{"id":"LREC3";,"clean&quot;:"defaultcleanLREC3","dest":"defaultdestLREC3","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"enable":true,"fallback":null,"metaSize":false},"LREC3-4":{"id":"LREC3-4","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC3-4","dest":"defaultdestLREC3-4","fallback&quot;:null,"metaSize&quot;:false},"LREC3-5":{"id":"LREC3-5","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC3-5","dest":"defaultdestLREC3-5","fallback&quot;:null,"metaSize&quot;:false},"LREC3-6":{"id":"LREC3-6","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC3-6","dest":"defaultdestLREC3-6","fallback&quot;:null,"metaSize&quot;:false},"LREC3-7":{"id":"LREC3-7","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC3-7","dest":"defaultdestLREC3-7","fallback&quot;:null,"metaSize&quot;:false},"LREC3-8":{"id":"LREC3-8","w":300,"h":250,"autoFetch":false,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"enable":true,"staticLayout&quot;:true,"fdb":true,"z":9,"clean";:"defaultcleanLREC3-8","dest":"defaultdestLREC3-8","fallback&quot;:null,"metaSize&quot;:false},"LREC3-9":{"id":"LREC3-9","w":300,"h":250,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"clean":"defaultcleanLREC3-9","dest":"defaultdestLREC3-9","enable&quot;:true,"fallback&quot;:null,"metaSize&quot;:false},"LDRB";:{"id":"LDRB","clean&quot;:"defaultcleanLDRB","dest":"defaultdestLDRB","w":728,"h":90,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"enable":true,"fallback":null,"metaSize":false},"LDRB-9":{"id":"LDRB-9","w":728,"h":90,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"clean":"defaultcleanLDRB-9","dest";:"defaultdestLDRB-9","enable&quot;:true,"fallback&quot;:null,"metaSize&quot;:false},"LDRB2&quot;:{"id":"LDRB2";,"clean&quot;:"defaultcleanLDRB2","dest":"defaultdestLDRB2","w":728,"h":90,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"enable":true,"fallback":null,"metaSize":false},"LDRB2-1":{"id":"LDRB2-1","w":728,"h":90,"fr":"expIfr_exp","supports&quot;:{"exp-ovr":1,"exp-push":1},"staticLayout&quot;:true,"fdb":true,"clean":"defaultcleanLDRB2-1","dest":"defaultdestLDRB2-1","enable&quot;:true,"fallback&quot;:null,"metaSize&quot;:false},

Sat Jul 29, 2017 11:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like this (and element #559) should work, based on what your
RCHGetWebData() function returned:

=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=CATO",3,">EPS
Trend","CURRENT ESTIMATE")

The "Error in formula" was an extra character at the end that Yahoo must
have inserted. All you had to do was delete it.

On Sat, Jul 29, 2017 at 10:42 PM, pmanz@
​...
wrote:

>
> 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",3,">EPS
> Trend","CURRENT ESTIMATE")​
> ​
> Excel says Error in formula
> =RCHGetTableCell("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","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 cla
>

Sun Jul 30, 2017 6:43 am (PDT) . Posted by:

mokwit

Randy, many thanks for your help. Back up and running after updating definition files.

Sun Jul 30, 2017 10:54 am (PDT) . Posted by:

pete_cook2001

Aside from the actual data elements returned, are there significant differences, including performance, among the various optionquotes functions (smfGetOptionQuotes, smfGetBarChartOptionQuote, smfGetMSNOptionQuote, etc.)?

Sun Jul 30, 2017 11:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

smfGetOptionQuotes() is just a top-level function that calls the others. It
allows the use of the "option ticker" that is easier to read and consistent
between sources.

On Sun, Jul 30, 2017 at 10:54 AM, peterscottcook@
​...
wrote:

> Aside from the actual data elements returned, are there significant
> differences, including performance, among the various optionquotes
> functions (smfGetOptionQuotes, smfGetBarChartOptionQuote, smfGetMSNOptionQuote,
> etc.)?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar