7 New Messages
Digest #2792
Messages
Sun Sep 29, 2013 8:57 am (PDT) . Posted by:
weekeewawa
hi randy, seems to be still down this weekend.
you are probably right
---In smf_addin@yahoogrou
Yeah. That web page no longer exists.
I'm getting a lot of missing pages from their web site right now.
Probably a temporary glitch.
On Sat, Sep 28, 2013 at 10:15 AM, <weekeewawa@
<mailto:weekeewa
=RCHGetTableCell(
ome-statement
<http://quotes.
",3,"
the error message is #VALUE# which it cant extract the info
when i visit wall street journal to manually extract the data,
the website gives me this error
HTTP Status 404 - /jsp/utils/page_
type Status report
message /jsp/utils/page_
description The requested resource (/jsp/utils/
not available.
Apache Tomcat/5.5.20
Sun Sep 29, 2013 9:18 am (PDT) . Posted by:
"Jacob Jose" pepecan47
When using the template with symbol MCD, the earnings per share are not corresponding to the dates. One of the two are in reverse order.
Regards,
Jose L. Jacob
Regards,
Jose L. Jacob
Sun Sep 29, 2013 11:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like MSN reversed the order of some of the 10-year tables. So the
dates are now in the wrong sort order for some items. *sigh*
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> When using the template with symbol MCD, the earnings per share are not
> corresponding to the dates. One of the two are in reverse order.
>
>
dates are now in the wrong sort order for some items. *sigh*
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.
>
> When using the template with symbol MCD, the earnings per share are not
> corresponding to the dates. One of the two are in reverse order.
>
>
Sun Sep 29, 2013 12:47 pm (PDT) . Posted by:
"Jacob Jose" pepecan47
Hi Randy - will a modification to the smf-elements-1.txt file fix it?
I know that you have a lot of things on your plate, just asking: you were trying to do something with Morningstar, trying to get data from the source from where the dynamic pages access the info. Do you have something?
Thanks a lot.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, September 29, 2013 2:46:05 PM
Subject: Re: [smf_addin] SMF-Template-MSN-10-Year-Summaries.xls
It looks like MSN reversed the order of some of the 10-year tables. So the dates are now in the wrong sort order for some items. *sigh*
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>When using the template with symbol MCD, the earnings per share are not corresponding to the dates. One of the two are in reverse order.
I know that you have a lot of things on your plate, just asking: you were trying to do something with Morningstar, trying to get data from the source from where the dynamic pages access the info. Do you have something?
Thanks a lot.
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, September 29, 2013 2:46:05 PM
Subject: Re: [smf_addin] SMF-Template-
It looks like MSN reversed the order of some of the 10-year tables. So the dates are now in the wrong sort order for some items. *sigh*
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.
>
>When using the template with symbol MCD, the earnings per share are not corresponding to the dates. One of the two are in reverse order.
Sun Sep 29, 2013 12:58 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. For a number of elements, I'll just have to reverse the order the
elements are retrieved in. So, instead of going from row 1 to row 10,
they'll need to go from row 10 to row 1.
The template for MorningStar is mostly documentation at this point.
However, I was unhappy to see that some of the web pages that used to exist
no longer exist. Which implies MorningStar is still making changes...
*sigh* *again*
It's too bad some web service hasn't been created to make all of this easy.
I mean, they've got to know that a web page full of numbers is pretty
useless to any analysis.
If only I were younger and had plenty of spare time. :)
On Sun, Sep 29, 2013 at 12:44 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Hi Randy - will a modification to the smf-elements-1.txt file fix it?
>
> I know that you have a lot of things on your plate, just asking: you were
> trying to do something with Morningstar, trying to get data from the source
> from where the dynamic pages access the info. Do you have something?
>
>
elements are retrieved in. So, instead of going from row 1 to row 10,
they'll need to go from row 10 to row 1.
The template for MorningStar is mostly documentation at this point.
However, I was unhappy to see that some of the web pages that used to exist
no longer exist. Which implies MorningStar is still making changes...
*sigh* *again*
It's too bad some web service hasn't been created to make all of this easy.
I mean, they've got to know that a web page full of numbers is pretty
useless to any analysis.
If only I were younger and had plenty of spare time. :)
On Sun, Sep 29, 2013 at 12:44 PM, Jacob Jose <pepecan47@yahoo.
>
> Hi Randy - will a modification to the smf-elements-
>
> I know that you have a lot of things on your plate, just asking: you were
> trying to do something with Morningstar, trying to get data from the source
> from where the dynamic pages access the info. Do you have something?
>
>
Sun Sep 29, 2013 5:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I changed elements #253-#352, on smf-elements-1.txt, because MSN changed
the sort order on a few of the 10-year summary tables.
I just uploaded that new file to the "Works in Progress" folder in the
FILES area of the group.
Either exit EXCEL before replacing the file, or run the
smfForceRecalculation macro after replacing the file, to force the add-in
to load the new definitions.
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> When using the template with symbol MCD, the earnings per share are not
> corresponding to the dates. One of the two are in reverse order.
>
the sort order on a few of the 10-year summary tables.
I just uploaded that new file to the "Works in Progress" folder in the
FILES area of the group.
Either exit EXCEL before replacing the file, or run the
smfForceRecalculati
to load the new definitions.
On Sun, Sep 29, 2013 at 9:18 AM, Jacob Jose <pepecan47@yahoo.
>
> When using the template with symbol MCD, the earnings per share are not
> corresponding to the dates. One of the two are in reverse order.
>
Sun Sep 29, 2013 10:31 am (PDT) . Posted by:
fincoolio
I propose we create an opensource database for every public
company on a major U.S. stock exchange with a market cap above
$100m.
This is about 3000 stocks and ADRs. We can start with the highest
market cap and work our way down to the bottom.
First we need to create a database template -- so we are all
using the same financial definitions for EBITDA, EBT, etc. This
template needs to be automatically updated with XBRL data and
adjusted manually by people that know what they are doing.
I am not a database expert but this shouldn't be too hard. Just
piggy back on whatever XBRL.org is doing and have 1- to a few
people be in charge of updating and error checking data of a
particular stock. Compile all the data to a single open source
point -- like a wikipedia of financial data.
I don't imagine we are going to get 3000+ people right off the
bat to sponsor the data integrity of 3000+ stocks and ADRs, but
we should start somewhere.
company on a major U.S. stock exchange with a market cap above
$100m.
This is about 3000 stocks and ADRs. We can start with the highest
market cap and work our way down to the bottom.
First we need to create a database template -- so we are all
using the same financial definitions for EBITDA, EBT, etc. This
template needs to be automatically updated with XBRL data and
adjusted manually by people that know what they are doing.
I am not a database expert but this shouldn'
piggy back on whatever XBRL.org is doing and have 1- to a few
people be in charge of updating and error checking data of a
particular stock. Compile all the data to a single open source
point -- like a wikipedia of financial data.
I don't imagine we are going to get 3000+ people right off the
bat to sponsor the data integrity of 3000+ stocks and ADRs, but
we should start somewhere.
Tidak ada komentar:
Posting Komentar