Senin, 04 Juni 2012

[smf_addin] Digest Number 2235

Messages In This Digest (8 Messages)

1a.
Re: MSN Financial Statements From: rebalance85
1b.
Re: MSN Financial Statements From: Randy Harmelink
2a.
code 25 not resulting in current price From: ufdn16
2b.
Re: code 25 not resulting in current price From: Randy Harmelink
3a.
Re: element numbers From: antonvanas1989
3b.
Re: element numbers From: Randy Harmelink
4a.
Cash Flow/Sales for Industry From: oryxius
4b.
Re: Cash Flow/Sales for Industry From: Randy Harmelink

Messages

1a.

Re: MSN Financial Statements

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

Sun Jun 3, 2012 3:37 am (PDT)



Thank you very much, it is ok now.
When I use the number to calculate some ratios, I met this problem, for example:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-cash-flow?stmtView=Ann&Symbol="&Ticker, 1,"Sale of Business")
the value is "Error". I know there is no this item in the financials. I want to get this kind of result:
If there is no this item, and get the error, the result is 0, otherwise is the value. I try the"If then" ,but it doesn't work.
I need some instrustions from you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Your search string is not what MSN is using as the label -- try:
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-balance-sheet?stmtView=Ann&Symbol="&A1,
> 1,"Accounts Receivable -Trade, Net")
>
> On Sat, Jun 2, 2012 at 3:17 AM, rebalance85 <rebalance85@...> wrote:
>
> > I find another formula get result ERROR:
> > =RCHGetTableCell("
> > http://investing.money.msn.com/investments/stock-balance-sheet?stmtView=Ann&Symbol="&Ticker,
> > 1,"Accounts Receivable - Trade, Net")
> > Any suggestions?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
1b.

Re: MSN Financial Statements

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Jun 3, 2012 8:21 am (PDT)



Check out the documentation for the function, you can have the function
return something other than "Error" if you want, when there is an error.

On Sun, Jun 3, 2012 at 3:36 AM, rebalance85 <rebalance85@yahoo.com> wrote:

> Thank you very much, it is ok now.
> When I use the number to calculate some ratios, I met this problem, for
> example:
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-cash-flow?stmtView=Ann&Symbol="&Ticker,
> 1,"Sale of Business")
> the value is "Error". I know there is no this item in the financials. I
> want to get this kind of result:
> If there is no this item, and get the error, the result is 0, otherwise is
> the value. I try the"If then" ,but it doesn't work.
> I need some instrustions from you.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2a.

code 25 not resulting in current price

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

Sun Jun 3, 2012 2:19 pm (PDT)



The element number 25 is not functioning in my worksheet any longer.
How do I now get the current price?

Thanks, David

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: code 25 not resulting in current price

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Jun 3, 2012 2:20 pm (PDT)



Use the RCHGetYahooQuotes() function. It's what it is intended for.

On Sun, Jun 3, 2012 at 2:01 PM, ufdn16 <ufdn16@yahoo.com> wrote:

> The element number 25 is not functioning in my worksheet any longer.
> How do I now get the current price?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: element numbers

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

Sun Jun 3, 2012 2:39 pm (PDT)



The element 13862 still not working..
It now says "Print"

Btw i have updated the RCH module by now, i'm using europe setting so i'm not realy looking for new updates because i need to change the codes.

Another question:
I´m getting 52weeks high-low from yahoo, using this formula to extract the data:
=smfStrExtr(RCHGetTableCell("http://finance.yahoo.com/q?s="&YHTicker;1;"52wk Range")&"~";"-";"~")

The formula works fine, but the problem i have that the output gives (10.00 instead of 10,00) all other lines i receive from yahoo changes but this one do not convert to ","
It was with the old Add in, and now with the newest add in it still is.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> But does element 13862 now work? The "nothing" return you got before would
> indicate no element definition was loaded. You are running with a very old
> copy of the add-in. I'd suggest updating it. I don't think it works with
> that style of element definition.
>
> On Sat, Jun 2, 2012 at 4:03 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > =smfGetAParms(13862)
> > it now gives this:
> > MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> > ","div",-1,"class=""cn""")&"<","|","<"))
> >
> >
> > --- In smf_addin@yahoogroups.com, "antonvanas1989" <antonvanas1989@>
> > wrote:
> > >
> > > Stock Market Functions add-in, Version 2.1.2010.08.02
> > > (Nothing)
> > > Error
> > > 3M Co
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (16)
3b.

Re: element numbers

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Jun 3, 2012 2:47 pm (PDT)



You get "Print" for ticker MMM on element #13862?

I can't give any advice on non-U.S. conversions. It's not an area I want to
get into.

On Sun, Jun 3, 2012 at 2:39 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> The element 13862 still not working..
> It now says "Print"
>
> Btw i have updated the RCH module by now, i'm using europe setting so i'm
> not realy looking for new updates because i need to change the codes.
>
> Another question:
> I´m getting 52weeks high-low from yahoo, using this formula to extract the
> data:
> =smfStrExtr(RCHGetTableCell("http://finance.yahoo.com/q?s="&YHTicker;1;"52wk
> Range")&"~";"-";"~")
>
> The formula works fine, but the problem i have that the output gives
> (10.00 instead of 10,00) all other lines i receive from yahoo changes but
> this one do not convert to ","
> It was with the old Add in, and now with the newest add in it still is.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (16)
4a.

Cash Flow/Sales for Industry

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

Sun Jun 3, 2012 9:37 pm (PDT)



Any idea where to find the industry Cash Flow/Sales ratio? Any website providing this ratio?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: Cash Flow/Sales for Industry

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Jun 3, 2012 11:01 pm (PDT)



No idea. Sorry.

On Sun, Jun 3, 2012 at 9:37 PM, oryxius <oryxius@yahoo.com> wrote:

> Any idea where to find the industry Cash Flow/Sales ratio? Any website
> providing this ratio?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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
Diposting oleh EXCEL FEED LEARNING di 01.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)