4 New Messages

Digest #2798

=RCHGetTableCell Array Entered by "flangeneral" flangeneral

Re: =RCHGetTableCell Array Entered by "Randy Harmelink" rharmelink

Re: =RCHGetTableCell Array Entered by "flangeneral" flangeneral

Re: Building stock screeners by gpommer1982

Messages

1a

=RCHGetTableCell Array Entered

Fri Oct 4, 2013 8:02 am (PDT) . Posted by:

"flangeneral" flangeneral

Hi All,
Is it possible to array enter this formula?

=RCHGetTableCell("http://finance.yahoo.com/q?s="&$H$5:$H$38&"&ql=1",1,F$3)

where H5:H38 is where the tickers are. Copy/paste formula works fine, but if I try to array enter it, it returns #VALUE. Any help appreciated.

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

1b

Re: =RCHGetTableCell Array Entered

Fri Oct 4, 2013 8:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You would need a separate function for each ticker symbol.

There would be no advantage to being able to array-enter the formula
anyway. The add-in would still have to retrieve an individual web page for
each ticker symbol.

The reason array-entering RCHGetYahooQuotes() improves speed so much is
that Yahoo prepares an entire CSV file based on the parameters. So all of
that data can be retrieved in a single Internet access, and then the
function parses all the CSV data out.

On Fri, Oct 4, 2013 at 8:02 AM, flangeneral <jefff@rogers.com> wrote:

>
> Is it possible to array enter this formula?
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s="&$H$5:$H$38&"&ql=1",1,F$3)
>
> where H5:H38 is where the tickers are. Copy/paste formula works fine, but
> if I try to array enter it, it returns #VALUE. Any help appreciated.
>

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

1c

Re: =RCHGetTableCell Array Entered

Fri Oct 4, 2013 8:14 am (PDT) . Posted by:

"flangeneral" flangeneral

Thanks Randy,
Your help is always appreciated.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You would need a separate function for each ticker symbol.
>
> There would be no advantage to being able to array-enter the formula
> anyway. The add-in would still have to retrieve an individual web page for
> each ticker symbol.
>
> The reason array-entering RCHGetYahooQuotes() improves speed so much is
> that Yahoo prepares an entire CSV file based on the parameters. So all of
> that data can be retrieved in a single Internet access, and then the
> function parses all the CSV data out.
>
> On Fri, Oct 4, 2013 at 8:02 AM, flangeneral <jefff@...> wrote:
>
> >
> > Is it possible to array enter this formula?
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q?s="&$H$5:$H$38&"&ql=1",1,F$3)
> >
> > where H5:H38 is where the tickers are. Copy/paste formula works fine, but
> > if I try to array enter it, it returns #VALUE. Any help appreciated.
> >
>

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

2a

Re: Building stock screeners

Fri Oct 4, 2013 6:51 pm (PDT) . Posted by:

gpommer1982

I had two reasons: one was to improve my Excel programming skills
and second was even the free custom screens don't contain
everything I would like to screen for. Certainly, the free
screeners can narrow down a large list of stocks to a small list
of commonly used valuation metrics but I was looking for
something that could crank through a large list based on very
specific criteria.

However, I appreciate Randy's point and won't use the SMF Add-In
to build screeners.

---In smf_addin@yahoogroups.com, <kermitp@...> wrote:

Why would anyone want to build a stock screener when there are
tons of free one. Plus, hundreds more fee based one.

Try these free ones -- FinBiz
<http://www.finviz.com/screener.ashx> Stockfetcher
<http://www.stockfetcher.com> MarketWatch
<http://www.marketwatch.com/tools/stockresearch/screener/>
Yahoo <http://screener.finance.yahoo.com/stocks.html>

Or try http://www.freestockcharts.com/
<http://www.freestockcharts.com/> where you can build your own
screening criteria.

But don't miss use this great tool.

Kermit

From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com] On Behalf Of gpommer1982@...
Sent: Wednesday, October 02, 2013 9:36 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Building stock screeners

I'm always impressed with the knowledge base of this group so I
thought I'd throw this out as I've been scratching my head. Has
anyone built a stock screener in Excel? I've been building some
financial analysis spreadsheets and have no problem analyzing a
single company but I'd like to make custom screens to sort
through and return companies that meet my criteria. My
programming knowledge is pretty basic but I haven't found
anything out in cyberspace that describes how one would go about
doing this.

Thanks in advance.