3 Messages
Digest #4553
Messages
Fri Jun 7, 2019 2:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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.
>
>
>
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,
> 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"
> 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.
>
>
>
Fri Jun 7, 2019 2:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They've changed the chart URLs. What you have before the "?" needs to be "
https://c.stockcharts.com/c-sc/sc"...
On Thu, Jun 6, 2019 at 6:27 AM friedman_steve@... wrote:
>
> 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")
>
>
>
https://c.stockcharts.com/c-sc/sc"...
On Thu, Jun 6, 2019 at 6:27 AM friedman_steve@... wrote:
>
> 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&"
>
>
>
Fri Jun 7, 2019 2:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm seeing similar results. The longer-term charts need wider bars. Since
my documentation is from 2003, there could have been changes.
The best process is to go to stockcharts.com and create the chart you want,
then determine the image's URL.
On Thu, Jun 6, 2019 at 6:12 AM friedman_steve@.... wrote:
>
> 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.
>
>
>
my documentation is from 2003, there could have been changes.
The best process is to go to stockcharts.com and create the chart you want,
then determine the image's URL.
On Thu, Jun 6, 2019 at 6:12 AM friedman_steve@.... wrote:
>
> 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&"
>
> Note, playing around, I did stumble upon a code that put out a monthly 4
> yr chart using m and then gc.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar