6 Messages
Digest #4271
3c
Re: Can no longer logon to Morningstar w/Excel 2016 by "Thomas J Strouse" thomas.strouse@nielsen.com
Messages
Wed Dec 20, 2017 8:20 pm (PST) . Posted by:
"Jose Jacob" pepecan47
Hi Randy - yes, I can get the GuruFocus data and I am not a subscriber
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date")
The only problem is that I can not get data from Canadian companies not listed in US exachanges for example (tsx:IPL).
For companies that are dual listed, I can get the dividend data for example (BNS).
Do you think it could be an easy way to get data in clean format from Morningstar? Regards, Jose L. Jacob
On Tuesday, December 19, 2017 1:51 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I think you'd have to make a range derived from it, extracting just the lines without those years.
Can you use GuruFocus, or is this data only available to subscribers?
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date";)
On Tue, Dec 19, 2017 at 10:55 AM, Jose Jacob pepecan47@... wrote:
I am trying to use:use
=RCHGetHTMLTable("http:// performance.morningstar.com/ Performance/stock/dividend- history.action?y=50&t=XOM"," Record Date",-1,"",1)
to get the dividend history. But the way it;s formatted in the table, I can not use it to compute dividend growth, dividend increases, etc.
Is there a way to get rid of the rows that have only the year?
#yiv2040214095 #yiv2040214095 -- #yiv2040214095ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2040214095 #yiv2040214095ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2040214095 #yiv2040214095ygrp-mkp #yiv2040214095hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2040214095 #yiv2040214095ygrp-mkp #yiv2040214095ads {margin-bottom:10px;}#yiv2040214095 #yiv2040214095ygrp-mkp .yiv2040214095ad {padding:0 0;}#yiv2040214095 #yiv2040214095ygrp-mkp .yiv2040214095ad p {margin:0;}#yiv2040214095 #yiv2040214095ygrp-mkp .yiv2040214095ad a {color:#0000ff;text-decoration:none;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ygrp-lc {font-family:Arial;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ygrp-lc #yiv2040214095hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ygrp-lc .yiv2040214095ad {margin-bottom:10px;padding:0 0;}#yiv2040214095 #yiv2040214095actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2040214095 #yiv2040214095activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2040214095 #yiv2040214095activity span {font-weight:700;}#yiv2040214095 #yiv2040214095activity span:first-child {text-transform:uppercase;}#yiv2040214095 #yiv2040214095activity span a {color:#5085b6;text-decoration:none;}#yiv2040214095 #yiv2040214095activity span span {color:#ff7900;}#yiv2040214095 #yiv2040214095activity span .yiv2040214095underline {text-decoration:underline;}#yiv2040214095 .yiv2040214095attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2040214095 .yiv2040214095attach div a {text-decoration:none;}#yiv2040214095 .yiv2040214095attach img {border:none;padding-right:5px;}#yiv2040214095 .yiv2040214095attach label {display:block;margin-bottom:5px;}#yiv2040214095 .yiv2040214095attach label a {text-decoration:none;}#yiv2040214095 blockquote {margin:0 0 0 4px;}#yiv2040214095 .yiv2040214095bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2040214095 .yiv2040214095bold a {text-decoration:none;}#yiv2040214095 dd.yiv2040214095last p a {font-family:Verdana;font-weight:700;}#yiv2040214095 dd.yiv2040214095last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2040214095 dd.yiv2040214095last p span.yiv2040214095yshortcuts {margin-right:0;}#yiv2040214095 div.yiv2040214095attach-table div div a {text-decoration:none;}#yiv2040214095 div.yiv2040214095attach-table {width:400px;}#yiv2040214095 div.yiv2040214095file-title a, #yiv2040214095 div.yiv2040214095file-title a:active, #yiv2040214095 div.yiv2040214095file-title a:hover, #yiv2040214095 div.yiv2040214095file-title a:visited {text-decoration:none;}#yiv2040214095 div.yiv2040214095photo-title a, #yiv2040214095 div.yiv2040214095photo-title a:active, #yiv2040214095 div.yiv2040214095photo-title a:hover, #yiv2040214095 div.yiv2040214095photo-title a:visited {text-decoration:none;}#yiv2040214095 div#yiv2040214095ygrp-mlmsg #yiv2040214095ygrp-msg p a span.yiv2040214095yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2040214095 .yiv2040214095green {color:#628c2a;}#yiv2040214095 .yiv2040214095MsoNormal {margin:0 0 0 0;}#yiv2040214095 o {font-size:0;}#yiv2040214095 #yiv2040214095photos div {float:left;width:72px;}#yiv2040214095 #yiv2040214095photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2040214095 #yiv2040214095photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2040214095 #yiv2040214095reco-category {font-size:77%;}#yiv2040214095 #yiv2040214095reco-desc {font-size:77%;}#yiv2040214095 .yiv2040214095replbq {margin:4px;}#yiv2040214095 #yiv2040214095ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2040214095 #yiv2040214095ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2040214095 #yiv2040214095ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2040214095 #yiv2040214095ygrp-mlmsg select, #yiv2040214095 input, #yiv2040214095 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2040214095 #yiv2040214095ygrp-mlmsg pre, #yiv2040214095 code {font:115% monospace;}#yiv2040214095 #yiv2040214095ygrp-mlmsg * {line-height:1.22em;}#yiv2040214095 #yiv2040214095ygrp-mlmsg #yiv2040214095logo {padding-bottom:10px;}#yiv2040214095 #yiv2040214095ygrp-msg p a {font-family:Verdana;}#yiv2040214095 #yiv2040214095ygrp-msg p#yiv2040214095attach-count span {color:#1E66AE;font-weight:700;}#yiv2040214095 #yiv2040214095ygrp-reco #yiv2040214095reco-head {color:#ff7900;font-weight:700;}#yiv2040214095 #yiv2040214095ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ov li a {font-size:130%;text-decoration:none;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2040214095 #yiv2040214095ygrp-sponsor #yiv2040214095ov ul {margin:0;padding:0 0 0 8px;}#yiv2040214095 #yiv2040214095ygrp-text {font-family:Georgia;}#yiv2040214095 #yiv2040214095ygrp-text p {margin:0 0 1em 0;}#yiv2040214095 #yiv2040214095ygrp-text tt {font-size:120%;}#yiv2040214095 #yiv2040214095ygrp-vital ul li:last-child {border-right:none !important;}#yiv2040214095
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date")
The only problem is that I can not get data from Canadian companies not listed in US exachanges for example (tsx:IPL).
For companies that are dual listed, I can get the dividend data for example (BNS).
Do you think it could be an easy way to get data in clean format from Morningstar? Regards, Jose L. Jacob
On Tuesday, December 19, 2017 1:51 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I think you'd have to make a range derived from it, extracting just the lines without those years.
Can you use GuruFocus, or is this data only available to subscribers?
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM","
On Tue, Dec 19, 2017 at 10:55 AM, Jose Jacob pepecan47@... wrote:
I am trying to use:use
=RCHGetHTMLTable(
to get the dividend history. But the way it;s formatted in the table, I can not use it to compute dividend growth, dividend increases, etc.
Is there a way to get rid of the rows that have only the year?
#yiv2040214095 #yiv2040214095 -- #yiv2040214095ygrp-
Thu Dec 21, 2017 12:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Like I said, I think you'd need to do a work area derived on retrieved
data, to make it structured as you need.
On Wed, Dec 20, 2017 at 9:19 PM, Jose Jacob pepecan47@
...
wrote:
>
> Hi Randy - yes, I can get the GuruFocus data and I am not a subscriber
>
> =RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date";)
>
> The only problem is that I can not get data from Canadian companies not
> listed in US exachanges for example (tsx:IPL).
>
> For companies that are dual listed, I can get the dividend data for
> example (BNS).
>
> Do you think it could be an easy way to get data in clean format from
> Morningstar?
>
>
>
data, to make it structured as you need.
On Wed, Dec 20, 2017 at 9:19 PM, Jose Jacob pepecan47@
...
wrote:
>
> Hi Randy - yes, I can get the GuruFocus data and I am not a subscriber
>
> =RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM","
>
> The only problem is that I can not get data from Canadian companies not
> listed in US exachanges for example (tsx:IPL).
>
> For companies that are dual listed, I can get the dividend data for
> example (BNS).
>
> Do you think it could be an easy way to get data in clean format from
> Morningstar?
>
>
>
Thu Dec 21, 2017 6:35 am (PST) . Posted by:
thomas.strouse@nielsen.com
Randy,
I am recently having the same problem. I use ALT+D+D+W to get the Net Web Query link, but when I enter the Morningstar URL (http://beta.morningstar.com/), a number of scripts try to run, which produce errors. Then Excel locks up. Hence, I can never log in. I tried the links from the previous post, and the Income Statement link only provides 5 yr data. This is consistent with what I'm seeing on my spread sheet; Income, Balance and Cash flow statements provide 5 yr data and Key Ratios provides 10 yr data. Any solutions??
Thanks
Tom
I am recently having the same problem. I use ALT+D+D+W to get the Net Web Query link, but when I enter the Morningstar URL (http://beta.morningstar.com/), a number of scripts try to run, which produce errors. Then Excel locks up. Hence, I can never log in. I tried the links from the previous post, and the Income Statement link only provides 5 yr data. This is consistent with what I'm seeing on my spread sheet; Income, Balance and Cash flow statements provide 5 yr data and Key Ratios provides 10 yr data. Any solutions??
Thanks
Tom
Thu Dec 21, 2017 7:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try logging in with this URL:
https://www.morningstar.com/members/login.html
On Thu, Dec 21, 2017 at 7:35 AM, thomas.strouse@
...
wrote:
>
> I am recently having the same problem. I use ALT+D+D+W to get the Net Web
> Query link, but when I enter the Morningstar URL (
> http://beta.morningstar.com/), a number of scripts try to run, which
> produce errors. Then Excel locks up. Hence, I can never log in. I tried
> the links from the previous post, and the Income Statement link only
> provides 5 yr data. This is consistent with what I'm seeing on my spread
> sheet; Income, Balance and Cash flow statements provide 5 yr data and Key
> Ratios provides 10 yr data. Any solutions??
>
>
>
https://www.morningstar.com/members/login.html
On Thu, Dec 21, 2017 at 7:35 AM, thomas.strouse@
...
wrote:
>
> I am recently having the same problem. I use ALT+D+D+W to get the Net Web
> Query link, but when I enter the Morningstar URL (
> http://beta.morningstar.com/), a number of scripts try to run, which
> produce errors. Then Excel locks up. Hence, I can never log in. I tried
> the links from the previous post, and the Income Statement link only
> provides 5 yr data. This is consistent with what I'm seeing on my spread
> sheet; Income, Balance and Cash flow statements provide 5 yr data and Key
> Ratios provides 10 yr data. Any solutions??
>
>
>
Thu Dec 21, 2017 7:38 am (PST) . Posted by:
"Thomas J Strouse" thomas.strouse@nielsen.com
Thanks! That worked! There were still some script errors, but I "X"ed out
of them. I couldn't close the Net Web Query box and Excel was locked up,
but was able to go into Options menu in the Net Web Query window and
disable redirects. Then the Net Web Query window disappeared and I was
able to get 10 yr data.
As always, thanks for your help!!
On Thu, Dec 21, 2017 at 10:10 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Try logging in with this URL:
>
> https://www.morningstar.com/members/login.html
>
> On Thu, Dec 21, 2017 at 7:35 AM, thomas..strouse@
> ...
> wrote:
>
>>
>> I am recently having the same problem. I use ALT+D+D+W to get the Net
>> Web Query link, but when I enter the Morningstar URL (
>> http://beta.morningstar.com/), a number of scripts try to run, which
>> produce errors. Then Excel locks up. Hence, I can never log in. I tried
>> the links from the previous post, and the Income Statement link only
>> provides 5 yr data. This is consistent with what I'm seeing on my spread
>> sheet; Income, Balance and Cash flow statements provide 5 yr data and Key
>> Ratios provides 10 yr data. Any solutions??
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.com
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
of them. I couldn't close the Net Web Query box and Excel was locked up,
but was able to go into Options menu in the Net Web Query window and
disable redirects. Then the Net Web Query window disappeared and I was
able to get 10 yr data.
As always, thanks for your help!!
On Thu, Dec 21, 2017 at 10:10 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Try logging in with this URL:
>
> https://www.morningstar.com/members/login.html
>
> On Thu, Dec 21, 2017 at 7:35 AM, thomas..strouse@
> ...
> wrote:
>
>>
>> I am recently having the same problem. I use ALT+D+D+W to get the Net
>> Web Query link, but when I enter the Morningstar URL (
>> http://beta.morningstar.com/), a number of scripts try to run, which
>> produce errors. Then Excel locks up. Hence, I can never log in. I tried
>> the links from the previous post, and the Income Statement link only
>> provides 5 yr data. This is consistent with what I'm seeing on my spread
>> sheet; Income, Balance and Cash flow statements provide 5 yr data and Key
>> Ratios provides 10 yr data. Any solutions??
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar