Skip to content

Instantly share code, notes, and snippets.

@Potherca
Last active September 11, 2022 13:31
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save Potherca/c94b43f2d5ef49deb5abcf59b83301e8 to your computer and use it in GitHub Desktop.
Save Potherca/c94b43f2d5ef49deb5abcf59b83301e8 to your computer and use it in GitHub Desktop.
Dutch Fair Finance Guide Scores (eerlijkegeldwijzer.nl) - Total scores

Introduction

Fair Finance Guide International (FFGI) is an international civil society network initiated by Oxfam, that seeks to strengthen the commitment of banks and other financial institutions to social, environmental and human rights standards.

Every year, the FFGI publishes records of how financial institutions perform on a set of subjects.

For the Netherlands these results are published at https://eerlijkegeldwijzer.nl/

In the past, the website showed the scores for each company per subject but did not show a total. Javascript logic was used to calculate these scores.

Since 20222, an overview of total scores is shown, so javascript is only used to gather the totals.

The result of each year can be seen in a separate file (eerlijkegeldwijzer-scores-20XX.md files).

The only difference with past scores is that the newer score is in percentages, rather than a grade.

Since both scores are on a similar scale (0.0 to 100.0 percent or 0.00 to 10.00 points) the year-to-year overview can still be used.

Last updated: September 2022 (scores are from various measurements, up until 2022)

/*Updated for 2022*/
const elements = document.querySelectorAll('#scores .score-row .percentage-text')
let total = 0
elements.forEach(e => {
total += parseInt(e.innerText)
})
console.log(total / elements.length / 10)
/*EOF*/
/*Updated for 2019*/
console.clear();
var iCount, iCounter, iRows, iTotal, sBank, sResult, aScores = [];
/* Calculate scores */
iCount = $('table.scores-container thead td').length;
for (iCounter = 1; iCounter <= iCount; iCounter++) {
sBank = '';
iTotal = 0;
iRows = 0;
$('table td:nth-of-type(' + iCounter + ')').each(function (i, o) {
var iScore, sScore;
if ($(o).find('span').attr('class')) {
sScore = $(o).find('span').attr('class').substr(6, 2);
iScore = parseInt(sScore);
if (isNaN(iScore) === false && iScore > 0) {
iTotal += iScore;
iRows++;
}
} else {
sBank = $(o).find('[data-bind="text: name"]').text().trim();
}
});
aScores.push({
name: sBank,
score: (iTotal / iRows).toFixed(2)
});
}
/* Sort by score */
aScores.sort(function (a, b) {
return b.score - a.score;
});
/* Create output */
sResult = '';
iCounter = 0;
aScores.forEach(function (p_oScore) {
sResult += (++iCounter) + '. ' + p_oScore.name + ': ' + p_oScore.score + "\n";
});
console.log(sResult);
/*EOF*/

Summary/Total scores of banks and insurance companies for the year 2017 as measured by https://eerlijkegeldwijzer.nl/

Banks

  1. Triodos Bank: 8.50
  2. ASN Bank: 8.00
  3. SNS: 7.62
  4. ABN Amro: 5.90
  5. NIBC: 5.90
  6. Van Lanschot: 5.86
  7. Rabobank: 5.67
  8. ING Bank: 5.00

Insurance companies

  1. ASR: 7.19
  2. Achmea: 6.38
  3. Vivat: 6.33
  4. Delta Lloyd: 5.05
  5. APG: 2.76
  6. NN Group: 2.71
  7. Aegon: 2.14
  8. Allianz: 2.14
  9. Legal en General: 1.48
  10. Generali: 1.38

Summary/Total scores of banks, insurance companies and pension funds for the year 2019 as measured by https://eerlijkegeldwijzer.nl/

Banks

  1. De Volksbank: 8.73
  2. Triodos Bank: 8.47
  3. NIBC: 6.40
  4. Rabobank: 5.93
  5. Van Lanschot: 5.47
  6. ABN Amro: 5.33
  7. ING Bank: 5.07

Insurance companies

  1. ASR: 8.00
  2. Vivat: 7.38
  3. Achmea: 6.95
  4. NN Group: 3.38
  5. Allianz: 2.43
  6. Aegon: 2.14
  7. VGZ: 2.14
  8. Menzis: 1.90
  9. CZ: 1.76

Pension funds

  1. PME: 2.80
  2. PF Zorg en Welzijn: 2.67
  3. PMT: 2.47
  4. BPL Pensioen: 2.20
  5. ABP: 2.13
  6. BPF Bouw: 2.00
  7. PF Detailhandel: 1.93
  8. PF Vervoer: 1.79
  9. StiPP: 1.73
  10. PF Horeca en Catering: 1.53

Summary/Total scores of banks, insurance companies and pension funds for the year 2020 as measured by https://eerlijkegeldwijzer.nl/

Banks

  1. De Volksbank (ASN, SNS, RegioBank): 9.27
  2. Triodos Bank: 8.27
  3. Bunq: 7.80
  4. NIBC: 6.67
  5. ABN Amro: 6.53
  6. Rabobank: 6.00
  7. Van Lanschot: 5.73
  8. ING Bank: 5.40

Insurance companies

  1. ASR: 8.29
  2. Vivat: 8.05
  3. Achmea: 7.14
  4. NN Group: 5.33
  5. Allianz: 3.14
  6. Aegon: 2.67
  7. VGZ: 2.57
  8. Menzis: 1.95
  9. CZ: 1.86

Pension funds

  1. PMT: 3.73
  2. ABP: 3.33
  3. PF Zorg en Welzijn: 3.13
  4. PME: 3.13
  5. BPL Pensioen: 2.87
  6. PF Horeca en Catering: 2.60
  7. BPF Bouw: 2.53
  8. PF Detailhandel: 2.20
  9. StiPP: 2.13
  10. PF Vervoer: 1.87

Summary/Total scores of banks, insurance companies and pension funds for the year 2022 as measured by https://eerlijkegeldwijzer.nl/

Banks

  1. De Volksbank ( ASN, SNS , RegioBank): 93%
  2. Triodos Bank: 83%
  3. Bunq: 78%
  4. NIBC: 66%
  5. ABN Amro: 66%
  6. Rabobank: 61%
  7. Van Lanschot: 57%
  8. ING Bank: 54%

Insurance companies

  1. ASR: 89%
  2. VGZ: 78%
  3. Achmea: 74%
  4. CZ: 59%
  5. NN Group: 55%
  6. Menzis: 54%
  7. Klaverblad: 54%
  8. Zorg en Zekerheid: 44%
  9. De Goudse: 43%
  10. Unive: 39%
  11. Aegon: 36%
  12. Allianz: 32%
  13. Unigarant: 31%
  14. ZLM: 29%
  15. ONVZ: 29%
  16. DSW: 26%

Pension funds

  1. ABP: 4.29
  2. PME: 4.29
  3. PMT: 4.07
  4. PF Detailhandel: 3.86
  5. PF Horeca en Catering: 3.79
  6. PF Zorg en Welzijn: 3.79
  7. BPL Pensioen: 3.57
  8. PF Vervoer: 3.50
  9. BPF Bouw: 3.21
  10. StiPP: 2.29
/*Updated for 2022*/
let sResult = '';
Array.from(document.querySelector('.average-scores').children).forEach(function (element, counter) {
sResult += `${counter + 1}. ${element.querySelector('img').alt}: ${element.querySelector('.percentage-text').innerText} \n`;
});
console.log(sResult);
/*EOF*/
Display the source blob
Display the rendered blob
Raw
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment