3 Messages
Digest #3353
Messages
Tue Mar 10, 2015 1:06 pm (PDT) . Posted by:
malli.boggala
Hello Randy,
I need your help.
I'm trying to pull last Quarterly PFCF data, but using formula below I can get annual PFCF(Dec 14), how to get 2nd line Quarterly data from the same page.
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"/Price-to-Free-Cash-Flow%2Bratio/National%2BOilwell%2BVarco%2BInc",10,">PFCF")
Thanks in advance.
Regards,
Arjun
I need your help.
I'm trying to pull last Quarterly PFCF data, but using formula below I can get annual PFCF(Dec 14), how to get 2nd line Quarterly data from the same page.
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"
Thanks in advance.
Regards,
Arjun
Tue Mar 10, 2015 1:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just add another search term to position yourself:
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"/Price-to-Free-Cash-Flow%2Bratio/xxx",1,"
Annual Data",">PFCF")
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"/Price-to-Free-Cash-Flow%2Bratio/xxx",1,"
Quarterly Data",">PFCF")
Note I dropped the irrelevant company name
"National%2BOilwell%2BVarco%2BInc" and replaced it with "xxx". You just
need a placeholder.
On Tue, Mar 10, 2015 at 1:06 PM, malli.boggala@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to pull last Quarterly PFCF data, but using formula below I
> can get annual PFCF(Dec 14), how to get 2nd line Quarterly data from the
> same page.
>
> =RCHGetTableCell("http://www.gurufocus.com/term/pfcf/
> "&A3&"/Price-to-Free-Cash-Flow%2Bratio/National%2BOilwell%2BVarco%2BInc",10,">PFCF")
>
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"/Price-to-Free-Cash-Flow%2Bratio/xxx",1,"
Annual Data",">PFCF")
=RCHGetTableCell("http://www.gurufocus.com/term/pfcf/"&A3&"/Price-to-Free-Cash-Flow%2Bratio/xxx",1,"
Quarterly Data",">PFCF")
Note I dropped the irrelevant company name
"National%2BOilwell%2BVarco%2BInc" and replaced it with "xxx". You just
need a placeholder.
On Tue, Mar 10, 2015 at 1:06 PM, malli.boggala@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to pull last Quarterly PFCF data, but using formula below I
> can get annual PFCF(Dec 14), how to get 2nd line Quarterly data from the
> same page.
>
> =RCHGetTableCell("http://www.gurufocus.com/term/pfcf/
> "&A3&"
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar