Messages In This Digest (6 Messages)
- 1a.
- cash and cash equivalents, Net Income (Quarterly) From: ermitesh
- 1b.
- Re: cash and cash equivalents, Net Income (Quarterly) From: Randy Harmelink
- 2a.
- How/where do I extract 5 year forecasted EPS growth for a stock issu From: investor952
- 2b.
- Re: How/where do I extract 5 year forecasted EPS growth for a stock From: Randy Harmelink
- 3a.
- Re: Standalone SMF Addin From: alexander
- 3b.
- Re: Standalone SMF Addin From: Randy Harmelink
Messages
- 1a.
-
cash and cash equivalents, Net Income (Quarterly)
Posted by: "ermitesh" ermitesh@yahoo.com ermitesh
Fri Jun 10, 2011 9:59 am (PDT)
Excellent job. I just learned about this group. I am already using these add-ins. I wanted to learn how to get quarterly data for following two things I am mainly looking for.
1. Cash and cash equivalents
2. Net Income
Thanks,
Mitesh
- 1b.
-
Re: cash and cash equivalents, Net Income (Quarterly)
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 10, 2011 10:03 am (PDT)
First thing to do is find the data source you want to deal with. For
example, Yahoo "Cash and equivalents" includes "Restricted Cash", which is
not acceptable for some valuation methods.
There are a number of templates and elements defined for financial
statements.
On Fri, Jun 10, 2011 at 9:55 AM, ermitesh <ermitesh@yahoo.com > wrote:
> Excellent job. I just learned about this group. I am already using these
> add-ins. I wanted to learn how to get quarterly data for following two
> things I am mainly looking for.
>
> 1. Cash and cash equivalents
> 2. Net Income
>
- 2a.
-
How/where do I extract 5 year forecasted EPS growth for a stock issu
Posted by: "investor952" investor952@yahoo.com investor952
Fri Jun 10, 2011 7:09 pm (PDT)
I am a newbie. I was looking at your files & links section but could not find this. I did see reference to average 5 year eps growth from Morningstar, but I'm looking for FORECASTED 5 year eps growth (preferably from Morningstar)..but elsewhere would do. Can you point me in the right direction? Thanks.
- 2b.
-
Re: How/where do I extract 5 year forecasted EPS growth for a stock
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 10, 2011 9:11 pm (PDT)
Try:
=0+smfStrExtr(RCHGetTableCell( "
http://quicktake.morningstar. ",0,"Fivecom/stocknet/ printreport. aspx?symbol= MMM
Year Growth Forecast:")&"|",":"," |")
On Fri, Jun 10, 2011 at 7:09 PM, investor952 <investor952@yahoo.com > wrote:
> I am a newbie. I was looking at your files & links section but could not
> find this. I did see reference to average 5 year eps growth from
> Morningstar, but I'm looking for FORECASTED 5 year eps growth (preferably
> from Morningstar)..but elsewhere would do. Can you point me in the right
> direction? Thanks.
>
- 3a.
-
Re: Standalone SMF Addin
Posted by: "alexander" alex.life2539@gmail.com life2539
Fri Jun 10, 2011 7:23 pm (PDT)
Hi,
I have attempted to get an offline copy of the ".txt" files to work to no avail. I believe the key is to use the GetUrlData function included in the SMF file but I have yet to get it working correctly.
If anybody has had more experience in this or would like to explore this while I do, I have made copies of the ".txt" files available online.
the address string is:
"dl.dropbox.com/u/667104/ SMF_addin/ 2.1.2010. 08.02/smf- elements- " & ElementNumber & ".txt"
where ElementNumber is from 0 to 9
I just hope this performs just as good as keeping local copies of the ".txt" files.
Alex
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
>
>
> You could certainly create your own "lite" version by copying over the VBA code and then setting the proper reference libraries.
>
> The .txt files would need to be in the same folder as the "lite" workbook if you want to use the RCHGetElementNumber() function.
>
> But it would be possible to relocate the .txt files to some location online and modify the code that loads them. I don't think it would add a lot of overhead time when they get loaded.
>
> Of course, if the add-in code is changed, or the .txt files are changed, you need to manually do updates of everything. That's one reason I did it as an add-in. But it would be possible to maintain all of the code automatically, with some VBA processing.
>
> --- In smf_addin@yahoogroups.com , "alexander" <alex.life2539@> wrote:
> >
> > I've noticed that there are "lite" versions of specific addins. I am
> > interested in a consolidated one if that were possible. I was
> > thinking that if an online copy of the .txt files can be stored
> > online, it could also be looked up as well.
> >
> > Probably someone has done this before so I am just curious if anybody
> > knows where I can start my search.
>
- 3b.
-
Re: Standalone SMF Addin
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 10, 2011 9:36 pm (PDT)
Try something like:
Dim sURL As String
sURL = "
http://dl.dropbox.com/u/667104/ "SMF_addin/ 2.1.2010. 08.02/smf- elements- 6.txt
xx = RCHGetURLData1(sURL)
yy = Split(xx, Chr(13))
For i1 = 0 To UBound(yy) - 1
sLine = yy(i1)
If Left(Trim(sLine), 1) <> "'" Then
iPos1 = InStr(sLine, ";")
aParms(CInt(Left(sLine, iPos1 - 1))) = Mid(sLine, iPos1 + 1)
End If
Next i1
On Fri, Jun 10, 2011 at 7:23 PM, alexander <alex.life2539@gmail.com > wrote:
>
> I have attempted to get an offline copy of the ".txt" files to work to no
> avail. I believe the key is to use the GetUrlData function included in the
> SMF file but I have yet to get it working correctly.
>
> If anybody has had more experience in this or would like to explore this
> while I do, I have made copies of the ".txt" files available online.
>
> the address string is:
>
> "dl.dropbox.com/u/667104/ SMF_addin/ 2.1.2010. 08.02/smf- elements- " &
> ElementNumber & ".txt"
>
> where ElementNumber is from 0 to 9
>
> I just hope this performs just as good as keeping local copies of the
> ".txt" files.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar