Thursday, August 04, 2016

How much does international business payments cost?

With the help of a research agency, TransferWise called up the high-street banks in the UK to see what sending £2000 to Germany, the US and India would cost for businesses. Turns out, it’s a lot, but they won’t tell you if you don’t ask.

Exposed: the hidden cost of transfering £2,000 to euros

The up-front fees charged by banks varies between £9 and £25. Santander is the most expensive, and Natwest is the cheapest. But that's not all, the banks all added a mark-up to the exchange rate. The worst one is again Santander, who added on 3.47% in the exchange rate.

It doesn’t end here however. We also investigated how much the recipient pays on the other end. Commerzbank in Germany took £14 and Bank of America took £24. Only in India were there no receiving fees.

Sending bank fees for £2000 to EUR


Name of bank
% exchange rate mark-up
International transfer fee
Exchange rate mark-up in £
Total sending fees
Barclays
2.02
£25.00
£40.39
£65.39
HSBC
2.07
£9.00
£41.45
£50.45
Lloyds
2.45
£15.00
£48.99
£63.99
Natwest
1.73
£12.00
£34.66
£46.66
RBS
2.29
£12.00
£45.72
£57.72
Santander
3.47
£25.00
£69.36
£94.36
Read the research here.

Sunday, May 15, 2016

The relationship between daily and weekly search volume from Google Trends

If you're familiar with Google Trends, you know that they provide data on a daily, weekly or monthly frequency. Google Trends only provide daily data for 90 days at a time, so sometimes we want to compare weekly and daily data. But how can we compare the daily and weekly search volume?

Google doesn't make any information about this available to the public, so I set out to find out through trial and error.

The graphs below show the daily search volume, weekly search volume, and the average daily search volume by week. Most of the time, the average daily SVI and the weekly SVI move in tandem. They have different values however, which is something we would have to keep in mind when combining several daily series into more than 90 days.

Also, at the end of the time period, where we have an incomplete week, the average daily and the weekly SVI differ.




Saturday, May 07, 2016

Google Trends bulk download service

The Google trends bulk download service is live. It allows you to specify an unlimited number of keywords, your desired date range, data frequency (daily, weekly or monthly) and if you need the search terms to be comparable in terms of search volume.

You create a request to the service by filling out this form. The service returns the raw files, along with the database ready tables containing historical search volumes for each search term, geographical data and related-searches data.

The Google trends bulk download service is a convenient way to access Google Trends for academic research, market analysis and competitor insight.

Leave a comment here to suggest further improvements.

Monday, April 25, 2016

How do remittance companies stack up against TransferWise on Google Trends?

The numbers from Google Trends below show how various companies focusing on international remittances stack up against TransferWise. TransferWise is the flat line, and the other companies' numbers are in relation to TransferWise's. Companies with a large offline foot print such as Western Union and Moneygram are in the lead world wide. Xoom, a remittance company acquired by PayPal in 2015, also do well.

If we zoom in on the UK, the story changes. While Western Union is still the most Googled brand in the remittance industry, the lead shrinks from 13X to 2.2X over TransferWise. Over time, the declining share of search volume of Western Union becomes quite clear. This might explain part of the reason that they are so eager to build their own online currency transfer platform.

World Wide


TransferWise is flat line.



Companies
Search interest relative to TransferWise
western union
 13.00
moneygram
 4.14
xoom
 1.38
transferwise
 1.00
post office money
 0.47
worldremit
 0.39
ria money transfer
 0.24
azimo
 0.20
transfast
 0.17
moneycorp
 0.17
caxton fx
 0.14
fairfx
 0.14
remitly
 0.12
currencyfair
 0.09
hifx
 0.08
transfergo
 0.06
worldfirst
 0.02
ukforex
 0.01
tawipay
 0.00

United Kingdom



Companies
Search interest relative to TransferWise
western union
 2.19
transferwise
 1.00
post office money
 0.83
moneygram
 0.58
moneycorp
 0.41
fairfx
 0.33
caxton fx
 0.28
azimo
 0.22
worldremit
 0.22
transfergo
 0.13
hifx
 0.09
currencyfair
 0.06
xoom
 0.06
