Rabu, 30 Mei 2018

[smf_addin] Digest Number 4333

15 Messages

Digest #4333
1a
Re: Dividend Pay Date by garyhartling
1b
Re: Dividend Pay Date by "Randy Harmelink" rharmelink
1c
Re: Dividend Pay Date by garyhartling
1d
Re: Dividend Pay Date by "Randy Harmelink" rharmelink
2b
Re: RCHGetTableCell Function by "Randy Harmelink" rharmelink
4a
4b
Re: rchgetelementnumber 617 and 621 by "Randy Harmelink" rharmelink
4d
Re: rchgetelementnumber 617 and 621 by "Randy Harmelink" rharmelink
4e
Re: rchgetelementnumber 617 and 621 by "Dave Charlaff" copthornelabs
4f
Re: rchgetelementnumber 617 and 621 by "Randy Harmelink" rharmelink

Messages

Tue May 22, 2018 4:27 pm (PDT) . Posted by:

garyhartling

Most of the results work, but a few still produce an error. Is there another source for "Dividend Pay Date" that I could try for these recalcitrants?

Tue May 22, 2018 5:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm surprised the NASDAQ site would be missing such data?

I typically use GuruFocus, but I'm a subscriber so I'm not sure what is
available without subscription:

https://www.gurufocus.com/dividend/MMM

Zacks also has a table:

https://www.zacks.com/stock/research/MMM/earnings-announcements

Or Morningstar:

http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM

On Tue, May 22, 2018 at 4:27 PM, Gary.Hartling@
​...
wrote:

>
> Most of the results work, but a few still produce an error. Is there
> another source for "Dividend Pay Date" that I could try for these
> recalcitrants?
>

Tue May 22, 2018 5:33 pm (PDT) . Posted by:

garyhartling

OK, so could you give me a formula to extract the next "Payable Date" from Morningstar for MMM?

Wed May 23, 2018 1:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=MMM",-3,"Cash
Dividends")

On Tue, May 22, 2018 at 5:33 PM, Gary.Hartling@
​...
wrote:

>
> OK, so could you give me a formula to extract the next "Payable Date" from
> Morningstar for MMM?
>

Thu May 24, 2018 10:26 pm (PDT) . Posted by:

bleushin19

Hi Randy,


Thank you for giving time to read my message. I have here a problem on RCHGetTableCell,


Example:
My previous code was
=RCHGetTableCell("https://finance.yahoo.com/quote/AAPL/history?p=AAPL",4,"Dec 29, 2017")
It will get the close* price from the given date. It was working before but I don't know what happened it suddenly show as error. I tried changing it to different dates and they all work fine from Jan 04, 2018 up to latest.


My question will be about what method should I use to get the needed data from the date Dec 29, 2017. Are there other ways/process for me to use, I already tried smfGetTagContent but It doesn't give me data from Dec 29, 2017 only for Jan 04, 2018.


Hope you could help me again.


Thanks and more power.

Thu May 24, 2018 10:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Right now, the source code for the web page only contains a table of data
that goes back to Jan 4th. Anything later than that is dynamically added to
the web page as you scroll down. But the add-in is extracting data from the
source code of the web page, so anything dynamically added would be
unavailable to the add-in.

You could specify the dates for the web page instead of letting it default
to the current date as the latest date, so that Dec 29 is within the source
code of the web page.

Why not just use the smfGetYahooHistory() function?

On Thu, May 24, 2018 at 10:26 PM, bleushin19@
​...
wrote:

> Thank you for giving time to read my message. I have here a problem on
> RCHGetTableCell,
>
> Example:
>
> My previous code was
>
> =RCHGetTableCell("https://finance.yahoo.com/quote/AAPL/history?p=AAPL",4,"Dec
> 29, 2017")
>
> It will get the close* price from the given date. It was working before
> but I don't know what happened it suddenly show as error. I tried changing
> it to different dates and they all work fine from Jan 04, 2018 up to latest.
>
> My question will be about what method should I use to get the needed data
> from the date Dec 29, 2017. Are there other ways/process for me to use, I
> already tried smfGetTagContent but It doesn't give me data from Dec 29,
> 2017 only for Jan 04, 2018.
>
> Hope you could help me again.
>
>
>

Thu May 24, 2018 10:53 pm (PDT) . Posted by:

bleushin19

Thank you so much Randy, I'll give it a try. Haven't played around much with the smfGetYahooHistory() function.

Thu May 24, 2018 11:22 pm (PDT) . Posted by:

bleushin19

Got it working again. Thanks a lot. You're the best.

Sat May 26, 2018 7:28 am (PDT) . Posted by:

john_hoel

I upgraded to the latest release and no change. However, I think I finally stumbled on a workaround. If I save the workbook before updating it, the problem does not occur. I suspect an Excel bug.

Sun May 27, 2018 11:11 pm (PDT) . Posted by:

markknutson2005

Hi Randy,


Is there any replacement for elements 617 and 621 that used to pull off yahoo?
I used the formulas below that don't work anymore:


=rchgetelementnumber(A2,621)
=rchgetelementnumber(A2,617)


Do I have any automated alternatives to get the next 5 year EGR and last 5 year EGR?
Any help would be greatly appreciated.


Thanks in advanced

Sun May 27, 2018 11:21 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do you have the latest element definitions? They were updated in mid-April:

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

On Sun, May 27, 2018 at 11:11 PM, mknu@
​..
wrote:

> Is there any replacement for elements 617 and 621 that used to pull off
> yahoo?
>
> I used the formulas below that don't work anymore:
>
> =rchgetelementnumber(A2,621)
>
> =rchgetelementnumber(A2,617)
>
> Do I have any automated alternatives to get the next 5 year EGR and last 5
> year EGR?
>
> Any help would be greatly appreciated.
>
>
>

Tue May 29, 2018 1:30 pm (PDT) . Posted by:

copthornelabs

Randy, I dont seem to be able to get these element no's working in my spreadsheets.
This is the cell content I have always used:

I have re-downloaded the latest definitions, reopened the spreadsheet before updating and still I get an error.
Addin is loaded and as far as I can tell is pointing at the SMF folder. Any suggestions wld be really welcome.
Thx
Dave C


=RCHGetElementNumber(A2,621)









Tue May 29, 2018 3:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("Definition",621)
=RCHGetElementNumber("MMM",621)
=smfGetTagContent("https://finance.yahoo.com/quote/MMM/analysis","td",1,">Growth
Estimates","Next 5 Years",,,1)

On Tue, May 29, 2018 at 12:27 PM, davecharlaff@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I dont seem to be able to get these element no's working in my
> spreadsheets.
> This is the cell content I have always used:
>
> I have re-downloaded the latest definitions, reopened the spreadsheet
> before updating and still I get an error.
> Addin is loaded and as far as I can tell is pointing at the SMF folder..
> Any suggestions wld be really welcome.
>
>

Wed May 30, 2018 3:17 am (PDT) . Posted by:

"Dave Charlaff" copthornelabs

Stock Market Functions add-in, Version 2.1.2017.09.17 (D:\SMF Add-In; Windows (32-bit) NT 6.02; 15.0; ; Local; 1)

=RCHGetElementNumber("Version")







YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS; ; ;0;0;0;0

=RCHGetElementNumber("Definition",621)


















Error

=RCHGetElementNumber("MMM",621)








0.093<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>

=smfGetTagContent("https://finance.yahoo.com/quote/MMM/analysis<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>","td",1,">Growth Estimates","Next 5 Years",,,1)










From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, May 29, 2018 6:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] rchgetelementnumber 617 and 621


What do you get with:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("Definition",621)
=RCHGetElementNumber("MMM",621)
=smfGetTagContent("https://finance.yahoo.com/quote/MMM/analysis<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>","td",1,">Growth Estimates","Next 5 Years",,,1)

On Tue, May 29, 2018 at 12:27 PM, davecharlaff@hotmail.com<mailto:davecharlaff@hotmail.com> [smf_addin] <smf_addin@yahoogroups.com<mailto:smf_addin@yahoogroups.com>> wrote:

I dont seem to be able to get these element no's working in my spreadsheets.
This is the cell content I have always used:

I have re-downloaded the latest definitions, reopened the spreadsheet before updating and still I get an error.
Addin is loaded and as far as I can tell is pointing at the SMF folder. Any suggestions wld be really welcome.


Wed May 30, 2018 3:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not working because you still have the old definition of the element.

You need to download the latest smf-elements-2.txt file from the web site
and place it in your add-in folder:

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

On Wed, May 30, 2018 at 3:17 AM, Dave Charlaff davecharlaff@hotmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Stock Market Functions add-in, Version 2.1.2017.09.17 (D:\SMF Add-In;
> Windows (32-bit) NT 6.02; 15.0; ; Local; 1)
>
> =RCHGetElementNumber("Version")
>
>
>
>
>
>
>
> YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS;
> ; ;0;0;0;0
>
> =RCHGetElementNumber("Definition",621)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Error
>
> =RCHGetElementNumber("MMM",621)
>
>
>
>
>
>
>
>
>
> *0.093
> <https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>*
>
> =smfGetTagContent("https://finance.yahoo.com/quote/MMM/analysis
> <https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>","td",1,">Growth
> Estimates","Next 5 Years",,,1)
>
>
>
>
>
>
>
>
>
>
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Tuesday, May 29, 2018 6:11 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] rchgetelementnumber 617 and 621
>
>
>
>
>
> What do you get with:
>
>
>
> =RCHGetElementNumber("Version")
>
> =RCHGetElementNumber("Definition",621)
>
> =RCHGetElementNumber("MMM",621)
>
> =smfGetTagContent("https://finance.yahoo.com/quote/MMM/analysis
> <https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMMM%2Fanalysis&data=02%7C01%7C%7C853ed732031645291c2608d5c5b132e4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636632287201799318&sdata=X3n39WCijYrYWrh%2FBsZdKhzuVNxNj8DCI%2FhNgYCEMWY%3D&reserved=0>","td",1,">Growth
> Estimates","Next 5 Years",,,1)
>
>
>
> On Tue, May 29, 2018 at 12:27 PM, davecharlaff@hotmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>
>
> I dont seem to be able to get these element no's working in my
> spreadsheets.
>
> This is the cell content I have always used:
>
>
> I have re-downloaded the latest definitions, reopened the spreadsheet
> before updating and still I get an error.
>
> Addin is loaded and as far as I can tell is pointing at the SMF folder..
> Any suggestions wld be really welcome.
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar