11.1 Background & Context

Alteryx Essentials Workshop 3 - Cryptocurrency Arbitrage
4 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€46.40
List Price:  €64.96
You save:  €18.56
£39.83
List Price:  £55.77
You save:  £15.93
CA$68.34
List Price:  CA$95.68
You save:  CA$27.34
A$75.73
List Price:  A$106.02
You save:  A$30.29
S$67.43
List Price:  S$94.41
You save:  S$26.98
HK$390.55
List Price:  HK$546.80
You save:  HK$156.25
CHF 45.24
List Price:  CHF 63.34
You save:  CHF 18.10
NOK kr543.62
List Price:  NOK kr761.11
You save:  NOK kr217.49
DKK kr346.42
List Price:  DKK kr485.02
You save:  DKK kr138.59
NZ$83.15
List Price:  NZ$116.42
You save:  NZ$33.26
د.إ183.60
List Price:  د.إ257.06
You save:  د.إ73.45
৳5,471.12
List Price:  ৳7,660.01
You save:  ৳2,188.88
₹4,168.17
List Price:  ₹5,835.78
You save:  ₹1,667.60
RM236.95
List Price:  RM331.75
You save:  RM94.80
₦61,737.65
List Price:  ₦86,437.65
You save:  ₦24,700
₨13,868
List Price:  ₨19,416.31
You save:  ₨5,548.31
฿1,837.56
List Price:  ฿2,572.74
You save:  ฿735.17
₺1,617.36
List Price:  ₺2,264.43
You save:  ₺647.07
B$254.77
List Price:  B$356.70
You save:  B$101.93
R925.26
List Price:  R1,295.44
You save:  R370.18
Лв90.75
List Price:  Лв127.05
You save:  Лв36.30
₩67,788.68
List Price:  ₩94,909.58
You save:  ₩27,120.90
₪185.35
List Price:  ₪259.50
You save:  ₪74.15
₱2,852.60
List Price:  ₱3,993.87
You save:  ₱1,141.27
¥7,651.21
List Price:  ¥10,712.31
You save:  ¥3,061.10
MX$848.45
List Price:  MX$1,187.89
You save:  MX$339.44
QR181.83
List Price:  QR254.57
You save:  QR72.74
P679.12
List Price:  P950.82
You save:  P271.70
KSh6,605.16
List Price:  KSh9,247.76
You save:  KSh2,642.59
E£2,394.23
List Price:  E£3,352.12
You save:  E£957.88
ብር2,861.57
List Price:  ብር4,006.43
You save:  ብር1,144.85
Kz41,791.64
List Price:  Kz58,511.64
You save:  Kz16,720
CLP$47,104.79
List Price:  CLP$65,950.47
You save:  CLP$18,845.68
CN¥361.78
List Price:  CN¥506.53
You save:  CN¥144.74
RD$2,896.80
List Price:  RD$4,055.76
You save:  RD$1,158.95
DA6,728.30
List Price:  DA9,420.16
You save:  DA2,691.86
FJ$112.64
List Price:  FJ$157.70
You save:  FJ$45.06
Q387.49
List Price:  Q542.52
You save:  Q155.02
GY$10,429.06
List Price:  GY$14,601.52
You save:  GY$4,172.46
ISK kr6,974.05
List Price:  ISK kr9,764.23
You save:  ISK kr2,790.17
DH502.81
List Price:  DH703.98
You save:  DH201.16
L883.05
List Price:  L1,236.34
You save:  L353.29
ден2,855.97
List Price:  ден3,998.59
You save:  ден1,142.61
MOP$401.24
List Price:  MOP$561.77
You save:  MOP$160.53
N$922.79
List Price:  N$1,291.99
You save:  N$369.19
C$1,835.15
List Price:  C$2,569.36
You save:  C$734.20
रु6,656.11
List Price:  रु9,319.09
You save:  रु2,662.97
S/186.09
List Price:  S/260.54
You save:  S/74.45
K192.70
List Price:  K269.79
You save:  K77.09
SAR187.49
List Price:  SAR262.50
You save:  SAR75.01
ZK1,344.69
List Price:  ZK1,882.68
You save:  ZK537.98
L230.99
List Price:  L323.40
You save:  L92.41
Kč1,163.34
List Price:  Kč1,628.77
You save:  Kč465.43
Ft18,074.53
List Price:  Ft25,305.79
You save:  Ft7,231.25
SEK kr539.27
List Price:  SEK kr755.02
You save:  SEK kr215.75
ARS$43,903.33
List Price:  ARS$61,468.17
You save:  ARS$17,564.84
Bs345.22
List Price:  Bs483.33
You save:  Bs138.11
COP$194,164.52
List Price:  COP$271,845.87
You save:  COP$77,681.34
₡25,478.72
List Price:  ₡35,672.25
You save:  ₡10,193.53
L1,231.47
List Price:  L1,724.16
You save:  L492.69
₲373,200.63
List Price:  ₲522,510.75
You save:  ₲149,310.11
$U1,910.59
List Price:  $U2,674.97
You save:  $U764.38
zł200.97
List Price:  zł281.37
You save:  zł80.40
Already have an account? Log In

Transcript

So before we select our exchanges and currencies, I want to explain some of the jargon I'll be using as it can get pretty confusing. In order to download coin information, we're going to be using an API call, which stands for application programming interface, which means a particular website or company is providing us access to specific features or functions within their application, instead of giving us access to the whole application itself. In this example, an exchange is providing us their price information without giving us access to the exchange as a whole. To bring this to life, let's take the by Nance API URL and look up the price of bitcoin against the US dollar. The buy Nance exchange has provided us the bid and ask price with all these curly braces and quotes which is actually a format called JSON or JavaScript Object Notation, which is another way of structuring gotta think of JSON as an alternative to XML.

What we want out of this JSON is the bid and ask price. With bid, as the name suggests, and what you would normally do at an auction, you're submitting a bid to buy bitcoin at $3,783. With an ask if you already hold Bitcoin or something else you want to sell, you would normally submit an asking price for it. And looking at the ask price here, people have submitted orders to sell Bitcoin at $3,783. So the price difference between bid and ask is $1. If you can't remember which one is buy or sell, I always remember it as bid and buy both start with B.

Therefore ask is sell the bid price will always be lower than the sell price. Therefore if I wanted to buy bitcoin, I can Immediately at the asking price, which will be more expensive. Or I can submit a bid, play the waiting game and hope someone sells it to me for the price that I want. Depending on the bid price you've put, you might only have to wait one minute or one day or even longer to get your order fulfilled. Sometimes your bid will never get fulfilled because you may have put an unrealistic bid of $1 instead of something closer to the current prices. To put it into perspective, let's go through the scenario of buying Bitcoin at the ask and bid price and then selling Bitcoin at the asking bid price.

So using the example at the bottom, if we were to buy bitcoin, we can buy it at the bid price of 3000 and the ask price of 3500. Now buying Bitcoin at the asking price is more expensive than the bid because that's the price the seller has set it at. However, I'll be able to purchase Just immediately buying Bitcoin at the bid price is cheaper than the asking price. But there may be a delay to purchasing it, as it requires someone who already owns Bitcoin to sell it to you at that lower price. Now let's go through the scenario of selling Bitcoin. If I were to sell Bitcoin at the asking price, I get a better ROI, but I may have a delay in myself as it requires someone to buy it at that more expensive price.

Selling Bitcoin at the bid price has worse ROI, but I'll be able to sell it immediately. So because arbitrage requires quick reactions and for orders to be fulfilled immediately, we need to identify the exchange with the cheapest ask so it can be bought immediately and then identify another exchange with the most expensive bid so it can be sold immediately. Putting All that into context Now, let's go make our workflow

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.