Senin, 08 Mei 2017

[smf_addin] Digest Number 3999

11 Messages

Digest #3999
1b
Re: RCHGetTableCell-Yahoo by "Randy Harmelink" rharmelink
1d
Re: RCHGetTableCell-Yahoo by "Randy Harmelink" rharmelink
3a
Gurufocus. Kaput? by "Jim Ranum" amt2100
3b
Re: Gurufocus. Kaput? by "Randy Harmelink" rharmelink
3c
Re: Gurufocus. Kaput? by "Jim Ranum" amt2100

Messages

Mon May 8, 2017 3:09 am (PDT) . Posted by:

irebian

Hi Randy,
Any chance of getting a new template of RCHGetTableCell-Template-Yahoo-Financial-Statements?
I've used it for years to get US and non US balance sheets.
thanks
Arthur


Mon May 8, 2017 3:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried the template from the website and it worked for me. Did you
not install the recent updates? Yahoo made a lot of changes recently that
required updates to the add-in.

On Mon, May 8, 2017 at 3:09 AM, irebian@yahoo.com.au [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Any chance of getting a new template of RCHGetTableCell-Template-
> Yahoo-Financial-Statements?
> I've used it for years to get US and non US balance sheets.
>

Mon May 8, 2017 6:13 am (PDT) . Posted by:

irebian

I'm running Stock Market Functions add-in, Version 2.1.2017.05.03 (D:\SMF Add-in; Windows (32-bit) NT 10.00; 16.0; ; ; 49)
usually with Excel 2003 but I just tried Excel2016 as well.
In the template cell C50 (total assets quarterly) calls

RCHGetTableCell("http://finance.yahoo.com/q/bs?s="&Ticker;1;"Period Ending";"Total Assets";;;;"Add to Portfolio")
but the new Yahoo website requires
https://finance.yahoo.com/quote/IBM/balance-sheet?p=IBM https://finance.yahoo.com/quote/IBM/balance-sheet?p=IBM as address.
Is this compatible?
Thanks
Arthur

Mon May 8, 2017 8:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ah, my mistake. Sorry. For some reason, I read "Key Statistics" instead of
"Financial Statements". No idea why.

Yes, all of the financial statements formulas need to use the JSON data
files instead of the web pages, as the web pages no longer contain the HTML
tables. They are built dynamically.

For example, the annual total assets will now be:

=smfGetYahooJSONField("MMM","balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.0.totalAssets.raw")

=smfGetYahooJSONField("MMM","balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.1.totalAssets.raw")

=smfGetYahooJSONField("MMM","balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.2.totalAssets.raw")

On Mon, May 8, 2017 at 6:13 AM, irebian@
​...wrote:

>
> I'm running
> Stock Market Functions add-in, Version 2.1.2017.05.03 (D:\SMF Add-in;
> Windows (32-bit) NT 10.00; 16.0; ; ; 49)
> usually with Excel 2003 but I just tried Excel2016 as well.
> In the template cell C50 (total assets quarterly) calls
>
> RCHGetTableCell("http://finance.yahoo.com/q/bs?s="&Ticker;1;"Period
> Ending";"Total Assets";;;;"Add to Portfolio")
> but the new Yahoo website requires
> https://finance.yahoo.com/quote/IBM/balance-sheet?p=IBM as address.
> Is this compatible?
> Thanks
> Arthur
>
> __._,_._
>

Mon May 8, 2017 4:57 am (PDT) . Posted by:

bleushin19

Hi Randy,


Thank you for last week. It's running fine now. Only problem for now is that I can't get the needed data using RCHGetTableCell on YahooFinance using.


=RCHGetTableCell("http://finance.yahoo.com/quote/AAPL/financials?p="AAPL,2,"Annual&quot;,">Income Statement",,,2)


I can only get the Annual but I can't seem to get the value for the Quarterly. It seems I am missing something in the formula.


Any idea what it is? I already tried changing "Annual" to "Quarterly&quot; but it doesn't seem to work.


Thanks,

Mon May 8, 2017 9:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The extractions need to change to using the new JSON files on Yahoo. For
example:

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.0.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.1.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.2.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.3.totalRevenue.raw")

I'm working on it, but it's going slowly. Sorry.

On Mon, May 8, 2017 at 4:57 AM, bleushin19@
​...wrote:

> Thank you for last week. It's running fine now. Only problem for now is
> that I can't get the needed data using RCHGetTableCell on YahooFinance
> using.
>
> =RCHGetTableCell("http://finance.yahoo.com/quote/AAPL/financials?p="AAPL
> ,2,"Annual&quot;,">Income Statement",,,2)
>
> I can only get the Annual but I can't seem to get the value for the
> Quarterly. It seems I am missing something in the formula.
>
> Any idea what it is? I already tried changing "Annual" to "Quarterly&quot; but
> it doesn't seem to work.
>
>

Mon May 8, 2017 3:42 pm (PDT) . Posted by:

bleushin19

No worries and thank you so much Randy, we really appreciate it. I'll check out some documentation you have on the site for the JSON call and study how to use it.


---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

The extractions need to change to using the new JSON files on Yahoo. For example:

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.0.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.1.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.2.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistoryQuarterly","quoteSummary.result.0.incomeStatementHistoryQuarterly.incomeStatementHistory.3.totalRevenue.raw")


I'm working on it, but it's going slowly. Sorry.


On Mon, May 8, 2017 at 4:57 AM, bleushin19@ ​...wrote:

Thank you for last week. It's running fine now. Only problem for now is that I can't get the needed data using RCHGetTableCell on YahooFinance using.

=RCHGetTableCell("http:// finance.yahoo.com/quote/AAPL/ financials?p= http://finance.yahoo.com/quote/AAPL/financials?p="AAPL,2,"Annual&quot;, ">Income Statement",,,2)

I can only get the Annual but I can't seem to get the value for the Quarterly. It seems I am missing something in the formula.

Any idea what it is? I already tried changing "Annual" to "Quarterly&quot; but it doesn't seem to work.









Mon May 8, 2017 10:39 am (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

All my links to Gurufocus stopped working. Did they do something to disable the SMF addin?

Specifically, I was grabbing PE, PS, etc. off of the "stock" page.
But I also need to revamp a couple requests off of the Financials page, which has the complication of multiple columns that change according to the individual stock.
Say Revenue, for the TTM column.
None of my links are working. I don't like the new built-in add-in they have. It's REALLY slow and requires constant and repetitive logins.
I'm wondering if they are now blocking other add-ins?


Thanks,
Jim

Mon May 8, 2017 11:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Did you miss last week's update? See:

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

On Mon, May 8, 2017 at 10:39 AM, 'Jim Ranum' amt2100@
​...wrote:

>
>
> All my links to Gurufocus stopped working. Did they do something to
> disable the SMF addin?
>
>
>
> Specifically, I was grabbing PE, PS, etc. off of the "stock" page.
>
> But I also need to revamp a couple requests off of the Financials page,
> which has the complication of multiple columns that change according to the
> individual stock.
>
> Say Revenue, for the TTM column.
>
> None of my links are working. I don't like the new built-in add-in they
> have. It's REALLY slow and requires constant and repetitive logins.
>
> I'm wondering if they are now blocking other add-ins?
>
>
>
>
>

Mon May 8, 2017 11:23 am (PDT) . Posted by:

"Jim Ranum" amt2100

Well I sure did!
I just thought it pertained to yahoo. Sorry about that.

Thank Randy. I'll try it.
Jim


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 08, 2017 2:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus. Kaput?


Did you miss last week's update? See:

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

On Mon, May 8, 2017 at 10:39 AM, 'Jim Ranum' amt2100@
​...wrote:

All my links to Gurufocus stopped working. Did they do something to disable the SMF addin?

Specifically, I was grabbing PE, PS, etc. off of the "stock" page.
But I also need to revamp a couple requests off of the Financials page, which has the complication of multiple columns that change according to the individual stock.
Say Revenue, for the TTM column.
None of my links are working. I don't like the new built-in add-in they have. It's REALLY slow and requires constant and repetitive logins.
I'm wondering if they are now blocking other add-ins?




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)