Rabu, 12 Oktober 2016

[smf_addin] Digest Number 3817

3 Messages

Digest #3817

Messages

Tue Oct 11, 2016 8:52 pm (PDT) . Posted by:

climbermel

None of the codes for AdvFn seem to work for me... (5196 - 13625). Did they change their page layout? I can get the data I was trying to get: Total Debt/Equity (Gearing Ratio) 0.28, by using
=smfGetTagContent("http://www.advfn.com/stock-market/NYSE/JNJ/financials","td",138).
Is there somewhere else I can get that ratio? element 967 is Yahoo Total Debt/Equity but that returns 36.64.


Thanks,
Mel



Tue Oct 11, 2016 9:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried the smfGetAdvFNElement-Template-Specific-Line-Items.xls
template from the website, using ticker symbol MMM, and I had data filled
in for all the line items it has.

Looking at GuruFocus, the 0.28 value seems to be the Dec 2015 value, while
the June 2016 value shows as 0.36:

http://www.gurufocus.com/financials/JNJ

I've not had much confidence in AdvFN data for several years, which is why
I am now a paid subscriber to Guru Focus.

If you want to pursue using AdvFN data, let me know which version of the
add-in you're using:

=RCHGetElementNumber("Version")

Also, did you need either or both of the AdvFN "fixes" mentioned on the
"Tip and FAQs" web page?

On Tue, Oct 11, 2016 at 8:52 PM, climbermel@
​...wrote:

>
> None of the codes for AdvFn seem to work for me... (5196 - 13625). Did
> they change their page layout? I can get the data I was trying to get:
> Total Debt/Equity (Gearing Ratio) 0.28, by using
>
> =smfGetTagContent("http://www.advfn.com/stock-market/NYSE/JNJ/financials
> ","td",138).
>
> Is there somewhere else I can get that ratio? element 967 is Yahoo Total
> Debt/Equity but that returns 36.64.
>
>

Wed Oct 12, 2016 1:33 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Templates and Examples/RCHGetYahooHistory/RCH_Stock_Market_Functions-2.1.2016.09.02.zip
Uploaded by : geoffw222 <geoffw222@yahoo.com>
Description :

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetYahooHistory/RCH_Stock_Market_Functions-2.1.2016.09.02.zip

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

geoffw222 <geoffw222@yahoo.com>

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar