Health Check For Your Holdings - Fri Oct 02, 2015 2:09 am
Dileepa wrote:This is a simple tool to check the fundamental value of your counters.
This will fetch data from Financial Times(need internet access) and
rank the counters based on several parameters and CSE norms.
Download the tool here:
http://www.mediafire.com/view/utfewtjjpv608j2/HealthCheck_3_0_0.xlsm
1. Select the counter in C2 (Yellow cell)
2. Click on "Fetch Financials"
Originally this was developed to keep me away from troubles.
Although I'm still testing the ranking parameters,
easy access to important data will be helpful to many.
#I usually pick counters which score over 60 and avoid which are bellow 40.
This may not work on some counters.
Let me know if you have difficulties getting it to work.
Cheers..
Great work mr.dileepa
i followed macro class but couldnt understand the coding etc...
can you pleas explain for what we can use these data (which are shown in the excel sheet)
for an example, RATING say 45 for company BLI. what does that mean? and also are alll the financial fetched informations upto date??
please explain your KPIs which is mentioned in your exel & also how we can use these data for decision making??
PLEASE EXPLAIN SIR!! EAGERLY WAITING TO LEARN!!