10 New Messages
Digest #2312
| |
Messages
Mon Aug 13, 2012 5:41 am (PDT) . Posted by:
"hbeetroot" hbeetroot
Hi All,
I am working on a DCF spreadsheet using (primarily) the data from MSN Money, which seems to be from what I can tell the most timely and accurate data out there, while providing a reasonable level of detail.
Unfortunately their choice of line items relating to deferred tax seem a bit weird.
There is a line item in liability section of the balance sheet called "Deferred Income Tax" - unfortunately it seems this would be more aptly named "Non-current Deferred Tax Liabilities".
They seem to aggregate all other deferred tax items into the respective "Other Assets/Liabilities" categories.
Does anyone know if there is an alternative data source that breaks down these items appropriately? It would be nice at least to know the net deferred tax position.
ADVFN seems to have the right line items, but unfortunately I don't think the data is that accurate.
Likewise, is there anywhere that actually reports the tax reconciliation table from annual reports that the SMF add-in could pull data from? (Short of the reports themselves).
While I'm at it, I may as well ask if anyone knows a data source for accumulated impairment to goodwill and cumulative amortization of intangibles.. probably asking a lot!
Thanks.
I am working on a DCF spreadsheet using (primarily) the data from MSN Money, which seems to be from what I can tell the most timely and accurate data out there, while providing a reasonable level of detail.
Unfortunately their choice of line items relating to deferred tax seem a bit weird.
There is a line item in liability section of the balance sheet called "Deferred Income Tax" - unfortunately it seems this would be more aptly named "Non-current Deferred Tax Liabilities"
They seem to aggregate all other deferred tax items into the respective "Other Assets/Liabilities" categories.
Does anyone know if there is an alternative data source that breaks down these items appropriately? It would be nice at least to know the net deferred tax position.
ADVFN seems to have the right line items, but unfortunately I don't think the data is that accurate.
Likewise, is there anywhere that actually reports the tax reconciliation table from annual reports that the SMF add-in could pull data from? (Short of the reports themselves).
While I'm at it, I may as well ask if anyone knows a data source for accumulated impairment to goodwill and cumulative amortization of intangibles.
Thanks.
Mon Aug 13, 2012 12:07 pm (PDT) . Posted by:
"eremon9" eremon9
These element numbers return error values for most, but not all, tickers:
13794 (Return on Equity)
13690 (Revenue)
13674 (Dividends)
Is there a trick to using these numbers, or are there alternative numbers to obtain this info?
Thanks for all your help, Randy.
Tom
13794 (Return on Equity)
13690 (Revenue)
13674 (Dividends)
Is there a trick to using these numbers, or are there alternative numbers to obtain this info?
Thanks for all your help, Randy.
Tom
Mon Aug 13, 2012 12:37 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
They work for me try the SMF-Template-Reuters-Ratios-Comparison.xls
Checkout the RCHGetElementNumber-Element-Definitions.xls for elements and
the template that uses the elements.
I do get error in the template for the SP-500 column but everything else
works.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of eremon9
Sent: Monday, August 13, 2012 3:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetElementNumber returns #Value
These element numbers return error values for most, but not all, tickers:
13794 (Return on Equity)
13690 (Revenue)
13674 (Dividends)
Is there a trick to using these numbers, or are there alternative numbers to
obtain this info?
Thanks for all your help, Randy.
Tom
------------------------------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatured@yahoogroups.com >
smf_addin-fullfeatured@yahoogroups.com
Checkout the RCHGetElementNumber
the template that uses the elements.
I do get error in the template for the SP-500 column but everything else
works.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of eremon9
Sent: Monday, August 13, 2012 3:07 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] RCHGetElementNumber returns #Value
These element numbers return error values for most, but not all, tickers:
13794 (Return on Equity)
13690 (Revenue)
13674 (Dividends)
Is there a trick to using these numbers, or are there alternative numbers to
obtain this info?
Thanks for all your help, Randy.
Tom
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Mon Aug 13, 2012 12:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Typically, if you get a #VALUE! error, it means you've entered a wrong-type
parameter. For example, a number where it's expecting a string, or a string
where it's expecting an integer.
I just tried the three element numbers with ticker MMM and they worked fine
here.
Please give me the exact function you're invoking that is giving the error,
showing the ticker symbol and the element number. If they work for some
tickers and not others, it's likely the tickers you are using are either
incorrect for Reuters or that Reuters doesn't carry the data for those
ticker symbols. In the latter case, people would need to know which tickers
-- if they are foreign, other services may not carry them.
Additionally, I know some parts of the Reuters web pages weren't being
populated with data last week, so it may still be a problem for SOME
tickers.
On Mon, Aug 13, 2012 at 12:07 PM, eremon9 <tamurphy@cableone.net > wrote:
> These element numbers return error values for most, but not all, tickers:
>
> 13794 (Return on Equity)
> 13690 (Revenue)
> 13674 (Dividends)
>
> Is there a trick to using these numbers, or are there alternative numbers
> to obtain this info?
>
parameter. For example, a number where it's expecting a string, or a string
where it's expecting an integer.
I just tried the three element numbers with ticker MMM and they worked fine
here.
Please give me the exact function you're invoking that is giving the error,
showing the ticker symbol and the element number. If they work for some
tickers and not others, it's likely the tickers you are using are either
incorrect for Reuters or that Reuters doesn't carry the data for those
ticker symbols. In the latter case, people would need to know which tickers
-- if they are foreign, other services may not carry them.
Additionally, I know some parts of the Reuters web pages weren't being
populated with data last week, so it may still be a problem for SOME
tickers.
On Mon, Aug 13, 2012 at 12:07 PM, eremon9 <tamurphy@cableone.
> These element numbers return error values for most, but not all, tickers:
>
> 13794 (Return on Equity)
> 13690 (Revenue)
> 13674 (Dividends)
>
> Is there a trick to using these numbers, or are there alternative numbers
> to obtain this info?
>
Mon Aug 13, 2012 4:28 pm (PDT) . Posted by:
"eremon9" eremon9
Actually, the #VALUE! error was triggered by trying to act upon an "Error" value returned by the RCH function. Here's an example of what's returning the "Error" value: =RCHGetElementNumber("MSFT",13794)
MSFT Error
NSC Error
PFE Error
PG 13.78
RY 18.71
SAN 8.9
While it could be the Reuters data source, these haven't been working for a couple of weeks.
Tom
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Typically, if you get a #VALUE! error, it means you've entered a wrong-type
> parameter. For example, a number where it's expecting a string, or a string
> where it's expecting an integer.
>
> I just tried the three element numbers with ticker MMM and they worked fine
> here.
>
> Please give me the exact function you're invoking that is giving the error,
> showing the ticker symbol and the element number. If they work for some
> tickers and not others, it's likely the tickers you are using are either
> incorrect for Reuters or that Reuters doesn't carry the data for those
> ticker symbols. In the latter case, people would need to know which tickers
> -- if they are foreign, other services may not carry them.
>
> Additionally, I know some parts of the Reuters web pages weren't being
> populated with data last week, so it may still be a problem for SOME
> tickers.
>
> On Mon, Aug 13, 2012 at 12:07 PM, eremon9 <tamurphy@...> wrote:
>
> > These element numbers return error values for most, but not all, tickers:
> >
> > 13794 (Return on Equity)
> > 13690 (Revenue)
> > 13674 (Dividends)
> >
> > Is there a trick to using these numbers, or are there alternative numbers
> > to obtain this info?
> >
>
MSFT Error
NSC Error
PFE Error
PG 13.78
RY 18.71
SAN 8.9
While it could be the Reuters data source, these haven't been working for a couple of weeks.
Tom
--- In smf_addin@yahoogrou
>
> Typically, if you get a #VALUE! error, it means you've entered a wrong-type
> parameter. For example, a number where it's expecting a string, or a string
> where it's expecting an integer.
>
> I just tried the three element numbers with ticker MMM and they worked fine
> here.
>
> Please give me the exact function you're invoking that is giving the error,
> showing the ticker symbol and the element number. If they work for some
> tickers and not others, it's likely the tickers you are using are either
> incorrect for Reuters or that Reuters doesn't carry the data for those
> ticker symbols. In the latter case, people would need to know which tickers
> -- if they are foreign, other services may not carry them.
>
> Additionally, I know some parts of the Reuters web pages weren't being
> populated with data last week, so it may still be a problem for SOME
> tickers.
>
> On Mon, Aug 13, 2012 at 12:07 PM, eremon9 <tamurphy@..
>
> > These element numbers return error values for most, but not all, tickers:
> >
> > 13794 (Return on Equity)
> > 13690 (Revenue)
> > 13674 (Dividends)
> >
> > Is there a trick to using these numbers, or are there alternative numbers
> > to obtain this info?
> >
>
Mon Aug 13, 2012 4:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried element #13794 for MSFT, NSC, and PFE -- all worked fine for
me. Although PFE was shown as 0, because the website had no data on it.
It could be that at the time you retrieved them, either you got a bad web
page, a time-out, or they hadn't been updated on Reuters. The add-in
extracts data from a SAVED copy of what was retrieved, so the function
result won't change until the SAVED copy of the web page is replaced. That
replacement should occur whenever you run the smfForceRecalculation macro,
or exit and restart EXCEL.
In some cases, you can get a new copy of the web page by adding an
ampersand to the end of the ticker symbol. It basically changes the URL,
forcing the add-in had to get and save a copy of that new web page.
On Mon, Aug 13, 2012 at 4:28 PM, eremon9 <tamurphy@cableone.net > wrote:
> Actually, the #VALUE! error was triggered by trying to act upon an "Error"
> value returned by the RCH function. Here's an example of what's returning
> the "Error" value: =RCHGetElementNumber("MSFT",13794)
>
> MSFT Error
> NSC Error
> PFE Error
> PG 13.78
> RY 18.71
> SAN 8.9
>
> While it could be the Reuters data source, these haven't been working for
> a couple of weeks.
>
me. Although PFE was shown as 0, because the website had no data on it.
It could be that at the time you retrieved them, either you got a bad web
page, a time-out, or they hadn't been updated on Reuters. The add-in
extracts data from a SAVED copy of what was retrieved, so the function
result won't change until the SAVED copy of the web page is replaced. That
replacement should occur whenever you run the smfForceRecalculati
or exit and restart EXCEL.
In some cases, you can get a new copy of the web page by adding an
ampersand to the end of the ticker symbol. It basically changes the URL,
forcing the add-in had to get and save a copy of that new web page.
On Mon, Aug 13, 2012 at 4:28 PM, eremon9 <tamurphy@cableone.
> Actually, the #VALUE! error was triggered by trying to act upon an "Error"
> value returned by the RCH function. Here's an example of what's returning
> the "Error" value: =RCHGetElementNumbe
>
> MSFT Error
> NSC Error
> PFE Error
> PG 13.78
> RY 18.71
> SAN 8.9
>
> While it could be the Reuters data source, these haven't been working for
> a couple of weeks.
>
Mon Aug 13, 2012 8:10 pm (PDT) . Posted by:
"eremon9" eremon9
That was it Randy. I had to force recalculation. I should have thought of that. Thanks for your patient assistance.
Tom
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just tried element #13794 for MSFT, NSC, and PFE -- all worked fine for
> me. Although PFE was shown as 0, because the website had no data on it.
>
> It could be that at the time you retrieved them, either you got a bad web
> page, a time-out, or they hadn't been updated on Reuters. The add-in
> extracts data from a SAVED copy of what was retrieved, so the function
> result won't change until the SAVED copy of the web page is replaced. That
> replacement should occur whenever you run the smfForceRecalculation macro,
> or exit and restart EXCEL.
>
> In some cases, you can get a new copy of the web page by adding an
> ampersand to the end of the ticker symbol. It basically changes the URL,
> forcing the add-in had to get and save a copy of that new web page.
>
> On Mon, Aug 13, 2012 at 4:28 PM, eremon9 <tamurphy@...> wrote:
>
> > Actually, the #VALUE! error was triggered by trying to act upon an "Error"
> > value returned by the RCH function. Here's an example of what's returning
> > the "Error" value: =RCHGetElementNumber("MSFT",13794)
> >
> > MSFT Error
> > NSC Error
> > PFE Error
> > PG 13.78
> > RY 18.71
> > SAN 8.9
> >
> > While it could be the Reuters data source, these haven't been working for
> > a couple of weeks.
> >
>
Tom
--- In smf_addin@yahoogrou
>
> I just tried element #13794 for MSFT, NSC, and PFE -- all worked fine for
> me. Although PFE was shown as 0, because the website had no data on it.
>
> It could be that at the time you retrieved them, either you got a bad web
> page, a time-out, or they hadn't been updated on Reuters. The add-in
> extracts data from a SAVED copy of what was retrieved, so the function
> result won't change until the SAVED copy of the web page is replaced. That
> replacement should occur whenever you run the smfForceRecalculati
> or exit and restart EXCEL.
>
> In some cases, you can get a new copy of the web page by adding an
> ampersand to the end of the ticker symbol. It basically changes the URL,
> forcing the add-in had to get and save a copy of that new web page.
>
> On Mon, Aug 13, 2012 at 4:28 PM, eremon9 <tamurphy@..
>
> > Actually, the #VALUE! error was triggered by trying to act upon an "Error"
> > value returned by the RCH function. Here's an example of what's returning
> > the "Error" value: =RCHGetElementNumbe
> >
> > MSFT Error
> > NSC Error
> > PFE Error
> > PG 13.78
> > RY 18.71
> > SAN 8.9
> >
> > While it could be the Reuters data source, these haven't been working for
> > a couple of weeks.
> >
>
Mon Aug 13, 2012 7:18 pm (PDT) . Posted by:
"svulej" svulej
I've just completed the upgrade to Yahoo! real-time quotes. If I'm logged into Yahoo! with Internet Explorer (without having to also log in through Excel Web Query), RCHGetYahooQuotes brings the real-time quote when updating with F9.
The URL which I'm using to login is https://login.
Sergio Vulej
--- In smf_addin@yahoogrou
>
> Web Query is asking for a URL - any ideas?
>
> --- On Fri, 3/23/12, Randy Harmelink <rharmelink@
>
> From: Randy Harmelink <rharmelink@
> Subject: Re: [smf_addin] Upgrading to real-time quotes
> To: smf_addin@yahoogrou
> Date: Friday, March 23, 2012, 3:32 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Â
>
>
>
>
>
>
>
>
>
> As I understand it, you just need to log in and you get the real time quotes instead of delayed quotes automatically. However, you must log in with either the EXCEL Web Query process or with IE, as something like FireFox will not create the proper security cookies for EXCEL and the add-in.
>
>
> On Fri, Mar 23, 2012 at 2:44 PM, thomas91112 <thomas91112@
>
> Have an SMF Excel spreadsheet with GetYahooQuotes that I would like to go with real-time quotes. Â Signed up for Yahoo Finance Market Tracker service (real-time quote product) but they don't say how to link it to an Excel file and SMF. Â Given your familiarity with Yahoo Finance and SMF, how do I go about making the link?
>
Mon Aug 13, 2012 7:48 pm (PDT) . Posted by:
"hbeetroot" hbeetroot
Does it match up if you use EBIT*(1-tax rate) in the numerator instead of net income?
If you are trying to calculate return on invested capital, this is the return available to all sources of capital (debt + equity) so the numerator should be BEFORE interest expense - may be why you are getting values that are lower than the reported numbers.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> How could you NOT change the formula? For the quarterly, you need to
> accumulate quarterly data (or adjust for year-to-date reported number) to
> come up with a match.
>
> I would suggest picking a fiscal year-end, then seeing how the numbers flow
> to it from the quarterly values. That should tell you how your quarterly
> formula has to change to match the annual. After all, the quarterly and
> annual should match for the same year-end fiscal period, right?
>
> On Mon, Aug 6, 2012 at 10:58 PM, highflight1985 <highflight1985@...>wrote:
>
> >
> > Why the disconnect? Why is it spot on for annual reports but so far off on
> > the quarterly reports when the formula isn't changed?
> >
>
If you are trying to calculate return on invested capital, this is the return available to all sources of capital (debt + equity) so the numerator should be BEFORE interest expense - may be why you are getting values that are lower than the reported numbers.
--- In smf_addin@yahoogrou
>
> How could you NOT change the formula? For the quarterly, you need to
> accumulate quarterly data (or adjust for year-to-date reported number) to
> come up with a match.
>
> I would suggest picking a fiscal year-end, then seeing how the numbers flow
> to it from the quarterly values. That should tell you how your quarterly
> formula has to change to match the annual. After all, the quarterly and
> annual should match for the same year-end fiscal period, right?
>
> On Mon, Aug 6, 2012 at 10:58 PM, highflight1985 <highflight1985@
>
> >
> > Why the disconnect? Why is it spot on for annual reports but so far off on
> > the quarterly reports when the formula isn't changed?
> >
>
Tue Aug 14, 2012 1:43 am (PDT) . Posted by:
"ufdn16" ufdn16
Tried using RCHgetelementnumber 995. Results in error.
Tried ctrl-alt-F9 to force recalculation.
I still don't have my holdings dividend yield.
Please help. David
Tried ctrl-alt-F9 to force recalculation.
I still don't have my holdings dividend yield.
Please help. David
Tidak ada komentar:
Posting Komentar