Minggu, 09 April 2017

[smf_addin] Digest Number 3958

14 Messages

Digest #3958
2b
Re: Getting the Sector and Industry from Yahoo by "Randy Harmelink" rharmelink

Messages

Sat Apr 8, 2017 10:54 pm (PDT) . Posted by:

ghart21

Things like =RCHGetElementNumber($B2,560) no longer work. Nor does:
=RCHGetTableCell("http://finance.yahoo.com/q/it?s="&$B2,1,">Net Institutional",">Net Shares Purchased")


Where $B2 is the stock symbol such as AAPL

Sun Apr 9, 2017 2:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like all the "holders" data is now on a JSON call:

https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=institutionOwnership,fundOwnership,majorDirectHolders,majorHoldersBreakdown,insiderTransactions,insiderHolders,netSharePurchaseActivity

​I have no access to EXCEL in the near future...​

On Sat, Apr 8, 2017 at 10:54 PM, ghart23@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Things like =RCHGetElementNumber($B2,560) no longer work. Nor does:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&$B2,1,">Net
> Institutional",">Net Shares Purchased")
>
>
> Where $B2 is the stock symbol such as AAPL
>
>
>
>

Sun Apr 9, 2017 6:53 am (PDT) . Posted by:

ghart21

Thanks Randy
Of course this major disruption in Yahoo earnings data access
would come up while you are "off the air"
Of the top of your head any idea what could be blocking the very
simple call:
=RCHGetElementNumber($B2,560)



-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Apr 9, 2017 5:25 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Did Yahoo make some massive change
within past day



It looks like all the "holders" data is now on a JSON call:

https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?mo\
dules=institutionOwnership,fundOwnership,majorDirectHolders,major\
HoldersBreakdown,insiderTransactions,insiderHolders,netSharePurch\
aseActivity
<https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?m\
odules=institutionOwnership,fundOwnership,majorDirectHolders,majo\
rHoldersBreakdown,insiderTransactions,insiderHolders,netSharePurc\
haseActivity>

​I have no access to EXCEL in the near future...​

On Sat, Apr 8, 2017 at 10:54 PM, ghart23@earthlink.net
<mailto:ghart23@earthlink.net> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:

Things like =RCHGetElementNumber($B2,560) no longer work. Nor
does:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=
<http://finance.yahoo.com/q/it?s=> "&$B2,1,">Net
Institutional",">Net Shares Purchased")




Where $B2 is the stock symbol such as AAPL





Sun Apr 9, 2017 8:06 am (PDT) . Posted by:

bob_15861586

Randy,


For me, the following use to work but it no longer does: =smfGetYahooOptionQuote("AMD","C",DATE(2018,1,19),20,"a")
It stopped working on Saturday. Any thoughts?


Bob

Sun Apr 9, 2017 11:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Probably the same issue of them moving things to JSON calls..

On Sun, Apr 9, 2017 at 8:06 AM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy,
>
> For me, the following use to work but it no longer does:
> =smfGetYahooOptionQuote("AMD","C",DATE(2018,1,19),20,"a")
> It stopped working on Saturday. Any thoughts?
>
> Bob
>
>
>
>
>

Sun Apr 9, 2017 11:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

At this point, I don't even know what element #560 is...

On Sun, Apr 9, 2017 at 6:49 AM, ghart23@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Thanks Randy
>
> Of course this major disruption in Yahoo earnings data access would come
> up while you are "off the air"
>
> Of the top of your head any idea what could be blocking the very simple
> call:
>
> =RCHGetElementNumber($B2,560)
>
>
>

Sun Apr 9, 2017 11:41 am (PDT) . Posted by:

ghart21

Randy
Current estimate of next years (FY2018) earnings
As compared with 7, 30 60 or 90 days ago
Thanks

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Apr 9, 2017 2:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Did Yahoo make some massive change
within past day



At this point, I don't even know what element #560 is...

On Sun, Apr 9, 2017 at 6:49 AM, ghart23@earthlink.net
<mailto:ghart23@earthlink.net> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:


Thanks Randy
Of course this major disruption in Yahoo earnings data access
would come up while you are "off the air"
Of the top of your head any idea what could be blocking the very
simple call:
=RCHGetElementNumber($B2,560)




Sun Apr 9, 2017 3:32 pm (PDT) . Posted by:

bob_15861586

Randy,

I am not sure it is Yahoo, in fact I think it is not. The following does not work for me either.
=smfGetGoogleOptionQuote("AMD","C",DATE(2018,1,19),20,"a")
Bob

Sun Apr 9, 2017 5:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The data is now being returned by a JSON call:

https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=upgradeDowngradeHistory,recommendationTrend,financialData,earningsHistory,earningsTrend,industryTrend,indexTrend,sectorTrend

On Sun, Apr 9, 2017 at 11:41 AM, ghart23@
​...wrote:

>
> Current estimate of next years (FY2018) earnings
>
> As compared with 7, 30 60 or 90 days ago
>
>
>

Sun Apr 9, 2017 6:24 pm (PDT) . Posted by:

ghart21

Randy
Does that mean the end of SMF-Addin as an extraction tool for
this earnings estimates part of Yahoo?
Forgive me if that is a particularly dopey question..
Thanks again
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Apr 9, 2017 8:42 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Did Yahoo make some massive change
within past day



The data is now being returned by a JSON call:

https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?mo\
dules=upgradeDowngradeHistory,recommendationTrend,financialData,e\
arningsHistory,earningsTrend,industryTrend,indexTrend,sectorTrend
<https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?m\
odules=upgradeDowngradeHistory,recommendationTrend,financialData,\
earningsHistory,earningsTrend,industryTrend,indexTrend,sectorTren\
d>

On Sun, Apr 9, 2017 at 11:41 AM, ghart23@​...wrote:

Current estimate of next years (FY2018) earnings
As compared with 7, 30 60 or 90 days ago




Sun Apr 9, 2017 7:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No. I've done a lot of extractions from JSON data. It's a bit trickier
though. And since I won't have access to EXCEL for another few weeks, I'm
not able to do much to fix things, or recommend exactly how to extract.

An example of extracting the number of full-time employees from a Yahoo
JSON query:

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

It may no longer work. I can't try it out. But it should give you some idea
of the function usage necessary to do an extraction from JSON output.

On Sun, Apr 9, 2017 at 6:24 PM, ghart23@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Does that mean the end of SMF-Addin as an extraction tool for this
> earnings estimates part of Yahoo?
>
> Forgive me if that is a particularly dopey question..
>
> Thanks again
>
>

Sun Apr 9, 2017 12:38 am (PDT) . Posted by:

"Robbie Geary" rgearyiii

Has Yahoo! broken the industry lookups in the course of getting rid of the
Industry Browser? All I get are errors now.

On Fri, Feb 3, 2017 at 12:34 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Works fine here. Could be Yahoo or communication issues?
>
> When you get an error on a ticker, do all of the items from that page
> return Error?
>
> *#* *Element*
> 13864 Sector Number
> 13865 Sector Name
> 13866 Industry Number
> 13867 Industry Name
> 13868 Industry Symbol
>
> On Thu, Feb 2, 2017 at 5:15 PM, Sundeep Chadha sundeep_chadha@
> ​...wrote:
>
>>
>> Any idea why this would return an error ?
>> =RCHGetElementNumber("YHOO&quot;,13867)
>>
>> Even though I see correct value on the actual page.
>> Lot of other symbols return correct value but some of then return with
>> error even when there is good value on the page
>>
>
>

--
Robbie Geary

Sun Apr 9, 2017 2:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like everything is being moved to JSON calls:

https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=assetProfile

​I have no access to EXCEL in the near future...​

On Sun, Apr 9, 2017 at 12:38 AM, Robbie Geary rgearyiii@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Has Yahoo! broken the industry lookups in the course of getting rid of the
> Industry Browser? All I get are errors now.
>
>
> On Fri, Feb 3, 2017 at 12:34 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Works fine here. Could be Yahoo or communication issues?
>>
>> When you get an error on a ticker, do all of the items from that page
>> return Error?
>>
>> *#* *Element*
>> 13864 Sector Number
>> 13865 Sector Name
>> 13866 Industry Number
>> 13867 Industry Name
>> 13868 Industry Symbol
>>
>> On Thu, Feb 2, 2017 at 5:15 PM, Sundeep Chadha sundeep_chadha@
>> ​...wrote:
>>
>>>
>>> Any idea why this would return an error ?
>>> =RCHGetElementNumber("YHOO&quot;,13867)
>>>
>>> Even though I see correct value on the actual page.
>>> Lot of other symbols return correct value but some of then return with
>>> error even when there is good value on the page
>>>
>>
>

Sun Apr 9, 2017 2:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

MorningStar is not a trivial extraction. It is not delivered within a web
page for the one you cited. They retrieve the data from here and build the
table dynamically:

http://financials.morningstar.com/finan/financials/getFinancePart.html?t=AAPL

I have no access to EXCEL in the near future...​

On Thu, Apr 6, 2017 at 4:47 PM, labsrcool@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> RCHGetElementNumber (13878) (Earning per Share (TTM) does not appear to
> be working. I also would prefer to grab data from Morningstar using
> the RCHGetTableCell
>
> I wrote the following...
>
> =RCHGetTableCell("http://financials.morningstar.com/
> ratios/r.html?t=TICKER®ion=usa&culture=en-US",1,"earnings per
> share","ttm").
>
> This is giving me an error and realize that it is user error, but don't
> know how to fix the formula. I have read Randy's guidance documentation
> on RCHGetTableCell, but did not enlighten me. Any guidance from the
> group on how to correct? Much appreciated.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)