{"action":"created","issue":{"url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/46","repository_url":"https://api.github.com/repos/ESPD/ESPD-EDM","labels_url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/46/labels{/name}","comments_url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/46/comments","events_url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/46/events","html_url":"https://github.com/ESPD/ESPD-EDM/issues/46","id":186775083,"number":46,"title":"Financial Ratios","user":{"login":"paulakeen","id":16134316,"avatar_url":"https://avatars.githubusercontent.com/u/16134316?v=3","gravatar_id":"","url":"https://api.github.com/users/paulakeen","html_url":"https://github.com/paulakeen","followers_url":"https://api.github.com/users/paulakeen/followers","following_url":"https://api.github.com/users/paulakeen/following{/other_user}","gists_url":"https://api.github.com/users/paulakeen/gists{/gist_id}","starred_url":"https://api.github.com/users/paulakeen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulakeen/subscriptions","organizations_url":"https://api.github.com/users/paulakeen/orgs","repos_url":"https://api.github.com/users/paulakeen/repos","events_url":"https://api.github.com/users/paulakeen/events{/privacy}","received_events_url":"https://api.github.com/users/paulakeen/received_events","type":"User","site_admin":false},"labels":[{"id":400935134,"url":"https://api.github.com/repos/ESPD/ESPD-EDM/labels/enhancement","name":"enhancement","color":"84b6eb","default":true},{"id":400935135,"url":"https://api.github.com/repos/ESPD/ESPD-EDM/labels/help%20wanted","name":"help wanted","color":"128A0C","default":true},{"id":400935137,"url":"https://api.github.com/repos/ESPD/ESPD-EDM/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/ESPD/ESPD-EDM/milestones/1","html_url":"https://github.com/ESPD/ESPD-EDM/milestones/v1.1","labels_url":"https://api.github.com/repos/ESPD/ESPD-EDM/milestones/1/labels","id":1857343,"number":1,"title":"v1.1","description":null,"creator":{"login":"ESPD","id":19166189,"avatar_url":"https://avatars.githubusercontent.com/u/19166189?v=3","gravatar_id":"","url":"https://api.github.com/users/ESPD","html_url":"https://github.com/ESPD","followers_url":"https://api.github.com/users/ESPD/followers","following_url":"https://api.github.com/users/ESPD/following{/other_user}","gists_url":"https://api.github.com/users/ESPD/gists{/gist_id}","starred_url":"https://api.github.com/users/ESPD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ESPD/subscriptions","organizations_url":"https://api.github.com/users/ESPD/orgs","repos_url":"https://api.github.com/users/ESPD/repos","events_url":"https://api.github.com/users/ESPD/events{/privacy}","received_events_url":"https://api.github.com/users/ESPD/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":0,"state":"open","created_at":"2016-06-30T13:09:02Z","updated_at":"2016-11-15T08:57:41Z","due_on":null,"closed_at":null},"comments":18,"created_at":"2016-11-02T11:24:39Z","updated_at":"2016-11-16T15:08:21Z","closed_at":null,"body":"## **About financial ratios:**\r\n\r\nThere would be the need of modifying the current model 1.0.2 to enhance the current structure for RATIOS. Below some considerations about how to approach according to ES:\r\n\r\nevery MS and public administration has its own practice; i.e. different schools for the same type of ratio, therefore it is not easy to come up with a clear and objective nomenclature different countries may interpret the same ratio in different ways. However, in the end, the ratio is **adimensional,** meaning there isn’t any unit measure associated to it. Possible solutions could be:\r\n\r\n1. **XBRL approach**: a ratio is represented as a numerator divided by a denominator in a structured and machine-oriented way. The most complex case could be that the numerator and/or the denominator are the result of a complex addition (or formula);\r\n2. **Codified ratios**: Use some of the ratios defined by the European Banks (see for instance the BACH system supported by 11 European Central Banks at [).](https://www.bach.banque-france.fr/) This would take advantage of the support that the main countries already using them could provide. Also, these countries have databases with temporal values, percentiles, etc. The solution would consist in using the exact terminology and values used by these banks. This database is currently managed (kept) by the Bank of France;\r\n3. **Self-maintenance of the ratio taxonomy**: Alternatively, if any of the two previous options were appropriate, the Contracting Authority would define its own taxonomy with different codes per ratio. In this case the CA could chose the type of ratio applicable to the specific sector the CA is interested in.\r\n\r\nAmongst the three options the second one is probably the simplest as it would take advantage of a well-proven (and free) system managed by trusted European institutions with a large experience in financial subjects.\r\n\r\nAs pointed above, the ratios are **adimensionals**, as they are the quocient between two amounts expressed in one single unit (the currency), but must be referred to a well defined temporal context (a period, with a start and end dates; or a specific point in time, e.g. a date). In general the temporal context will be a specific date, although for some ratios both the numerator and the denominator are \"varying flows\" (e.g. \"profit margin\"), in which case the temporal context is the period (generally an annual period, not necesarily the \"natural\" year) through which numerator and denominator have been measured (\"net income\" and \"sales\", for example).\r\n\r\nFrom the technical perspective, none of the above cases would impact on the the XSD Schema; the impacts would be on (i) the XML instantiation; the GUIs, (ii) the business rules currently expressed in Schematron.\r\n\r\n**Proposed milestone:  v1.1.0**\r\n\r\nThe figure below would illustrate a data-structure that would cover any of these possibilities. Ideally if the RatioType code is used the Numerator and Denominator values should not be used (and vice-versa). This would be controlled via Schematron. However one could also consider that Numerator, Denominator and RatioType could **simultaneously** be specified; the con: possible inconsistencies wouldn't be so easy to validate. Let's recall you that if the RatioType is used, the code issuer agency should be specified (compulsorily) amongst the code attributes (so to identify XBRL, European Banks, the CA, other).\r\n\r\n**This proposal will have to be readjusted to match the final decisions on the above three possibilities.** \r\n\r\n![eds-financialratio](https://cloud.githubusercontent.com/assets/16134316/19927535/5cdd6186-a0fa-11e6-97fb-9629b42518b7.png)\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/comments/260968993","html_url":"https://github.com/ESPD/ESPD-EDM/issues/46#issuecomment-260968993","issue_url":"https://api.github.com/repos/ESPD/ESPD-EDM/issues/46","id":260968993,"user":{"login":"rantati7","id":20238848,"avatar_url":"https://avatars.githubusercontent.com/u/20238848?v=3","gravatar_id":"","url":"https://api.github.com/users/rantati7","html_url":"https://github.com/rantati7","followers_url":"https://api.github.com/users/rantati7/followers","following_url":"https://api.github.com/users/rantati7/following{/other_user}","gists_url":"https://api.github.com/users/rantati7/gists{/gist_id}","starred_url":"https://api.github.com/users/rantati7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rantati7/subscriptions","organizations_url":"https://api.github.com/users/rantati7/orgs","repos_url":"https://api.github.com/users/rantati7/repos","events_url":"https://api.github.com/users/rantati7/events{/privacy}","received_events_url":"https://api.github.com/users/rantati7/received_events","type":"User","site_admin":false},"created_at":"2016-11-16T15:08:21Z","updated_at":"2016-11-16T15:08:21Z","body":"2.\tCA defines three ratios: Current ratio, Quick ratio and Net Gearing and minimum or maximum passable values for each (>1,5; > 1 and <100%, subsequently)\r\n\r\n![2](https://cloud.githubusercontent.com/assets/20238848/20352252/44bcfcda-ac1f-11e6-8715-9ece3aab793a.jpg)\r\n![Uploading 2.jpg…]()\r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"rantati7"}}