Selasa, 08 September 2015

[smf_addin] Digest Number 3505

7 Messages

Digest #3505
1a
1b
Re: Domicile Adresses by "Randy Harmelink" rharmelink
2a
Dividend Yield % from MorningStar by "Jose Jacob" pepecan47
2b
Re: Dividend Yield % from MorningStar by "Randy Harmelink" rharmelink
2c
Re: Dividend Yield % from MorningStar by "Jose Jacob" pepecan47
2d
Re: Dividend Yield % from MorningStar by "Randy Harmelink" rharmelink
3a
Re: ETF.com data by thomas777crown

Messages

Mon Sep 7, 2015 5:56 am (PDT) . Posted by:

rjemery7

For a given ticker, from where and how might I extract its domicile address (city, state/province, country)?

By domicile address, I mean the HQ for tax purposes. Some companies may have their HQ in Ireland or Switzerland but their Operational HQ in the United States.


Mon Sep 7, 2015 8:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I know of several sources of addresses, but I don't know if they fit your
definition of "HQ for tax purposes"...

http://finance.yahoo.com/q/pr?s=MMM

http://financials.morningstar.com/company-profile/component.action?component=ContactInfo&t=MMM

http://www.barchart.com/profile/stocks/MMM

http://money.cnn.com/quote/profile/profile.html?symb=MMM

On Mon, Sep 7, 2015 at 5:55 AM, rjemery@... wrote:

>
> For a given ticker, from where and how might I extract its domicile
> address (city, state/province, country)?
>
> By domicile address, I mean the HQ for tax purposes. Some companies may
> have their HQ in Ireland or Switzerland but their Operational HQ in the
> United States.
>

Mon Sep 7, 2015 10:40 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy, I need some help to extract the Dividend Yield for the 10 last years from the page:

http://performance.morningstar.com/stock/performance-return.action?t=EMR®ion=USA&culture=en-US

Thanks a lot.

Regards,
Jose L. Jacob

Mon Sep 7, 2015 10:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just do something like:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=EMR
",
-1,">Year-end")

...varying that -1 from -1 to -10.

Note I used a different URL, as those web pages in MorningStar are
dynamically generated web pages and don't contain the data. The data comes
from static web pages like the one in the formula above.

On Mon, Sep 7, 2015 at 10:37 AM, Jose Jacob pepecan47@... wrote:

> Hi Randy, I need some help to extract the Dividend Yield for the 10 last
> years from the page:
>
> http://performance.morningstar.com/stock/performance-return.action?t=EMR
> ®ion=USA&culture=en-US
>
>

Mon Sep 7, 2015 11:44 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - thank you very much.

Another related favor, is there somewhere a list of these static M* web pages?

Regards,
Jose L. Jacob

--------------------------------------------
On Mon, 9/7/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Dividend Yield % from MorningStar
To: smf_addin@yahoogroups.com
Received: Monday, September 7, 2015, 1:53 PM


 









Just do something
like:

=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=EMR",
-1,">Year-end")

...varying that -1 from
-1 to -10.

Note I
used a different URL, as those web pages in MorningStar are
dynamically generated web pages and don't contain the
data. The data comes from static web pages like the one in
the formula above.

On Mon, Sep 7, 2015 at
10:37 AM, Jose Jacob pepecan47@... wrote:
Hi Randy, I need some help to extract the
Dividend Yield for the 10 last years from the page:



http://performance.morningstar.com/stock/performance-return.action?t=EMR®ion=USA&culture=en-US














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

#yiv3386272207 #yiv3386272207ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3386272207 #yiv3386272207ygrp-mkp #yiv3386272207hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3386272207 #yiv3386272207ygrp-mkp #yiv3386272207ads {
margin-bottom:10px;}

#yiv3386272207 #yiv3386272207ygrp-mkp .yiv3386272207ad {
padding:0 0;}

#yiv3386272207 #yiv3386272207ygrp-mkp .yiv3386272207ad p {
margin:0;}

#yiv3386272207 #yiv3386272207ygrp-mkp .yiv3386272207ad a {
color:#0000ff;text-decoration:none;}
#yiv3386272207 #yiv3386272207ygrp-sponsor
#yiv3386272207ygrp-lc {
font-family:Arial;}

#yiv3386272207 #yiv3386272207ygrp-sponsor
#yiv3386272207ygrp-lc #yiv3386272207hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3386272207 #yiv3386272207ygrp-sponsor
#yiv3386272207ygrp-lc .yiv3386272207ad {
margin-bottom:10px;padding:0 0;}

#yiv3386272207 #yiv3386272207actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3386272207 #yiv3386272207activity span {
font-weight:700;}

#yiv3386272207 #yiv3386272207activity span:first-child {
text-transform:uppercase;}

#yiv3386272207 #yiv3386272207activity span a {
color:#5085b6;text-decoration:none;}

#yiv3386272207 #yiv3386272207activity span span {
color:#ff7900;}

#yiv3386272207 #yiv3386272207activity span
.yiv3386272207underline {
text-decoration:underline;}

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

#yiv3386272207 .yiv3386272207attach div a {
text-decoration:none;}

#yiv3386272207 .yiv3386272207attach img {
border:none;padding-right:5px;}

#yiv3386272207 .yiv3386272207attach label {
display:block;margin-bottom:5px;}

#yiv3386272207 .yiv3386272207attach label a {
text-decoration:none;}

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

#yiv3386272207 .yiv3386272207bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3386272207 .yiv3386272207bold a {
text-decoration:none;}

#yiv3386272207 dd.yiv3386272207last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3386272207 dd.yiv3386272207last p
span.yiv3386272207yshortcuts {
margin-right:0;}

#yiv3386272207 div.yiv3386272207attach-table div div a {
text-decoration:none;}

#yiv3386272207 div.yiv3386272207attach-table {
width:400px;}

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

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

#yiv3386272207 div#yiv3386272207ygrp-mlmsg
#yiv3386272207ygrp-msg p a span.yiv3386272207yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3386272207 .yiv3386272207green {
color:#628c2a;}

#yiv3386272207 .yiv3386272207MsoNormal {
margin:0 0 0 0;}

#yiv3386272207 o {
font-size:0;}

#yiv3386272207 #yiv3386272207photos div {
float:left;width:72px;}

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

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

#yiv3386272207 #yiv3386272207reco-category {
font-size:77%;}

#yiv3386272207 #yiv3386272207reco-desc {
font-size:77%;}

#yiv3386272207 .yiv3386272207replbq {
margin:4px;}

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

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

#yiv3386272207 #yiv3386272207ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3386272207 #yiv3386272207ygrp-mlmsg pre, #yiv3386272207
code {
font:115% monospace;}

#yiv3386272207 #yiv3386272207ygrp-mlmsg * {
line-height:1.22em;}

#yiv3386272207 #yiv3386272207ygrp-mlmsg #yiv3386272207logo {
padding-bottom:10px;}


#yiv3386272207 #yiv3386272207ygrp-msg p a {
font-family:Verdana;}

#yiv3386272207 #yiv3386272207ygrp-msg
p#yiv3386272207attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3386272207 #yiv3386272207ygrp-reco
#yiv3386272207reco-head {
color:#ff7900;font-weight:700;}

#yiv3386272207 #yiv3386272207ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3386272207 #yiv3386272207ygrp-sponsor #yiv3386272207ov
li a {
font-size:130%;text-decoration:none;}

#yiv3386272207 #yiv3386272207ygrp-sponsor #yiv3386272207ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3386272207 #yiv3386272207ygrp-sponsor #yiv3386272207ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3386272207 #yiv3386272207ygrp-text {
font-family:Georgia;}

#yiv3386272207 #yiv3386272207ygrp-text p {
margin:0 0 1em 0;}

#yiv3386272207 #yiv3386272207ygrp-text tt {
font-size:120%;}

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


Mon Sep 7, 2015 12:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not really. I find new ones all the time. When they first converted to
dynamic web pages, I listed a few of them:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/22956

At the time, I was wading through JavaScript code to find them. Now I use
httpFox, a URL sniffer extension for the FireFox browser.

On Mon, Sep 7, 2015 at 11:41 AM, Jose Jacob pepecan47@... wrote:

>
> Another related favor, is there somewhere a list of these static M* web
> pages?
>
> <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
>

Tue Sep 8, 2015 12:21 am (PDT) . Posted by:

thomas777crown

Hi, Randy

Just wanted to ask something on this question already asked what if you had a Ticker in A1 and wanted to pull data from etf.com on Assets Under Management




Thanks in Advance


Thomas

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

Tidak ada komentar:

Poskan Komentar