3 Messages
Digest #4555
Messages
Sun Jun 9, 2019 7:16 am (PDT) . Posted by:
lhassrick
Thanks for checking.
I think it is (was) a Yahoo glitch. It worked for me for years and stopped working, a few weeks ago. Then it gave me sporadic results for some stocks (no rhyme or reason that I could discern). Then yesterday it seemed to work fully again.
I tend to only use it once or twice a month on my portfolio to pull in my stock's history to rough up performance calculations.
I think it is (was) a Yahoo glitch. It worked for me for years and stopped working, a few weeks ago. Then it gave me sporadic results for some stocks (no rhyme or reason that I could discern). Then yesterday it seemed to work fully again.
I tend to only use it once or twice a month on my portfolio to pull in my stock's history to rough up performance calculations.
Sun Jun 9, 2019 3:15 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Randy - some of the the calculations I want to make with the table: I have them using Yahoo, but Yahoo dividend data is pretty unreliable.
- Number of dividend payments per year- % last dividend increase- Forward dividend yield- Dividends per year in the last 10 years- Dividends paid in last period
Regarding smfGetTagContent, is it possible to add an optional switch to the formula to not convert all <th> and </th> tags into <td> and </td>? In this way, I would grab only "td" tags. Regards, Jose L. Jacob
On Saturday, June 8, 2019 5:22 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
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?
#yiv4915868280 #yiv4915868280 -- #yiv4915868280ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4915868280 #yiv4915868280ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4915868280 #yiv4915868280ygrp-mkp #yiv4915868280hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4915868280 #yiv4915868280ygrp-mkp #yiv4915868280ads {margin-bottom:10px;}#yiv4915868280 #yiv4915868280ygrp-mkp .yiv4915868280ad {padding:0 0;}#yiv4915868280 #yiv4915868280ygrp-mkp .yiv4915868280ad p {margin:0;}#yiv4915868280 #yiv4915868280ygrp-mkp .yiv4915868280ad a {color:#0000ff;text-decoration:none;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ygrp-lc {font-family:Arial;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ygrp-lc #yiv4915868280hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ygrp-lc .yiv4915868280ad {margin-bottom:10px;padding:0 0;}#yiv4915868280 #yiv4915868280actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4915868280 #yiv4915868280activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4915868280 #yiv4915868280activity span {font-weight:700;}#yiv4915868280 #yiv4915868280activity span:first-child {text-transform:uppercase;}#yiv4915868280 #yiv4915868280activity span a {color:#5085b6;text-decoration:none;}#yiv4915868280 #yiv4915868280activity span span {color:#ff7900;}#yiv4915868280 #yiv4915868280activity span .yiv4915868280underline {text-decoration:underline;}#yiv4915868280 .yiv4915868280attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4915868280 .yiv4915868280attach div a {text-decoration:none;}#yiv4915868280 .yiv4915868280attach img {border:none;padding-right:5px;}#yiv4915868280 .yiv4915868280attach label {display:block;margin-bottom:5px;}#yiv4915868280 .yiv4915868280attach label a {text-decoration:none;}#yiv4915868280 blockquote {margin:0 0 0 4px;}#yiv4915868280 .yiv4915868280bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4915868280 .yiv4915868280bold a {text-decoration:none;}#yiv4915868280 dd.yiv4915868280last p a {font-family:Verdana;font-weight:700;}#yiv4915868280 dd.yiv4915868280last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4915868280 dd.yiv4915868280last p span.yiv4915868280yshortcuts {margin-right:0;}#yiv4915868280 div.yiv4915868280attach-table div div a {text-decoration:none;}#yiv4915868280 div.yiv4915868280attach-table {width:400px;}#yiv4915868280 div.yiv4915868280file-title a, #yiv4915868280 div.yiv4915868280file-title a:active, #yiv4915868280 div.yiv4915868280file-title a:hover, #yiv4915868280 div.yiv4915868280file-title a:visited {text-decoration:none;}#yiv4915868280 div.yiv4915868280photo-title a, #yiv4915868280 div.yiv4915868280photo-title a:active, #yiv4915868280 div.yiv4915868280photo-title a:hover, #yiv4915868280 div.yiv4915868280photo-title a:visited {text-decoration:none;}#yiv4915868280 div#yiv4915868280ygrp-mlmsg #yiv4915868280ygrp-msg p a span.yiv4915868280yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4915868280 .yiv4915868280green {color:#628c2a;}#yiv4915868280 .yiv4915868280MsoNormal {margin:0 0 0 0;}#yiv4915868280 o {font-size:0;}#yiv4915868280 #yiv4915868280photos div {float:left;width:72px;}#yiv4915868280 #yiv4915868280photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4915868280 #yiv4915868280photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4915868280 #yiv4915868280reco-category {font-size:77%;}#yiv4915868280 #yiv4915868280reco-desc {font-size:77%;}#yiv4915868280 .yiv4915868280replbq {margin:4px;}#yiv4915868280 #yiv4915868280ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4915868280 #yiv4915868280ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4915868280 #yiv4915868280ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4915868280 #yiv4915868280ygrp-mlmsg select, #yiv4915868280 input, #yiv4915868280 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4915868280 #yiv4915868280ygrp-mlmsg pre, #yiv4915868280 code {font:115% monospace;}#yiv4915868280 #yiv4915868280ygrp-mlmsg * {line-height:1.22em;}#yiv4915868280 #yiv4915868280ygrp-mlmsg #yiv4915868280logo {padding-bottom:10px;}#yiv4915868280 #yiv4915868280ygrp-msg p a {font-family:Verdana;}#yiv4915868280 #yiv4915868280ygrp-msg p#yiv4915868280attach-count span {color:#1E66AE;font-weight:700;}#yiv4915868280 #yiv4915868280ygrp-reco #yiv4915868280reco-head {color:#ff7900;font-weight:700;}#yiv4915868280 #yiv4915868280ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ov li a {font-size:130%;text-decoration:none;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4915868280 #yiv4915868280ygrp-sponsor #yiv4915868280ov ul {margin:0;padding:0 0 0 8px;}#yiv4915868280 #yiv4915868280ygrp-text {font-family:Georgia;}#yiv4915868280 #yiv4915868280ygrp-text p {margin:0 0 1em 0;}#yiv4915868280 #yiv4915868280ygrp-text tt {font-size:120%;}#yiv4915868280 #yiv4915868280ygrp-vital ul li:last-child {border-right:none !important;}#yiv4915868280
- Number of dividend payments per year- % last dividend increase- Forward dividend yield- Dividends per year in the last 10 years- Dividends paid in last period
Regarding smfGetTagContent, is it possible to add an optional switch to the formula to not convert all <th> and </th> tags into <td> and </td>? In this way, I would grab only "td" tags. Regards, Jose L. Jacob
On Saturday, June 8, 2019 5:22 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
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@..
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,
#yiv4915868280 #yiv4915868280 -- #yiv4915868280ygrp-
Sun Jun 9, 2019 8:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is no optional switch. And no need.
You could easily extract the table into another table, keeping only rows of
dividend payments. For example, if I do the RCHGetHTMLTable() in cells
B1:Gnnn, you could use an array-entered formula to extract a column with
something like:
=DATEVALUE(INDEX($B:$B,MATCH(LARGE(IFERROR(DATEVALUE($E:$E),0),MATCH(LARGE(IFERROR(DATEVALUE($E:$E),0),ROW($E$1:$E$100)),IFERROR(DATEVALUE($E:$E),0),0)),IFERROR(DATEVALUE($E:$E),0),0)))
I've attached an example using forms of that last array-entered formula..
On Sun, Jun 9, 2019 at 3:26 PM Jose Jacob pepecan47@... wrote:
>
> Hi Randy - some of the the calculations I want to make with the table: I
> have them using Yahoo, but Yahoo dividend data is pretty unreliable.
>
> - Number of dividend payments per year
> - % last dividend increase
> - Forward dividend yield
> - Dividends per year in the last 10 years
> - Dividends paid in last period
>
> Regarding smfGetTagContent, is it possible to add an optional switch to
> the formula to not convert all <th> and </th> tags into <td> and </td>? In
> this way, I would grab only "td" tags.
>
>
>
You could easily extract the table into another table, keeping only rows of
dividend payments. For example, if I do the RCHGetHTMLTable(
B1:Gnnn, you could use an array-entered formula to extract a column with
something like:
=DATEVALUE(INDEX(
I've attached an example using forms of that last array-entered formula..
On Sun, Jun 9, 2019 at 3:26 PM Jose Jacob pepecan47@..
>
> Hi Randy - some of the the calculations I want to make with the table: I
> have them using Yahoo, but Yahoo dividend data is pretty unreliable.
>
> - Number of dividend payments per year
> - % last dividend increase
> - Forward dividend yield
> - Dividends per year in the last 10 years
> - Dividends paid in last period
>
> Regarding smfGetTagContent, is it possible to add an optional switch to
> the formula to not convert all <th> and </th> tags into <td> and </td>? In
> this way, I would grab only "td" tags.
>
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar