Sabtu, 26 Mei 2012

[smf_addin] Digest Number 2226

Messages In This Digest (17 Messages)

1a.
Proforma EPS From: manan_atit
1b.
Re: Proforma EPS From: Randy Harmelink
2.1.
Re: ADVFN Financial Statements From: Clark F. Grain
3a.
market cap for a specific date From: Juan
3b.
Re: market cap for a specific date From: Randy Harmelink
3c.
Re: market cap for a specific date From: Juan
3d.
Re: market cap for a specific date From: Randy Harmelink
4a.
smfStrExtr to the end of the string From: Jim
4b.
Re: smfStrExtr to the end of the string From: Randy Harmelink
4c.
Re: smfStrExtr to the end of the string From: Jim
5a.
rchgetelementnumber errors From: Lucky Pierre
5b.
Re: rchgetelementnumber errors From: Randy Harmelink
5c.
Re: rchgetelementnumber errors From: Lucky Pierre
5d.
Re: rchgetelementnumber errors From: Randy Harmelink
6a.
Porting SMF to Perl? From: Malcolm
6b.
Re: Porting SMF to Perl? From: Randy Harmelink
7.1.
Re: New file uploaded to smf_addin From: Lucky Pierre

Messages

1a.

Proforma EPS

Posted by: "manan_atit" manan.atit@gmail.com   manan_atit

Fri May 25, 2012 6:43 am (PDT)



Hi - THanks for a fantastic tool. I've learn a lot from the folks that post. Was wondering if there was a website or field that pulls Proforma EPS numbers?

Thanks!
Manan

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

Re: Proforma EPS

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

Fri May 25, 2012 6:55 am (PDT)



I don't even know what that would be...

On Fri, May 25, 2012 at 6:43 AM, manan_atit <manan.atit@gmail.com> wrote:

> Hi - THanks for a fantastic tool. I've learn a lot from the folks that
> post. Was wondering if there was a website or field that pulls Proforma
> EPS numbers?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2.1.

Re: ADVFN Financial Statements

Posted by: "Clark F. Grain" cgrain@rcn.com   cgrain76

Fri May 25, 2012 6:46 am (PDT)



I forgot to give instructions. Open the Start tab and type in the stock symbol in the upper left cell (Blue) press enter and wait about 30 seconds or so for the downloads to finish.

C. Grain
----- Original Message -----
From: rebalance85
To: smf_addin@yahoogroups.com
Sent: Thursday, May 24, 2012 11:01 PM
Subject: [smf_addin] Re: ADVFN Financial Statements

Thank you very much for your kindess.
We want to have 10 years financial statments, the goal is the same, find, analysis, buy and sell.
I want to put some tab into your file, if it's possible, I will sent the file to your mailbox.
Thanks again!

--- In smf_addin@yahoogroups.com, "Clark F. Grain" <cgrain@...> wrote:
>
> Hello all,
>
> I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order to purchase shares of the company, If this is true I have developed a rather simple way of getting the data and analyzing it using "web queries". If you are interested the spreadsheets can be downloaded from the link shown below. The files to be downloaded are "SA_6.0.4"(Excel 2007-2010), and "SA_6.0.4(2000) for Excel 97-2003.
>
> C. Grain
> https://www.myiclub.com/club/folders/public.aspx?club=3442
> ----- Original Message -----
> From: Randy Harmelink
> To: smf_addin@yahoogroups.com
> Sent: Thursday, May 24, 2012 9:03 PM
> Subject: Re: [smf_addin] Re: ADVFN Financial Statements
>
>
>
> If you JUST use "IBM" as the ticker symbol, your domain assumes it is the one on the London Stock Exchange, which has no web pages for quarterly and annual financial statements data. So, yes, you would get "Error" for everything.
>
>
>
> On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@...> wrote:
>
> http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM
>
> Now works well in Excel 2007, but IBM is still error. I check the URL, it seems that there is no difference.
>

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

market cap for a specific date

Posted by: "Juan" emarco@fibertel.com.ar   juangecko

Fri May 25, 2012 9:04 am (PDT)



hello, i would like to know if it is possible to get the market cap for a specific date for a US stock.
I am able to do it for the price... =smfPricesByDates(B8,DATE(2012,3,31)). is there any similar function for market cap?
Thanks

Juan

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

Re: market cap for a specific date

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

Fri May 25, 2012 9:09 am (PDT)



You would need to create it yourself by retrieving the price that way, but
you would also need to get the number of shares from another source --
which isn't retrievable by specific date, so you'd need to retrieve a
number of them from quarterly sources and search for the one to use. Which
may not necessarily be correct for the given date because things may have
changed.

I wouldn't think it would be worth the effort, nor actually, would I trust
the value I calculated.

On Fri, May 25, 2012 at 9:03 AM, Juan <emarco@fibertel.com.ar> wrote:

> hello, i would like to know if it is possible to get the market cap for a
> specific date for a US stock.
> I am able to do it for the price... =smfPricesByDates(B8,DATE(2012,3,31)).
> is there any similar function for market cap?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: market cap for a specific date

Posted by: "Juan" emarco@fibertel.com.ar   juangecko

Fri May 25, 2012 9:30 am (PDT)



Thanks Randy for your quick reply.
i would only need the number of shares of their latest earnings report.
also what the formula to get today's outstanding shares for a stock?
thanks

Juan

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You would need to create it yourself by retrieving the price that way, but
> you would also need to get the number of shares from another source --
> which isn't retrievable by specific date, so you'd need to retrieve a
> number of them from quarterly sources and search for the one to use. Which
> may not necessarily be correct for the given date because things may have
> changed.
>
> I wouldn't think it would be worth the effort, nor actually, would I trust
> the value I calculated.
>
> On Fri, May 25, 2012 at 9:03 AM, Juan <emarco@...> wrote:
>
> > hello, i would like to know if it is possible to get the market cap for a
> > specific date for a US stock.
> > I am able to do it for the price... =smfPricesByDates(B8,DATE(2012,3,31)).
> > is there any similar function for market cap?
> >
>

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

Re: market cap for a specific date

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

Fri May 25, 2012 9:33 am (PDT)



Check the list of elements that came with the add-in. There are a few
choices, so I'm not sure which number of shares would be the appropriate
one to use.

On Fri, May 25, 2012 at 9:30 AM, Juan <emarco@fibertel.com.ar> wrote:

> i would only need the number of shares of their latest earnings report.
> also what the formula to get today's outstanding shares for a stock?
> thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

smfStrExtr to the end of the string

Posted by: "Jim" buckleca@yahoo.com   buckleca

Fri May 25, 2012 9:07 am (PDT)



I'm using smfStrExtr to extract what I need from the search.

The search finds: "45201020 - Communications Equipment"

I'd like to extract "Communications Equipment" and I can't see how you extract to the end of the string. The best I can do is:

smfstrextr(GetNameExSW(+$A8,"C","Sector",2),"- ","")

which returns: "Communications"

Will the function support this or do I need to combine some other formulas to extract to the end of the string?

Thanks

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

Re: smfStrExtr to the end of the string

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

Fri May 25, 2012 9:13 am (PDT)



The technique I use is to append a dummy string value to the end (or to the
beginning if I need something there). I usually use "|" because it's not
typically found in retrieved strings. For example:

=smfStrExtr("45201020 - Communications Equipment" & "|", "- ","|")

On Fri, May 25, 2012 at 9:07 AM, Jim <buckleca@yahoo.com> wrote:

> I'm using smfStrExtr to extract what I need from the search.
>
> The search finds: "45201020 - Communications Equipment"
>
> I'd like to extract "Communications Equipment" and I can't see how you
> extract to the end of the string. The best I can do is:
>
> smfstrextr(GetNameExSW(+$A8,"C","Sector",2),"- ","")
>
> which returns: "Communications"
>
> Will the function support this or do I need to combine some other formulas
> to extract to the end of the string?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4c.

Re: smfStrExtr to the end of the string

Posted by: "Jim" buckleca@yahoo.com   buckleca

Fri May 25, 2012 9:30 am (PDT)





Ingenious guy you are!

In my formula:

=+smfstrextr(GetNameExSW(+$A8,"c","Sector",2)& "|", "- ","|")

returns: "Communications Equipment"

Many Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The technique I use is to append a dummy string value to the end (or to the
> beginning if I need something there). I usually use "|" because it's not
> typically found in retrieved strings. For example:
>
> =smfStrExtr("45201020 - Communications Equipment" & "|", "- ","|")
>
> On Fri, May 25, 2012 at 9:07 AM, Jim <buckleca@...> wrote:
>
> > I'm using smfStrExtr to extract what I need from the search.
> >
> > The search finds: "45201020 - Communications Equipment"
> >
> > I'd like to extract "Communications Equipment" and I can't see how you
> > extract to the end of the string. The best I can do is:
> >
> > smfstrextr(GetNameExSW(+$A8,"C","Sector",2),"- ","")
> >
> > which returns: "Communications"
> >
> > Will the function support this or do I need to combine some other formulas
> > to extract to the end of the string?
> >
>

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

rchgetelementnumber errors

Posted by: "Lucky Pierre" pierre_powell@yahoo.com   pierre_powell

Fri May 25, 2012 10:32 am (PDT)



My excel (2010) will no longer pull down certain numbers. For example, the rchgetelementnumber function won't pull company name, dividends from msn or other functions. Yet it will pull certain numbers such as volume; so I believe everything installed correctly. I've been using this for about 3 years and have never had this problem until recently.

Thanks - Pierre

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

Re: rchgetelementnumber errors

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

Fri May 25, 2012 10:33 am (PDT)



See: http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Fri, May 25, 2012 at 10:07 AM, Lucky Pierre <pierre_powell@yahoo.com>wrote:

> My excel (2010) will no longer pull down certain numbers. For example,
> the rchgetelementnumber function won't pull company name, dividends from
> msn or other functions. Yet it will pull certain numbers such as volume;
> so I believe everything installed correctly. I've been using this for
> about 3 years and have never had this problem until recently.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5c.

Re: rchgetelementnumber errors

Posted by: "Lucky Pierre" pierre_powell@yahoo.com   pierre_powell

Fri May 25, 2012 10:47 am (PDT)



Thanks Randy, I updated this file with no avail. I am also having problems bringing down from non-msn sites. I reinstalled and seem to be stuck. The elements I can't bring down (for example) are 40, 42, 353, 7, 111, 989...)

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Fri, May 25, 2012 at 10:07 AM, Lucky Pierre <pierre_powell@...>wrote:
>
> > My excel (2010) will no longer pull down certain numbers. For example,
> > the rchgetelementnumber function won't pull company name, dividends from
> > msn or other functions. Yet it will pull certain numbers such as volume;
> > so I believe everything installed correctly. I've been using this for
> > about 3 years and have never had this problem until recently.
> >
>

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

Re: rchgetelementnumber errors

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

Fri May 25, 2012 11:13 am (PDT)



All of those element numbers are working fine here for ticker MMM. Only 989
is non-MSN.

What do you get for:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",7)
=smfGetAParms(7)
=RCHGetElementNumber("MMM",989)
=smfGetAParms(989)

On Fri, May 25, 2012 at 10:47 AM, Lucky Pierre <pierre_powell@yahoo.com>wrote:

> Thanks Randy, I updated this file with no avail. I am also having
> problems bringing down from non-msn sites. I reinstalled and seem to be
> stuck. The elements I can't bring down (for example) are 40, 42, 353, 7,
> 111, 989...)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
6a.

Porting SMF to Perl?

Posted by: "Malcolm" malcolmdlphillips@yahoo.com   malcolmdlphillips

Fri May 25, 2012 11:07 am (PDT)



Is there an explanation somewhere of how the SMF functions work?
I am wondering if they can be ported to Perl or other scripting language.
Does anyone know if this has been done?

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

Re: Porting SMF to Perl?

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

Fri May 25, 2012 11:14 am (PDT)



The VBA code is open source, so that would be how they work.

On Fri, May 25, 2012 at 10:48 AM, Malcolm <malcolmdlphillips@yahoo.com>wrote:

> Is there an explanation somewhere of how the SMF functions work?
> I am wondering if they can be ported to Perl or other scripting language.
> Does anyone know if this has been done?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7.1.

Re: New file uploaded to smf_addin

Posted by: "Lucky Pierre" pierre_powell@yahoo.com   pierre_powell

Fri May 25, 2012 11:37 am (PDT)



I solved the problem. My permissions were denying me the ability to save the new smf-elements-1 file. I had to move the smf folder out of programs to get the permissions to update files. i think it works now!

Pierre

--- In smf_addin@yahoogroups.com, smf_addin@yahoogroups.com wrote:
>
>
> 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 : /Works-In-Progress/smf-elements-1.txt
> Uploaded by : rharmelink <rharmelink@...>
> Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> Regards,
>
> rharmelink <rharmelink@...>
>

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

Learn more now.

Reach customers

searching for you.

Yahoo! News

Odd News

You won't believe

it, but it's true

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)