Kamis, 19 Januari 2017

[smf_addin] Digest Number 3894

8 Messages

Digest #3894

Messages

Wed Jan 18, 2017 3:07 am (PST) . Posted by:

oldabuelo

Randy .... this is the Yahoo page I am currently getting the info from ....

http://finance.yahoo.com/quote/A/key-statistics?p=A http://finance.yahoo.com/quote/A/key-statistics?p=A

I enter Tkr in box at top of page .... hit search button .... pull info from page manually .... thinking if I could auto pull info into Excell sheet for 10 - 20 at one time it would save me some time and I could compare them quickly ....

Info does not have to come from Yahoo if you have another source you would recommend which might be easier to work with.

Thanks ....

Wed Jan 18, 2017 5:40 am (PST) . Posted by:

"Randy Randall" randyr_cds

I'll assume you have installed the smf add-in...and it works.

Try the following:

=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Income
Statement","Quarterly Revenue Growth")

=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Income
Statement","Quarterly Earnings Growth")

=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Cash
Flow Statement","Operating Cash Flow")

There should be enough above so you can get the last two. If you need
help, ask.

Also, you will need excel's concatenate function. If the ticker symbol is
in cell E1:

=RCHGetTableCell("http://finance.yahoo.com/quote/" & $E1 &
"/key-statistics?p=" & $E1,1,"Income Statement","Quarterly Revenue Growth")

Hope this helps.

Randy R

On Wed, Jan 18, 2017 at 6:07 AM, stuff@nc.rr.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy .... this is the Yahoo page I am currently getting the info from ....
>
> http://finance.yahoo.com/quote/A/key-statistics?p=A
>
> I enter Tkr in box at top of page .... hit search button .... pull info
> from page manually .... thinking if I could auto pull info into Excell
> sheet for 10 - 20 at one time it would save me some time and I could
> compare them quickly ....
>
> Info does not have to come from Yahoo if you have another source you would
> recommend which might be easier to work with.
>
> Thanks ....
>
>
>
>
>

Wed Jan 18, 2017 7:34 am (PST) . Posted by:

"Jose Jacob" pepecan47

You can take a look at the template

RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Regards,
Jose L. Jacob

--------------------------------------------
On Wed, 1/18/17, Randy Randall positive.theta@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Yahoo stock statistics data retrieval?
To: smf_addin@yahoogroups.com
Received: Wednesday, January 18, 2017, 8:40 AM


 









I'll assume you have
installed the smf add-in...and it works.

Try the following:


=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Income
Statement","Quarterly Revenue Growth")

=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Income
Statement","Quarterly Earnings
Growth")

=RCHGetTableCell("http://finance.yahoo.com/quote/A/key-statistics?p=A",1,"Cash
Flow Statement","Operating Cash Flow")


There should be enough above so you
can get the last two.  If you need help, ask.

Also, you will need
excel's concatenate function.  If the ticker symbol is
in cell E1:

=RCHGetTableCell("http://finance.yahoo.com/quote/"
& $E1 & "/key-statistics?p=" &
$E1,1,"Income Statement","Quarterly Revenue
Growth")

Hope this helps.

Randy R





On Wed, Jan 18, 2017 at
6:07 AM, stuff@nc.rr.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:















 









Randy .... this is the Yahoo page I am currently
getting the info from ....

http://finance.yahoo.com/
quote/A/key-statistics?p=A

I enter Tkr in box at top of page .... hit
search button .... pull info from page manually ....
thinking if I could auto pull info into Excell sheet for 10
- 20 at one time it would save me some time and I could
compare them quickly ....

Info does not have to come from Yahoo if you
have another source you would recommend which might be
easier to work with.

Thanks
....
 





























Wed Jan 18, 2017 10:46 am (PST) . Posted by:

troy212

I have the same error that jacobjwilson got -- "Compile Error: Can't find project or library".

Has anyone had any success with this?


@pdyson10 - can you share what you did to make this work with the group?







Wed Jan 18, 2017 10:48 am (PST) . Posted by:

troy212

Hi Jim and others - has anyone been successful with setting up SMF Add-In for the Mac? If so, could you share with the group? I am still stuck with the same "Compile Error: Can't find project or library" error.

@pdyson10 - can you share an update with the group if you had success with this?


Thanks!
Jake

Wed Jan 18, 2017 10:48 am (PST) . Posted by:

sfesky

Gang:

Note: there are two spaces after Industry and the ":"


in Win10 I needed the syntax to look like this to get results: =smfGetTagContent("https://www.zacks.com/stock/research/kr/industry-comparison","strong",1,">Industry&quot;)



notably the last part:


... ,">Industry")



(or with both spaces before the colon)


-J


P.S. Thanks Randy for the helpful API! I discovered it over the weekend.



Wed Jan 18, 2017 12:34 pm (PST) . Posted by:


--------------------------------------------
On Mon, 1/16/17, j@sloan.mit.edu [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] GetElementNumber 850 (Zacks Industry classification)?
To: smf_addin@yahoogroups.com
Date: Monday, January 16, 2017, 11:15 PM


 









Gang: 
Note: there are two spaces after
Industry and the ":"
in Win10 I needed the syntax to look
like this to get
results:=smfGetTagContent("https://www.zacks.com/stock/research/kr/industry-comparison","strong",1,">Industry&quot;)

notably
the last part:
...  
   ,">Industry")

(or with
both spaces before the colon)
-J
P.S. Thanks Randy for the helpful
API! I discovered it over the weekend.










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

#yiv5954500068 #yiv5954500068ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5954500068 #yiv5954500068ygrp-mkp #yiv5954500068hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5954500068 #yiv5954500068ygrp-mkp #yiv5954500068ads {
margin-bottom:10px;}

#yiv5954500068 #yiv5954500068ygrp-mkp .yiv5954500068ad {
padding:0 0;}

