Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 8098 - 8127 of 8127   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#8127 From: Randy Harmelink <rharmelink@...>
Date: Wed Nov 25, 2009 7:40 am
Subject: Re: #NAME? error
rharmelink
Offline Offline
Send Email Send Email
 
Try:

=smfGetTagContent("http://in.reuters.com/money/quotes/quote?symbol=ABG.BO","span",1,"Last Trade")

At this point, it's just an experimental function I threw together for someone.  It may go through a few iterations before it gets finalized.  It's parameters are very to RCHGetTableCell().  For now, only the first 7 parameters are important:

#1 is pURL -- same purpose as RCHGetTableCell()
#2 is pTag -- the only new item, which indicates the type of HTML tag to grab ("td", "table", "span", etc)
#3 is pTags -- same purpose as pCells in RCHGetTableCell(), which is the number of tags beyond the last found string from which to extract the data
#4-#7 are pFind1 thru pFind4 -- same purpose as RCHGetTableCell()

For the most part, it returns the raw data from within a pair of HTML tags.  I mostly use it for debugging purposes.  It can be nice to enumerate the values of all tables on the page, or all rows of a given table, etc.  That can give me a better idea of how the web page HTML code is structured.

On Wed, Nov 25, 2009 at 12:24 AM, Farhan Ansari <farhan86a@...> wrote:

Many thanks Randy, I chose smfGetTagContent(). I am also trying to be able to get the Last Trade value from http://in.reuters.com/money/quotes/quote?symbol=ABG.BO but I believe its not in a table format and thus smfGetTableCell() is not returning me any value. Is it too put it in a sort of header??. I also don't know the syntax of smfGetTagContent("Link", ?,?) Sorry for using Charlie's mail as a reply ..unknowingly :-)


#8126 From: Farhan Ansari <farhan86a@...>
Date: Wed Nov 25, 2009 7:24 am
Subject: Re: #NAME? error
farsdocs
Offline Offline
Send Email Send Email
 
Many thanks Randy, I chose smfGetTagContent(). I am also trying to be able to get the Last Trade value from http://in.reuters.com/money/quotes/quote?symbol=ABG.BO but I believe its not in a table format and thus smfGetTableCell() is not returning me any value. Is it too put it in a sort of header??. I also don't know the syntax of smfGetTagContent("Link", ?,?) Sorry for using Charlie's mail as a reply ..unknowingly :-)

Thanks,
Farhan



On Tue, Nov 24, 2009 at 7:51 PM, Randy Harmelink <rharmelink@...> wrote:
 

There is a function in the new beta version of the add-in ("Works in Progress" folder) that can extract it fairly easily:

=MID(smfGetTagContent("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","title",1),21,99)
=smfGetTagContent("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","b",1,"CompanyAddress")

Otherwise, it would be something you'd need to parse out using the RCHGetWebData() function, and it would be complicated as a single cell formula.  For example:

=MID(RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"),
FIND(" for ",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))+5,
FIND("</",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))-
FIND(" for ",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))-5)



On Tue, Nov 24, 2009 at 5:50 AM, Farhan Ansari <farhan86a@...> wrote:

Is there a simple way out to get any of the two headers from http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO which includes the company name i.e. A B G Infralogistics Ltd. I used RCHGetWebData() to get that string but it seems to cumbersome to me and redundant for other symbols.



#8125 From: "davey_11372" <davey_11372@...>
Date: Wed Nov 25, 2009 3:23 am
Subject: Sourcing and Extracting trading data
davey_11372
Offline Offline
Send Email Send Email
 
Hello everyone. Thanks for all the valuable resources posted on/in this group. I
am trying to get a hang of it.

I would like to know if anyone may have insight on sources for the following
data: (and how to extract download/export it via excel for a 
watchlist/portfolio etc)

- stock beta
- stock standard deviation
- implied volatility

preferably for a list/portfolio versus one stock at a time.

Also, is it possible to extract information/data (in my case from scottrade)
keeping in mind that the broker platform does not have a function/link to
download/export the same via excel/csv format.

Thanks in advance and greetings for the Thanksgiving holiday weekend!

#8124 From: Gabriele Sorbara <g_sorbara@...>
Date: Wed Nov 25, 2009 2:24 am
Subject: Re: Real-Time Intra-Day Prices
g_sorbara
Offline Offline
Send Email Send Email
 
Many thanks!

--- On Tue, 11/24/09, Randy Harmelink <rharmelink@...> wrote:

From: Randy Harmelink <rharmelink@...>
Subject: Re: [smf_addin] Real-Time Intra-Day Prices
To: smf_addin@yahoogroups.com
Date: Tuesday, November 24, 2009, 9:20 PM

 
RCHGetTableCell- Template- BATS-Real- Time-Quotes. xls

I don't know of a source for accumulated minute-by-minute prices.

On Tue, Nov 24, 2009 at 7:11 PM, Gabriele Sorbara <g_sorbara@yahoo. com> wrote:

Thanks for the quick response.  I don't think I was clear though.  I am looking to download minute by minute prices.  Do you know the name of the "BATS template"?



#8123 From: Randy Harmelink <rharmelink@...>
Date: Wed Nov 25, 2009 2:20 am
Subject: Re: Real-Time Intra-Day Prices
rharmelink
Offline Offline
Send Email Send Email
 
RCHGetTableCell-Template-BATS-Real-Time-Quotes.xls

I don't know of a source for accumulated minute-by-minute prices.

On Tue, Nov 24, 2009 at 7:11 PM, Gabriele Sorbara <g_sorbara@...> wrote:

Thanks for the quick response.  I don't think I was clear though.  I am looking to download minute by minute prices.  Do you know the name of the "BATS template"?


#8122 From: Gabriele Sorbara <g_sorbara@...>
Date: Wed Nov 25, 2009 2:11 am
Subject: Re: Real-Time Intra-Day Prices
g_sorbara
Offline Offline
Send Email Send Email
 
Thanks for the quick response.  I don't think I was clear though.  I am looking to download minute by minute prices.  Do you know the name of the "BATS template"?

--- On Tue, 11/24/09, Randy Harmelink <rharmelink@...> wrote:

From: Randy Harmelink <rharmelink@...>
Subject: Re: [smf_addin] Real-Time Intra-Day Prices
To: smf_addin@yahoogroups.com
Date: Tuesday, November 24, 2009, 9:02 PM

 
If you don't need a large quantity of them, there is a BATS template in the files area.

Otherwise, I've been told that if you sign up for real-time quotes on Yahoo and create the security cookie for the add-in to use, the RCHGetYahooQuotes( ) function returns real-time quotes.  I've not done it myself though.

On Tue, Nov 24, 2009 at 6:55 PM, Gabriele Sorbara <g_sorbara@yahoo. com> wrote:
 
I am trying to find a source where I can download real-time intra-day stock prices into Excel.  Any suggestions?  I also have Schwab, Fidelity and E*Trade services.  Does anyone download prices from these services?



#8121 From: Randy Harmelink <rharmelink@...>
Date: Wed Nov 25, 2009 2:02 am
Subject: Re: Real-Time Intra-Day Prices
rharmelink
Offline Offline
Send Email Send Email
 
If you don't need a large quantity of them, there is a BATS template in the files area.

Otherwise, I've been told that if you sign up for real-time quotes on Yahoo and create the security cookie for the add-in to use, the RCHGetYahooQuotes() function returns real-time quotes.  I've not done it myself though.

On Tue, Nov 24, 2009 at 6:55 PM, Gabriele Sorbara <g_sorbara@...> wrote:
 
I am trying to find a source where I can download real-time intra-day stock prices into Excel.  Any suggestions?  I also have Schwab, Fidelity and E*Trade services.  Does anyone download prices from these services?


#8120 From: Gabriele Sorbara <g_sorbara@...>
Date: Wed Nov 25, 2009 1:55 am
Subject: Real-Time Intra-Day Prices
g_sorbara
Offline Offline
Send Email Send Email
 
Hi:
 
I am trying to find a source where I can download real-time intra-day stock prices into Excel.  Any suggestions?  I also have Schwab, Fidelity and E*Trade services.  Does anyone download prices from these services?
 
Thanks,
 
Gabriele
 


#8119 From: Rangga Valbury <rangga_valbury@...>
Date: Tue Nov 24, 2009 4:03 pm
Subject: Re: need helps
rangga_valbury@...
Send Email Send Email
 
thanks Randy for your quick response,
I expect your addins can solve my problem.
Yup i think no free service out there..
thanks anyway..

rangga




--- On Tue, 11/24/09, Randy Harmelink <rharmelink@...> wrote:

From: Randy Harmelink <rharmelink@...>
Subject: Re: [smf_addin] need helps
To: smf_addin@yahoogroups.com
Date: Tuesday, November 24, 2009, 10:49 AM

 

I'm not aware of a free source.  If you do a Google search on:

    historical stock prices delisted

...you should find a number of pay services.  I've not used any of them.

On Tue, Nov 24, 2009 at 8:20 AM, Rangga Valbury <rangga_valbury@ yahoo.com> wrote:
I have a question, how can i find daily stock prices for public companies, whose stock is no longer listed, for example Warner lamber prior to merger into Pfeizer.



#8118 From: Randy Harmelink <rharmelink@...>
Date: Tue Nov 24, 2009 3:49 pm
Subject: Re: need helps
rharmelink
Offline Offline
Send Email Send Email
 
I'm not aware of a free source.  If you do a Google search on:

    historical stock prices delisted

...you should find a number of pay services.  I've not used any of them.

On Tue, Nov 24, 2009 at 8:20 AM, Rangga Valbury <rangga_valbury@...> wrote:
I have a question, how can i find daily stock prices for public companies, whose stock is no longer listed, for example Warner lamber prior to merger into Pfeizer.


#8117 From: Kevin Bruemmer <kevin.bruemmer@...>
Date: Tue Nov 24, 2009 3:47 pm
Subject: Re: Bond information
kevin.bruemmer
Offline Offline
Send Email Send Email
 
I will probably being using the FINRA or InvestinginBonds.  I have yet
to use the RCHGetTableCell(), so looks like I will be soon.

The site you sent is only for Munis; but it may be that several
different sites will need to be used.

Thanks,

Kevin

Randy Harmelink wrote:
>
>
> Do you have any preferred sources of the data (i.e sample URLs)?  The
> RCHGetTableCell() function may be able to grab the data from there.
>
> I don't know if this would be of any help or not:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/6699
> <http://finance.groups.yahoo.com/group/smf_addin/message/6699>
>
> On Tue, Nov 24, 2009 at 5:36 AM, Kevin Bruemmer <kevin.bruemmer@...
> <mailto:kevin.bruemmer@...>> wrote:
>
>     while I know that most of the group is into stocks and funds, there are
>     those of us out there that might be a little bit older and have a larger
>     focus on bond activity.
>
>     I have been using the the RCHGetElementNumber and find it pretty
>     helpful.  Any thoughts on what function to use for pulling down
>     corporate, state, Muni, bonds by CUSIP #.
>
>
>
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.425 / Virus Database: 270.14.79/2522 - Release Date: 11/23/09
19:45:00
>

#8116 From: Rangga Valbury <rangga_valbury@...>
Date: Tue Nov 24, 2009 3:20 pm
Subject: need helps
rangga_valbury@...
Send Email Send Email
 
Hi guys,

My name is rangga, i'm a new member of this group.
I have a question, how can i find daily stock prices for public companies, whose stock is no longer listed, for example Warner lamber prior to merger into Pfeizer.

Thanks, i really appreciate your assistance...

rangga


#8115 From: Randy Harmelink <rharmelink@...>
Date: Tue Nov 24, 2009 2:27 pm
Subject: Re: Bond information
rharmelink
Offline Offline
Send Email Send Email
 
Do you have any preferred sources of the data (i.e sample URLs)?  The RCHGetTableCell() function may be able to grab the data from there.

I don't know if this would be of any help or not:

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

On Tue, Nov 24, 2009 at 5:36 AM, Kevin Bruemmer <kevin.bruemmer@...> wrote:
while I know that most of the group is into stocks and funds, there are
those of us out there that might be a little bit older and have a larger
focus on bond activity.

I have been using the the RCHGetElementNumber and find it pretty
helpful.  Any thoughts on what function to use for pulling down
corporate, state, Muni, bonds by CUSIP #.


#8114 From: Randy Harmelink <rharmelink@...>
Date: Tue Nov 24, 2009 2:21 pm
Subject: Re: #NAME? error
rharmelink
Offline Offline
Send Email Send Email
 
There is a function in the new beta version of the add-in ("Works in Progress" folder) that can extract it fairly easily:

=MID(smfGetTagContent("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","title",1),21,99)
=smfGetTagContent("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","b",1,"CompanyAddress")

Otherwise, it would be something you'd need to parse out using the RCHGetWebData() function, and it would be complicated as a single cell formula.  For example:

=MID(RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"),
FIND(" for ",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))+5,
FIND("</",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))-
FIND(" for ",RCHGetWebData("http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO","<title"))-5)

On Tue, Nov 24, 2009 at 5:50 AM, Farhan Ansari <farhan86a@...> wrote:

Is there a simple way out to get any of the two headers from http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO which includes the company name i.e. A B G Infralogistics Ltd. I used RCHGetWebData() to get that string but it seems to cumbersome to me and redundant for other symbols.


#8113 From: Kevin Bruemmer <kevin.bruemmer@...>
Date: Tue Nov 24, 2009 12:36 pm
Subject: Bond information
kevin.bruemmer
Offline Offline
Send Email Send Email
 
while I know that most of the group is into stocks and funds, there are
those of us out there that might be a little bit older and have a larger
focus on bond activity.

I have been using the the RCHGetElementNumber and find it pretty
helpful.  Any thoughts on what function to use for pulling down
corporate, state, Muni, bonds by CUSIP #.

If this was already raised in the past, sorry for being redundant.

Kevin

#8112 From: "kein520" <hanchung.lee@...>
Date: Tue Nov 24, 2009 11:32 am
Subject: Office 2010 Help
kein520
Offline Offline
Send Email Send Email
 
I tried to use smf_addin on Office 2010 64 bit but it crashes every time it
accesses the Internet.

My other spreadsheets don't have the same problem.  Could the informed please
help?

#8111 From: Farhan Ansari <farhan86a@...>
Date: Tue Nov 24, 2009 12:50 pm
Subject: Re: #NAME? error
farsdocs
Offline Offline
Send Email Send Email
 
Randy,

Is there a simple way out to get any of the two headers from http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO which includes the company name i.e. A B G Infralogistics Ltd. I used RCHGetWebData() to get that string but it seems to cumbersome to me and redundant for other symbols.

Thanks,
Farhan

#8110 From: Randy Harmelink <rharmelink@...>
Date: Tue Nov 24, 2009 2:04 am
Subject: Re: #NAME? error
rharmelink
Offline Offline
Send Email Send Email
 
See:

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

On Mon, Nov 23, 2009 at 6:20 PM, charlie51952 <cbackus@...> wrote:
Just moved my link to C:\SMF as directed by "Old School Value" (out of the "Program Files Folder")

Now all cells are #NAME?


#8109 From: "charlie51952" <cbackus@...>
Date: Tue Nov 24, 2009 1:20 am
Subject: #NAME? error
charlie51952
Offline Offline
Send Email Send Email
 
Just moved my link to C:\SMF as directed by "Old School Value" (out of the
"Program Files Folder")

Now all cells are #NAME?

Whats up?  By the way Randy, you are terrific in your efforts to keep us all
going.  Many Thanks

#8108 From: Randy Harmelink <rharmelink@...>
Date: Tue Nov 24, 2009 12:29 am
Subject: Re: Number of Columns Limitation
rharmelink
Offline Offline
Send Email Send Email
 
Not having a problem here.  I just put this formula in cell JX41:

=RCHGetElementNumber("MMM",941)

...and it worked fine for me.  As did this just below that:

=RCHGetYahooQuotes("IBM,MMM","sl1")

What results are you getting?   A description of "do not work" doesn't tell me much.

On Mon, Nov 23, 2009 at 3:19 PM, mstrobel35 <mark.strobel@...> wrote:

Just recently upgraded to Excel2007 and discovered that the number of columns has increased from 256 (Column IV) to 16384 (Column XFD).  The only problem is that it appears that the RCHGetElementNumber and RCHGetYahooQuotes functions do not work beyond Column IV.

Has anyone else experienced this or discovered a workaround?


#8107 From: "mstrobel35" <mark.strobel@...>
Date: Mon Nov 23, 2009 10:19 pm
Subject: Number of Columns Limitation
mstrobel35
Offline Offline
Send Email Send Email
 
Hi All

Just recently upgraded to Excel2007 and discovered that the number of columns
has increased from 256 (Column IV) to 16384 (Column XFD).  The only problem is
that it appears that the RCHGetElementNumber and RCHGetYahooQuotes functions do
not work beyond Column IV.

Has anyone else experienced this or discovered a workaround?

Thanks

#8106 From: Glen Fullmer <gfullmer@...>
Date: Mon Nov 23, 2009 11:10 pm
Subject: Re: Altman Function does not appear to be working....
gfullmer
Offline Offline
Send Email Send Email
 
On Monday 23 November 2009 12:14:31 Randy Harmelink wrote:
> Thanks, but a donation to a worthy charitable cause would be enough for me
> -- Cancer, Diabetes, Parkinson's, etc.

Will do.  Thanks again.

> By the way, have you noticed if your workbook calculates faster now?  One
>  of my Piotroski calculation worksheets does run more quickly now.

I haven't timed them, but they seem at least 20-50% faster, thanks.

Have a super T-Day,
Glen

#8105 From: Randy Harmelink <rharmelink@...>
Date: Mon Nov 23, 2009 7:14 pm
Subject: Re: Altman Function does not appear to be working....
rharmelink
Offline Offline
Send Email Send Email
 
Thanks, but a donation to a worthy charitable cause would be enough for me -- Cancer, Diabetes, Parkinson's, etc.

By the way, have you noticed if your workbook calculates faster now?  One of my Piotroski calculation worksheets does run more quickly now.  Both the Piotroski and Altman calculations use the quarterly data from AdvFN.  In the past, that required six or seven Internet calls per ticker to retrieve the information.  Now it should only take one or two.  Plus, the amount of data it needs to parse through for the current quarter/year of data is much less.

On Mon, Nov 23, 2009 at 12:04 PM, Glen Fullmer <gfullmer@...> wrote:
PS I would like to compensate you for this fantastic package.  How can I do
that?


#8104 From: Glen Fullmer <gfullmer@...>
Date: Mon Nov 23, 2009 7:04 pm
Subject: Re: Altman Function does not appear to be working....
gfullmer
Offline Offline
Send Email Send Email
 
Hi Randy,

On Monday 23 November 2009 09:37:38 Randy Harmelink wrote:
> Wow.  Unbelievable!  The problem?  You have trailing blanks on your ticker
> symbols.

Thank you, thank you and thank you.  It would have taken me a while to figure
that one out.  I have tried the new 2.07k and it works beautimus.  I do a cut
and paste special with just values from another part of a spreadsheet and that
is probably where the space got into the mix.

Thanks again,
Glen
PS I would like to compensate you for this fantastic package.  How can I do
that?

#8103 From: "Pete" <petekoch@...>
Date: Mon Nov 23, 2009 4:55 pm
Subject: Re: Altman Function does not appear to be working.... [1 Attachment]
petekoch
Offline Offline
Send Email Send Email
 
Trailing blanks are also generally an issue with GetTableCell. If your search
string is, e.g., "Daily Volume", but the actual value on the page is "bDaily
Volume" (where the 'b' is a blank), the string won't be found.  The price of
precision....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Wow.  Unbelievable!  The problem?  You have trailing blanks on your ticker
> symbols.  I've even tried it in the browser, and using a ticker symbol with
> a trailing blank with AdvFN brings me to a different web page -- their
> default web page -- for Ford.  The reason each number is slightly different
> is because the Market Cap is retrieved from Yahoo, so it IS getting the
> correct Market Cap for each company, but all of the financial statements
> data is for Ford.
>
> I made a quick change to the smfGetAdvFNElement() function to TRIM() the
> ticker symbol when it creates the URL to grab the data from AdvFN, just so
> that can't happen again.
>
> I am amazed that the trailing blank makes a difference, but AdvFN must look
> at the entire string that is passed and looks for an exact match on the
> ticker symbol.  When none is found, it pops up the financial statements data
> for Ford.
>
> On Mon, Nov 23, 2009 at 8:55 AM, Glen Fullmer <gfullmer@...> wrote:
>
> > That is great and good enough for me.  I am enclosing a spread sheet that
> > still shows the lower numbers.
> >
>

#8102 From: Randy Harmelink <rharmelink@...>
Date: Mon Nov 23, 2009 4:37 pm
Subject: Re: Altman Function does not appear to be working.... [1 Attachment]
rharmelink
Offline Offline
Send Email Send Email
 
Wow.  Unbelievable!  The problem?  You have trailing blanks on your ticker symbols.  I've even tried it in the browser, and using a ticker symbol with a trailing blank with AdvFN brings me to a different web page -- their default web page -- for Ford.  The reason each number is slightly different is because the Market Cap is retrieved from Yahoo, so it IS getting the correct Market Cap for each company, but all of the financial statements data is for Ford.

I made a quick change to the smfGetAdvFNElement() function to TRIM() the ticker symbol when it creates the URL to grab the data from AdvFN, just so that can't happen again.

I am amazed that the trailing blank makes a difference, but AdvFN must look at the entire string that is passed and looks for an exact match on the ticker symbol.  When none is found, it pops up the financial statements data for Ford.

On Mon, Nov 23, 2009 at 8:55 AM, Glen Fullmer <gfullmer@...> wrote:
That is great and good enough for me.  I am enclosing a spread sheet that
still shows the lower numbers. 


#8101 From: Glen Fullmer <gfullmer@...>
Date: Mon Nov 23, 2009 3:55 pm
Subject: Re: Altman Function does not appear to be working....
gfullmer
Offline Offline
Send Email Send Email
 
Hi Randy,

On Monday 23 November 2009 01:03:50 Randy Harmelink wrote:
> Here's what I'm getting for those four:
>
>  Ticker AdvFN Graham 15011 Qtr Annual  ADI 9.61 8.78 8.60 8.60 10.40  AIPC
> 2.52 3.95 3.66 3.66 2.45  VALE 4.03 N/A 3.22 3.22 4.21  IPI 26.73 25.79
> 25.79 25.79 26.77

That is great and good enough for me.  I am enclosing a spread sheet that
still shows the lower numbers.  I have tested it in two environments.  One on
Vista on a laptop (using Excel 2000) and the other on a Linux (Fidora wine
(codeweavers.com)) environment both with the same low numbers. These
environments are separate and use different RCH_Plugins (however both 2.0k). Do
I need to be using Excel 2007?

I like using my Linux box but can use my Vista box if I have to go to Excel
2007.  I will be forced to do that if 2007 is required as codeweavers have not
got their emulation so it can handle add-ins with Excel 2007.  Let me know if
Excel 2007 is required.

Your help is very much appreciated.

Thanks again,
Glen

1 of 1 File(s)


#8100 From: "Pete" <petekoch@...>
Date: Mon Nov 23, 2009 2:49 pm
Subject: Re: Altman Function does not appear to be working....
petekoch
Offline Offline
Send Email Send Email
 
I just uploaded a sheet named Altman_Piotroski.xls.  The sheet calculates both
the Altman Z-Score and the Piotroski number for a given security.  Being a
careful sort, I check to see whether my calculated value(s) agree with the
values returned by elements 15010 and 15011.  I think it might be useful to the
group.

