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
=smfGetTagContent("http://www.advfn.com/stock-market/NYSE/JNJ/financials","
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.
>
>
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
> ","
>
> Is there somewhere else I can get that ratio? element 967 is Yahoo Total
> Debt/Equity but that returns 36.64.
>
>
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:
Posting Komentar