#yiv5954500068 #yiv5954500068ygrp-mkp .yiv5954500068ad p {
margin:0;}

#yiv5954500068 #yiv5954500068ygrp-mkp .yiv5954500068ad a {
color:#0000ff;text-decoration:none;}
#yiv5954500068 #yiv5954500068ygrp-sponsor
#yiv5954500068ygrp-lc {
font-family:Arial;}

#yiv5954500068 #yiv5954500068ygrp-sponsor
#yiv5954500068ygrp-lc #yiv5954500068hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5954500068 #yiv5954500068ygrp-sponsor
#yiv5954500068ygrp-lc .yiv5954500068ad {
margin-bottom:10px;padding:0 0;}

#yiv5954500068 #yiv5954500068actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5954500068 #yiv5954500068activity span {
font-weight:700;}

#yiv5954500068 #yiv5954500068activity span:first-child {
text-transform:uppercase;}

#yiv5954500068 #yiv5954500068activity span a {
color:#5085b6;text-decoration:none;}

#yiv5954500068 #yiv5954500068activity span span {
color:#ff7900;}

#yiv5954500068 #yiv5954500068activity span
.yiv5954500068underline {
text-decoration:underline;}

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

#yiv5954500068 .yiv5954500068attach div a {
text-decoration:none;}

#yiv5954500068 .yiv5954500068attach img {
border:none;padding-right:5px;}

#yiv5954500068 .yiv5954500068attach label {
display:block;margin-bottom:5px;}

#yiv5954500068 .yiv5954500068attach label a {
text-decoration:none;}

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

#yiv5954500068 .yiv5954500068bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5954500068 .yiv5954500068bold a {
text-decoration:none;}

#yiv5954500068 dd.yiv5954500068last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5954500068 dd.yiv5954500068last p
span.yiv5954500068yshortcuts {
margin-right:0;}

#yiv5954500068 div.yiv5954500068attach-table div div a {
text-decoration:none;}

#yiv5954500068 div.yiv5954500068attach-table {
width:400px;}

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

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

#yiv5954500068 div#yiv5954500068ygrp-mlmsg
#yiv5954500068ygrp-msg p a span.yiv5954500068yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5954500068 .yiv5954500068green {
color:#628c2a;}

#yiv5954500068 .yiv5954500068MsoNormal {
margin:0 0 0 0;}

#yiv5954500068 o {
font-size:0;}

#yiv5954500068 #yiv5954500068photos div {
float:left;width:72px;}

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

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

#yiv5954500068 #yiv5954500068reco-category {
font-size:77%;}

#yiv5954500068 #yiv5954500068reco-desc {
font-size:77%;}

#yiv5954500068 .yiv5954500068replbq {
margin:4px;}

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

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

#yiv5954500068 #yiv5954500068ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5954500068 #yiv5954500068ygrp-mlmsg pre, #yiv5954500068
code {
font:115% monospace;}

#yiv5954500068 #yiv5954500068ygrp-mlmsg * {
line-height:1.22em;}

#yiv5954500068 #yiv5954500068ygrp-mlmsg #yiv5954500068logo {
padding-bottom:10px;}


#yiv5954500068 #yiv5954500068ygrp-msg p a {
font-family:Verdana;}

#yiv5954500068 #yiv5954500068ygrp-msg
p#yiv5954500068attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5954500068 #yiv5954500068ygrp-reco
#yiv5954500068reco-head {
color:#ff7900;font-weight:700;}

#yiv5954500068 #yiv5954500068ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5954500068 #yiv5954500068ygrp-sponsor #yiv5954500068ov
li a {
font-size:130%;text-decoration:none;}

#yiv5954500068 #yiv5954500068ygrp-sponsor #yiv5954500068ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5954500068 #yiv5954500068ygrp-sponsor #yiv5954500068ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5954500068 #yiv5954500068ygrp-text {
font-family:Georgia;}

#yiv5954500068 #yiv5954500068ygrp-text p {
margin:0 0 1em 0;}

#yiv5954500068 #yiv5954500068ygrp-text tt {
font-size:120%;}

#yiv5954500068 #yiv5954500068ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv5954500068
mpotriva celor decise la Balta-Liman emigratia romana a adresat un protest Adunarii Nationale a republicii franceze si din initiativa lui CA. Rosetti s-a constituit la Paris la inceputul lunii iunie 1849 Comitetul Democratic Roman.

Wed Jan 18, 2017 10:49 am (PST) . Posted by:

globalinkus

I use 886, 887 regularly with no problem!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.57

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)