Selasa, 29 November 2016

[smf_addin] Digest Number 3854

15 Messages

Digest #3854
1a
Yahoo Elements by justy_sports
1b
Re: Yahoo Elements by "Randy Harmelink" rharmelink
1c
Re: Yahoo Elements by justy_sports
1d
1e
1f
Re: Yahoo Elements by "Randy Harmelink" rharmelink
1g
Re: Yahoo Elements by justy_sports
1h
Re: Yahoo Elements by "Randy Harmelink" rharmelink
1i
Re: Yahoo Elements by justy_sports
1j
Re: Yahoo Elements by justy_sports
1k
1l
Re: Yahoo Elements by justy_sports
1m
Re: Yahoo Elements by "Randy Harmelink" rharmelink
1n
Re: Yahoo Elements by justy_sports
2
IBD json extraction by sirons1962

Messages

Tue Nov 29, 2016 11:56 am (PST) . Posted by:

justy_sports

Anyone else having issues retrieving Yahoo data elements (ex. element # 599)?


I have been trying to self-troubleshoot all morning and can't figure out why no Yahoo elements will pull in for me.


Thanks!

Tue Nov 29, 2016 12:15 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried it for MMM and received "N/A", which is what Yahoo has posted.

On Tue, Nov 29, 2016 at 12:56 PM, justy_sports@
​...wrote:

> Anyone else having issues retrieving Yahoo data elements (ex. element #
> 599)?
>
> I have been trying to self-troubleshoot all morning and can't figure out
> why no Yahoo elements will pull in for me.
>
>

Tue Nov 29, 2016 12:24 pm (PST) . Posted by:

justy_sports

I receive "Error" when I try =RCHGetElementNumber("MMM",599)

My version is - Stock Market Functions add-in, Version 2.1.2016.09.02 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; www; Local; 1)


smfGetAParms - YahooAE;Earnings Estimates -- Year Ago EPS -- FY1;http://finance.yahoo.com/q/ae?s=~~~~~;3;EARNINGS EST;YEAR AGO EPS; ; ;0;0;0;0


I have a colleague experiencing the same issue on his computer... might we have an outdated definition file? I tried removing all definition files and re-downloading the current versions but that did not help.



Tue Nov 29, 2016 12:28 pm (PST) . Posted by:

ghart21

Randy
For a few days now Yahoo Finance has had N/A for many but not all
stocks in the Earnings Estimates part of Analyst Estimates.
Wish Yahoo would just make this available as a "for fee" service
and keep it maintained. It's getting noticeably more shaky.

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Nov 29, 2016 8:15 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Elements



I just tried it for MMM and received "N/A", which is what Yahoo
has posted.

On Tue, Nov 29, 2016 at 12:56 PM, justy_sports@​...wrote:

