Minggu, 19 Februari 2012

[smf_addin] Digest Number 2120

Messages In This Digest (12 Messages)

Messages

1a.

Re: Just started with the RCHGetYahooquotes formula

Posted by: "RonaldKok_98" rkok@gmx.de   RonaldKok_98

Sat Feb 18, 2012 3:16 am (PST)



Hi Randy,

Thanks, but where could I find the documentation folder?

Regards,

Ronald

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, but the add-in is based on U.S. Regional settings. There are some
> items in the "Links" area for adjusting conversion of amounts.
>
> Check the "Documentation" folder of the Files area of the group for more
> info on the function parameters. But, no, you would not comma-delimit the
> Yahoo codes.
>
> On Sat, Feb 18, 2012 at 1:58 AM, RonaldKok_98 <rkok@...> wrote:
>
> >
> > I just joined this group and just started with the
> > RCHGetYahooQuote-formula.
> >
> > If I use thise code:
> >
> > =RCHGetYahooQuotes(A2;"o") I get the price in cents (it should be 59,59
> > euro)
> >
> > Example
> > ADS.DE ADIDAS N 5.959,00
> >
> > Does anyone know how to get right?
> >
> > And I also want to add another variable, how do I do that? Is that by
> > adding it comma-separated like =RCHGetYahooQuotes(A2;"o,p,f") etc?
> >
> >
>

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

Re: Just started with the RCHGetYahooquotes formula

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

Sat Feb 18, 2012 5:27 am (PST)



In the "Files" area of the group...

On Sat, Feb 18, 2012 at 4:16 AM, RonaldKok_98 <rkok@gmx.de> wrote:

>
> Thanks, but where could I find the documentation folder?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

Re: Get Table Cell

Posted by: "sysmodie" yg07@sysmod.com   sysmodie

Sat Feb 18, 2012 9:47 am (PST)



Thank you, Mike.

In my Privacy settings of IE I have "Always Allow" for msrb.org
If I goto that page now it displays it without asking me to Accept.
If I launch Excel now and call that function, with the page still open in IE, I still get "Error" for
=smfGetTagContent("http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6","a",-1,"/IssueDetails.")

Whereas
=smfGetTagContent("http://uk.finance.yahoo.com/q?s=GBPUSD=X","span",0,"yfs_l10_gbpusd")
gives me the rate today with no error.

Is there some other security setting I should consider?
I ask because the same problem may occur with other sites that require cookies.

Thanks
Patrick

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> You have to view the original webpage and "Accept" using Internet Explorer
> or the Excel Web Query.
>
> The add-in uses the Excel interface which relies on IE so it must have the
> "accept" cookie. Cookies from other browsers aren't visible to Excel or IE.

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

Re: Get Table Cell

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

Sat Feb 18, 2012 10:34 am (PST)



Have you tried visiting that web page in EXCEL's Web Query dialog? On a
very few rare situations, the problem has been that the version of IE
used by EXCEL is not the same as the one used as a browser.

In any case, you shouldn't need to keep the page open in IE -- just
creating the cookie is sufficient. My cookie is still working for EXCEL,
as a copy and paste of your formula below worked just fine.

Do you have your Internet settings set to always get new content when
visiting a web page? Have you tried running the smfForceRecalculation
macro? See the "Links" area of the group for more info on both of those.

On Sat, Feb 18, 2012 at 10:47 AM, sysmodie <yg07@sysmod.com> wrote:

In my Privacy settings of IE I have "Always Allow" for msrb.org
<http://msrb.org/>
If I goto that page now it displays it without asking me to Accept.
If I launch Excel now and call that function, with the page still open
in IE, I still get "Error" for
=smfGetTagContent("http://emma.msrb.org/SecurityView/SecurityDetails.asp\
x?cusip=838736UV6
<http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6>
","a",-1,"/IssueDetails.")

Whereas
=smfGetTagContent("http://uk.finance.yahoo.com/q?s=GBPUSD=X
<http://uk.finance.yahoo.com/q?s=GBPUSD=X> ","span",0,"yfs_l10_gbpusd")
gives me the rate today with no error.

Is there some other security setting I should consider?
I ask because the same problem may occur with other sites that require
cookies.

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

Difference in Reported Dividend Yield

Posted by: "rjemery7" rjemery@gmail.com   rjemery7

Sat Feb 18, 2012 12:02 pm (PST)



Why is the dividend yield different from what RCHGetYahooQuotes("MMM","y") reports versus many other sources? For example, for 3M Corp, RCHGetYahooQuotes("MMM","y") reports a dividend yield of 2.56% while the websites of Yahoo Finance, Google Finance, Schwab, TD AMeritrade and Fidelity all report a yield of 2.70%.

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

Re: Difference in Reported Dividend Yield

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Sat Feb 18, 2012 12:33 pm (PST)



You do realize that dividend yield varies each day based on the stock price.

Kermit

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of rjemery7
Sent: Saturday, February 18, 2012 3:02 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Difference in Reported Dividend Yield

Why is the dividend yield different from what RCHGetYahooQuotes("MMM","y")
reports versus many other sources? For example, for 3M Corp,
RCHGetYahooQuotes("MMM","y") reports a dividend yield of 2.56% while the
websites of Yahoo Finance, Google Finance, Schwab, TD AMeritrade and
Fidelity all report a yield of 2.70%.

------------------------------------

Yahoo! Groups Links

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

Re: Difference in Reported Dividend Yield

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

Sat Feb 18, 2012 12:54 pm (PST)



2.56% would be the trailing yield. 2.7% would be the forward yield, *
assuming* that they keep paying $0.59 per quarter. On MMM, that's probably
a good assumption. On some other stocks, maybe not.

Note that the number of sites reporting one data value or another may make
little difference -- it may just mean there are two different sources of
the fundamental data. For example, if Google, Schwab, Ameritrade, and
Fidelity all get their fundamental data from Reuters, it doesn't mean it's
a consensus value.

And it may also differ because some update data from Reuters (or whoever)
on a daily basis, while others do it weekly. For example, a lot of mutual
fund data on Yahoo comes from Morningstar, but it not updated on a daily
basis.

On Sat, Feb 18, 2012 at 1:02 PM, rjemery7 <rjemery@gmail.com> wrote:

> Why is the dividend yield different from what RCHGetYahooQuotes("MMM","y")
> reports versus many other sources? For example, for 3M Corp,
> RCHGetYahooQuotes("MMM","y") reports a dividend yield of 2.56% while the
> websites of Yahoo Finance, Google Finance, Schwab, TD AMeritrade and
> Fidelity all report a yield of 2.70%.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.

Re: Difference in Reported Dividend Yield

Posted by: "rjemery7" rjemery@gmail.com   rjemery7

Sat Feb 18, 2012 1:22 pm (PST)




Kermit,

Yes, I do realize yield depends on stock price, both of which would change on those days the market is open. However, the values I reported are all from retrievals made today (Saturday, 2/18/2012), so the two percentages I related are not necessarily affected by a changing market conditions.

--- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@...> wrote:
>
> You do realize that dividend yield varies each day based on the stock price.
>
>
> Kermit
>
>

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

Re: Difference in Reported Dividend Yield

Posted by: "rjemery7" rjemery@gmail.com   rjemery7

Sat Feb 18, 2012 1:25 pm (PST)



Randy,

Thank you for that information. At least I have a clearer understanding of such reported differences. And yes, it is possible the sources I cited obtain their data from a common source.

Again, allow me to congratulate you on a wonderful SMF add-in package. I am finding it very useful.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 2.56% would be the trailing yield. 2.7% would be the forward yield, *
> assuming* that they keep paying $0.59 per quarter. On MMM, that's probably
> a good assumption. On some other stocks, maybe not.
>
> Note that the number of sites reporting one data value or another may make
> little difference -- it may just mean there are two different sources of
> the fundamental data. For example, if Google, Schwab, Ameritrade, and
> Fidelity all get their fundamental data from Reuters, it doesn't mean it's
> a consensus value.
>
> And it may also differ because some update data from Reuters (or whoever)
> on a daily basis, while others do it weekly. For example, a lot of mutual
> fund data on Yahoo comes from Morningstar, but it not updated on a daily
> basis.
>

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

Historical Price Comparison Workbook - Google docs version

Posted by: "bobsledproductions" JPeters3515@snet.net   bobsledproductions

Sat Feb 18, 2012 2:53 pm (PST)



If you're interested I put together a simple historical price comparison workbook in google docs. Search for the template here:

https://docs.google.com/templates?q=historical+price+comparison&type=spreadsheets&sort=hottest&view=public

I also blogged about the steps in creating the sheet here:

http://justspreadsheets.blogspot.com/2012/02/charting-dividend-stocks.html

Within the workbook I created a simple chart comparison between stocks with and without reinvested dividends. Far too many charts just show pricing data, and if you invest in high yielding stocks as I do, the charts you get don't do them justice.

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

Re: TED Spread

Posted by: "msdalt" msdalt@earthlink.net   msdalt

Sat Feb 18, 2012 3:19 pm (PST)



That formula worked flawlessly for the last 19 months and then Bloomberg
apparently changed the format. I tried to figure out how to modify the
formula myself but have decided to admit failure and ask for help.

Please...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> How about:
>
>
=RCHGetTableCell("http://www.bloomberg.com/apps/quote?ticker=.tedsp:ind
> ",1,">Value<")
>
> On Sun, Jun 27, 2010 at 4:49 AM, msdalt msdalt@... wrote:
>
> > Bloomberg rearranged the web site from which I was pulling the TED
Spread
> > and a few other data. I can't figure out how to pull it into Excel
from its
> > new location. Here is the url to the quote.
> >
> > http://www.bloomberg.com/apps/quote?ticker=.tedsp%3Aind
> >
> > Can someone help me with a function I can paste into a cell?
> >
>

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

Re: TED Spread

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

Sat Feb 18, 2012 4:03 pm (PST)



Is this what you're after?

=0+smfGetTagContent("http://www.bloomberg.com/quote/.tedsp:ind","span",1\
,">.TEDSP:IND")

On Sat, Feb 18, 2012 at 4:19 PM, msdalt <msdalt@earthlink.net> wrote:
That formula worked flawlessly for the last 19 months and then Bloomberg
apparently changed the format. I tried to figure out how to modify the
formula myself but have decided to admit failure and ask for help.

Please...

--- In smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> How about:
>
=RCHGetTableCell("http://www.bloomberg.com/apps/quote?ticker=.tedsp:ind
<http://www.bloomberg.com/apps/quote?ticker=.tedsp:ind>
> ",1,">Value<")
>
> On Sun, Jun 27, 2010 at 4:49 AM, msdalt msdalt@... wrote:
>
> > Bloomberg rearranged the web site from which I was pulling the TED
Spread
> > and a few other data. I can't figure out how to pull it into Excel
from its
> > new location. Here is the url to the quote.
> >
> > http://www.bloomberg.com/apps/quote?ticker=.tedsp%3Aind
<http://www.bloomberg.com/apps/quote?ticker=.tedsp%3Aind>
> >
> > Can someone help me with a function I can paste into a cell?

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

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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 02.19

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)