[smf_addin] Digest Number 2243

EXCEL Stock Market Functions Add-in

Messages In This Digest (2 Messages)

1a.

Re: ADVFN Element Numbers From: Ron Spruell

2a.

Re: SCTR scores From: smithjhhic

View All Topics | Create New Topic

Messages

1a.

Re: ADVFN Element Numbers

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Sun Jun 10, 2012 4:39 pm (PDT)

Simply amazing!  Thanks.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, June 10, 2012 6:03 PM
>Subject: Re: [smf_addin] ADVFN Element Numbers
>
>
> 
>Elements were only set up for the quarterly and annual financials.
>
>These work fine for me for RAVN:
>
>=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=RAVN",1,">Dividend ps")
>=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=RAVN",1,">Free Cash Flow ps")
>
>
>On Sun, Jun 10, 2012 at 3:10 PM, Ron Spruell <hashky@yahoo.com> wrote:
>
>
>>
>>Do you have Element Numbers for Company Data Tab on ADVFN?  I searched the .txt files and could not find them.
>>
>>
>>
>>http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14
>>
>>
>>I want to pull Free Cash Flow pS and Dividend pS. 
>>
>>
>>
>>I can pull these with RCHGetTableCell.
>>
>>
>>=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's Close","Free Cash Flow pS")
>>=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's Close","Dividend pS")
>>
>>Do you have any idea why this doesn't work with RAVN, CTWS, CTAS, and many more?
>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.

Re: SCTR scores

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Jun 10, 2012 5:01 pm (PDT)

That work, Thank you.
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It's hard for me to see what's wrong without you showing the formula? :)
>
> This works for me:
>
> =RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",5,"?c="&C3&",")
>
> On Sun, Jun 10, 2012 at 3:24 PM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > Thanks, I am having trouble replacing symbol "T" with obtaining symbol
> > from cell C3 similar to my other formulas. I must have a typo, but can't
> > seem to find it.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)

Recent Activity

•  83
  New Members
•  1
  New Files

Visit Your Group

Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe