4 New Messages
Digest #2658
Messages
Sun Jun 16, 2013 8:08 am (PDT) . Posted by:
"RaviA" rannavajjhala
Hi Randy,
I am using smfGetAdvFNElement to retrieve financial statement data. It's generally working well. but, it seems to be missing some fields.
For eg. if I am pulling annual financial statements of Pfizer (PFE), most fields are being pulled. One example of a field that's not getting pulled is "Pre-Tax Income". The field is populated and has numbers - yet I get a zero in excel. This is the syntax I am using (which works for every other field)
Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data (currently set to A) and C9 has the field "Pre-Tax Income"
=smfGetADVFNElement($B$2,$B$3,COLUMNS($D:D),">"&$C9&"<",,"--")
I even cut and paste the field "Pre-Tax Income" from advfn website-just to make sure I am not messing something up - still doesn't work.
Can you please help?
Thank you!
Ravi
I am using smfGetAdvFNElement to retrieve financial statement data. It's generally working well. but, it seems to be missing some fields.
For eg. if I am pulling annual financial statements of Pfizer (PFE), most fields are being pulled. One example of a field that's not getting pulled is "Pre-Tax Income"
Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data (currently set to A) and C9 has the field "Pre-Tax Income"
=smfGetADVFNElement
I even cut and paste the field "Pre-Tax Income" from advfn website-just to make sure I am not messing something up - still doesn't work.
Can you please help?
Thank you!
Ravi
Sun Jun 16, 2013 8:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I look at the source code of the web page, I'm seeing the tag on the
web page as ">pre-tax income <", not ">pre-tax income<", with a space
before the HTML mark at the end.
So this works for me:
=smfGetADVFNElement("PFE","Q",1,">Pre-Tax Income <",,"--")
On Sun, Jun 16, 2013 at 7:42 AM, RaviA <rannavajjhala@yahoo.com > wrote:
> I am using smfGetAdvFNElement to retrieve financial statement data. It's
> generally working well. but, it seems to be missing some fields.
> For eg. if I am pulling annual financial statements of Pfizer (PFE), most
> fields are being pulled. One example of a field that's not getting pulled
> is "Pre-Tax Income". The field is populated and has numbers - yet I get a
> zero in excel. This is the syntax I am using (which works for every other
> field)
> Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data
> (currently set to A) and C9 has the field "Pre-Tax Income"
> =smfGetADVFNElement($B$2,$B$3,COLUMNS($D:D),">"&$C9&"<",,"--")
>
> I even cut and paste the field "Pre-Tax Income" from advfn website-just to
> make sure I am not messing something up - still doesn't work.
>
web page as ">pre-
before the HTML mark at the end.
So this works for me:
=smfGetADVFNElement
On Sun, Jun 16, 2013 at 7:42 AM, RaviA <rannavajjhala@
> I am using smfGetAdvFNElement to retrieve financial statement data. It's
> generally working well. but, it seems to be missing some fields.
> For eg. if I am pulling annual financial statements of Pfizer (PFE), most
> fields are being pulled. One example of a field that's not getting pulled
> is "Pre-Tax Income"
> zero in excel. This is the syntax I am using (which works for every other
> field)
> Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data
> (currently set to A) and C9 has the field "Pre-Tax Income"
> =smfGetADVFNElement
>
> I even cut and paste the field "Pre-Tax Income" from advfn website-just to
> make sure I am not messing something up - still doesn't work.
>
Sun Jun 16, 2013 12:22 pm (PDT) . Posted by:
"nuagesolutions" nuagesolutions
Any help somebody ??
--- In smf_addin@yahoogroups.com , "nuagesolutions" <nuagesolutions@...> wrote:
>
> Hi,
>
> I saw this post and I would be interested by the .net accessibility for this add-in.
>
> I am using vb.net and it would be great to use this add-in functions through vb.net.
>
> Can somebody help ?
>
> Thanks.
>
> --- In smf_addin@yahoogroups.com , "jackoblacko1" <jackoblacko1@> wrote:
> >
> > Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group.
> >
> > I assume that's ok with you. Let me know if it's not.
> >
> > .luca
> >
>
--- In smf_addin@yahoogrou
>
> Hi,
>
> I saw this post and I would be interested by the .net accessibility for this add-in.
>
> I am using vb.net and it would be great to use this add-in functions through vb.net.
>
> Can somebody help ?
>
> Thanks.
>
> --- In smf_addin@yahoogrou
> >
> > Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group.
> >
> > I assume that's ok with you. Let me know if it's not.
> >
> > .luca
> >
>
Mon Jun 17, 2013 12:07 am (PDT) . Posted by:
"sri yanto" sri.yanto
hallo randy, i need your help again.
here i want to capture P/E data from WSJ.
i am using RCHGettable
=RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/BMRI ",1,"P/E Ratio")
it's return "ERROR"
are this stuff need use smftagcontent to grab it?
Thanks after all
here i want to capture P/E data from WSJ.
i am using RCHGettable
=RCHGetTableCell(
it's return "ERROR"
are this stuff need use smftagcontent to grab it?
Thanks after all
Tidak ada komentar:
Posting Komentar