3 New Messages
Digest #2793
Messages
Mon Sep 30, 2013 10:28 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
So who would maintain this DB? It would need constant updating if it is to be accurate. Who would decide with elements you want to keep updated?
I think I'll stick with the SMF-Addin and pull the data when I need it. But then I am not that much of a fundamentalist.
Good luck,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of scasty@gmail.com
Sent: Sunday, September 29, 2013 1:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] this lack of useful financial data is silly
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.
I think I'll stick with the SMF-Addin and pull the data when I need it. But then I am not that much of a fundamentalist.
Good luck,
Kermit
From: smf_addin@yahoogrou
Sent: Sunday, September 29, 2013 1:32 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] this lack of useful financial data is silly
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'
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.
Mon Sep 30, 2013 12:02 pm (PDT) . Posted by:
petekoch
I have uploaded a fresh copy of Altman_Piotroski.xlsx to the
files area.
I chose to use Morningstar as the data source via the
smfGetCSVFile function. While I attempted to duplicate the
previous version of this workbook, I don't completely trust the
Z-Scores, but then I never really used them; I created the sheet
in the first place largely for the Piotroski numbers, since I
felt that the sites which provide them give scores which are
generally too high.
Please note that the metrics Morningstar generates move around,
i.e., one cannot trust that a particular metric will be in a
specific row in an array. I overcame that (I think) with the
additional cells at the top of the 'MStar' tab. These cells
search the arrays for the metrics desired.
files area.
I chose to use Morningstar as the data source via the
smfGetCSVFile function. While I attempted to duplicate the
previous version of this workbook, I don't completely trust the
Z-Scores, but then I never really used them; I created the sheet
in the first place largely for the Piotroski numbers, since I
felt that the sites which provide them give scores which are
generally too high.
Please note that the metrics Morningstar generates move around,
i.e., one cannot trust that a particular metric will be in a
specific row in an array. I overcame that (I think) with the
additional cells at the top of the 'MStar&#
search the arrays for the metrics desired.
Mon Sep 30, 2013 3:35 pm (PDT) . Posted by:
petekoch
BTW, since this sheet does NOT use 10-year financial data, it
works just fine without having to login to Morningstar, i.e.,
there is no requirement for a Morningstar subscription.
---In smf_addin@yahoogrou
I have uploaded a fresh copy of Altman_Piotroski.
files area.
I chose to use Morningstar as the data source via the
smfGetCSVFile function. While I attempted to duplicate the
previous version of this workbook, I don't completely trust the
Z-Scores, but then I never really used them; I created the sheet
in the first place largely for the Piotroski numbers, since I
felt that the sites which provide them give scores which are
generally too high.
Please note that the metrics Morningstar generates move around,
i.e., one cannot trust that a particular metric will be in a
specific row in an array. I overcame that (I think) with the
additional cells at the top of the 'MStar&#
search the arrays for the metrics desired.
Tidak ada komentar:
Posting Komentar