Messages In This Digest (8 Messages)
- 1a.
- Gross and Net PPE From: Chovek2
- 1b.
- Re: Gross and Net PPE From: Mike McQuaid
- 1c.
- Re: Gross and Net PPE From: Randy Harmelink
- 1d.
- Re: Gross and Net PPE From: Chovek2
- 2a.
- Re: Making element definitions generic with possibly unique URLs From: curls07
- 2b.
- Re: Making element definitions generic with possibly unique URLs From: Randy Harmelink
- 3a.
- Re: smfPrice by and between From: antonvanas1989
- 3b.
- Re: smfPrice by and between From: antonvanas1989
Messages
- 1a.
-
Gross and Net PPE
Posted by: "Chovek2" keith@dalrymplefinance.com Chovek2
Tue Jan 10, 2012 5:39 am (PST)
Hi, there. I have an issue in that I am constructing historical statements, generally using Google. Google gives gross PPE; however, I need net PPE. Although Google does give accumulated depreciation, there seems to be no code for that line item.
1) does anyone know of code for line item accumulated depreciation on Google, if so where can I get it?
Additionally, Yahoo gives PPE as a net figure. However,Yahoo code seems to exist only for the quarterly balance sheet, from what I see.
2)Does yahoo have code for annual balance sheets, if so, where can I get it.
Many thanks for any help with this small, but irksome detail.
Keith
- 1b.
-
Re: Gross and Net PPE
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Tue Jan 10, 2012 6:04 am (PST)
AdvFN has historical quarterly and yearly financials - income, balance sheet
and cash flow. They have every element for every period.
The site is a bit slow but I've found it to be very reliable.
SMF has many (all?) of the elements in its definition list. Just see that.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Chovek2
Sent: Tuesday, January 10, 2012 6:01 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Gross and Net PPE
Hi, there. I have an issue in that I am constructing historical statements,
generally using Google. Google gives gross PPE; however, I need net PPE.
Although Google does give accumulated depreciation, there seems to be no
code for that line item.
1) does anyone know of code for line item accumulated depreciation on
Google, if so where can I get it?
Additionally, Yahoo gives PPE as a net figure. However,Yahoo code seems to
exist only for the quarterly balance sheet, from what I see.
2)Does yahoo have code for annual balance sheets, if so, where can I get it.
Many thanks for any help with this small, but irksome detail.
Keith
- 1c.
-
Re: Gross and Net PPE
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jan 10, 2012 6:48 am (PST)
Where elements aren't defined, you would need to use other add-in functions
to retrieve the data. For example, to get the most recent quarter of
depreciation from IBM's income statement:
=RCHGetTableCell("https://www. google.com/ finance?q= NYSE:IBM& fstype=ii
",1,">Depreciation/Amortization" )
It's not a good idea to mix financial statements data from different
sources, because they can have different meanings. For example, Yahoo's
"Cash and Equivalents" includes "Restricted Cash", while some other sources
break out the "Restricted Cash". In fact, Yahoo has a "Cash" amount listed
on their Key Statistics web page -- which you cannot calculate using their
financial statements data, because of the "Restricted Cash" issue.
On Tue, Jan 10, 2012 at 4:01 AM, Chovek2 <keith@dalrymplefinance.com > wrote:
> Hi, there. I have an issue in that I am constructing historical
> statements, generally using Google. Google gives gross PPE; however, I
> need net PPE. Although Google does give accumulated depreciation, there
> seems to be no code for that line item.
>
> 1) does anyone know of code for line item accumulated depreciation on
> Google, if so where can I get it?
>
> Additionally, Yahoo gives PPE as a net figure. However,Yahoo code seems
> to exist only for the quarterly balance sheet, from what I see.
>
> 2)Does yahoo have code for annual balance sheets, if so, where can I get
> it.
>
> Many thanks for any help with this small, but irksome detail.
>
- 1d.
-
Re: Gross and Net PPE
Posted by: "Chovek2" keith@dalrymplefinance.com Chovek2
Tue Jan 10, 2012 7:37 am (PST)
That's fantastic, thanks Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Where elements aren't defined, you would need to use other add-in functions
> to retrieve the data. For example, to get the most recent quarter of
> depreciation from IBM's income statement:
>
> =RCHGetTableCell("https://www. google.com/ finance?q= NYSE:IBM& fstype=ii
> ",1,">Depreciation/Amortization" )
>
> It's not a good idea to mix financial statements data from different
> sources, because they can have different meanings. For example, Yahoo's
> "Cash and Equivalents" includes "Restricted Cash", while some other sources
> break out the "Restricted Cash". In fact, Yahoo has a "Cash" amount listed
> on their Key Statistics web page -- which you cannot calculate using their
> financial statements data, because of the "Restricted Cash" issue.
>
> On Tue, Jan 10, 2012 at 4:01 AM, Chovek2 <keith@...> wrote:
>
> > Hi, there. I have an issue in that I am constructing historical
> > statements, generally using Google. Google gives gross PPE; however, I
> > need net PPE. Although Google does give accumulated depreciation, there
> > seems to be no code for that line item.
> >
> > 1) does anyone know of code for line item accumulated depreciation on
> > Google, if so where can I get it?
> >
> > Additionally, Yahoo gives PPE as a net figure. However,Yahoo code seems
> > to exist only for the quarterly balance sheet, from what I see.
> >
> > 2)Does yahoo have code for annual balance sheets, if so, where can I get
> > it.
> >
> > Many thanks for any help with this small, but irksome detail.
> >
>
- 2a.
-
Re: Making element definitions generic with possibly unique URLs
Posted by: "curls07" agc11d@gmail.com curls07
Tue Jan 10, 2012 6:00 am (PST)
I've used those for the ticker before, but I don't know how to get past the unique ids in the URL
The items that are spaced out are the unique ids;
http://ipoportal.edgar-online. 785256 &find= 65660&IPO =1&coname=YOUKU+com/ipo/displayF undamentals. asp?cikid= INC%2E
Is there a way to figure out how those ids are assigned, or to simply get around them entirely? For example the name at the end of the URL doesn't matter, &coname=YOUKU+INC%2E, you can delete it and still get to the same page.
Perhaps I could have an ticker input as well as an id column input and use a =rchgettablecell?
Please let me know your thoughts on this.
Thank you for the help Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Place a "~~~~~" string in your URL for the ticker symbol. The ticker symbol
> you pass to the function will replace those give tildas. However, that is
> the only substitution that can occur.
>
> On Mon, Jan 9, 2012 at 9:45 PM, curls07 <agc11d@...> wrote:
>
> >
> > I've been working on some research analyzing Chinese companies IPOs traded
> > on the NASDAQ and NYSE. I've been trying to collect information from about
> > the circumstances in which they went public.
> >
> > I am trying to collect information from EDGAR OnlineIpo like share price,
> > number of shares outstanding, offer amount etc. I have written these
> > elements to grab the information from the page. I am having trouble making
> > the elements 'generic' so that I can input any ticker and get the
> > corresponding information because it seems that each URL is unique.
> >
> > Does anyone have any ideas to get around this?
> >
> > Thanks in advance.
> >
> > Here's an example of the page I am trying to pull information form;
> >
> >
> > http://ipoportal.edgar-online. com/ipo/displayF undamentals. asp?cikid= 785256&fnid= 65660&IPO= 1&coname= YOUKU+INC% 2E
> >
> > Here are the current element formulas I'm using:
> >
> > 19564;Evaluate;ipo share price;=RCHGetTableC ell("
> > http://ipoportal.edgar-online. ",1,"Sharecom/ipo/displayF undamentals. asp?cikid= 785256&fnid= 65660&IPO= 1&coname= YOUKU+INC% 2E
> > Price :");;;;;;;;;0
> > 19565;Evaluate;ipo Shares Offered;=RCHGetTabl eCell("
> > http://ipoportal.edgar-online. ",1,"Sharescom/ipo/displayF undamentals. asp?cikid= 785256&fnid= 65660&IPO= 1&coname= YOUKU+INC% 2E
> > Offered");;;;;;;;;0
> > 19566;Evaluate;ipo Offer Amount ;=RCHGetTableCell( "
> > http://ipoportal.edgar-online. ",1,"Offercom/ipo/displayF undamentals. asp?cikid= 785256&fnid= 65660&IPO= 1&coname= YOUKU+INC% 2E
> > Amount");;;;;;;;;0
> > 19567;Evaluate;ipo Shares Outstanding ;=RCHGetTableCell( "
> > http://ipoportal.edgar-online. ",1,"Sharescom/ipo/displayF undamentals. asp?cikid= 785256&fnid= 65660&IPO= 1&coname= YOUKU+INC% 2E
> > Outstanding ");;;;;;;;;0
> >
>
- 2b.
-
Re: Making element definitions generic with possibly unique URLs
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jan 10, 2012 7:52 am (PST)
I usually end up with some trial and error things to see what's what. What
changes in the URL as I do different companies. Etc.
I also use the "Web Developer" add-on for FireFox to do some of the
legwork. For example, sometimes you can see a better URL if you tell a form
to do a "Get" instead of a "Post".
There may be a page where you search by ticker, but the links are by
"chkid" -- in which case you could extract the "chkid" for a ticker from
that page.
On Tue, Jan 10, 2012 at 7:00 AM, curls07 <agc11d@gmail.com > wrote:
> I've used those for the ticker before, but I don't know how to get past
> the unique ids in the URL
>
> The items that are spaced out are the unique ids;
> http://ipoportal.edgar-online. com/ipo/displayF undamentals. asp?cikid=
> 785256 &find= 65660&IPO =1&coname=YOUKU+INC%2E
>
> Is there a way to figure out how those ids are assigned, or to simply get
> around them entirely? For example the name at the end of the URL doesn't
> matter, &coname=YOUKU+INC%2E, you can delete it and still get to the same
> page.
>
> Perhaps I could have an ticker input as well as an id column input and use
> a =rchgettablecell?
>
> Please let me know your thoughts on this.
>
- 3a.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Tue Jan 10, 2012 9:13 am (PST)
thats not realy hard to do..
The fisical year is reported so you got that date so ur end date is not 12/31/11 but 03/31/12 for example the formula is the same but only ur data changes..
But Randy says its better to take them straight from the source and he's right
--- In smf_addin@yahoogroups.com , "Mike McQuaid" <mikemcq802@...> wrote:
>
> Simply that earnings, sales, and such are reported for fiscal years.
>
> If you want to calculate ratios you should use prices which align with the
> fiscal periods.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of antonvanas1989
> Sent: Monday, January 09, 2012 5:15 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: smfPrice by and between
>
>
>
>
> How do you mean?
>
> What issues?
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > You also have issues between fiscal years and calendar.
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ] On
> Behalf
> > Of Randy Harmelink
> > Sent: Monday, January 09, 2012 2:42 PM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com>
> > Subject: Re: [smf_addin] Re: smfPrice by and between
> >
> >
> >
> >
> > I think you're best off retrieving the array of data and computing the
> high
> > from it.
> >
> > If you're computing your own ratios, though, you've got another problem --
> > during that year, you may have a different number of shares. A split, a
> > buyback, additional shares released, etc. So you'd need to adjust the high
> > prices by the number of shares, on a daily basis, before creating your
> > ratio.
> >
> >
> >
> > On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@>
> > wrote:
> >
> >
> > It's works here too now but i don't get the High of the year only.
> >
> > How i would get that with this formula
> >
>
- 3b.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Tue Jan 10, 2012 11:18 am (PST)
what do normalized mean on the advfn website?
Normalized Close PE Ratio
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> thats not realy hard to do..
>
> The fisical year is reported so you got that date so ur end date is not 12/31/11 but 03/31/12 for example the formula is the same but only ur data changes..
>
> But Randy says its better to take them straight from the source and he's right
>
> --- In smf_addin@yahoogroups.com , "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Simply that earnings, sales, and such are reported for fiscal years.
> >
> > If you want to calculate ratios you should use prices which align with the
> > fiscal periods.
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> > Of antonvanas1989
> > Sent: Monday, January 09, 2012 5:15 PM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: smfPrice by and between
> >
> >
> >
> >
> > How do you mean?
> >
> > What issues?
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
> > "Mike McQuaid" <mikemcq802@> wrote:
> > >
> > > You also have issues between fiscal years and calendar.
> > >
> > > _____
> > >
> > > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com>
> > [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ] On
> > Behalf
> > > Of Randy Harmelink
> > > Sent: Monday, January 09, 2012 2:42 PM
> > > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com>
> > > Subject: Re: [smf_addin] Re: smfPrice by and between
> > >
> > >
> > >
> > >
> > > I think you're best off retrieving the array of data and computing the
> > high
> > > from it.
> > >
> > > If you're computing your own ratios, though, you've got another problem --
> > > during that year, you may have a different number of shares. A split, a
> > > buyback, additional shares released, etc. So you'd need to adjust the high
> > > prices by the number of shares, on a daily basis, before creating your
> > > ratio.
> > >
> > >
> > >
> > > On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@>
> > > wrote:
> > >
> > >
> > > It's works here too now but i don't get the High of the year only.
> > >
> > > How i would get that with this formula
> > >
> >
>
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