Rabu, 18 April 2012

[smf_addin] Digest Number 2180

Messages In This Digest (12 Messages)

Messages

1a.

Re: "Earnings" source not working?

Posted by: "enomisdue" enomisdue@yahoo.it   enomisdue

Tue Apr 17, 2012 1:47 am (PDT)



tnx for your answer, but unfortunately i had already done, anyway i did it again some minutes ago trying different possibility and i still receive "undefined"

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

Re: "Earnings" source not working?

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

Tue Apr 17, 2012 1:54 am (PDT)



Are you sure you have them in the folder that has the XLA file, and that
XLA file is the one being pointed to by the add-in manager? Some people
have had issues because they installed the add-in more than once, in
multiple locations.

On Tue, Apr 17, 2012 at 1:47 AM, enomisdue <enomisdue@yahoo.it> wrote:

> tnx for your answer, but unfortunately i had already done, anyway i did it
> again some minutes ago trying different possibility and i still receive
> "undefined"
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
1c.

Re: "Earnings" source not working?

Posted by: "enomisdue" enomisdue@yahoo.it   enomisdue

Tue Apr 17, 2012 7:33 am (PDT)



yes.

as i'm getting crazy deleted the add-in files then i checked if on my pc there were other copies, i deleted all. i also deleted the add in from excel and i restart my pc.
i downloaded again the add in files zip from this site and i did exactly what is written on page 2 of the "manual", but it's still the same

