6 Messages
Digest #3741
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
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.
>
>
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
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
>
# 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?
Unfortunately this:
=RCHGetElementNumbe
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 =RCHGetElementNumbe
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?
>
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:
> =RCHGetElementNumbe
> 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
> =RCHGetElementNumbe
> 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:
Posting Komentar