[smf_addin] Digest Number 3264

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3264

1a

ADVFN fail? by bikeflagaz

1b

Re: ADVFN fail? by "Randy Harmelink" rharmelink

2a

Re: Randy..How can I identify a Stock's 1 year out Target Price by "Randy Harmelink" rharmelink

Messages

1a

ADVFN fail?

Wed Dec 10, 2014 11:40 am (PST) . Posted by:

bikeflagaz

Things were fine until today. Now none of my =RCHGetElementNumber() functions that try to retrieve data from ADVFN.com work.


Is anyone else having this problem?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: ADVFN fail?

Wed Dec 10, 2014 11:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

There are no drop-down boxes for date selection available on the website at
the moment, for the quarterly and annual financials. Hopefully, a temporary
issue...

On Wed, Dec 10, 2014 at 11:50 AM, bikeflagaz@... wrote:

> Things were fine until today. Now none of my =RCHGetElementNumber()
> functions that try to retrieve data from ADVFN.com work.
>
> Is anyone else having this problem?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Re: Randy..How can I identify a Stock's 1 year out Target Price

Wed Dec 10, 2014 11:49 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I know of target prices available from Yahoo, Zacks, and FinViz:

=RCHGetYahooQuotes("MMM","t8")
=RCHGetElementNumber("MMM",849)
=RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Target Price")

On Tue, Dec 9, 2014 at 11:40 PM, mb0329@... wrote:

>
> Hello Randy...What formula can I use to get a stock's estimated 1 Year Out
> Target Price, and where can I find this? Is there an element number or
> numbers that give this. I haven't looked at your website for awhile and
> things have changed. Thanks.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use