13 New Messages
Digest #2443
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
In here "=RCHGetElementNumb
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?
>
>
http://finance.
However, I would change it to:
=RCHGetYahooQuotes(
...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.
>
>
> In here "=RCHGetElementNumb
> 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
>
--- In smf_addin@yahoogrou
>
> HI!
>
> In here "=RCHGetElementNumb
> 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
"=RCHGetElementNumb
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 ?
> >
>
If I'm not mistaken, there is an error in Altman_Piotroski.
--- In smf_addin@yahoogrou
>
>
> 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@yahoogrou
> >
> > Where is Altman_Piotroski.
> >
>
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 ?
> > >
> >
>
--- In smf_addin@yahoogrou
>
> @Pete
>
> If I'm not mistaken, there is an error in Altman_Piotroski.
>
>
>
>
> --- In smf_addin@yahoogrou
> >
> >
> > 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@yahoogrou
> > >
> > > Where is Altman_Piotroski.
> > >
> >
>
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.
>
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@yahoogrou
>
> Altman_Piotroski.
>
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.
>
On Fri, Dec 21, 2012 at 12:43 PM, Pete <petekoch@yahoo.
> 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
>
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@yahoogrou
>
> 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.
>
> However, it is more easily accessible with RCHGetTableCell(
> 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?
>
http://finance.
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@
>
> 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?
> >
>
=RCHGetElementNumbe
--- In smf_addin@yahoogrou
>
> For CNBC, I think the process here might still work:
>
> http://finance.
>
> 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@
>
> >
> > 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)
>
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@
> 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?
> =RCHGetElementNumbe
>
Tidak ada komentar:
Posting Komentar