Sabtu, 22 Desember 2012

[smf_addin] Digest Number 2443

13 New Messages

Digest #2443
1b
2a
Re: Altman_Piotroski.xls by "José Azevedo" jma_resende
2b
Re: Altman_Piotroski.xls by "Jovica Bozic" jovica.bozic
2c
Re: Altman_Piotroski.xls by "Jovica Bozic" jovica.bozic
3a
Thank You for Altman_Piotroski.xls by "almondtree" almondtree
3c
Re: Thank You for Altman_Piotroski.xls by "Randy Harmelink" rharmelink
4a
Re: Earnings data from CNBC by "lawrence.leesh" lawrence.leesh
4b
Re: Earnings data from CNBC by "Randy Harmelink" rharmelink
4c
Re: Earnings data from CNBC by "lawrence.leesh" lawrence.leesh
4d
Re: Earnings data from CNBC by "Randy Harmelink" rharmelink

Messages

Fri Dec 21, 2012 5:52 am (PST) . Posted by:

"José Azevedo" jma_resende

HI!

In here "=RCHGetElementNumber(MTicker;25)" I get a error in Net-nets.xlsm.
Is the "MTicker" the name of the ticker in D5?

thanks
Jose

Fri Dec 21, 2012 7:15 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Probable reason:
http://finance.groups.yahoo.com/group/smf_addin/message/19858

However, I would change it to:

=RCHGetYahooQuotes(MTicker,"l1")

...since MSN is now populating "Last Price" with the previous day's closing
price.

On Fri, Dec 21, 2012 at 6:52 AM, José Azevedo <jmazevedo@gmail.com> wrote:

>
>
> In here "=RCHGetElementNumber(MTicker;25)" I get a error in Net-nets.xlsm.
> Is the "MTicker" the name of the ticker in D5?
>
>

Fri Dec 21, 2012 11:27 am (PST) . Posted by:

"Pete" petekoch

I just uploaded a new version which retrieves additional info, e.g., Piotroski F-Score. Also made the change Randy recommended, added name definitions, and changed the VBA code.

--- In smf_addin@yahoogroups.com, José Azevedo <jmazevedo@...> wrote:
>
> HI!
>
> In here "=RCHGetElementNumber(MTicker;25)" I get a error in Net-nets.xlsm.
> Is the "MTicker" the name of the ticker in D5?
>
> thanks
> Jose
>

Fri Dec 21, 2012 5:59 am (PST) . Posted by:

"José Azevedo" jma_resende

I have same error, Altman_Piotroski.xls, here
"=RCHGetElementNumber(Ticker;25)"

Some help?

Thanks
Jose

Fri Dec 21, 2012 7:13 am (PST) . Posted by:

"Jovica Bozic" jovica.bozic

@Pete

If I'm not mistaken, there is an error in Altman_Piotroski.xls file. X4 in Z Score should be Total Liabilities*1000, 'cause MktCap is in thousands and total liab. in millions.

--- In smf_addin@yahoogroups.com, "Pete" <petekoch@...> wrote:
>
>
> Randy is correct. In a snit, I deleted it a while ago, but it's back.
> Be aware that I keep the SMF addin in a 'non-standard' location on my PC, so you'll have to do a global change to the Data tab to correct.
>
> --- In smf_addin@yahoogroups.com, "almondtree" <almondtree@> wrote:
> >
> > Where is Altman_Piotroski.xls ?
> >
>

Fri Dec 21, 2012 9:36 am (PST) . Posted by:

"Jovica Bozic" jovica.bozic

So sorry, my mistake I didn't look at the final score. In final formula X4 is divided with 1000.

--- In smf_addin@yahoogroups.com, "Jovica Bozic" <jovica.bozic@...> wrote:
>
> @Pete
>
> If I'm not mistaken, there is an error in Altman_Piotroski.xls file. X4 in Z Score should be Total Liabilities*1000, 'cause MktCap is in thousands and total liab. in millions.
>
>
>
>
> --- In smf_addin@yahoogroups.com, "Pete" <petekoch@> wrote:
> >
> >
> > Randy is correct. In a snit, I deleted it a while ago, but it's back.
> > Be aware that I keep the SMF addin in a 'non-standard' location on my PC, so you'll have to do a global change to the Data tab to correct.
> >
> > --- In smf_addin@yahoogroups.com, "almondtree" <almondtree@> wrote:
> > >
> > > Where is Altman_Piotroski.xls ?
> > >
> >
>