ria money transfer
 0.05
ukforex
 0.04
worldfirst
 0.04
transfast
 0.02
remitly
 0.00
tawipay
0.00


If we look at the market over a longer period of time, the decline of Western Union's share of search volume becomes clear.


Sunday, March 13, 2016

Google Trends bulk download

I put together an API to make it easier for everyone to download data from Google Trends. You can find it here: http://46.101.74.214:8000/getgt.html

Here are a couple of examples of how it can be used:

It generates the download links for Google Trends and to be able to download the files you need to be signed in to Google.

Wednesday, February 24, 2016

How does the payment card ecosystem work?

There are five entities in any card transaction. The cardholder, the merchant, the acquirer, the card scheme and the card issuer. The cardholder is usually a person looking to buy something. The merchant is someone like Booking. The acquirer is a company like Adyen. The card scheme is Visa or MasterCard. The card issuer is a bank, Barclays for instance.

Flow of information


Source

Flow of money
When the payment processor receives the transaction data, they bill the cardholder and deposits the money to the merchant's bank account. The bank account must be a merchant account.

The payment processor

A payment processor, also known as an acquirer, is the one that receives card transaction details (name, card number, expiry date, CCV code). They then pass on the information to the card issuer via the card scheme for authorisation. When you buy something from Booking.com, they pass on your card details to Adyen, that send the information to MasterCard or Visa, that send the information to Barclays. Barclays then authorise the payment, via the card scheme, to Adyen, to Booking.com. 

The main job of the payment processor (besides passing on the information) is to deal with chargebacks and to respond to request for information from the issuer. 

There may also be a payment gateway between the merchant and the payment processor. It is prohibited (at least in the US) to send transaction details directly from a website to a payment processor. The payment gateway acts as a physical payment terminal.


The merchant acquirer

The merchant acquirer recruits the merchant to join the network and provides front-end and back-end services. The merchant acquirer routes the transaction to the payment processor. 

The card issuer

The job of the card issuer (typically a bank) is to issue card, bill the card holder and collect payment.

The card holder

The credit card holder's liability is limited to $50 in the US (regulation Z). Regulation E affords similar limitations on liability to debit cards.

The issuing bank

The issuing bank is responsible for authorisation of the payment. That means checking that the card holder has sufficient credit and carrying out fraud checks. After authorisation comes clearing and settlement. Settlement is the process of clearing the debt incurred by the card holder when the purchase was made. Clearing is a set of transfers that happen after purchase and before settlement. Money usually don't change hands. Instead, lots of transactions are netted. Clearing also includes meeting reporting requirements and the exchange of information this entails. The most common example of clearing is the exchange of transaction information from the merchant to the bank.

What is authorisation?
Authorisation is the process of obtaining permission from the bank that issued the card to accept the card for payment. 

What is clearing and settlement?
Clearing and settlement is the process of sending transactions through the Visa or MasterCard network so that the merchant can be paid for the sale

Sunday, February 21, 2016

What Coen brothers movies are on UK Netflix?

Do you also love the Coen brothers but don't know which of their movies are on Netflix? I've solved the problem for you.

Here's the full list:

Year of release  Title On Netflix UK?
1984
Blood Simple No
1986
Crimewave No
1987
Raising Arizona No
1990
Miller's Crossing Yes
1991
Barton Fink No
1994
The Hudsucker Proxy No
1996
Fargo Yes
1998
The Big Lebowski No
1998
The Naked Man No
2000
O Brother, Where Art Thou? No
2001
The Man Who Wasn't There No
2003
Intolerable Cruelty No
2004
The Ladykillers No
2006
Paris, je t'aime: "Tuileries" segment No
2007
Chacun son cinéma: "World Cinema" segment No
2007
No Country for Old Men Yes
2008
Burn After Reading No
2009
A Serious Man No
2010
True Grit No
2012
Gambit Yes
2013
Inside Llewyn Davis No
2014
Unbroken No
2015
Bridge of Spies No
2016
Hail, Caesar! No


Not a lot by the Coen brothers on Netflix UK unfortunately.

Entertaining Blogs - BlogCatalog Blog Directory
Bloggtoppen.se