Kamis, 04 Desember 2014

[smf_addin] Digest Number 3257

14 Messages

Digest #3257
1a
AdvFN & Get Table Cell by stevenletzer
1b
Re: AdvFN & Get Table Cell by "Randy Harmelink" rharmelink
1c
1d
Re: AdvFN & Get Table Cell by "Randy Harmelink" rharmelink
2a
Morningstar Key Ratios by "Jose Jacob" pepecan47
2b
Re: Morningstar Key Ratios by "Randy Harmelink" rharmelink
2c
Re: Morningstar Key Ratios by "Jose Jacob" pepecan47
2d
Re: Morningstar Key Ratios by "Randy Harmelink" rharmelink
2e
Re: Morningstar Key Ratios by "Jose Jacob" pepecan47
2f
Re: Morningstar Key Ratios by "Randy Harmelink" rharmelink

Messages

Wed Dec 3, 2014 10:58 am (PST) . Posted by:

stevenletzer

This should be a no brainer, but i have spent all day with no success. At the web site advfn, I am trying to import all of the the info on the financial page. I have used every variation of gettablecell that I can think of, with no results
http://www.advfn.com/exchanges/NYSE/TOT/financials http://www.advfn.com/exchanges/NYSE/TOT/financials
This is the type of info, but not limited to all data points on the page.

PE Ratio - LTM 11.6 Market Capitalisation 128,114.6 mil Latest Shares Outstanding 2,275.2 mil Earnings pS (EPS) 5.15 $ Dividend pS (DPS) 2.57 ¢ Dividend Yield 5.9 % Dividend Payout Ratio 1 %
DIVIDEND INFO Dividend Declared Date 05/29/2013 Dividend Ex-Date 06/18/2013 Dividend Record Date 06/20/2013 Dividend Pay Date 07/18/2013 Dividend Amount 539 Type of Payment Cash Payment Dividend Rate 2.57 Current Dividend Yield 5.9 5-Y Average Dividend Yield 5.
GROWTH RATES 5-Year
Growh R² of 5-Year Growth 3-Year
Growth Revenue 0.01 0.2 0.08 Income -0.05 0.0 -0.06 Dividend -0.04 0.2 0.01 Capital Spending 0.03 NA 0.06 R&D 0.00 NA 0.00 Normalized Inc. -4.02 NA 1.58

Wed Dec 3, 2014 11:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The most basic version of the function worked fine for me:

=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/TOT/financials",1,">PE
Ratio")

=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/TOT/financials",1,">Dividend
Ex-Date")

By the way, did you notice those dividend dates are over a year old? :(

On Wed, Dec 3, 2014 at 11:58 AM, stevenletzer@...wrote:

> This should be a no brainer, but i have spent all day with no success.
> At the web site advfn, I am trying to import all of the the info on the
> financial page. I have used every variation of gettablecell that I can
> think of, with no results
>
> http://www.advfn.com/exchanges/NYSE/TOT/financials
>
> This is the type of info, but not limited to all data points on the page.
> PE Ratio - LTM11.6Market Capitalisation128,114.6milLatest Shares
> Outstanding2,275.2milEarnings pS (EPS)5.15$Dividend pS (DPS)2.57¢Dividend
> Yield5.9%Dividend Payout Ratio1%
>
>
> DIVIDEND INFODividend Declared Date05/29/2013Dividend Ex-Date06/18/2013Dividend
> Record Date06/20/2013Dividend Pay Date07/18/2013Dividend Amount539Type of
> PaymentCash PaymentDividend Rate2.57Current Dividend Yield5.95-Y Average
> Dividend Yield
>
> 5.
> GROWTH RATES5-Year
> GrowhR² of 5-Year Growth3-Year
> GrowthRevenue0.010.20.08Income-0.050.0-0.06Dividend-0.040.20.01Capital
> Spending0.03NA0.06R&D0.00NA0.00Normalized Inc.-4.02NA1.58
>

Wed Dec 3, 2014 1:19 pm (PST) . Posted by:

stevenletzer

Thank you,
I am using this table for TTM data and need to reference other cells for the formula. For example:
Cell A6 = the symbol, in this case MMM
Cell B6 = the exchange, in this case NYSE
Cell C6 = the data point, in this case PE Ratio - LTM

My formula should be
RCHGetTableCell("http://www.advfn.com/exchanges/"&A6&"/"&B6&";/financials",1,">"&C6), but it does not work.

What do you think?

Wed Dec 3, 2014 1:29 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It doesn't work because you have the ticker symbol and exchange in the
wrong order in your constructed URL. Exchange either the values or the cell
references and it works fine.

On Wed, Dec 3, 2014 at 2:19 PM, stevenletzer@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am using this table for TTM data and need to reference other cells for
> the formula. For example:
>
> Cell A6 = the symbol, in this case MMM
>
> Cell B6 = the exchange, in this case NYSE
>
> Cell C6 = the data point, in this case PE Ratio - LTM
>
> My formula should be
>
> RCHGetTableCell("http://www.advfn.com/exchanges/"&A6&"/"&B6&";/financials&quot;,1,">"&C6),
> but it does not work.
>
> What do you think?
>
>

Wed Dec 3, 2014 11:00 am (PST) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - is there any way to extract a particular value from:

http://financials.morningstar.com/ratios/r.html?t=MCD without having to export the .CVS file to another worksheet?

I am particularly interested in "Earnings Per Share USD"  TTM, 5.09
and "Dividends USD" TTM, 3.24

Regards,
Jose L. Jacob

Wed Dec 3, 2014 11:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Same answer as before:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27471

But you do have to look at the source code on that web page to determine
which "i*" identifier to use, and change which "Y*" offset (i.e. Y0 =
oldest, Y9 = most recent, Y10 = TTM) to use. In this case:

=smfConvertData(smfstrExtr(RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?t=MCD","""Y10
i5\""",20),">","<"))

=smfConvertData(smfstrExtr(RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?t=MCD","""Y10
i6\""",20),">","<"))

On Wed, Dec 3, 2014 at 12:00 PM, Jose Jacob pepecan47@... wrote:

> Hi Randy - is there any way to extract a particular value from:
>
> http://financials.morningstar.com/ratios/r.html?t=MCD without having to
> export the .CVS file to another worksheet?
>
> I am particularly interested in "Earnings Per Share USD" TTM, 5.09
> and "Dividends USD" TTM, 3.24
>

Wed Dec 3, 2014 1:42 pm (PST) . Posted by:

"Jose Jacob" pepecan47

Randy, when I copy the formulas into my spreadsheet, I don't get any values.

When I try to open with IE http://financials.morningstar.com/financials/getFinancePart.html?t=MCD

I get a pop up "Do you want to open or save getFinancePart.json form financial.morningstart.com?"

I click "open" and then I have to select an application.

Can't figure out how to make this thing work.

Regards,
Jose L. Jacob

--------------------------------------------
On Wed, 12/3/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar Key Ratios
To: smf_addin@yahoogroups.com
Received: Wednesday, December 3, 2014, 2:44 PM


 









Same answer as before: https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27471

But you do have to look
at the source code on that web page to determine which
"i*" identifier to use, and change which
"Y*" offset (i.e. Y0 = oldest, Y9 = most recent,
Y10 = TTM) to use. In this case:

=smfConvertData(smfstrExtr(RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?t=MCD","""Y10
i5\""",20),">","<"))

=smfConvertData(smfstrExtr(RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?t=MCD","""Y10
i6\""",20),">","<"))


On Wed, Dec 3, 2014 at
12:00 PM, Jose Jacob pepecan47@...
wrote:
Hi Randy - is
there any way to extract a particular value from:



http://financials.morningstar.com/ratios/r.html?t=MCD
without having to export the .CVS file to another
worksheet?



I am particularly interested in "Earnings Per Share
USD"  TTM, 5.09

and "Dividends USD" TTM, 3.24












#yiv7499819424 #yiv7499819424 --
#yiv7499819424ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7499819424 #yiv7499819424ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7499819424 #yiv7499819424ygrp-mkp #yiv7499819424hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7499819424 #yiv7499819424ygrp-mkp #yiv7499819424ads {
margin-bottom:10px;}

#yiv7499819424 #yiv7499819424ygrp-mkp .yiv7499819424ad {
padding:0 0;}

#yiv7499819424 #yiv7499819424ygrp-mkp .yiv7499819424ad p {
margin:0;}

#yiv7499819424 #yiv7499819424ygrp-mkp .yiv7499819424ad a {
color:#0000ff;text-decoration:none;}
#yiv7499819424 #yiv7499819424ygrp-sponsor
#yiv7499819424ygrp-lc {
font-family:Arial;}

#yiv7499819424 #yiv7499819424ygrp-sponsor
#yiv7499819424ygrp-lc #yiv7499819424hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7499819424 #yiv7499819424ygrp-sponsor
#yiv7499819424ygrp-lc .yiv7499819424ad {
margin-bottom:10px;padding:0 0;}

#yiv7499819424 #yiv7499819424actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7499819424 #yiv7499819424activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv7499819424 #yiv7499819424activity span {
font-weight:700;}

#yiv7499819424 #yiv7499819424activity span:first-child {
text-transform:uppercase;}

#yiv7499819424 #yiv7499819424activity span a {
color:#5085b6;text-decoration:none;}

#yiv7499819424 #yiv7499819424activity span span {
color:#ff7900;}

#yiv7499819424 #yiv7499819424activity span
.yiv7499819424underline {
text-decoration:underline;}

#yiv7499819424 .yiv7499819424attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7499819424 .yiv7499819424attach div a {
text-decoration:none;}

#yiv7499819424 .yiv7499819424attach img {
border:none;padding-right:5px;}

#yiv7499819424 .yiv7499819424attach label {
display:block;margin-bottom:5px;}

#yiv7499819424 .yiv7499819424attach label a {
text-decoration:none;}

#yiv7499819424 blockquote {
margin:0 0 0 4px;}

#yiv7499819424 .yiv7499819424bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7499819424 .yiv7499819424bold a {
text-decoration:none;}

#yiv7499819424 dd.yiv7499819424last p a {
font-family:Verdana;font-weight:700;}

#yiv7499819424 dd.yiv7499819424last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7499819424 dd.yiv7499819424last p
span.yiv7499819424yshortcuts {
margin-right:0;}

#yiv7499819424 div.yiv7499819424attach-table div div a {
text-decoration:none;}

#yiv7499819424 div.yiv7499819424attach-table {
width:400px;}

#yiv7499819424 div.yiv7499819424file-title a, #yiv7499819424
div.yiv7499819424file-title a:active, #yiv7499819424
div.yiv7499819424file-title a:hover, #yiv7499819424
div.yiv7499819424file-title a:visited {
text-decoration:none;}

#yiv7499819424 div.yiv7499819424photo-title a,
#yiv7499819424 div.yiv7499819424photo-title a:active,
#yiv7499819424 div.yiv7499819424photo-title a:hover,
#yiv7499819424 div.yiv7499819424photo-title a:visited {
text-decoration:none;}

#yiv7499819424 div#yiv7499819424ygrp-mlmsg
#yiv7499819424ygrp-msg p a span.yiv7499819424yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7499819424 .yiv7499819424green {
color:#628c2a;}

#yiv7499819424 .yiv7499819424MsoNormal {
margin:0 0 0 0;}

#yiv7499819424 o {
font-size:0;}

#yiv7499819424 #yiv7499819424photos div {
float:left;width:72px;}

#yiv7499819424 #yiv7499819424photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv7499819424 #yiv7499819424photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7499819424 #yiv7499819424reco-category {
font-size:77%;}

#yiv7499819424 #yiv7499819424reco-desc {
font-size:77%;}

#yiv7499819424 .yiv7499819424replbq {
margin:4px;}

#yiv7499819424 #yiv7499819424ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg select,
#yiv7499819424 input, #yiv7499819424 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg pre, #yiv7499819424
code {
font:115% monospace;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg * {
line-height:1.22em;}

#yiv7499819424 #yiv7499819424ygrp-mlmsg #yiv7499819424logo {
padding-bottom:10px;}


#yiv7499819424 #yiv7499819424ygrp-msg p a {
font-family:Verdana;}

#yiv7499819424 #yiv7499819424ygrp-msg
p#yiv7499819424attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7499819424 #yiv7499819424ygrp-reco
#yiv7499819424reco-head {
color:#ff7900;font-weight:700;}

#yiv7499819424 #yiv7499819424ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7499819424 #yiv7499819424ygrp-sponsor #yiv7499819424ov
li a {
font-size:130%;text-decoration:none;}

#yiv7499819424 #yiv7499819424ygrp-sponsor #yiv7499819424ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7499819424 #yiv7499819424ygrp-sponsor #yiv7499819424ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7499819424 #yiv7499819424ygrp-text {
font-family:Georgia;}

#yiv7499819424 #yiv7499819424ygrp-text p {
margin:0 0 1em 0;}

#yiv7499819424 #yiv7499819424ygrp-text tt {
font-size:120%;}

#yiv7499819424 #yiv7499819424ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7499819424


Wed Dec 3, 2014 1:58 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you try to open it in IE, you'll need to save it. Then you can view the
saved copy of the source code. Or maybe select Notepad as your application
of choice?

But I'm not sure what to tell you if the formulas aren't working for you,
since your machine is acting differently than mine.

Hmmm. What do you get with:

=RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?t=MCD
",1,100)
=RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?t=MCD
","i5")

On Wed, Dec 3, 2014 at 2:35 PM, Jose Jacob pepecan47@... wrote:

> Randy, when I copy the formulas into my spreadsheet, I don't get any
> values.
>
> When I try to open with IE
> http://financials.morningstar.com/financials/getFinancePart.html?t=MCD
>
> I get a pop up "Do you want to open or save getFinancePart.json form
> financial.morningstart.com?"
>
> I click "open" and then I have to select an application.
>
> Can't figure out how to make this thing work.
>
>
>

Wed Dec 3, 2014 7:37 pm (PST) . Posted by:

"Jose Jacob" pepecan47

=RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?t=MCD",1,100)
Error--too many wep page retrievals

=RCHGetWebData(".mornihttp://financialsngstar.com/financials/getFinancePart.html?t=MCD","i5")
Error

Regards,
Jose L. Jacob

--------------------------------------------
On Wed, 12/3/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar Key Ratios
To: smf_addin@yahoogroups.com
Received: Wednesday, December 3, 2014, 4:58 PM


 









If you try to open it
in IE, you'll need to save it. Then you can view the
saved copy of the source code. Or maybe select Notepad as
your application of choice?

But I'm not sure what to tell you if
the formulas aren't working for you, since your machine
is acting differently than mine.

Hmmm. What do you get with:

=RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?t=MCD",1,100)
=RCHGetWebData(".mornihttp://financialsngstar.com/financials/getFinancePart.html?t=MCD","i5")

On Wed, Dec 3, 2014 at 2:35
PM, Jose Jacob pepecan47@... wrote:
Randy, when I copy the formulas into my
spreadsheet, I don't get any values.



When I try to open with IE http://financials.morningstar.com/financials/getFinancePart.html?t=MCD



I get a pop up "Do you want to open or save
getFinancePart.json form financial.morningstart.com?"



I click "open" and then I have to select an
application.



Can't figure out how to make this thing work.

















#yiv0368411107 #yiv0368411107 --
#yiv0368411107ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0368411107 #yiv0368411107ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0368411107 #yiv0368411107ygrp-mkp #yiv0368411107hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0368411107 #yiv0368411107ygrp-mkp #yiv0368411107ads {
margin-bottom:10px;}

#yiv0368411107 #yiv0368411107ygrp-mkp .yiv0368411107ad {
padding:0 0;}

#yiv0368411107 #yiv0368411107ygrp-mkp .yiv0368411107ad p {
margin:0;}

#yiv0368411107 #yiv0368411107ygrp-mkp .yiv0368411107ad a {
color:#0000ff;text-decoration:none;}
#yiv0368411107 #yiv0368411107ygrp-sponsor
#yiv0368411107ygrp-lc {
font-family:Arial;}

#yiv0368411107 #yiv0368411107ygrp-sponsor
#yiv0368411107ygrp-lc #yiv0368411107hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0368411107 #yiv0368411107ygrp-sponsor
#yiv0368411107ygrp-lc .yiv0368411107ad {
margin-bottom:10px;padding:0 0;}

#yiv0368411107 #yiv0368411107actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0368411107 #yiv0368411107activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0368411107 #yiv0368411107activity span {
font-weight:700;}

#yiv0368411107 #yiv0368411107activity span:first-child {
text-transform:uppercase;}

#yiv0368411107 #yiv0368411107activity span a {
color:#5085b6;text-decoration:none;}

#yiv0368411107 #yiv0368411107activity span span {
color:#ff7900;}

#yiv0368411107 #yiv0368411107activity span
.yiv0368411107underline {
text-decoration:underline;}

#yiv0368411107 .yiv0368411107attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0368411107 .yiv0368411107attach div a {
text-decoration:none;}

#yiv0368411107 .yiv0368411107attach img {
border:none;padding-right:5px;}

#yiv0368411107 .yiv0368411107attach label {
display:block;margin-bottom:5px;}

#yiv0368411107 .yiv0368411107attach label a {
text-decoration:none;}

#yiv0368411107 blockquote {
margin:0 0 0 4px;}

#yiv0368411107 .yiv0368411107bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0368411107 .yiv0368411107bold a {
text-decoration:none;}

#yiv0368411107 dd.yiv0368411107last p a {
font-family:Verdana;font-weight:700;}

#yiv0368411107 dd.yiv0368411107last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0368411107 dd.yiv0368411107last p
span.yiv0368411107yshortcuts {
margin-right:0;}

#yiv0368411107 div.yiv0368411107attach-table div div a {
text-decoration:none;}

#yiv0368411107 div.yiv0368411107attach-table {
width:400px;}

#yiv0368411107 div.yiv0368411107file-title a, #yiv0368411107
div.yiv0368411107file-title a:active, #yiv0368411107
div.yiv0368411107file-title a:hover, #yiv0368411107
div.yiv0368411107file-title a:visited {
text-decoration:none;}

#yiv0368411107 div.yiv0368411107photo-title a,
#yiv0368411107 div.yiv0368411107photo-title a:active,
#yiv0368411107 div.yiv0368411107photo-title a:hover,
#yiv0368411107 div.yiv0368411107photo-title a:visited {
text-decoration:none;}

#yiv0368411107 div#yiv0368411107ygrp-mlmsg
#yiv0368411107ygrp-msg p a span.yiv0368411107yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0368411107 .yiv0368411107green {
color:#628c2a;}

#yiv0368411107 .yiv0368411107MsoNormal {
margin:0 0 0 0;}

#yiv0368411107 o {
font-size:0;}

#yiv0368411107 #yiv0368411107photos div {
float:left;width:72px;}

#yiv0368411107 #yiv0368411107photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0368411107 #yiv0368411107photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0368411107 #yiv0368411107reco-category {
font-size:77%;}

#yiv0368411107 #yiv0368411107reco-desc {
font-size:77%;}

#yiv0368411107 .yiv0368411107replbq {
margin:4px;}

#yiv0368411107 #yiv0368411107ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg select,
#yiv0368411107 input, #yiv0368411107 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg pre, #yiv0368411107
code {
font:115% monospace;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg * {
line-height:1.22em;}

#yiv0368411107 #yiv0368411107ygrp-mlmsg #yiv0368411107logo {
padding-bottom:10px;}


#yiv0368411107 #yiv0368411107ygrp-msg p a {
font-family:Verdana;}

#yiv0368411107 #yiv0368411107ygrp-msg
p#yiv0368411107attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0368411107 #yiv0368411107ygrp-reco
#yiv0368411107reco-head {
color:#ff7900;font-weight:700;}

#yiv0368411107 #yiv0368411107ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0368411107 #yiv0368411107ygrp-sponsor #yiv0368411107ov
li a {
font-size:130%;text-decoration:none;}

#yiv0368411107 #yiv0368411107ygrp-sponsor #yiv0368411107ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0368411107 #yiv0368411107ygrp-sponsor #yiv0368411107ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0368411107 #yiv0368411107ygrp-text {
font-family:Georgia;}

#yiv0368411107 #yiv0368411107ygrp-text p {
margin:0 0 1em 0;}

#yiv0368411107 #yiv0368411107ygrp-text tt {
font-size:120%;}

#yiv0368411107 #yiv0368411107ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0368411107


Wed Dec 3, 2014 8:05 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That means you've accessed the 1000 web page limit per session of the
add-in. You'll need to exit EXCEL and restart it, then try the functions
I've given you again. Or, use the smfForceRecalculation macro to purge all
of the 1000 saved web pages and start over.

How come you're accessing so many web pages?

On Wed, Dec 3, 2014 at 8:37 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> =RCHGetWebData("
> http://financials.morningstar.com/financials/getFinancePart.html?t=MCD
> ",1,100)
> Error--too many wep page retrievals
>
>

Wed Dec 3, 2014 8:38 pm (PST) . Posted by:

harry144g

Hi -

I was wondering if there is a way to retrieve the industry and/or sector for a ticker symbol using RCHGetYahooQuotes. For example, T (AT&T) is Telecommunications, and C (Citibank) is Financial Services, etc.


I couldn't find anything in the documentation that indicated this was available:-( If that function can't do it, is there some other easy way to extract that data?


Thanks!


HarryG

Wed Dec 3, 2014 9:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but Yahoo doesn't provide the industry or the sector on the CSV file
that RCHGetYahooQuotes() uses.

Right now, the two ways I know of to get the data:

1. Extract it from a web page, ticker by ticker. This will be slow if you
have a lot of ticker symbols. But it does only need to be done once.

2. Use the Zacks screener. For example, filter on anything with a price
over $5 and export the CSV file with the sector and industry fields. That
gives me about 6000 companies. Then you can do a VLOOKUP() on the export
results to get the sector and industry values you want.

On Wed, Dec 3, 2014 at 9:38 PM, harry@harry144.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I was wondering if there is a way to retrieve the industry and/or sector
> for a ticker symbol using RCHGetYahooQuotes. For example, T (AT&T) is
> Telecommunications, and C (Citibank) is Financial Services, etc.
>
> I couldn't find anything in the documentation that indicated this was
> available:-( If that function can't do it, is there some other easy way to
> extract that data?
>

Wed Dec 3, 2014 9:16 pm (PST) . Posted by:

tzewei_79

Hi Randy,

I was using the function and it was fine until I reach some ticker and it return "#value" where A26 is JMP.


=smfConvertData(smfstrExtr(RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t="&A26,"""Y10 i91\""",20),">","<"))/100



What does it mean if it returns #value? Is there a limit to use smfconvert? I can see the same formula works if I enter it in a new excel on another pc.

Wed Dec 3, 2014 9:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

There is no limit to smfConvert(), but there would be for RCHGetWebData().
What's probably happening is the RCHGetWebData() function is returning an
"Error" result, and then you're trying to divide that by 100. That would
cause the #VALUE result.

Just take off the division by 100 and you'll see what the add-in is
returning.

On Wed, Dec 3, 2014 at 10:16 PM, tzewei_79@...wrote:

>
>
> I was using the function and it was fine until I reach some ticker and it
> return "#value" where A26 is JMP.
>
> =smfConvertData(smfstrExtr(RCHGetWebData("
> http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t="&A26,"""Y10
> i91\""",20),">","<"))/100
>
> What does it mean if it returns #value? Is there a limit to use
> smfconvert? I can see the same formula works if I enter it in a new excel
> on another pc.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)