Anyone else having issues retrieving Yahoo data elements (ex.
element # 599)?



I have been trying to self-troubleshoot all morning and can't
figure out why no Yahoo elements will pull in for me.




Tue Nov 29, 2016 12:29 pm (PST) . Posted by:

ghart21

For a few days now Yahoo Finance has had N/A for many but not all
stocks in the Earnings Estimates part of Analyst Estimates.
Wish Yahoo would just make this available as a "for fee" service
and keep it maintained. It's getting noticeably more shaky.

++++++++++++++++++++
-----Original Message-----
From: "justy_sports@yahoo.com [smf_addin]"
Sent: Nov 29, 2016 8:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Elements


I receive "Error" when I try =RCHGetElementNumber("MMM",599)

My version is - Stock Market Functions add-in, Version
2.1.2016.09.02 (C:\Program Files\SMF Add-in; Windows (32-bit) NT
6.01; 15.0; www; Local; 1)
smfGetAParms - YahooAE;Earnings Estimates -- Year Ago EPS --
FY1;http://finance.yahoo.com/q/ae?s=~~~~~;3;EARNINGS EST;YEAR AGO
EPS; ; ;0;0;0;0
I have a colleague experiencing the same issue on his computer...
might we have an outdated definition file? I tried removing all
definition files and re-downloading the current versions but that
did not help.


Tue Nov 29, 2016 2:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Your definition is the same as mine...that definition should be doing:

=RCHGetTableCell("http://finance.yahoo.com/q/ae?s=MMM",3,"EARNINGS
EST","YEAR AGO EPS")

What do you get if you use the above formula?

On Tue, Nov 29, 2016 at 1:24 PM, justy_sports@
​...wrote:

>
> I receive "Error" when I try =RCHGetElementNumber("MMM",599)
>
> My version is - Stock Market Functions add-in, Version 2.1.2016.09.02
> (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; www; Local; 1)
>
> smfGetAParms - YahooAE;Earnings Estimates -- Year Ago EPS -- FY
> ​​
> 1;http://finance.yahoo.com/q/ae?s=~~~~~;3;EARNINGS EST;YEAR AGO EPS; ;
> ;0;0;0;0
>
> I have a colleague experiencing the same issue on his computer... might we
> have an outdated definition file? I tried removing all definition files and
> re-downloading the current versions but that did not help.
>

Tue Nov 29, 2016 3:08 pm (PST) . Posted by:

justy_sports

That formula returns "Error"

When I enter the URL in your formula directly into my web browser, I am redirected to - http://finance.yahoo.com/quote/MMM/analysts?ltr=1 http://finance.yahoo.com/quote/MMM/analysts?ltr=1


Might that have something to do with it?




Tue Nov 29, 2016 3:29 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It probably does. Try this Internet Options fix:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464

I'm assuming the formula works with the new URL:

=RCHGetTableCell("http://finance.yahoo.com/quote/MMM/analysts",3,"EARNINGS
EST","YEAR AGO EPS")

On Tue, Nov 29, 2016 at 4:08 PM, justy_sports@
​...wrote:

>
> That formula returns "Error"
>
> When I enter the URL in your formula directly into my web browser, I am
> redirected to - http://finance.yahoo.com/quote/MMM/analysts?ltr=1
>
> Might that have something to do with it?
>
>

Tue Nov 29, 2016 4:17 pm (PST) . Posted by:

justy_sports

No luck. I'll have to keep experimenting.

I'd be interested to know if anyone else is having a similar issue. Seems like the Yahoo data elements would be commonly used.


Tue Nov 29, 2016 4:25 pm (PST) . Posted by:

justy_sports

No luck with that change. I'll have to keep experimenting.

I'd be interested to know if anyone else has experienced something similar. Seems like the Yahoo elements would be commonly used.

Tue Nov 29, 2016 5:16 pm (PST) . Posted by:

ghart21

I'm puzzled , are you in a parallel universe where there are actual numbers in the Earnings Estimates for MMM and not just "N/A"? This week many stocks have N/A in some or all Yahoo Finance "Earnings Estimates": AVGO, PWR, VMC ... The list is long

Tue Nov 29, 2016 5:22 pm (PST) . Posted by:

justy_sports

This issue is not the N/A. My formula returns "Error" instead of N/A. I totally understand that if the Yahoo site displays N/A, that is what will be displayed in Excel.

Problem is when I use RCHGetElementNumber for any Yahoo element for any Ticker, I receive a value of Error, regardless of what the Yahoo site shows.


Other elements from other sites work just fine (Zacks, BarChart, AdvFN, etc).

Tue Nov 29, 2016 6:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts",,500)

=RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts","Year Ago
EPS",200)

=smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","td",1,"Year
Ago EPS")

=smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","span",1,"Year
Ago EPS")

If you get "Error" on the first, the others are irrelevant because you
aren't even able to access the web page.

On Tue, Nov 29, 2016 at 6:22 PM, justy_sports@
​...wrote:

>
> This issue is not the N/A. My formula returns "Error" instead of N/A. I
> totally understand that if the Yahoo site displays N/A, that is what will
> be displayed in Excel.
>
> Problem is when I use RCHGetElementNumber for any Yahoo element for any
> Ticker, I receive a value of Error, regardless of what the Yahoo site shows.
>
> Other elements from other sites work just fine (Zacks, BarChart, AdvFN,
> etc).
>

Tue Nov 29, 2016 6:18 pm (PST) . Posted by:

justy_sports

=RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts",,500) <!DOCTYPE html><html id="atomic" class="NoJs ie-11 desktop" lang="en-US"><head prefix="og: http://ogp.me/ns#"><script>window.performance && window.performance.mark && window.performance.mark('PageStart');</script><meta charset="utf-8"/><title>MMM Analyst Opinion | Analyst Estimates | 3M Company Common Stock Stock - Yahoo Finance</title><meta name="keywords" content="recommendation,analyst,analyst rating,strong buy,strong sell,hold,buy,sell,overweight,underweight,upgrade,downgrade,price target,EP


=RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts","Year Ago EPS",200) Year Ago EPS","YEAR_AGO_SALES":"Year Ago Sales","YORIG_TITLE":"Yahoo Originals","YOY":"yoy","YTD":"YTD","YTD_RETURN":"YTD Return","YTD_RETURN_MKT":"Year-to-Date Return (Mkt)","YTD_RETURN_PCT":"Year-to


=smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","td",1,"Year Ago EPS") Error


=smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","span",1,"Year Ago EPS") Error


Tue Nov 29, 2016 7:07 pm (PST) . Posted by:

sirons1962

Randy,

Is there a way to pull the data from this:

http://research.investors.com/services/PsyChartService.svc/summary?type=highlowratio&frequency=1 http://research.investors.com/services/PsyChartService.svc/summary?type=highlowratio&frequency=1

which leads to a json item, I think, which is this:

{"GetSummaryResult":{"ErrorMessage":"","Frequency":1,"HasError&quot;:false,"Price";:3.34,"Price2":0,"Price2Change&quot;:0,"PriceChange";:0.2652,"Type":3,"Updated":"&#92;/Date(1480320000000-0800)\/"}}

I am looking to get the "Price":3.34 out of it.


Thanks for all you do with this great add-in!

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

Tidak ada komentar:

Poskan Komentar