Jumat, 25 Januari 2019

[smf_addin] Digest Number 4469

13 Messages

Digest #4469
1.1
Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink
1.4
Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink
2c
Re: RCHCreateComment Function is not working by "Randy Harmelink" rharmelink
4a
4b
Re: SMF-Template-Total-Return by "Randy Harmelink" rharmelink
5
Balance sheet data Investing.com by dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg

Messages

Thu Jan 24, 2019 7:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Could be the website has some type of throttle on things. Be sure to verify
the URLs are correct and the web page shows the data you're after.

On Thu, Jan 24, 2019 at 4:47 AM alankc_mok@... wrote:

>
> I have a list of ten stock using the format of the above macro. However,
> some of the Stock can have quote and some didn't. I also try to reinstall
> the add-in. But still having intermittent problem. Is there any thing I can
> do to ?
>
>

Thu Jan 24, 2019 8:24 am (PST) . Posted by:

alankc_mok

Randy,

After changing the browser setting to get a fresh copy every time, the macro is working again.


If I want to get the current price from investing.com https://www.investing.com/indices/hang-sen-40 https://www.investing.com/indices/hang-sen-40 , what should be the macro to use ?


Regards


Alan

Thu Jan 24, 2019 9:11 am (PST) . Posted by:

alankc_mok

Randy,

I just try SPY using smfGetTagContent("https://www.investing.com/etfs/spdr-s-p-500","span",0,"last_last",,,,1)


And it seems working. However, the quote is static and not real time. So if I want to get the real time quote , is there any way to do it ?


Thanks


Alan

Thu Jan 24, 2019 9:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to update the data retrieval using the smfForceRecalculation to
get a new quote.

On Thu, Jan 24, 2019 at 10:13 AM alankc_mok@... wrote:

>
> I just try SPY using smfGetTagContent("
> https://www.investing.com/etfs/spdr-s-p-500","span",0,"last_last",,,,1)
>
> And it seems working. However, the quote is static and not real time. So
> if I want to get the real time quote , is there any way to do it ?
>
>
>

Thu Jan 24, 2019 1:42 pm (PST) . Posted by:

friedman_steve

Hi Randy,

my RCH Create comment for stock chart not working any longer as well.


I see old stock chart display you posted here, and that works on my computer. But how can I adjust this to show different time period? and place in different location? (I couldn't find where you actually typed in formula?)


Also, if i want to add this to an existing spreadsheet, would I just copy the VBA code to my existing spreadsheet?


I used to use this formula:
=rchcreatecomment("http://stockcharts.com/c-sc/sc?s="&$A$1&"&p=D&yr=0&mn="&$H$2&"&dy=0&id="&$AV$3&"",99,244,120,1,0,26,,,"Sell Side Analysts")



Thanks for your help.

Thu Jan 24, 2019 1:45 pm (PST) . Posted by:

friedman_steve

should have mentioned, I'm basically just looking for ability to show a basic 6 month stock price chart in a specific location and size on my spreadsheet. and same thing for a 3 year chart.
Thanks.

Thu Jan 24, 2019 3:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It's this statement that defines the chart to display:

sChart = "https://c.stockcharts.com/c-sc/sc?chart=" & oCell.Value &
",uu[305,180]dacayaci[pb20!b50][dg]"

If you want, you can create that URL in your worksheet, relative to the
ticker symbol. Something like:

sChart = oCell.Offset(0,1).Value

Since it's worksheet event, the VBA code would need to go into the
worksheet's module within the VBA project.

If you need to insert two charts for each ticker symbol, the code in the
module would need to be repeated again for the second chart.

On Thu, Jan 24, 2019 at 2:43 PM friedman_steve@... wrote:

>
> my RCH Create comment for stock chart not working any longer as well.
>
> I see old stock chart display you posted here, and that works on my
> computer. But how can I adjust this to show different time period? and
> place in different location? (I couldn't find where you actually typed in
> formula?)
>
> Also, if i want to add this to an existing spreadsheet, would I just copy
> the VBA code to my existing spreadsheet?
>
> I used to use this formula:
> =rchcreatecomment("http://stockcharts.com/c-sc/sc?s="&$A$1&"&p=D&yr=0&mn="&$H$2&"&dy=0&id="&$AV$3&"",99,244,120,1,0,26,,,"Sell
> Side Analysts")
>
>
On Thu, Jan 24, 2019 at 2:48 PM friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> should have mentioned,
> I'm basically just looking for ability to show a basic 6 month stock price
> chart in a specific location and size on my spreadsheet. and same thing
> for a 3 year chart.
> Thanks.
>
>
>

Thu Jan 24, 2019 4:41 pm (PST) . Posted by:

bobc94595

Thanks, Randy.


Is there any formula to retrieve historical dividend payment dates and amounts?

Thu Jan 24, 2019 5:16 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You can extract it from the JavaScript code on the Zacks dividend page with
something like:

=smfStrExtr(smfWord(smfWord(RCHGetWebData("
https://www.zacks.com/stock/research/MMM/earnings-announcements?tab=dividends","""earnings_announcements_dividends_table""
: "),3,"["),1,","),"""","""")

....where:

-- The "3" parameter is the most recent dividend payment. Increment it to
get earlier payments.
-- The "1" parameter is for the payment date, "2" gets amount, "3" gets
announcement date, "4" gets ex-dividend date

I can grab a table from GuruFocus with this array-entered over a range:

=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Frequency&quot;)

....but I'm not sure if that works because I'm a subscriber?

On Thu, Jan 24, 2019 at 5:41 PM conlonrc@... wrote:

>
> Is there any formula to retrieve historical dividend payment dates and
> amounts?
>
>

Thu Jan 24, 2019 9:01 pm (PST) . Posted by:

"Jose Jacob" pepecan47

I use
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/"&$A$1,">Ex-Date") 
and I am not a subscriber

Regards, Jose L. Jacob

On Thursday, January 24, 2019 8:16 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  You can extract it from the JavaScript code on the Zacks dividend page with something like:
=smfStrExtr(smfWord(smfWord(RCHGetWebData("https://www.zacks.com/stock/research/MMM/earnings-announcements?tab=dividends","""earnings_announcements_dividends_table""  : "),3,"["),1,","),"""","""")
....where: 
-- The "3" parameter is the most recent dividend payment. Increment it to get earlier payments.-- The "1" parameter is for the payment date, "2" gets amount, "3" gets announcement date, "4" gets ex-dividend date
I can grab a table from GuruFocus with this array-entered over a range:
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Frequency&quot;)

....but I'm not sure if that works because I'm a subscriber?
On Thu, Jan 24, 2019 at 5:41 PM conlonrc@... wrote:

Is there any formula to retrieve historical dividend payment dates and amounts?

#yiv0489924960 #yiv0489924960 -- #yiv0489924960ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0489924960 #yiv0489924960ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0489924960 #yiv0489924960ygrp-mkp #yiv0489924960hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0489924960 #yiv0489924960ygrp-mkp #yiv0489924960ads {margin-bottom:10px;}#yiv0489924960 #yiv0489924960ygrp-mkp .yiv0489924960ad {padding:0 0;}#yiv0489924960 #yiv0489924960ygrp-mkp .yiv0489924960ad p {margin:0;}#yiv0489924960 #yiv0489924960ygrp-mkp .yiv0489924960ad a {color:#0000ff;text-decoration:none;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ygrp-lc {font-family:Arial;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ygrp-lc #yiv0489924960hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ygrp-lc .yiv0489924960ad {margin-bottom:10px;padding:0 0;}#yiv0489924960 #yiv0489924960actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0489924960 #yiv0489924960activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0489924960 #yiv0489924960activity span {font-weight:700;}#yiv0489924960 #yiv0489924960activity span:first-child {text-transform:uppercase;}#yiv0489924960 #yiv0489924960activity span a {color:#5085b6;text-decoration:none;}#yiv0489924960 #yiv0489924960activity span span {color:#ff7900;}#yiv0489924960 #yiv0489924960activity span .yiv0489924960underline {text-decoration:underline;}#yiv0489924960 .yiv0489924960attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0489924960 .yiv0489924960attach div a {text-decoration:none;}#yiv0489924960 .yiv0489924960attach img {border:none;padding-right:5px;}#yiv0489924960 .yiv0489924960attach label {display:block;margin-bottom:5px;}#yiv0489924960 .yiv0489924960attach label a {text-decoration:none;}#yiv0489924960 blockquote {margin:0 0 0 4px;}#yiv0489924960 .yiv0489924960bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0489924960 .yiv0489924960bold a {text-decoration:none;}#yiv0489924960 dd.yiv0489924960last p a {font-family:Verdana;font-weight:700;}#yiv0489924960 dd.yiv0489924960last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0489924960 dd.yiv0489924960last p span.yiv0489924960yshortcuts {margin-right:0;}#yiv0489924960 div.yiv0489924960attach-table div div a {text-decoration:none;}#yiv0489924960 div.yiv0489924960attach-table {width:400px;}#yiv0489924960 div.yiv0489924960file-title a, #yiv0489924960 div.yiv0489924960file-title a:active, #yiv0489924960 div.yiv0489924960file-title a:hover, #yiv0489924960 div.yiv0489924960file-title a:visited {text-decoration:none;}#yiv0489924960 div.yiv0489924960photo-title a, #yiv0489924960 div.yiv0489924960photo-title a:active, #yiv0489924960 div.yiv0489924960photo-title a:hover, #yiv0489924960 div.yiv0489924960photo-title a:visited {text-decoration:none;}#yiv0489924960 div#yiv0489924960ygrp-mlmsg #yiv0489924960ygrp-msg p a span.yiv0489924960yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0489924960 .yiv0489924960green {color:#628c2a;}#yiv0489924960 .yiv0489924960MsoNormal {margin:0 0 0 0;}#yiv0489924960 o {font-size:0;}#yiv0489924960 #yiv0489924960photos div {float:left;width:72px;}#yiv0489924960 #yiv0489924960photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0489924960 #yiv0489924960photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0489924960 #yiv0489924960reco-category {font-size:77%;}#yiv0489924960 #yiv0489924960reco-desc {font-size:77%;}#yiv0489924960 .yiv0489924960replbq {margin:4px;}#yiv0489924960 #yiv0489924960ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0489924960 #yiv0489924960ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0489924960 #yiv0489924960ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0489924960 #yiv0489924960ygrp-mlmsg select, #yiv0489924960 input, #yiv0489924960 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0489924960 #yiv0489924960ygrp-mlmsg pre, #yiv0489924960 code {font:115% monospace;}#yiv0489924960 #yiv0489924960ygrp-mlmsg * {line-height:1.22em;}#yiv0489924960 #yiv0489924960ygrp-mlmsg #yiv0489924960logo {padding-bottom:10px;}#yiv0489924960 #yiv0489924960ygrp-msg p a {font-family:Verdana;}#yiv0489924960 #yiv0489924960ygrp-msg p#yiv0489924960attach-count span {color:#1E66AE;font-weight:700;}#yiv0489924960 #yiv0489924960ygrp-reco #yiv0489924960reco-head {color:#ff7900;font-weight:700;}#yiv0489924960 #yiv0489924960ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ov li a {font-size:130%;text-decoration:none;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0489924960 #yiv0489924960ygrp-sponsor #yiv0489924960ov ul {margin:0;padding:0 0 0 8px;}#yiv0489924960 #yiv0489924960ygrp-text {font-family:Georgia;}#yiv0489924960 #yiv0489924960ygrp-text p {margin:0 0 1em 0;}#yiv0489924960 #yiv0489924960ygrp-text tt {font-size:120%;}#yiv0489924960 #yiv0489924960ygrp-vital ul li:last-child {border-right:none !important;}#yiv0489924960

Thu Jan 24, 2019 6:06 pm (PST) . Posted by:

crollalanzaws

Hi,


I'm not able to pull any data using SMF-Template-Total-Return.


When I go to the Morningstar website and enter the ticker F0CAN05N6O, I get back information. However,
in the Total Return template, all the fields come back as "Error".


Yahoo doesn't even seem to know about this fund. When I try the same code on Yahoo, I get three web site listings, but not the quote page.


The Total Return template seems to be for ad-hoc requests. Is there a more efficient way to pull the data for about 20 funds. I was interested in the fund name, 1/3/5 and 10 year returns.


Thank you.


Thu Jan 24, 2019 11:47 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The Morningstar element number are largely based on the print report page
that Morningstar used to have. The new pages are dynamically created, and
it looks like they are heading towards a protected API, so I haven't
bothered to try and reassign the element numbers.

In any case, I get a "Ticker Not Found" error if I use F0CAN05N6O as a
ticker symbol. Possibly because it's only available on their Canadian web
site. So even the old element definitions would not have worked.

Hmm. It looks like the ticker symbol Morningstar actually uses for their
data pages is ADM3987? Try:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?ndec=2&ep=true&align=d&t=ADM3987",6,">Total
Return %",">ADM3987")

=RCHGetTableCell("
http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?ndec=2&ep=true&align=d&t=ADM3987",7,">Total
Return %",">ADM3987")

=RCHGetTableCell("
http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?ndec=2&ep=true&align=d&t=ADM3987",8,">Total
Return %",">ADM3987")

=RCHGetTableCell("
http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?ndec=2&ep=true&align=d&t=ADM3987",9,">Total
Return %",">ADM3987";)

But if your other 20 or so tickers have similar issues, that ticker
inconsistency is going to cause problems.

On Thu, Jan 24, 2019 at 7:06 PM florio.crollalanza@... wrote:

> I'm not able to pull any data using SMF-Template-Total-Return..
>
> When I go to the Morningstar website and enter the ticker F0CAN05N6O, I
> get back information. However,
>
> in the Total Return template, all the fields come back as "Error".
>
> Yahoo doesn't even seem to know about this fund. When I try the same code
> on Yahoo, I get three web site listings, but not the quote page.
>
> The Total Return template seems to be for ad-hoc requests. Is there a
> more efficient way to pull the data for about 20 funds. I was interested
> in the fund name, 1/3/5 and 10 year returns.
>
>
>

Thu Jan 24, 2019 11:12 pm (PST) . Posted by:

dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg

Hi all,


I saw some posts that some of you where struggling to extract data from Investing.com, but couldn't find whether it is possble by now. Investing.com is a great source and covers more stocks than other sources, so it would be great to extract price and balance/P&L data from it.


Is this still a problem?


Thanks!


Best,
Rico
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar