Rabu, 11 Maret 2015

[smf_addin] Digest Number 3353

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

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&quot;,10,">PFCF")
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar