4 Messages
Digest #4554
Messages
Sat Jun 8, 2019 9:16 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Thank you Randy - I use the whole table as well, but because of the year dividers, I cannot do calculations within the table.
A question: In my formula, smfGetTagContent, I am trying to grab content wit the tag "td". The year dividers don't have a "td" tag, how come I am grabbing them? Is there a way not to grab them?
dividers between every year
Regards, Jose L. Jacob
On Friday, June 7, 2019 5:42 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
The problem is that they have dividers between every year, and no easy way to determine where they are going to be. Especially since each year doesn't necessarily have to have the same number of dividends per year. Some may pay out other than a quarterly dividend, or have a special dividend at some point.
I would suggest just grabbing the whole table:
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM","Ex-Dividend")
On Thu, Jun 6, 2019 at 8:52 PM Jose Jacob pepecan47@... wrote:
Hello Randy - still trying to work with Morningstar to get the dividend history.. I was really happy with Gurufocus, until the SMF cannot extract the data anymore. With Yahoo there are several problems, data reliability and timing of updating the dividends being the main ones.
I am using: MCD is in A1 cell, to get the latest dividend
=smfGetTagContent("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t="&$A$1,"td",1,">Cash Dividends")
Checking the source, if I use 7 as the parameter, I should get the next dividend. The problem is that when using 2, there is a "<img width ="12"......" that the SMF is pulling out. And then, the next dividend is 8. I thought the only "td" tags would be pulled.
Is there a way to bypass this "<img width//" thing, so I can predictable use 1, 7 , 13, 20, etc. to get the dividends?
I guess I don't understand 100% how the smfGetTagContent works.
#yiv5881622749 #yiv5881622749 -- #yiv5881622749ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5881622749 #yiv5881622749ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5881622749 #yiv5881622749ygrp-mkp #yiv5881622749hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5881622749 #yiv5881622749ygrp-mkp #yiv5881622749ads {margin-bottom:10px;}#yiv5881622749 #yiv5881622749ygrp-mkp .yiv5881622749ad {padding:0 0;}#yiv5881622749 #yiv5881622749ygrp-mkp .yiv5881622749ad p {margin:0;}#yiv5881622749 #yiv5881622749ygrp-mkp .yiv5881622749ad a {color:#0000ff;text-decoration:none;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ygrp-lc {font-family:Arial;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ygrp-lc #yiv5881622749hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ygrp-lc .yiv5881622749ad {margin-bottom:10px;padding:0 0;}#yiv5881622749 #yiv5881622749actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5881622749 #yiv5881622749activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5881622749 #yiv5881622749activity span {font-weight:700;}#yiv5881622749 #yiv5881622749activity span:first-child {text-transform:uppercase;}#yiv5881622749 #yiv5881622749activity span a {color:#5085b6;text-decoration:none;}#yiv5881622749 #yiv5881622749activity span span {color:#ff7900;}#yiv5881622749 #yiv5881622749activity span .yiv5881622749underline {text-decoration:underline;}#yiv5881622749 .yiv5881622749attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5881622749 .yiv5881622749attach div a {text-decoration:none;}#yiv5881622749 .yiv5881622749attach img {border:none;padding-right:5px;}#yiv5881622749 .yiv5881622749attach label {display:block;margin-bottom:5px;}#yiv5881622749 .yiv5881622749attach label a {text-decoration:none;}#yiv5881622749 blockquote {margin:0 0 0 4px;}#yiv5881622749 .yiv5881622749bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5881622749 .yiv5881622749bold a {text-decoration:none;}#yiv5881622749 dd.yiv5881622749last p a {font-family:Verdana;font-weight:700;}#yiv5881622749 dd.yiv5881622749last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5881622749 dd.yiv5881622749last p span.yiv5881622749yshortcuts {margin-right:0;}#yiv5881622749 div.yiv5881622749attach-table div div a {text-decoration:none;}#yiv5881622749 div.yiv5881622749attach-table {width:400px;}#yiv5881622749 div.yiv5881622749file-title a, #yiv5881622749 div.yiv5881622749file-title a:active, #yiv5881622749 div.yiv5881622749file-title a:hover, #yiv5881622749 div.yiv5881622749file-title a:visited {text-decoration:none;}#yiv5881622749 div.yiv5881622749photo-title a, #yiv5881622749 div.yiv5881622749photo-title a:active, #yiv5881622749 div.yiv5881622749photo-title a:hover, #yiv5881622749 div.yiv5881622749photo-title a:visited {text-decoration:none;}#yiv5881622749 div#yiv5881622749ygrp-mlmsg #yiv5881622749ygrp-msg p a span.yiv5881622749yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5881622749 .yiv5881622749green {color:#628c2a;}#yiv5881622749 .yiv5881622749MsoNormal {margin:0 0 0 0;}#yiv5881622749 o {font-size:0;}#yiv5881622749 #yiv5881622749photos div {float:left;width:72px;}#yiv5881622749 #yiv5881622749photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5881622749 #yiv5881622749photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5881622749 #yiv5881622749reco-category {font-size:77%;}#yiv5881622749 #yiv5881622749reco-desc {font-size:77%;}#yiv5881622749 .yiv5881622749replbq {margin:4px;}#yiv5881622749 #yiv5881622749ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5881622749 #yiv5881622749ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5881622749 #yiv5881622749ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5881622749 #yiv5881622749ygrp-mlmsg select, #yiv5881622749 input, #yiv5881622749 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5881622749 #yiv5881622749ygrp-mlmsg pre, #yiv5881622749 code {font:115% monospace;}#yiv5881622749 #yiv5881622749ygrp-mlmsg * {line-height:1.22em;}#yiv5881622749 #yiv5881622749ygrp-mlmsg #yiv5881622749logo {padding-bottom:10px;}#yiv5881622749 #yiv5881622749ygrp-msg p a {font-family:Verdana;}#yiv5881622749 #yiv5881622749ygrp-msg p#yiv5881622749attach-count span {color:#1E66AE;font-weight:700;}#yiv5881622749 #yiv5881622749ygrp-reco #yiv5881622749reco-head {color:#ff7900;font-weight:700;}#yiv5881622749 #yiv5881622749ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ov li a {font-size:130%;text-decoration:none;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5881622749 #yiv5881622749ygrp-sponsor #yiv5881622749ov ul {margin:0;padding:0 0 0 8px;}#yiv5881622749 #yiv5881622749ygrp-text {font-family:Georgia;}#yiv5881622749 #yiv5881622749ygrp-text p {margin:0 0 1em 0;}#yiv5881622749 #yiv5881622749ygrp-text tt {font-size:120%;}#yiv5881622749 #yiv5881622749ygrp-vital ul li:last-child {border-right:none !important;}#yiv5881622749
A question: In my formula, smfGetTagContent, I am trying to grab content wit the tag "td". The year dividers don't have a "td" tag, how come I am grabbing them? Is there a way not to grab them?
dividers between every year
Regards, Jose L. Jacob
On Friday, June 7, 2019 5:42 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
The problem is that they have dividers between every year, and no easy way to determine where they are going to be. Especially since each year doesn't necessarily have to have the same number of dividends per year. Some may pay out other than a quarterly dividend, or have a special dividend at some point.
I would suggest just grabbing the whole table:
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM","Ex-Dividend")
On Thu, Jun 6, 2019 at 8:52 PM Jose Jacob pepecan47@... wrote:
Hello Randy - still trying to work with Morningstar to get the dividend history.. I was really happy with Gurufocus, until the SMF cannot extract the data anymore. With Yahoo there are several problems, data reliability and timing of updating the dividends being the main ones.
I am using: MCD is in A1 cell, to get the latest dividend
=smfGetTagContent("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t="&$A$1,
Checking the source, if I use 7 as the parameter, I should get the next dividend. The problem is that when using 2, there is a "<img width ="12"
Is there a way to bypass this "<img width//" thing, so I can predictable use 1, 7 , 13, 20, etc. to get the dividends?
I guess I don't understand 100% how the smfGetTagContent works.
#yiv5881622749 #yiv5881622749 -- #yiv5881622749ygrp-
Sat Jun 8, 2019 2:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why can't you do calculations within the table? What calculations are you
attempting?
The add-in converts all <th> and </th> tags into <td> and </td> when the
source code of a web page is retrieved.
On Sat, Jun 8, 2019 at 9:16 AM Jose Jacob pepecan47@... wrote:
>
> Thank you Randy - I use the whole table as well, but because of the year
> dividers, I cannot do calculations within the table.
>
> A question: In my formula, smfGetTagContent, I am trying to grab content
> wit the tag "td". The year dividers don't have a "td" tag, how come I am
> grabbing them? Is there a way not to grab them?
>
>
>
attempting?
The add-in converts all <th> and </th> tags into <td> and </td> when the
source code of a web page is retrieved.
On Sat, Jun 8, 2019 at 9:16 AM Jose Jacob pepecan47@..
>
> Thank you Randy - I use the whole table as well, but because of the year
> dividers, I cannot do calculations within the table.
>
> A question: In my formula, smfGetTagContent, I am trying to grab content
> wit the tag "td"
> grabbing them? Is there a way not to grab them?
>
>
>
Sat Jun 8, 2019 10:13 pm (PDT) . Posted by:
amitc@ymail.com
Hi,
I am running into same issue with the function, it has not been working for 4 weeks.
Tried multiple symbols. The data is available on yahoo finance history site.
Any fix or alternatives to use?
Thanks
Amit
I am running into same issue with the function, it has not been working for 4 weeks.
Tried multiple symbols. The data is available on yahoo finance history site.
Any fix or alternatives to use?
Thanks
Amit
Sat Jun 8, 2019 10:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. It's working fine here. I just tried:
=RCHGetYahooHistory("MMM")
....and get:
Date Open High Low Close Volume Unadj
2019-06-07 $165.56 $167.09 $164.64 $166.61 2017700 $166.61
2019-06-06 $164.00 $166.35 $162.46 $164.72 3581800 $164.72
2019-06-05 $165.14 $165.83 $162.88 $163.85 3161600 $163.85
2019-06-04 $161.73 $165.09 $161.58 $164.29 3746800 $164.29
On Sat, Jun 8, 2019 at 10:13 PM ac11@... wrote:
>
> I am running into same issue with the function, it has not been working
> for 4 weeks.
> Tried multiple symbols. The data is available on yahoo finance history
> site.
>
> Any fix or alternatives to use?
>
>
>
=RCHGetYahooHistory
....and get:
Date Open High Low Close Volume Unadj
2019-06-07 $165.56 $167.09 $164.64 $166.61 2017700 $166.61
2019-06-06 $164.00 $166.35 $162.46 $164.72 3581800 $164.72
2019-06-05 $165.14 $165.83 $162.88 $163.85 3161600 $163.85
2019-06-04 $161.73 $165.09 $161.58 $164.29 3746800 $164.29
On Sat, Jun 8, 2019 at 10:13 PM ac11@... wrote:
>
> I am running into same issue with the function, it has not been working
> for 4 weeks.
> Tried multiple symbols. The data is available on yahoo finance history
> site.
>
> Any fix or alternatives to use?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar