ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
BITTREX //FULL API RETURN
2
#ERROR!
3
4
5
6
POLONIEX //FULL API RETURN
7
#ERROR!
8
9
10
11
12
BITTREX (BTC-LTC)POLONIEX (BTC-LTC)
13
14
15
RAZERGLASS CUSTOM CODING
16
1
To use these functions: go to the top left -> file -> make a copy of this spread sheet.
17
2
and then simply put a equal sign ' = ' in font of "importJSON" so it will look like "=importJSON....." change tickers to whatever you want! A2, A7 is the working example
18
19
BITTREX API
importJSON("https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-ltc", "/result", null)
20
21
POLONIEX API
importJSON("https://poloniex.com/public?command=returnTicker", "/BTC_LTC", null)
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100