FWIW, I've been using Version 2.0k for a week now and find that it is working
properly.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm.  Saw your uploads.  Looked at ADI.  How did you get the 1.07?
>
> As you noted in the second upload, AdvFN reports 9.61.  I also get that via
> RCHGetElementNumber() below.  I don't see anything on the AdvFN site
> documenting their calculation of it.
>
> From another site, I see 8,78 reported.  Also retrieved with
> RCHGetElementNumber() below.
>
> I get 8.60 from element #15001 and if I do it manually from quarterly data.
>
> I get 10.40 if I do it manually from annual data.  However, I'm using the
> current market capitalization, so I'm not sure how valid the calculation
> is.  Should it be based on market capitalization at the time of the
> financial statement?
>
> Here are the numbers I'm retrieving and/or calculating:
>
>  Element# ADI *Description*  10786 2005.7 n1 = RCHGetElementNumber(pTicker,
> 10786) ' FQ1, Working Capital  10146 3280.2 n2 =
> RCHGetElementNumber(pTicker, 10146) ' FQ1, Total Assets  10646 2426.6 n3 =
> RCHGetElementNumber(pTicker, 10646) ' FQ1, Retained Earnings  8666 81.4 n4 =
> RCHGetElementNumber(pTicker, 8666) ' FQ1, EBIT  8667 62.2 n5 =
> RCHGetElementNumber(pTicker, 8667) ' FQ2, EBIT  8668 28 n6 =
> RCHGetElementNumber(pTicker, 8668) ' FQ3, EBIT  8669 171.4 n7 =
> RCHGetElementNumber(pTicker, 8669) ' FQ4, EBIT    343 n8 = n4 + n5 + n6 + n7
> 941 8010000 n9 = RCHGetElementNumber(pTicker, 941) ' Market Capitalization
> 10526 821.8 n10 = RCHGetElementNumber(pTicker, 10526) ' Total Liabilities
> 8186 492 n11 = RCHGetElementNumber(pTicker, 8186) ' FQ1, Operating Revenue
> 8187 474.7 n12 = RCHGetElementNumber(pTicker, 8187) ' FQ2, Operating Revenue
> 8188 476.6 n13 = RCHGetElementNumber(pTicker, 8188) ' FQ3, Operating Revenue
> 8189 660.7 n14 = RCHGetElementNumber(pTicker, 8189) ' FQ4, Operating Revenue
>   2104 n15 = n11 + n12 + n13 + n14    8.60 RCHSpecialExtraction = 1.2 * (n1
> / n2) + 1.4 * (n3 / n2) + 3.3 * (n8 / n2) + 0.6 * (n9 / n10 / 1000) + (n15 /
> n2)  15011 8.60 Altman Z-Score    9.61 =RCHGetTableCell("
> http://www.advfn.com/p.php?pid=financials&symbol="&C2,1,"Altman")    8.78
> =RCHGetTableCell("
> http://www.grahaminvestor.com/stock-quotes/current_quote?tickersym:string=
> "&C2,1,"Altman")    10.40 Annual calculation  6586 1520.5 Annual Balance
> Sheet -- Equity and Liabilities -- Working Capital -- FY1  6266 3091 Annual
> Balance Sheet -- Assets -- Total Assets -- FY1  6516 2419.9 Annual Balance
> Sheet -- Equity and Liabilities -- Retained Earnings -- FY1  5526 666.1 Annual
> Income Statement -- EBIT -- FY1  941 8010000 Market Cap  6456 670.7 Annual
> Balance Sheet -- Equity and Liabilities -- Total Liabilities -- FY1  5286
> 2582.9 Annual Income Statement -- Operating Revenue -- FY1
>
> On Sun, Nov 22, 2009 at 11:56 PM, Glen Fullmer <gfullmer@...> wrote:
>
> > OK. Tried it and it is returning numbers but they appear to be awful low.
> > All below my 3.0 threshold for 25 stocks.....
> >
>

#8099 From: smf_addin@yahoogroups.com
Date: Mon Nov 23, 2009 2:43 pm
Subject: New file uploaded to smf_addin
smf_addin@yahoogroups.com
Send Email Send Email
 
Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

   File        : /Uploads by forum members/Altman_Piotroski.xls
   Uploaded by : petekoch <petekoch@...>
   Description : Altman Z-Score and Piotroski Number

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/Alt\
man_Piotroski.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/forms/general.htmlfiles

Regards,

petekoch <petekoch@...>

#8098 From: Randy Harmelink <rharmelink@...>
Date: Mon Nov 23, 2009 8:03 am
Subject: Re: Altman Function does not appear to be working....
rharmelink
Offline Offline
Send Email Send Email
 
Here's what I'm getting for those four:

Ticker AdvFN Graham 15011 Qtr Annual
ADI 9.61 8.78 8.60 8.60 10.40
AIPC 2.52 3.95 3.66 3.66 2.45
VALE 4.03 N/A 3.22 3.22 4.21
IPI 26.73 25.79 25.79 25.79 26.77

The AdvFN numbers are closer to the Annual calculation.  The Graham numbers are closed to the quarterly (and element #15011).  However, I'm at a loss as to where you're getting your comparison numbers from?  I assumed there were element #15011, but they aren't what I'm getting from that element number -- I'm matching the calculations I compute from retrieving each component of the quarterly calculation (which is what SHOULD be happening).  So I'm confused at this point.

On Mon, Nov 23, 2009 at 12:51 AM, Glen Fullmer <gfullmer@...> wrote:

On Monday 23 November 2009 00:08:02 Randy Harmelink wrote:
> Neither attachment you sent came through.  Do you have a ticker symbol or
> two for me so I could look at the discrepancy?

ADI at 9.61 vs 1.07
AIPC 2.52 vs 1.05
VALE 4.03 vs 1.46
IPI 26.73 vs 1.05

To name some of the first ones off the list.


Messages 8098 - 8127 of 8127   Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help