is there some particular library / reference in vba to activate? do you have a list of references that must be activated? (even if i don't think the problem is connected because, on one another pc worked once and now has the same problem)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Are you sure you have them in the folder that has the XLA file, and that
> XLA file is the one being pointed to by the add-in manager? Some people
> have had issues because they installed the add-in more than once, in
> multiple locations.
>
> On Tue, Apr 17, 2012 at 1:47 AM, enomisdue <enomisdue@...> wrote:
>
> > tnx for your answer, but unfortunately i had already done, anyway i did it
> > again some minutes ago trying different possibility and i still receive
> > "undefined"
> >
>

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

Re: "Earnings" source not working?

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

Tue Apr 17, 2012 8:50 am (PDT)



Nope. Nothing special needs to be done, except that the TXT files need to
be in the same folder as the XLA file.

If that's the case, I'm at a loss as to why it's not working.

On Tue, Apr 17, 2012 at 7:33 AM, enomisdue <enomisdue@yahoo.it> wrote:

> yes.
>
> as i'm getting crazy deleted the add-in files then i checked if on my pc
> there were other copies, i deleted all. i also deleted the add in from
> excel and i restart my pc.
> i downloaded again the add in files zip from this site and i did exactly
> what is written on page 2 of the "manual", but it's still the same
>
> is there some particular library / reference in vba to activate? do you
> have a list of references that must be activated? (even if i don't think
> the problem is connected because, on one another pc worked once and now has
> the same problem)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2a.

Re: msn last 10 year eps rchelement #'s 333...342 I get an error mes

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

Tue Apr 17, 2012 5:14 am (PDT)



For dividends, in addition to Randy's suggestion you can use the AdvFN elements.

AdvFN shows dividends per share in the Income Statement section. They also provide the payout ratio, however, I've had some odd results with their calculation. So, I recommend dividing this by the EPS to derive the payout ratio yourself.

--- In smf_addin@yahoogroups.com, "rr76012" <rr76012@...> wrote:
>
> I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get the last 10 years eps for a stock.
>
> I keep getting an "error" message in excel. Do I need to do any addin updating?
>
> Randy, what am I doing wrong.
>
> Also, is there any element numbers for the last few 5 years of dividends or payout?
>
> Thanks,
>

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

EPS element numbers,  for the last 5 years?

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

Tue Apr 17, 2012 9:14 am (PDT)



Hello Mike,

Do I use =rchgetelementnumber function to get the dividends?

What element numbers do I use for the last 5 years dividends?

Mike,
Thank you,

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> For dividends, in addition to Randy's suggestion you can use the AdvFN elements.
>
> AdvFN shows dividends per share in the Income Statement section. They also provide the payout ratio, however, I've had some odd results with their calculation. So, I recommend dividing this by the EPS to derive the payout ratio yourself.
>
>
> --- In smf_addin@yahoogroups.com, "rr76012" <rr76012@> wrote:
> >
> > I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get the last 10 years eps for a stock.
> >
> > I keep getting an "error" message in excel. Do I need to do any addin updating?
> >
> > Randy, what am I doing wrong.
> >
> > Also, is there any element numbers for the last few 5 years of dividends or payout?
> >
> > Thanks,
> >
>

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

Re: EPS element numbers,  for the last 5 years?

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Tue Apr 17, 2012 11:48 am (PDT)



Use the YahooHistory formula (see below)

It has to be array entered over two columns and as many rows as you need

My example gets MMM dividends 2/21/07 thru 02/15/12

=RCHGetYahooHistory("mmm",2007,1,3,2012,3,31,"v",,,,)

Marty

________________________________
From: rr76012 <rr76012@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 17, 2012 12:14 PM
Subject: [smf_addin] EPS element numbers, for the last 5 years?


 
Hello Mike,

Do I use =rchgetelementnumber function to get the dividends?

What element numbers do I use for the last 5 years dividends?

Mike,
Thank you,

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> For dividends, in addition to Randy's suggestion you can use the AdvFN elements.
>
> AdvFN shows dividends per share in the Income Statement section. They also provide the payout ratio, however, I've had some odd results with their calculation. So, I recommend dividing this by the EPS to derive the payout ratio yourself.
>
>
> --- In smf_addin@yahoogroups.com, "rr76012" <rr76012@> wrote:
> >
> > I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get the last 10 years eps for a stock.
> >
> > I keep getting an "error" message in excel. Do I need to do any addin updating?
> >
> > Randy, what am I doing wrong.
> >
> > Also, is there any element numbers for the last few 5 years of dividends or payout?
> >
> > Thanks,
> >
>

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

=RCHGetElementNumber($B$2,3522) dividends per share dps

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

Tue Apr 17, 2012 6:13 am (PDT)



Hello Randy,

I am using rchgetelementnumber to try and get the last 5-10 years of dps, after the 5th year (3522) doesn't work.

=RCHGetElementNumber($B$2,3522) to =RCHGetElementNumber($B$2,3518)

Would you make a suggestion for how best to get dps perhaps for at least 5 years?

Thanks,

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

Re: =RCHGetElementNumber($B$2,3522) dividends per share dps

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

Tue Apr 17, 2012 8:45 am (PDT)



I would use RCHGetYahooHistory().

On Tue, Apr 17, 2012 at 6:13 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> I am using rchgetelementnumber to try and get the last 5-10 years of dps,
> after the 5th year (3522) doesn't work.
>
> =RCHGetElementNumber($B$2,3522) to =RCHGetElementNumber($B$2,3518)
>
> Would you make a suggestion for how best to get dps perhaps for at least 5
> years?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

RCHGetElementNumber only succesful when using one way, very strange!

Posted by: "wolfiyah" p.wolfensberger@datacomm.ch   wolfiyah

Tue Apr 17, 2012 3:33 pm (PDT)



Hi Randy,

I have been using the RCHGetElementNumber function successfully at least on one computer on my network.

Now I experience this strange situation:
When I assign "=RCHGetElementNumber("ABB", 848)" to a cell formula, I get results, however when I instead use RCHGetElementNumber("~~~~~", 848) as a header in a Table with ABB as the Symbol in the Ticker column, I receive an error! How is this possible??
I have to add, that previously the second variant worked fine on both computers. Now only the first variant is working and only on the computer which runs Windows XP, IE 8. The one who fails runs on Windows 7.

It is also important to note that it seems to concern only 848 (& 849)which is Zacks Rank from their website.
I haven't made changes to the program and none to the setup (Windows, Network), and the failure of variant 1 occured on both computers simultaneously. Must there be a special http or other port enabled in NAT?

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

Re: RCHGetElementNumber only succesful when using one way, very stra

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

Tue Apr 17, 2012 3:59 pm (PDT)



Very strange. The actual formula works for me as well, but not the version
for smfUpdateDownloadTable. I'm running under Vista. It's failing under an
Evaluate() function, so I'm not getting any diagnostic with the error.

This workaround appears to work:

RCHGetTableCell("http://www.zacks.com/research/print.php?t=~~~~~",1,">Zacks
Rank")

Ahhhhh. I know what it is. I recently changed the Zacks element definitions
to be formulas. But Evaluate() errors out if an internal string gets too
long during the evaluate process.

On Tue, Apr 17, 2012 at 3:27 PM, wolfiyah <p.wolfensberger@datacomm.ch>wrote:

> Hi Randy,
>
> I have been using the RCHGetElementNumber function successfully at least
> on one computer on my network.
>
> Now I experience this strange situation:
> When I assign "=RCHGetElementNumber("ABB", 848)" to a cell formula, I get
> results, however when I instead use RCHGetElementNumber("~~~~~", 848) as a
> header in a Table with ABB as the Symbol in the Ticker column, I receive an
> error! How is this possible??
> I have to add, that previously the second variant worked fine on both
> computers. Now only the first variant is working and only on the computer
> which runs Windows XP, IE 8. The one who fails runs on Windows 7.
>
> It is also important to note that it seems to concern only 848 (&
> 849)which is Zacks Rank from their website.
> I haven't made changes to the program and none to the setup (Windows,
> Network), and the failure of variant 1 occured on both computers
> simultaneously. Must there be a special http or other port enabled in NAT?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

Re: Historical annual EPS and annual Dividends

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

Tue Apr 17, 2012 3:49 pm (PDT)



Hello Jeff,

I was wondering if you had any luck with designing a template using the naic ssg model?

How did you get around the yearly dividends?

Did you use?

=rchgetelements?

or

=gethistory?

Thanks,

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Look over the element definitions and you'll find a number of options.
>
> By the way, if you subscribe to AAII's Stock Investor Pro database, they
> distribute individual SSG files with the database updates.
>
> On Mon, May 16, 2011 at 4:56 AM, Jeff F <jeff_fulkerson@...> wrote:
>
> > Is there a function of the smf_addin to pull historical yearly EPS data?
> >
> > I am using an Excel spreadsheet that I downloaded from AAII (American
> > Association of Individual Investors) that I am trying to make as automated
> > as possible. I am currently using the smfPricesBetween function to pull in
> > low and high prices from each of the last 5 years and would also like to
> > pull in yearly EPS data from each of the last 5 years.
> >
> > I was looking through the documentation, but did not see anything that
> > would accomplish this. If it would help, I could upload the file I am using.
> > Let me know.
> >
>

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

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need traffic?

Drive customers

With search ads

on Yahoo!

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)