ABCDE
1
2
Foreign transfer rate comparison
3
Compare foreign transfer rates offered by various fintechs. The higher amount received on the other end, the better.
4
Rates vary all the time. Factors include, but not limited to:
5
1.The fintech/company itself
6
2.
Date and time of day, e.g. business hours tend to be cheaper.
7
3.Currency being exchanged
8
4.Promotions
9
5.Global market price
10
Use this sheet everytime you'd like to make a transfer to overseas, to help you decide which service you'd like to opt for.
11
Disclaimer: the sheet owner is not affliated to any listed service here.
12
Credits: https://forum.lowyat.net/topic/4857608
13
14
15
16
How to use this template
17
#ActionStepsReference
18
1.Start your own spreadsheetFile > Make a copy
19
2.Start a new comparison sheetTEMPLATE sheet > New snapshot macro button. Let the script run:
Duplicates and renames the template for a new sheet > Saves the current exchange rate > Move to after Changelog sheet.		Sheet in YYYYMMDD format
20
3.Change sending currencyModify cell A7 to fill in the 3-letter currency code based on ISO 4217 format.https://www.xe.com/iso4217.php
21
4.Change receiving currencyModify cell A11 to fill in the 3-letter currency code based on ISO 4217 format.https://www.xe.com/iso4217.php
22
5.CompareClear and fill each row after "via", at the RECEIVE section, by following the rates offered in their website/app.
23
6.Add new competitorIn the same sheet > Add row macro button. Let the script run:
Add a new row > adjust existing formulas and conditional formattings to take account of the new row.
24
7.Adjust the macrosTools > Script editor. Adjust at your own risk. The macros currently support the format as per TEMPLATE. Additional columns/rows may break them.
25
26
27
28
29