3 Messages
Digest #4552
Messages
Thu Jun 6, 2019 6:12 am (PDT) . Posted by:
friedman_steve
Thanks Randy, that's exactly what I'm looking for.... BUT some of those duration codes don't seem to work for me.
For daily, i could only get 3 mnths (using d and then ac) and 6 mnths (using d and then dc)
for weekly, i could only get 6 months (using w and then ac) and 1 year (using w and then dc)
Nothing would put out a 2 year or 3 yr chart (any suggestion for this?).
The others (like fc that should put out 3 year chart, isn't). Am I doing something wrong?
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][ac]",99,450,421,1,0,50,500,,"chart")
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][dc]",99,450,421,1,0,50,500,,"chart")
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]wacayaci[pb50!b200][ac]",99,450,421,1,0,50,500,,"chart")
Note, playing around, I did stumble upon a code that put out a monthly 4 yr chart using m and then gc.
Thanks a ton Randy.
For daily, i could only get 3 mnths (using d and then ac) and 6 mnths (using d and then dc)
for weekly, i could only get 6 months (using w and then ac) and 1 year (using w and then dc)
Nothing would put out a 2 year or 3 yr chart (any suggestion for this?).
The others (like fc that should put out 3 year chart, isn't). Am I doing something wrong?
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][ac]",99,450,421,1,0,50,500,,"chart")
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][dc]",99,450,421,1,0,50,500,,"chart")
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&"
Note, playing around, I did stumble upon a code that put out a monthly 4 yr chart using m and then gc.
Thanks a ton Randy.
Thu Jun 6, 2019 6:27 am (PDT) . Posted by:
friedman_steve
I should also point out that I found a different formula in an excel file that used to work for me, but doesn't seem to any longer that looked like this:
=rchcreatecomment("https://stockcharts.com/c-sc/sc?s="&$A$1&"&p=D&yr=0&mn=12&dy=0&id=p97581559629",99,800,750,0,,,,,"Chart")
=rchcreatecomment("https://stockcharts.com/c-sc/sc?s="&$A$1&"
Thu Jun 6, 2019 8:49 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
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.
Regards, Jose L. Jacob
On Thursday, December 21, 2017 3:52 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
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?
#yiv4751841709 #yiv4751841709 -- #yiv4751841709ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4751841709 #yiv4751841709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4751841709 #yiv4751841709ygrp-mkp #yiv4751841709hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4751841709 #yiv4751841709ygrp-mkp #yiv4751841709ads {margin-bottom:10px;}#yiv4751841709 #yiv4751841709ygrp-mkp .yiv4751841709ad {padding:0 0;}#yiv4751841709 #yiv4751841709ygrp-mkp .yiv4751841709ad p {margin:0;}#yiv4751841709 #yiv4751841709ygrp-mkp .yiv4751841709ad a {color:#0000ff;text-decoration:none;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ygrp-lc {font-family:Arial;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ygrp-lc #yiv4751841709hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ygrp-lc .yiv4751841709ad {margin-bottom:10px;padding:0 0;}#yiv4751841709 #yiv4751841709actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4751841709 #yiv4751841709activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4751841709 #yiv4751841709activity span {font-weight:700;}#yiv4751841709 #yiv4751841709activity span:first-child {text-transform:uppercase;}#yiv4751841709 #yiv4751841709activity span a {color:#5085b6;text-decoration:none;}#yiv4751841709 #yiv4751841709activity span span {color:#ff7900;}#yiv4751841709 #yiv4751841709activity span .yiv4751841709underline {text-decoration:underline;}#yiv4751841709 .yiv4751841709attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4751841709 .yiv4751841709attach div a {text-decoration:none;}#yiv4751841709 .yiv4751841709attach img {border:none;padding-right:5px;}#yiv4751841709 .yiv4751841709attach label {display:block;margin-bottom:5px;}#yiv4751841709 .yiv4751841709attach label a {text-decoration:none;}#yiv4751841709 blockquote {margin:0 0 0 4px;}#yiv4751841709 .yiv4751841709bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4751841709 .yiv4751841709bold a {text-decoration:none;}#yiv4751841709 dd.yiv4751841709last p a {font-family:Verdana;font-weight:700;}#yiv4751841709 dd.yiv4751841709last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4751841709 dd.yiv4751841709last p span.yiv4751841709yshortcuts {margin-right:0;}#yiv4751841709 div.yiv4751841709attach-table div div a {text-decoration:none;}#yiv4751841709 div.yiv4751841709attach-table {width:400px;}#yiv4751841709 div.yiv4751841709file-title a, #yiv4751841709 div.yiv4751841709file-title a:active, #yiv4751841709 div.yiv4751841709file-title a:hover, #yiv4751841709 div.yiv4751841709file-title a:visited {text-decoration:none;}#yiv4751841709 div.yiv4751841709photo-title a, #yiv4751841709 div.yiv4751841709photo-title a:active, #yiv4751841709 div.yiv4751841709photo-title a:hover, #yiv4751841709 div.yiv4751841709photo-title a:visited {text-decoration:none;}#yiv4751841709 div#yiv4751841709ygrp-mlmsg #yiv4751841709ygrp-msg p a span.yiv4751841709yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4751841709 .yiv4751841709green {color:#628c2a;}#yiv4751841709 .yiv4751841709MsoNormal {margin:0 0 0 0;}#yiv4751841709 o {font-size:0;}#yiv4751841709 #yiv4751841709photos div {float:left;width:72px;}#yiv4751841709 #yiv4751841709photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4751841709 #yiv4751841709photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4751841709 #yiv4751841709reco-category {font-size:77%;}#yiv4751841709 #yiv4751841709reco-desc {font-size:77%;}#yiv4751841709 .yiv4751841709replbq {margin:4px;}#yiv4751841709 #yiv4751841709ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4751841709 #yiv4751841709ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4751841709 #yiv4751841709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4751841709 #yiv4751841709ygrp-mlmsg select, #yiv4751841709 input, #yiv4751841709 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4751841709 #yiv4751841709ygrp-mlmsg pre, #yiv4751841709 code {font:115% monospace;}#yiv4751841709 #yiv4751841709ygrp-mlmsg * {line-height:1.22em;}#yiv4751841709 #yiv4751841709ygrp-mlmsg #yiv4751841709logo {padding-bottom:10px;}#yiv4751841709 #yiv4751841709ygrp-msg p a {font-family:Verdana;}#yiv4751841709 #yiv4751841709ygrp-msg p#yiv4751841709attach-count span {color:#1E66AE;font-weight:700;}#yiv4751841709 #yiv4751841709ygrp-reco #yiv4751841709reco-head {color:#ff7900;font-weight:700;}#yiv4751841709 #yiv4751841709ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ov li a {font-size:130%;text-decoration:none;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4751841709 #yiv4751841709ygrp-sponsor #yiv4751841709ov ul {margin:0;padding:0 0 0 8px;}#yiv4751841709 #yiv4751841709ygrp-text {font-family:Georgia;}#yiv4751841709 #yiv4751841709ygrp-text p {margin:0 0 1em 0;}#yiv4751841709 #yiv4751841709ygrp-text tt {font-size:120%;}#yiv4751841709 #yiv4751841709ygrp-vital ul li:last-child {border-right:none !important;}#yiv4751841709
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.
Regards, Jose L. Jacob
On Thursday, December 21, 2017 3:52 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
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/
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?
#yiv4751841709 #yiv4751841709 -- #yiv4751841709ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar