Rabu, 23 Mei 2012

[smf_addin] Digest Number 2221

Messages In This Digest (9 Messages)

Messages

1a.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Tue May 22, 2012 6:19 am (PDT)



Can't you just divide the dividends per share by the earnings per share to derive the ratio yourself? I have had good success with these two historical numbers from AdvFN.

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> hmm...do you know if there are other areas in rchgetelementnumber that have HISTORICAL payout ratios over several years?..whether they are financial companies or not?thx.
>

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

Re: What does #value! response mean when using RCHGetElementNumber f

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

Tue May 22, 2012 11:06 am (PDT)



I am looking for the historical payout ratios going back 1 to 5 years

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> Can't you just divide the dividends per share by the earnings per share to derive the ratio yourself? I have had good success with these two historical numbers from AdvFN.
>
> --- In smf_addin@yahoogroups.com, "investor952" <investor952@> wrote:
> >
> > hmm...do you know if there are other areas in rchgetelementnumber that have HISTORICAL payout ratios over several years?..whether they are financial companies or not?thx.
> >
>

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

Re: RCHGet

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

Tue May 22, 2012 9:03 am (PDT)



These worked fine for me:

=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement/\
detail?stmtType=INC&perType=INT&symbol=SOLB.BR",1,">Revenue")
=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement/\
detail?stmtType=BAL&perType=INT&symbol=SOLB.BR",1,">Total Inventory")

...although I did have to create a cookie for the Reuters site first,
using the EXCEL Web Query dialog. Otherwise, I got "Error" returned.

On Tue, May 22, 2012 at 4:37 AM, ego_1230 <ego_1230@...
<mailto:ego_1230@yahoo.de> > wrote:

I made my Excel(2003) sheet of Belgian companies, (using
RCHGetTableCell) ,which relies on the following url's for ticker
SOLB.BR <http://SOLB.BR> (Solvay SA).

Income :

http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=IN\
C&perType=INT&symbol=SOLB.BR
<http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=I\
NC&perType=INT&symbol=SOLB.BR>

balance sheet :
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=BA\
L&perType=INT&symbol=SOLB.BR
<http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=B\
AL&perType=INT&symbol=SOLB.BR>

The url's seem still to be correct.

Curiously: just now, when the income sheet of SOLB.BR <http://SOLB.BR>
was open in IE, Excel actually managed to add-in the income data for
SOLB.BR <http://SOLB.BR> when opening the excel file-
but not for the other tickers,
no balance sheet data at all were added.

The cells for AB Inbev also work, since these rely on google finance
(ticker BUD) , not Reuters....

Hence, I believe that Reuters.com is somehow the problem.

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

Like FinViz

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

Tue May 22, 2012 12:07 pm (PDT)



when I roll over a ticker I would like latest news.


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

Re: Like FinViz

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

Tue May 22, 2012 1:38 pm (PDT)



That's an event-driven item you'd need to do yourself, since latest would
mean an instant refresh. That's not what the add-in does.

On Tue, May 22, 2012 at 12:06 PM, almondtree <almondtree@yahoo.com> wrote:

> when I roll over a ticker I would like latest news.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Rchgetelement errors

Posted by: "bobc94595" conlonrc@comcast.net   bobc94595

Tue May 22, 2012 5:39 pm (PDT)



Randy, Currently, when I run a particular spreadsheet, it shows "Error" regarding MSN data, but retrieves other data. It also shows that I am using "Stock Market Functions add-in, Version RCH_Stock_Market_Functions-2.1.2012.04.07,C\Program Files (x86)\SMF Add-In;1)" and that includes "smf-elements-1.txt" dated January 27, 2012 as it appears in Works In Progress .
You also have a revised "smf-elements-1.txt" in your entry dated May 10, 2012. I assume that this revision is of a date later than Jan 27, and could be dated May 10, although I can't tell. How do I get this latest revision into my SMF Add-In file to replace the current Jan 10 version? I have tried cut and paste, but get "access denied."
I am running Win7 and Excel 2010

