Sabtu, 09 Juni 2012

[smf_addin] Digest Number 2240

Messages In This Digest (16 Messages)

Messages

1a.

Bloomberg Table download ... ?

Posted by: "back" backmehl@yahoo.de   backmehl

Fri Jun 8, 2012 1:52 am (PDT)



Hello Randy,

i hope you can help me, do you have any idea, how
i can donload the tables per page like here:

http://www.bloomberg.com/markets/companies/country/france/

Thank you very much and kind regards

bm

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

Re: Bloomberg Table download ... ?

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

Fri Jun 8, 2012 2:16 am (PDT)



Looks like a straight-forward:

=RCHGetHTMLTable("http://www.bloomberg.com/markets/companies/country/france/
","Sub-Industry",-1,"",1)

On Fri, Jun 8, 2012 at 1:52 AM, back <backmehl@yahoo.de> wrote:

>
> i hope you can help me, do you have any idea, how
> i can donload the tables per page like here:
>
> http://www.bloomberg.com/markets/companies/country/france/
>
> Thank you very much and kind regards
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

SMF Add-in on MacBook

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Fri Jun 8, 2012 7:07 am (PDT)



I'm sure this has been addressed, but I cannot find the relevant messages. Essentially, I would like to know if it is possible to use the add-in on a mac, and if so, what the steps necessary to install the add-in. Any help is greatly appreciated.

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

Re: SMF Add-in on MacBook

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

Fri Jun 8, 2012 8:17 am (PDT)



I no practically nothing about Macs. But I have had a few mention that
they've been able to use the add-in in a Windows emulated environment on
the Mac.

On Fri, Jun 8, 2012 at 7:07 AM, addison.ingle <addison.ingle@gmail.com>wrote:

> I'm sure this has been addressed, but I cannot find the relevant messages.
> Essentially, I would like to know if it is possible to use the add-in on a
> mac, and if so, what the steps necessary to install the add-in. Any help is
> greatly appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

How to leave cell empty if no value

Posted by: "Steven" sdavis81@yahoo.com   sdavis81

Fri Jun 8, 2012 7:36 am (PDT)



In my sheet I am pulling PE's for a bunch of tickers. This result goes into many other formulas.

For some (MAKO in this case), it returns #VALUE because there is no earnings. I usually use an IF command to fix this and make it blank for an empty value, but can't figure out the syntax to this for the RCH web query. I wonder if someone could help. I would like to have the formula there (so it updates in future when there are earnings) but leave cell blank if the current return is #VALUE (for RCHGetElement) or N/A (for RCHGetYahooQuote)

Thanks!

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

How to leave cell empty if no value

Posted by: "Steven" sdavis81@yahoo.com   sdavis81

Fri Jun 8, 2012 7:37 am (PDT)



In my sheet I am pulling PE's for a bunch of tickers. This result goes into many other formulas.

For some (MAKO in this case), it returns #VALUE because there is no earnings. I usually use an IF command to fix this and make it blank for an empty value, but can't figure out the syntax to this for the RCH web query. I wonder if someone could help. I would like to have the formula there (so it updates in future when there are earnings) but leave cell blank if the current return is #VALUE (for RCHGetElement) or N/A (for RCHGetYahooQuote)

Thanks!

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

Re: How to leave cell empty if no value

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

Fri Jun 8, 2012 8:25 am (PDT)



RCHGetElementNumber() should NOT return a #VALUE! error, unless you are
passing it invalid parameters (e.g. a numeric value instead of a string, or
vice versa). I suspect you are doing some mathematical calculation and not
getting a numeric value returned from the function.

In any case, one test I sometimes do is something like:

=IF(ISERROR(1/C47),"--",C47)

...where "--" can be any error-indicator you want to use.

On Fri, Jun 8, 2012 at 7:36 AM, Steven <sdavis81@yahoo.com> wrote:

> In my sheet I am pulling PE's for a bunch of tickers. This result goes
> into many other formulas.
>
> For some (MAKO in this case), it returns #VALUE because there is no
> earnings. I usually use an IF command to fix this and make it blank for an
> empty value, but can't figure out the syntax to this for the RCH web query.
> I wonder if someone could help. I would like to have the formula there
> (so it updates in future when there are earnings) but leave cell blank if
> the current return is #VALUE (for RCHGetElement) or N/A (for
> RCHGetYahooQuote)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNumber

Posted by: "Steven" sdavis81@yahoo.com   sdavis81

Fri Jun 8, 2012 9:40 am (PDT)



Hello all,

I have been trying to figure this out and I am stumped. Probably my Excel skills are too elementary and Google has helped.

I have a sheet that pulls all sorts of data using the add-in, and for some fields when negative (earnings) or non-existent (FCF), it pulls a "#VALUE" or "N/A".

I would like to write a formula that would just leave the cell blank if these values are pulled. I used some IF commands in other cells but can't see how to use this with the add-in cells.

An example formula which is simple:

=RCHGetYahooQuotes($A7, "y")

This pulls the yield for ticker in cell A7. Right now that is NVDA with no yield. I get #VALUE. How can I modify that cell to leave it blank, until the day the NVDA has a yield? Many thanks in advance.

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

Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum

Posted by: "Steven" sdavis81@yahoo.com   sdavis81

Fri Jun 8, 2012 12:39 pm (PDT)



I am sorry I inadvertently started a new thread, I did not think the first sent as the browser crashed. Anyway, Randy did reply, and I think maybe this post is more clear...indeed the #VALUE returns are all formulas which incorporate GetElement. The actual return is N/A, typically for PE or Yield.

How might one try to enter a formula that would leave the cell empty if N/A is returned as part of the value then?

thanks

--- In smf_addin@yahoogroups.com, "Steven" <sdavis81@...> wrote:
>
> Hello all,
>
> I have been trying to figure this out and I am stumped. Probably my Excel skills are too elementary and Google has helped.
>
> I have a sheet that pulls all sorts of data using the add-in, and for some fields when negative (earnings) or non-existent (FCF), it pulls a "#VALUE" or "N/A".
>
> I would like to write a formula that would just leave the cell blank if these values are pulled. I used some IF commands in other cells but can't see how to use this with the add-in cells.
>
> An example formula which is simple:
>
> =RCHGetYahooQuotes($A7, "y")
>
> This pulls the yield for ticker in cell A7. Right now that is NVDA with no yield. I get #VALUE. How can I modify that cell to leave it blank, until the day the NVDA has a yield? Many thanks in advance.
>

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

Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum

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

Fri Jun 8, 2012 12:48 pm (PDT)



The same advice applies -- use a work column instead.

You can do it in the same cell, but then it will double your Internet
access bottleneck on RCHGetYahooQuotes() invocations (which can also be
sped up significantly with an array-entered formula over a range).

On Fri, Jun 8, 2012 at 12:37 PM, Steven <sdavis81@yahoo.com> wrote:

> I am sorry I inadvertently started a new thread, I did not think the first
> sent as the browser crashed. Anyway, Randy did reply, and I think maybe
> this post is more clear...indeed the #VALUE returns are all formulas which
> incorporate GetElement. The actual return is N/A, typically for PE or
> Yield.
>
> How might one try to enter a formula that would leave the cell empty if
> N/A is returned as part of the value then?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum

Posted by: "Clark F. Grain" cgrain@rcn.com   cgrain76

Fri Jun 8, 2012 5:38 pm (PDT)



Try the IFERROR Formula in Excel.

Clark Grain
----- Original Message -----
From: Steven
To: smf_addin@yahoogroups.com
Sent: Friday, June 08, 2012 12:40 PM
Subject: [smf_addin] Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNumber

Hello all,

I have been trying to figure this out and I am stumped. Probably my Excel skills are too elementary and Google has helped.

I have a sheet that pulls all sorts of data using the add-in, and for some fields when negative (earnings) or non-existent (FCF), it pulls a "#VALUE" or "N/A".

I would like to write a formula that would just leave the cell blank if these values are pulled. I used some IF commands in other cells but can't see how to use this with the add-in cells.

An example formula which is simple:

=RCHGetYahooQuotes($A7, "y")

This pulls the yield for ticker in cell A7. Right now that is NVDA with no yield. I get #VALUE. How can I modify that cell to leave it blank, until the day the NVDA has a yield? Many thanks in advance.

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

Re: element numbers

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

Fri Jun 8, 2012 3:14 pm (PDT)



Yes i get "Print" on every ticker i tried. on element #13862..

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...>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 (18)
5b.

Re: element numbers

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

Fri Jun 8, 2012 3:30 pm (PDT)



I have no explanation for it...

On Fri, Jun 8, 2012 at 3:14 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> Yes i get "Print" on every ticker i tried. on element #13862..
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
6a.

Re: Daily Prices and TTM Ratio Chart

Posted by: "invesco88" franklin.forward@gmail.com   invesco88

Fri Jun 8, 2012 3:52 pm (PDT)



Randy here is the workbook. I'm surprised this hasn't been requested
before, hedge funds use this type of analysis in their models. Its
usually from Bloomberg and then dumped into excel and then dates are
recorded for when a series of ttm fundamental indicators align across
the board. Here's a public link to the workbook. Thanks again for all
you're help. I'll upload the finished model once it's completed if you
think there would be an interest for it.

https://dl.dropbox.com/u/1765269/Book1.xlsx

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

Re: Daily Prices and TTM Ratio Chart

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

Fri Jun 8, 2012 4:15 pm (PDT)



Here's an array-entered formula I would use in cell H41 and copy downward:

=IF(C41="","--",INDEX($L$43:$L$62,1+MIN(IF(C41>=DATEVALUE($K$43:$K$62),ROW($K$43:$K$62),"--"))-ROW($L$43)))

...although your shaded cells were off. The historical quotes for 4/19 and
4/20 should receive the EPS from 4/19, not from 1/26.

I couldn't use MATCH() because it would require the dates be serial dates
instead of string fields, and be sorted in ascending order.

On Fri, Jun 8, 2012 at 3:51 PM, invesco88 <franklin.forward@gmail.com>wrote:

> Randy here is the workbook. I'm surprised this hasn't been requested
> before, hedge funds use this type of analysis in their models. Its
> usually from Bloomberg and then dumped into excel and then dates are
> recorded for when a series of ttm fundamental indicators align across
> the board. Here's a public link to the workbook. Thanks again for all
> you're help. I'll upload the finished model once it's completed if you
> think there would be an interest for it.
>
> https://dl.dropbox.com/u/1765269/Book1.xlsx
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7.

StockScouter Rating

Posted by: "Brendyn" bsarnacki2000@yahoo.com   bsarnacki2000

Fri Jun 8, 2012 9:04 pm (PDT)



If this will help anyone. I found this to work for getting the stockscouter rating number:
=1*MID(smfGetTagContent("http://investing.money.msn.com/investments/stock-ratings?symbol="&A3,"p",0,"Stock Rating Summary"),100,2)

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Odd News

You won't believe

it, but it's true

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)