Fri Dec 21, 2012 11:09 am (PST) . Posted by:

"almondtree" almondtree

Altman_Piotroski.xls I made changes to (MAIN sheet) RchGetElemetNumber(Ticker,25) to RCHGetYahooQoutes(Ticker,"l1"),and =RCHGetElementNumber(Ticker,13863)from(,13862)....I didn't know you could combine element numbers or do calculations.

Fri Dec 21, 2012 11:43 am (PST) . Posted by:

"Pete" petekoch

Changing to RCHGYQ to retrieve price is a good idea.

I don't know how you got 13863 for Company Name. My copy shows 13862 and I don't remember touching that cell recently.

Either I'm losing it or it's one of life's little mysteries.

--- In smf_addin@yahoogroups.com, "almondtree" <almondtree@...> wrote:
>
> Altman_Piotroski.xls I made changes to (MAIN sheet) RchGetElemetNumber(Ticker,25) to RCHGetYahooQoutes(Ticker,"l1"),and =RCHGetElementNumber(Ticker,13863)from(,13862)....I didn't know you could combine element numbers or do calculations.
>

Fri Dec 21, 2012 12:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

13862 would get it from MSN. 13863 would get it from Yahoo.

On Fri, Dec 21, 2012 at 12:43 PM, Pete <petekoch@yahoo.com> wrote:

> Changing to RCHGYQ to retrieve price is a good idea.
>
> I don't know how you got 13863 for Company Name. My copy shows 13862 and I
> don't remember touching that cell recently.
>
> Either I'm losing it or it's one of life's little mysteries.
>

Fri Dec 21, 2012 11:02 pm (PST) . Posted by:

"lawrence.leesh" lawrence.leesh

Hi Randy

What is the number codes for the addin to get future earnings estimates for the next four quarters from either cnbc or other sites?

thanks

LL

--- In smf_addin@yahoogroups.com, "Randy Harmelink" <rharmelink@...> wrote:
>
> Just thought I'd mention another site I just ran into that may be
> easier to get data from, although only 4 quarters of future estimates:
>
> http://finapps.forbes.com/finapps/jsp/finance/compinfo/Earnings.jsp?tkr=IBM
>
> However, it is more easily accessible with RCHGetTableCell() and some
> of the other forecast items go out further -- to 2009 for IBM.
>
> On 11/2/07, mgbuck55 <mgbuck@...> wrote:
> > I would like to download historical actual vs estimated earnings for
> > selected companies from the the CNBC website
>

Fri Dec 21, 2012 11:22 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

For CNBC, I think the process here might still work:

http://finance.groups.yahoo.com/group/smf_addin/message/3113

For other sites, sample URLs please. Or for CNBC if not from the web page
used on the link above.

On Sat, Dec 22, 2012 at 12:02 AM, lawrence.leesh
<lawrence.leesh@yahoo.com>wrote:

>
> What is the number codes for the addin to get future earnings estimates
> for the next four quarters from either cnbc or other sites?
>

Fri Dec 21, 2012 11:39 pm (PST) . Posted by:

"lawrence.leesh" lawrence.leesh

Hi Randy, thanks for your prompt response. I went to the page and saw many lines of coding. Need to know some kind of programming in order to get the data? Would the data be available for download in this format like it is for price data?
=RCHGetElementNumber("ibm",25)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> For CNBC, I think the process here might still work:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/3113
>
> For other sites, sample URLs please. Or for CNBC if not from the web page
> used on the link above.
>
> On Sat, Dec 22, 2012 at 12:02 AM, lawrence.leesh
> <lawrence.leesh@...>wrote:
>
> >
> > What is the number codes for the addin to get future earnings estimates
> > for the next four quarters from either cnbc or other sites?
> >
>

Sat Dec 22, 2012 12:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It would require the special VBA programming to get to the CNBC data. It
wouldn't be available to normal add-in processing, since the data is
dynamically placed onto the web page.

On Sat, Dec 22, 2012 at 12:39 AM, lawrence.leesh
<lawrence.leesh@yahoo.com>wrote:

> Hi Randy, thanks for your prompt response. I went to the page and saw many
> lines of coding. Need to know some kind of programming in order to get the
> data? Would the data be available for download in this format like it is
> for price data?
> =RCHGetElementNumber("ibm",25)
>

Tidak ada komentar:

Posting Komentar