11 New Messages
Digest #2770
Messages
Wed Sep 11, 2013 1:50 pm (PDT) . Posted by:
hamishthedenizen
Gurufocus "bundles" together several items in the current
liabilities section together. The total Current Liabilities
number is correct but the "Other Current Liabilities" is in fact
"Deferred Income" (comparing to the 10-K). The debt number is
correct and "Accounts Payable" would appear to be "all other
current liabilities". Unfortunately I don't see any other data on
the page that would allow you to break out the components of what
is listed as Accounts Payable.
Possible Solution: Use Randy's ready-made spreadsheets that use
Google data. They will give you 4 years of more granular data,
including Accounts Payable.
As for Morningstar, last I remember there was an issue pulling
data from there. If it's been solved, would love to know.
--- In smf_addin@yahoogroups.com, <mike.russo@...> wrote:
Has anyone else noticed that some of the data on Gurufocus
appears to be incorrect? I am specifically talking about
Accounts Payable from the Balance Sheet. For example, INTC's
2012 AP on all other sites is listed as $3023 (in millions) on
Gurufocus it is listed as $7253. Am I missing something? I'm
trying to create a DCF model where changes in working capital is
needed to determine free cash flow so I feel it is pretty
important to have a reliable number. I'm not sure if other data
is off, but AP is. I tried for a few other tickers as well and I
found the same thing.
Also, has anyone created a model to retrieve 5 years worth of
data from Morningstar?
Thanks.
liabilities section together. The total Current Liabilities
number is correct but the "Other Current Liabilities" is in fact
"Deferred Income" (comparing to the 10-K). The debt number is
correct and "Accounts Payable" would appear to be "all other
current liabilities"
the page that would allow you to break out the components of what
is listed as Accounts Payable.
Possible Solution: Use Randy's ready-made spreadsheets that use
Google data. They will give you 4 years of more granular data,
including Accounts Payable.
As for Morningstar, last I remember there was an issue pulling
data from there. If it's been solved, would love to know.
--- In smf_addin@yahoogrou
Has anyone else noticed that some of the data on Gurufocus
appears to be incorrect? I am specifically talking about
Accounts Payable from the Balance Sheet. For example, INTC's
2012 AP on all other sites is listed as $3023 (in millions) on
Gurufocus it is listed as $7253. Am I missing something? I'm
trying to create a DCF model where changes in working capital is
needed to determine free cash flow so I feel it is pretty
important to have a reliable number. I'm not sure if other data
is off, but AP is. I tried for a few other tickers as well and I
found the same thing.
Also, has anyone created a model to retrieve 5 years worth of
data from Morningstar?
Thanks.
Wed Sep 11, 2013 6:03 pm (PDT) . Posted by:
"raiders8112" raiders8112
Thanks for your feed back. I fixed the Morningstar file and have uploaded a new copy called Morningstar Data Model.
Does anyone know how to retrieve quarterly data?
Wed Sep 11, 2013 2:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Take a look at recent messages and you'll see tons of questions about the
problem. AdvFN is updating their web site, and not doing a very good job at
it. It changes every other day or so.
At this point, I'm in standby mode.
On Wed, Sep 11, 2013 at 12:55 PM, <chris.ccmcma@gmail.com> wrote:
>
> Is there a problem with RCH get element number?
>
>
> I am trying to run the 10 year financial data sheet and i am getting
> errors across the board. Wondering if there has been an update since a week
> ago or if anyone else is having the same problem.
>
>
problem. AdvFN is updating their web site, and not doing a very good job at
it. It changes every other day or so.
At this point, I'm in standby mode.
On Wed, Sep 11, 2013 at 12:55 PM, <chris.ccmcma@
>
> Is there a problem with RCH get element number?
>
>
> I am trying to run the 10 year financial data sheet and i am getting
> errors across the board. Wondering if there has been an update since a week
> ago or if anyone else is having the same problem.
>
>
Wed Sep 11, 2013 2:35 pm (PDT) . Posted by:
dmatu2000
I assume this is most likely not the case but I wonder if AdvFn
is attempting to keep groups like this one from using data
without visiting their website.
--- In smf_addin@yahoogrou
Take a look at recent messages and you'll see tons of questions
about the problem. AdvFN is updating their web site, and not
doing a very good job at it. It changes every other day or so.
At this point, I'm in standby mode.
On Wed, Sep 11, 2013 at 12:55 PM, <chris.ccmcma@
<mailto:chris.
Is there a problem with RCH get element number?
I am trying to run the 10 year financial data sheet and i am
getting errors across the board. Wondering if there has been an
update since a week ago or if anyone else is having the same
problem.
Wed Sep 11, 2013 8:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
By creating non-functional web pages, so no one can use them? I doubt it.
On Wed, Sep 11, 2013 at 2:35 PM, <david_matuszak@yahoo.com> wrote:
> I assume this is most likely not the case but I wonder if AdvFn is
> attempting to keep groups like this one from using data without visiting
> their website.
>
On Wed, Sep 11, 2013 at 2:35 PM, <david_matuszak@
> I assume this is most likely not the case but I wonder if AdvFn is
> attempting to keep groups like this one from using data without visiting
> their website.
>
Wed Sep 11, 2013 2:31 pm (PDT) . Posted by:
"Douglas" jurisdoctor74
One quick clarification -- I am only having the problem when using the command within a VBA program. It works normally within a spreadsheet.
Wed Sep 11, 2013 8:02 pm (PDT) . Posted by:
sunnyinca
Hi,
pardon my naivete. I'm new to the forum. I got into a SJ_IBD
thread where it was posted Join this group to get smf_addin excel
plugin from.
I am using windows 7 with office Excel 2010 ..
Can someone please point me to link for downloading smf_addin
excel plugin.
Thanks in advance.
Regards,
Sunny
pardon my naivete. I'm new to the forum. I got into a SJ_IBD
thread where it was posted Join this group to get smf_addin excel
plugin from.
I am using windows 7 with office Excel 2010 ..
Can someone please point me to link for downloading smf_addin
excel plugin.
Thanks in advance.
Regards,
Sunny
Wed Sep 11, 2013 8:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
From the "Welcome to the Group" message you should have received upon
joining the group:
The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation" folder. Sample uses
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions.
On Wed, Sep 11, 2013 at 5:56 PM, <sunnyinca@yahoo.com> wrote:
>
> pardon my naivete. I'm new to the forum. I got into a SJ_IBD thread where
> it was posted Join this group to get smf_addin excel plugin from.
>
> I am using windows 7 with office Excel 2010 ..
>
> Can someone please point me to link for downloading smf_addin excel
> plugin.
> Thanks in advance.
>
joining the group:
The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions.
On Wed, Sep 11, 2013 at 5:56 PM, <sunnyinca@yahoo.
>
> pardon my naivete. I'm new to the forum. I got into a SJ_IBD thread where
> it was posted Join this group to get smf_addin excel plugin from.
>
> I am using windows 7 with office Excel 2010 ..
>
> Can someone please point me to link for downloading smf_addin excel
> plugin.
> Thanks in advance.
>
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/Morningstar Data Model.xlsx
Uploaded by : raiders8112 <mike.russo@comcast.
Description : I did not create the original, but fixed the Cash Flow Statement Error.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
raiders8112 <mike.russo@comcast.
Thu Sep 12, 2013 12:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because Yahoo throws a comma-delimited number in the middle of a
comma-delimited file, the "float shares" data item shouldn't be used --
unless you want to make it your last field, so you know how to construct
it. The RCHGetYahooQuotes() function is little more than a CSV file parser,
so it doesn't know what each field is in each record sent by Yahoo.
On Wed, Sep 11, 2013 at 7:21 AM, Michael Grames <mike@grames.net> wrote:
>
> Float Shares is returning 3 columns, the first value seems correct, but I
> don't know the following two (88 & 0 in my example). I shifted the input
> parameters over one column, so the symbol shows twice. I usually don't
> have the Symbol as one of the inputs, but you didn't either, as you were
> only taking inputs from B2 to R2.
>
comma-delimited file, the "float shares" data item shouldn'
unless you want to make it your last field, so you know how to construct
it. The RCHGetYahooQuotes(
so it doesn't know what each field is in each record sent by Yahoo.
On Wed, Sep 11, 2013 at 7:21 AM, Michael Grames <mike@grames.
>
> Float Shares is returning 3 columns, the first value seems correct, but I
> don't know the following two (88 & 0 in my example). I shifted the input
> parameters over one column, so the symbol shows twice. I usually don't
> have the Symbol as one of the inputs, but you didn't either, as you were
> only taking inputs from B2 to R2.
>
Thu Sep 12, 2013 12:36 am (PDT) . Posted by:
"sri yanto" sri.yanto
hai randy,
=RCHGetYahooQuotes - smoe function didn;'t work properly
i wanna ask, this function, since yesterday, i just realized that some code like "k", "k5", "j", or somethin related o 52 high or low, can return as usual, any idea?
thanks
=RCHGetYahooQuotes - smoe function didn;'t work properly
i wanna ask, this function, since yesterday, i just realized that some code like "k"
thanks
Tidak ada komentar:
Posting Komentar