You need a concatenation symbol AFTER the A1 as well.

As I said, you should try creating the URL string independent of the
formula first, until you're more experienced and more comfortable doing
concatenations.

When I entered your formula, EXCEL pointed me directly to where the problem
was.

On Tue, May 28, 2013 at 10:07 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

>
> tried to extract balance sheet from
>
>
> http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=balanceSheet&period=A¤cy=native
>
> with this code
>
> =RCHGetHTMLTable("
> http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=balanceSheet&period=A¤cy=native","US
> Dollars",-1,"",1)
>
> and it works
>
> but when i tried to point to cell A1 with this code
>
> =RCHGetHTMLTable("
> http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker="&A1"&dataset=balanceSheet&period=A¤cy=native","US
> Dollars",-1,"",1)
>
> something wrong with it?
>

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

2a

Option quote problems ??

Tue May 28, 2013 2:11 pm (PDT) . Posted by:

"ssztaba" ssztaba

I'm using smfGetOptionQuotes, and my formulas were working last friday, but all day today I've been getting 'N/A' error messages

=smfGETOptionQuotes((A10&" "&F10&" "&G10&" "&H10&" "&C10),"a",,$J$3)

A10 is GME F10 is 6 G10 is 2013 H10 is 38 and C10 is C

$J$3 is Y (indicating Yahoo)

The assembled string is GME 6 2013 38 C

Thus I'm looking for the Ask GME June 2013 38 Call option quote from Yahoo

Anyone having problems with options quotes today, or anyone see a problem in my request ??

Thanks

Stan

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

2b

Re: Option quote problems ??

Tue May 28, 2013 2:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you're getting "N/A", then that would be what the add-in found on Yahoo.
The add-in wouldn't create such a value.

I assume you're refreshing your quotes with smfForceRecalculation? Maybe
you need to set your Internet Options to make sure you get a fresh copy of
the web page every time? Otherwise, you could be getting a cached copy of
the web page from IE's temporary Internet files...

I just tried your option symbol and get 0.21 returned, which is what I see
on the web page.

On Tue, May 28, 2013 at 2:11 PM, ssztaba <ssjurik@optonline.net> wrote:

> I'm using smfGetOptionQuotes, and my formulas were working last friday,
> but all day today I've been getting 'N/A' error messages
>
> =smfGETOptionQuotes((A10&" "&F10&" "&G10&" "&H10&" "&C10),"a",,$J$3)
>
> A10 is GME F10 is 6 G10 is 2013 H10 is 38 and C10 is C
>
> $J$3 is Y (indicating Yahoo)
>
> The assembled string is GME 6 2013 38 C
>
> Thus I'm looking for the Ask GME June 2013 38 Call option quote from Yahoo
>
> Anyone having problems with options quotes today, or anyone see a problem
> in my request ??
>

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

3a

Re: Split history from Morningstar

Tue May 28, 2013 4:59 pm (PDT) . Posted by:

"David Rocha" DavidARocha

Randy,

Is there a link to the ratio of the split?

David

Sent from my iPhone

On May 27, 2013, at 4:19 AM, "szazdrew"; <szazdrew@yahoo.com> wrote:

> That's great! Exactly what I need. Thank You, Randy. It saves me a lot of hours.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > It appears the source page for the split info is:
> >
> > http://performance.morningstar.com/PerformanceHtml/stock/split-history.action?t=F
>
>

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

3b

Re: Split history from Morningstar

Tue May 28, 2013 7:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If that isn't it, you'll have to explain what you're asking for...

On Tue, May 28, 2013 at 4:59 PM, David Rocha <davidarocha@yahoo.com> wrote:

>
> Is there a link to the ratio of the split?
>
> On May 27, 2013, at 4:19 AM, "szazdrew"; <szazdrew@yahoo.com> wrote:
>
> That's great! Exactly what I need. Thank You, Randy. It saves me a lot of
> hours.
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > It appears the source page for the split info is:
> >
> >
> http://performance.morningstar.com/PerformanceHtml/stock/split-history.action?t=F
>
>

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

3c

Re: Split history from Morningstar

Tue May 28, 2013 8:11 pm (PDT) . Posted by:

"David Rocha" DavidARocha

Sorry Randy.

My poor eyesight focused only on the left side of the page (dates).

The ratios are on the right.

Thanks for your help.

David

Sent from my iPhone

On May 28, 2013, at 9:59 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

> If that isn't it, you'll have to explain what you're asking for...
>
>
> On Tue, May 28, 2013 at 4:59 PM, David Rocha <davidarocha@yahoo.com> wrote:
>>
>> Is there a link to the ratio of the split?
>>
>> On May 27, 2013, at 4:19 AM, "szazdrew"; <szazdrew@yahoo.com> wrote:
>>> That's great! Exactly what I need. Thank You, Randy. It saves me a lot of hours.
>>>
>>> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>>> >
>>> > It appears the source page for the split info is:
>>> >
>>> > http://performance.morningstar.com/PerformanceHtml/stock/split-history.action?t=F
>
>

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

4a

Re: Value Screening

Tue May 28, 2013 7:56 pm (PDT) . Posted by:

"Seth Wu" sewuzy

Hi Randy,

I do use other online screeners to first narrow the field down.

For example, using Finviz's screener, narrows 6445 symbols (
http://finviz.com/screener.ashx?v=111&ft=4
<http://finviz.com/screener.ashx?v=111&ft=4> )
down to 47 symbols (
http://finviz.com/screener.ashx?v=111&f=fa_pb_low,fa_ps_low,fa_qu\
ickratio_high&ft=4
<http://finviz.com/screener.ashx?v=111&f=fa_pb_low,fa_ps_low,fa_q\
uickratio_high&ft=4> )
by choosing P/B <1, P/S <1, Quick Ratio High>3.

But I that is still too many stocks, and I want to retrieve the
more exacting data to be better able to fine tune and
comparatively evaluate the narrowed down selection.

I would really appreciate any help on extracting the specifics
of:

Cash & Equivalents
Accounts Receivables
Inventory
Total Liabilities

Thanks so much.
Seth

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

4b

Re: Value Screening

Tue May 28, 2013 8:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'd need to decide on a data source first.

Take a look through the element definitions workbook that is distributed
with the add-in. Or a few of the templates in the FILES area of the group
that grab financial statements data.

You may think what you are asking for is simple, but the devil is in the
details.

On Tue, May 28, 2013 at 7:56 PM, Seth Wu <sewuzy@gmail.com> wrote:

>
> I do use other online screeners to first narrow the field down.
>
> For example, using Finviz's screener, narrows 6445 symbols (http://finviz.com/screener.ashx?v=111&ft=4)
>
> down to 47 symbols (
> http://finviz.com/screener.ashx?v=111&f=fa_pb_low,fa_ps_low,fa_quickratio_high&ft=4)
> by choosing P/B <1, P/S <1, Quick Ratio High>3.
>
> But I that is still too many stocks, and I want to retrieve the more
> exacting data to be better able to fine tune and comparatively evaluate the
> narrowed down selection.
>
> I would really appreciate any help on extracting the specifics of:
>
> Cash & Equivalents
> Accounts Receivables
> Inventory
> Total Liabilities
>