Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Value Investing -- Ignore unavailable to you. Want to Upgrade?

To: E_K_S who wrote (58522)	11/20/2016 12:41:12 PM
From: bruwin	Respond to of 78774

Hi E_K_S ... the thing about using the ADVFN database and EXCEL is the fact that ADVFN has an enormous number of Financial Statement items plus many other financial factors and parameters. You can also create many of your own unique spreadsheets. For example, you can create one purely for the Bank Sector with its own set of items you are interested in. Once you have the data that you want in your ADVFN Screen, you can then quickly download it into your own EXCEL Template via a Copy and Paste. EXCEL will then do the calculations to obtain financial ratios, etc, from the ADVFN data. And this is done for all the companies in your screen, not just for one company. As you know, I'm a fan of financial ratios, similar to what Buffett targets, in order to check on the business performance of a company. Therefore by loading the relevant data from ADVFN into EXCEL, one can get the spreadsheet to calculate numerous ratios simultaneously for many companies. One can also get EXCEL to sort them such that one can determine those companies that have the best overall results. So, in essence, it's a case of using the relevant data from ADVFN and then using the "formulation" process from EXCEL to calculate what you may want to have, at the end of the day.