ABCIJKLMNOPQRSTUVWXYZ
1
PairBidTimeCCY index code for tradingview
2
EUR/USD1.144317:16:45USD
1/eurusd*1.1443+usdjpy/107.24+1/gbpusd*1.2655+usdchf/0.9391+usdcad/1.3532+1/audusd*0.7015+1/nzdusd*0.6572
1/eurusd*1.1443+usdjpy/107.24+1/gbpusd*1.2655+usdchf/0.9391+usdcad/1.3532+1/audusd*0.7015+1/nzdusd*0.6572
3
USD/JPY107.2417:16:49*EUReurusd/1.1443+eurjpy/122.71+eurgbp/0.904+eurchf/1.0748+eurcad/1.5485+euraud/1.6305+eurnzd/1.7401eurusd/1.1443+eurjpy/122.71+eurgbp/0.904+eurchf/1.0748+eurcad/1.5485+euraud/1.6305+eurnzd/1.7401
4
GBP/USD1.265517:16:53GBP
gbpusd/1.2655+gbpjpy/135.71+1/eurgbp*0.904+gbpchf/1.1884+gbpcad/1.7125+gbpaud/1.8029+gbpnzd/1.9241
gbpusd/1.2655+gbpjpy/135.71+1/eurgbp*0.904+gbpchf/1.1884+gbpcad/1.7125+gbpaud/1.8029+gbpnzd/1.9241
5
USD/CHF0.939117:16:48JPY
1/usdjpy*107.24+1/eurjpy*122.71+1/gbpjpy*135.71+1/chfjpy*114.11+1/cadjpy*79.22+1/audjpy*75.23+1/nzdjpy*70.48
1/usdjpy*107.24+1/eurjpy*122.71+1/gbpjpy*135.71+1/chfjpy*114.11+1/cadjpy*79.22+1/audjpy*75.23+1/nzdjpy*70.48
6
USD/CAD1.353217:16:55AUD
audusd/0.7015+1/euraud*1.6305+1/gbpaud*1.8029+audchf/0.6588+audcad/0.9494+audjpy/75.23+audnzd/1.0668
audusd/0.7015+1/euraud*1.6305+1/gbpaud*1.8029+audchf/0.6588+audcad/0.9494+audjpy/75.23+audnzd/1.0668
7
EUR/JPY122.7117:16:49NZD
nzdusd/0.6572+1/eurnzd*1.7401+1/gbpnzd*1.9241+nzdjpy/70.48+1/audnzd*1.0668+nzdcad/0.8894+nzdchf/0.6173
nzdusd/0.6572+1/eurnzd*1.7401+1/gbpnzd*1.9241+nzdjpy/70.48+1/audnzd*1.0668+nzdcad/0.8894+nzdchf/0.6173
8
AUD/USD0.701517:16:48CAD
1/usdcad*1.3532+cadjpy/79.22+1/gbpcad*1.7125+cadchf/0.6939+1/eurcad*1.5485+1/audcad*0.9494+1/nzdcad*0.8894
1/usdcad*1.3532+cadjpy/79.22+1/gbpcad*1.7125+cadchf/0.6939+1/eurcad*1.5485+1/audcad*0.9494+1/nzdcad*0.8894
9
NZD/USD0.657217:16:53CHF
1/usdchf*0.9391+chfjpy/114.11+1/gbpchf*1.1884+1/cadchf*0.6939+1/eurchf*1.0748+1/audchf*0.6588+1/nzdchf*0.6173
1/usdchf*0.9391+chfjpy/114.11+1/gbpchf*1.1884+1/cadchf*0.6939+1/eurchf*1.0748+1/audchf*0.6588+1/nzdchf*0.6173
10
EUR/GBP0.90417:16:54
11
EUR/CHF1.074817:16:48The blue boxes contain the text for tradingview
12
AUD/JPY75.2317:16:54* if used on the daily timeframe the wicks
13
GBP/JPY135.7117:16:54Can be inaccurate. Better to set tf to 24h
14
CHF/JPY114.1117:16:54
15
EUR/CAD1.548517:16:58
16
AUD/CAD0.949417:16:56If you want access to this sheet go to File > Make a Copy
17
CAD/JPY79.2217:16:56
18
NZD/JPY70.4817:16:54
19
AUD/NZD1.066817:16:54index_usd := 1/eurusd*1.1443+usdjpy/107.24+1/gbpusd*1.2655+usdchf/0.9391+usdcad/1.3532+1/audusd*0.7015+1/nzdusd*0.6572 index_eur := eurusd/1.1443+eurjpy/122.71+eurgbp/0.904+eurchf/1.0748+eurcad/1.5485+euraud/1.6305+eurnzd/1.7401 index_gbp := gbpusd/1.2655+gbpjpy/135.71+1/eurgbp*0.904+gbpchf/1.1884+gbpcad/1.7125+gbpaud/1.8029+gbpnzd/1.9241 index_jpy := 1/usdjpy*107.24+1/eurjpy*122.71+1/gbpjpy*135.71+1/chfjpy*114.11+1/cadjpy*79.22+1/audjpy*75.23+1/nzdjpy*70.48 index_aud := audusd/0.7015+1/euraud*1.6305+1/gbpaud*1.8029+audchf/0.6588+audcad/0.9494+audjpy/75.23+audnzd/1.0668 index_nzd := nzdusd/0.6572+1/eurnzd*1.7401+1/gbpnzd*1.9241+nzdjpy/70.48+1/audnzd*1.0668+nzdcad/0.8894+nzdchf/0.6173 index_cad := 1/usdcad*1.3532+cadjpy/79.22+1/gbpcad*1.7125+cadchf/0.6939+1/eurcad*1.5485+1/audcad*0.9494+1/nzdcad*0.8894 index_chf := 1/usdchf*0.9391+chfjpy/114.11+1/gbpchf*1.1884+1/cadchf*0.6939+1/eurchf*1.0748+1/audchf*0.6588+1/nzdchf*0.6173
20
GBP/AUD1.802917:16:54
21
EUR/AUD1.630517:16:58
22
GBP/CHF1.188417:16:54
23
EUR/NZD1.740117:16:53
24
AUD/CHF0.658817:16:54
25
GBP/NZD1.924117:16:54
26
USD/INR74.7416:58:02
27
USD/CNY6.982913:19:38
28
USD/SGD1.389117:17:00
29
USD/HKD7.751917:16:46
30
USD/DKK6.506117:16:52
31
GBP/CAD1.712517:16:56
32
USD/SEK8.956317:17:00
33
USD/RUB71.342817:00:02
34
USD/TRY6.856817:17:00
35
USD/MXN22.48117:16:49
36
USD/ZAR16.632517:15:45
37
CAD/CHF0.693917:16:58
38
NZD/CAD0.889417:16:58
39
NZD/CHF0.617317:16:53
40
BTC/USD9,184.0017:16:57
41
BTC/EUR8,027.2017:17:02
42
ETH/USD236.2817:16:49
43
USD/CHF221.97:21:10
44
45
46
47
48
49
50
51