Rabu, 13 Juli 2016

[smf_addin] Digest Number 3741

6 Messages

Digest #3741
1a
Financials by davidjosephchapman
1b
Re: Financials by "Randy Harmelink" rharmelink
2b
Re: number of employees data from Yahoo by "Randy Harmelink" rharmelink
2d
Re: number of employees data from Yahoo by "Randy Harmelink" rharmelink

Messages

Tue Jul 12, 2016 8:01 am (PDT) . Posted by:

davidjosephchapman

is there a function to pull in these:

Income Statement
Balance Sheet
Cash Flow Statement

I am trying to setup intrinsic value calcs.

David



Tue Jul 12, 2016 8:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup, All kinds of formulas, and a number of templates on the web site.

This is probably the easiest way:

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

On Tue, Jul 12, 2016 at 7:03 AM, davidjosephchapman@icloud.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> is there a function to pull in these:
>
> Income Statement
> Balance Sheet
> Cash Flow Statement
>
> I am trying to setup intrinsic value calcs.
>
>

Tue Jul 12, 2016 5:46 pm (PDT) . Posted by:

mokwit

From the new format it now seems Yahoo carries the data for a companies number of employees under 'profile' e.g.

http://finance.yahoo.com/quote/HPQ/profile http://finance.yahoo.com/quote/HPQ/profile
http://finance.yahoo.com/quote/HPQ/profile

HPQ Profile | HP Inc. Common Stock Stock - Yahoo Finance http://finance.yahoo.com/quote/HPQ/profile See the company profile for HP Inc. Common Stock (HPQ) including business summary, industry/sector information, number of employees, business summary, corporate governance, key executives and their compensation.



View on finance.yahoo.com http://finance.yahoo.com/quote/HPQ/profile
Preview by Yahoo



This is a very useful data point.

If it is new can I respectfully request that it is added to the smf_addin.

If it is old (and despite looking intently in the documentation I cannot find it) and already there, can someone please give me the identifier number


Tue Jul 12, 2016 8:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element numbers are defined for getting it from AdvFN:

# Source Element
6686 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY1
6687 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY2
6688 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY3
6689 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY4
6690 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY5
6691 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY6
6692 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY7
6693 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY8
6694 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY9
6695 AdvFN-A Annual Balance Sheet -- Equity and Liabilities -- Number of
Employees -- FY10
This gets the same number shown on Yahoo:

=RCHGetElementNumber("HPQ",6686)

The Yahoo web page you cite is brand new. They just redid it. I don't think
they've displayed that information before? The data you want is not
physically located in the source code of the page. It is placed there
dynamically from JSON output. So the extraction is a bit convoluted:

=smfConvertData(smfStrExtr(RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/HPQ?modules=assetProfile&corsDomain=finance.yahoo.com
"),"fullTimeEmployees"":",","))

I believe they get the data from MorningStar, so you
​could get it directly from them, with:

=smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=HPQ
","span",1,"Employees",,,,1)

On Tue, Jul 12, 2016 at 5:46 PM, pmanz@
​...wrote:

>
> From the new format it now seems Yahoo carries the data for a companies
> number of employees under 'profile' e.g.
>
> http://finance.yahoo.com/quote/HPQ/profile
>
>
This is a very useful data point.
>
> If it is new can I respectfully request that it is added to the smf_addin.
>
> If it is old (and despite looking intently in the documentation I cannot
> find it) and already there, can someone please give me the identifier number
>

Tue Jul 12, 2016 11:09 pm (PDT) . Posted by:

mokwit

Randy. Thanks for reply.
Unfortunately this:
=RCHGetElementNumber("HPQ";,6686)
copied and pasted into a cell just gives "error" - something I am not doing?

Also I need to use a cell reference for the ticker as in =RCHGetElementNumber(A1,6686)
so that also rules out the URL solutions e.g direct from Morningstar or does it?

Tue Jul 12, 2016 11:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check the "FAQs and Tips" web page for a few items that may be an issue
with AdvFN items.

You just need to use normal EXCEL concatenation to get the cell reference
within the strings in the URL's. For example:

=smfGetTagContent("http://quotes.morningstar.com/stock/c-company-profile?t=
<http://quotes.morningstar.com/stock/c-company-profile?t=HPQ>" &
A1,"span",1,"Employees",,,,1)

On Tue, Jul 12, 2016 at 11:09 PM, pmanz@usa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Unfortunately this:
> =RCHGetElementNumber("HPQ";,6686)
> copied and pasted into a cell just gives "error" - something I am not
> doing?
>
> Also I need to use a cell reference for the ticker as in
> =RCHGetElementNumber(A1,6686)
> so that also rules out the URL solutions e.g direct from Morningstar or
> does it?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar