2 Messages
Digest #4004
Messages
Sat May 13, 2017 2:03 pm (PDT) . Posted by:
"Allan" aprivoisermoi2005
This fix from a couple month ago got Yahoo financials for me but now,
for example:
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,1,"Period
Ending","Total Revenue",,,,"Add to Portfolio")
returns "Error" everywhere. Is there another fix or a better way or
place now to get financial data?
Allan
On 03/07/2017 05:25 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Yahoo financial data items are "unsupported" to the extent there are
> only a few defined elements. However, there is a template on the Yahoo
> group:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
>
> But that does use an older Yahoo page that they may remove.
> Unfortunately, the web page you quoted does not have the data within
> it. It is a generated web page. The actual data to fill the web page
> is done via an API call that returns JSON data:l
>
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
>
> Difficult to extract from.
>
> I tend to avoid Google and Yahoo for financials, because they have so
> few time periods. I also don't like the way Yahoo pigeon-holes the
> data (e.g. "Restricted cash" is included within "Cash and Equivalents").
>
> Google financials templates are on the web site:
>
> http://ogres-crypt.com/SMF/Templates/#Google
>
>
>
>
>
> On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
> ...wrote:
>
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
> <http://finance.yahoo.com/quote/LIND/financials?p=LIND>
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
>
>
--
Allan Anderson
3701 East Minnehaha Parkway
Minneapolis, MN 55417
612-217-2285
for example:
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,1,"Period
Ending","Total Revenue",,,,"Add to Portfolio")
returns "Error" everywhere. Is there another fix or a better way or
place now to get financial data?
Allan
On 03/07/2017 05:25 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Yahoo financial data items are "unsupported" to the extent there are
> only a few defined elements. However, there is a template on the Yahoo
> group:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
>
> But that does use an older Yahoo page that they may remove.
> Unfortunately, the web page you quoted does not have the data within
> it. It is a generated web page. The actual data to fill the web page
> is done via an API call that returns JSON data:l
>
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
>
> Difficult to extract from.
>
> I tend to avoid Google and Yahoo for financials, because they have so
> few time periods. I also don't like the way Yahoo pigeon-holes the
> data (e.g. "Restricted cash" is included within "Cash and Equivalents").
>
> Google financials templates are on the web site:
>
> http://ogres-crypt.com/SMF/Templates/#Google
>
>
>
>
>
> On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
> ...wrote:
>
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
> <http://finance.yahoo.com/quote/LIND/financials?p=LIND>
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
>
>
--
Allan Anderson
3701 East Minnehaha Parkway
Minneapolis, MN 55417
612-217-2285
Sat May 13, 2017 2:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As of last month, Yahoo no longer delivers the data in HTML pages on their
web pages. Instead, they do JSON calls and build the tables dynamically
from the returned data. The new experimental functions I've added should be
able to retrieve the data. For example:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.1.totalRevenue.raw")
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.2.totalRevenue.raw")
Unfortunately, between stocks and funds, there are dozens of modules and
thousands of field names available. And I've needed to change the
experimental functions as I run into issues. Lately, I haven't had a lot of
time available. I just got my new desktop computer installed this week, and
got the Creator's Update downloaded and installed yesterday. So the Yahoo
changes couldn't have come at a worse time.
I may be able to put up a workbook with a module/fieldname database, so
people can look things up as needed.
On Sat, May 13, 2017 at 9:03 AM, Allan allanhasmail@
...wrote:
>
> This fix from a couple month ago got Yahoo financials for me but now, for
> example:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/is?s="
> <http://finance.yahoo.com/q/is?s=>&Ticker,1,"Period Ending","Total
> Revenue",,,,"Add to Portfolio")
>
> returns "Error" everywhere. Is there another fix or a better way or place
> now to get financial data?
>
>
web pages. Instead, they do JSON calls and build the tables dynamically
from the returned data. The new experimental functions I've added should be
able to retrieve the data. For example:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.1.totalRevenue.raw")
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.2.totalRevenue.raw")
Unfortunately, between stocks and funds, there are dozens of modules and
thousands of field names available. And I've needed to change the
experimental functions as I run into issues. Lately, I haven't had a lot of
time available. I just got my new desktop computer installed this week, and
got the Creator's Update downloaded and installed yesterday. So the Yahoo
changes couldn't have come at a worse time.
I may be able to put up a workbook with a module/fieldname database, so
people can look things up as needed.
On Sat, May 13, 2017 at 9:03 AM, Allan allanhasmail@
...wrote:
>
> This fix from a couple month ago got Yahoo financials for me but now, for
> example:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/is?s="
> <http://finance.yahoo.com/q/is?s=>&Ticker,
> Revenue"
>
> returns "Error" everywhere. Is there another fix or a better way or place
> now to get financial data?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar