(18-09-2013, 07:03 PM)zf87 Wrote: But my question is where to get a reliable data source for those 10000 Asian stocks? Do you guys have any idea if there is any free or cheap FA data source available to retail investors? Currently, I have collected a list of around 100 stocks mentioned in various forums, and I enter the financial data into an excel file myself, then I rank the list by so-called "quant model". But the data-entering process is tedious, no need to mention that one has to update the table quite often.
I have been trying to look for the same but without much success. However, I use POEMS 2.0 and you might find it useful for a quick and dirty to do it for all SGX's listed companies. But instead of financial statements, it summarised the financial statements into ratios.
The information can be exported to Excel en masse and hence save one the trouble to collate information from various companies.
Steps:
1. Go to <<Fundamentals >> tab within POEMS 2.0
2. Click on <<Reset>> button to ensure all SGX listed companies are selected. Alternatively, you may want use some of the filters within the filter criteria to reduce the return result.
3. Click on <<Search>> button. This will return a list of companies based on your filter criteria.
4. Click on <<Export to Excel>> button and the list of companies together with the financial info/ratios below are exported to Excel. You can then build your score cards within Excel based on the information.
According to POEMS, the financial results are provided by Thomson Reuters, hence the result should be relatively reliable.
The available financial ratios / data are:
1. Last Close Price
2. Market Cap
3. ROE
4. ROA
5. Operating Margin
6. Revenue Growth
7. EPS Growth
8. Dividend Yield
9. P/E
10. P/BV
11. Current Ratio
12. Debt/Equity %
Hope this helps.