--- In smf_addin@yahoogroups.com, "brbar" <brbar@...> wrote:
>
>
>
> Ok, somehow I missed that big topic. Brain rot and all of that. Replacing element definitions worked perfectly.
>
> Thanks for the reply.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > It's because you don't have the new element definitions in the
> > smf-elements-1.txt file from the "Works in Progress" folder of the Files
> > area. I had to redefine all of the elements because of MSN web site
> > changes. It was a big topic of conversation here on the group at the end of
> > April and the first week of May.
> >
> > On Sun, May 20, 2012 at 12:45 PM, brbar <brbar@> wrote:
> >
> > >
> > > For what it's worth, I am also getting "Error" returned for any MSN data
> > > elements.
> > >
> > > This is what I get for:
> > > =RCHGetElementNumber("Version")
> > > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files
> > > (x86)\SMF Add-in; 1)
> > >
> > > =RCHGetElementNumber("MMM",3)
> > > Error
> > >
> > > =smfGetAParms(3)
> > > MSN;Exchange;
> > > http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;QUICKFACTS;EXCHANGE; ; ;0;0;0;0
> > >
> > > =smfGetAParms(25)
> > > MSN;Last Price;
> > > http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> > >
> > > I visited the MSN web site for the MMM url below and was not redirected.
> > >
> > > Non-MSN data comes in fine for the non-random sample of 3 element numbers
> > > I tried (Google, Earnings.com, AdvFN-A).
> > >
> > > Software: Window 7 64-bit, Office 2010 32-bit (and Office 2007 32-bit on
> > > a different pc)
> > >
> > > Thank you for your work on this add-in. It's been a life-saver.
> > >
> >
>

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

Re: Rchgetelement errors

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

Tue May 22, 2012 7:20 pm (PDT)



You should exit EXCEL, download the new file and use it as a replacement
for the file in the add-in folder. I don't know what you're doing cut and
paste on, but I doubt it would replace a file that already exists.

On Tue, May 22, 2012 at 5:39 PM, bobc94595 <conlonrc@comcast.net> wrote:

> You also have a revised "smf-elements-1.txt" in your entry dated May 10,
> 2012. I assume that this revision is of a date later than Jan 27, and could
> be dated May 10, although I can't tell. How do I get this latest revision
> into my SMF Add-In file to replace the current Jan 10 version? I have tried
> cut and paste, but get "access denied."
> I am running Win7 and Excel 2010
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
5a.

Retrieving Information form morningstar for Australia stocks

Posted by: "mtr_os" mtr_os@yahoo.co.uk   mtr_os

Tue May 22, 2012 7:17 pm (PDT)



Hi there,

Apologies for the stupid question - Anyone know how I can retrieve data from morningstar using RCHGetElementNumber() for ASX listed equities?

I can get RCHGetElementNumber("IBM",878) to work but if I try to retrieve RCHGetElementNumber("XASX:BHP",878) it doesn't work. I guess something wrong with the "XASX:BHP" label as most of the URL is identical. I have tried a number of combinations but no luck so far - any ideas?

Many thanks in advance.

Mal.

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

Re: Retrieving Information form morningstar for Australia stocks

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

Tue May 22, 2012 7:28 pm (PDT)



The element definitions come from a print report page on MorningStar, but
MorningStar doesn't have such a print page for Australian stocks, or at
least not for XASX:BHP -- it redirected me back to the quotes page instead.

On Tue, May 22, 2012 at 7:07 PM, mtr_os <mtr_os@yahoo.co.uk> wrote:

>
> Apologies for the stupid question - Anyone know how I can retrieve data
> from morningstar using RCHGetElementNumber() for ASX listed equities?
>
> I can get RCHGetElementNumber("IBM",878) to work but if I try to retrieve
> RCHGetElementNumber("XASX:BHP",878) it doesn't work. I guess something
> wrong with the "XASX:BHP" label as most of the URL is identical. I have
> tried a number of combinations but no luck so far - any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Need traffic?

Drive customers

With search ads

on Yahoo!

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.16

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)