{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Table 1","Table 2","Table 3","Table 4","Table 5","Table 6","Table 7"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Table 1","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[1,1,1,3],[13,1,13,4]],"flags":["formulas_cached_only"]}
[]
[null,"RBA Semi-Annual Report on Foreign Exchange Turnover\n  Oct 2022 \n    \n  Table 1\nForeign Exchange Turnover by Instrumentᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Oct 2022","Apr 2022"]
[null,"","US$m","US$m"]
[null,"Outright Spot",43049.56316934721,43214.16125335867]
[null,"Outright Forwards",20746.834929507324,24947.97879617556]
[null,"FX Swaps",79746.12052888356,86330.15270183366]
[null,"TRADITIONAL FOREIGN  EXCHANGE TURNOVERᵇ",143544,154494]
[null,"Currency Swaps",2689.5712981999454,2962.680434958583]
[null,"OTC Options",1456.1768192766456,1810.3001650601962]
[null,"TOTAL TURNOVER",147688,159268]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days (Apr 2022 calculated on 18 trading days).\nb Totals and sub-totals may not sum due to rounding.",{"$nulls":3}," "]

{"sheet":"Table 2","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"merged":[[1,0,1,4],[32,0,32,3]],"flags":["formulas_cached_only"]}
[]
["RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 2\nForeign Exchange Turnover by Instrument and Counterpartyᵃ ᵇ\nDaily average (US$m) "]
[]
["","Oct 2022","Apr 2022"]
["","US$m","US$m"]
["Outright Spot",43049.56316934721,43214.16125335867]
["Financial Institutions - Local",5571.882699788722,7958.848650377835]
["Financial Institutions - Overseas",35795.08664752531,32896.65573226831]
["Non-financial Institutions - Local",1316.0098484173009,1681.981726115894]
["Non-financial Institutions - Overseas",366.58397361587356,676.6751445966314]
["Outright Forwards",20746.834929507324,24947.97879617556]
["Financial Institutions - Local",4455.474961034114,7186.358426498314]
["Financial Institutions - Overseas",14711.302143806124,15526.605001186215]
["Non-financial Institutions - Local",1465.4734637432632,2059.339844399257]
["Non-financial Institutions - Overseas",114.58436092382206,175.6755240917743]
["FX Swaps",79746.12052888356,86330.15270183366]
["Financial Institutions - Local",30461.012781262198,33552.70811259079]
["Financial Institutions - Overseas",47691.22050939438,51131.874951089245]
["Non-financial Institutions - Local",1244.8803353967226,1219.1003486864488]
["Non-financial Institutions - Overseas",349.0069028302644,426.46928946718197]
["Currency Swaps",2689.5712981999454,2962.680434958583]
["Financial Institutions - Local",1099.3595200436525,839.3449647720203]
["Financial Institutions - Overseas",1463.210119358721,2046.472410678209]
["Non-financial Institutions - Local",85.92988062006349,28.332576429710024]
["Non-financial Institutions - Overseas",41.07177817750863,48.530483078643776]
["OTC Options",1456.1768192766456,1810.3001650601962]
["Financial Institutions - Local",166.16323498305832,224.5227208106685]
["Financial Institutions - Overseas",1113.8599705665138,1343.331753614379]
["Non-financial Institutions - Local",173.65326997830712,177.628026234637]
["Non-financial Institutions - Overseas",2.5003437487665,64.81766440051155]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated \n   on 20 trading days (Apr 2022 calculated on 18 trading days).\nb Totals and sub-totals may not sum due to rounding. ",{"$nulls":3}," "]

{"sheet":"Table 3","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[1,1,1,8],[2,5,2,8],[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[10,1,10,5]],"flags":["formulas_cached_only"]}
[]
[null,"RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 3\nForeign Exchange Turnover by Currencyᵃ\nDaily average (US$m)"]
[null,"","Oct 2022"," Proportion of Totalᵇ","Apr 2022"," Proportion of Totalᵇ"]
[null,"","US$m","%","US$m","%"]
[null,"AUD",66771.48274115934,45.21109510774513,71375.43776556774,44.81544297989697]
[null,"USD",132422.560965501,89.6635622340606,142667.82261818319,89.5787384255546]
[null,"EUR",29599.730665321476,20.04203266626836,30372.725307528497,19.070525964889537]
[null,"OTHER CURRENCIES",66501.91597015916,45.08330999192591,73956.5028832245,46.53529262965889]
[null,"TOTAL",147688.2667452147,"",159265.27335138668,""]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days (Apr 2022 calculated on 18 trading days).\nb Totals and sub-totals may not sum due to rounding. \n",{"$nulls":4},""]

{"sheet":"Table 4","index":3,"n_rows":40,"n_cols":7,"rows_kept":40,"merged":[[1,1,1,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[39,1,39,5]],"flags":["formulas_cached_only"]}
[]
[null,"RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022 \n\nTable 4\nForeign Exchange Turnover by Currency Pairᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Oct 2022","Proportion of Total","Apr 2022"," Proportion of Total"]
[null,"","US$m","%","US$m","%"]
[null,"AUD/USD",58851.68086,39.84858252958738,61975.557755,38.913415618246404]
[null,"AUD/EUR",3147.73913,2.1313400173192028,3458.463514,2.1715113666720556]
[null,"AUD/JPY",1198.00693,0.8111727196830079,1437.283367,0.902446174705888]
[null,"AUD/GBP",988.850016,0.6695521843411255,1181.364117,0.7417587601717853]
[null,"AUD/CHF",226.744837,0.15352935070531712,211.226348,0.13262548925725842]
[null,"AUD/CAD",386.477408,0.26168457151028285,476.925115,0.29945329886567573]
[null,"AUD/NZD",958.617979,0.6490820158798735,1283.815174,0.8060860644508342]
[null,"AUD/SEK",70.870415,0.047986489761468604,105.777744,0.06641607537772243]
[null,"AUD/OTHER ASIAN",723.072556,0.48959377203157245,939.783291,0.5900742021287584]
[null,"AUD/OTHER EUROPEAN",102.057813,0.06910353493206407,121.079408,0.07602373414598451]
[null,"AUD/OTHER",117.364796,0.07946792158068852,184.161933,0.11563219597342772]
[null,"EUR/USD",21998.904326,14.89549902033347,23227.581994,14.584210044749417]
[null,"USD/JPY",13157.150336,8.908730954779468,15320.897063,9.619734886674594]
[null,"USD/GBP",7445.053157,5.041059334730437,8272.219098,5.193987944702272]
[null,"USD/CHF",1896.506432,1.2841280311640246,2120.196558,1.3312359394970237]
[null,"USD/CAD",3080.039064,2.0855001767600676,4682.167748,2.9398547777905804]
[null,"USD/NZD",11855.218017,8.02719016098253,12452.910812,7.81897431242102]
[null,"USD/SEK",311.628348,0.2110041338220663,522.592931,0.32812735632895423]
[null,"USD/OTHER ASIAN",12647.902657,8.563918404515933,12483.282679,7.838044299468902]
[null,"USD/OTHER EUROPEAN",538.668487,0.36473343406062014,591.40521,0.3713334348115589]
[null,"USD/OTHER",639.809281,0.4332160537228276,1019.010769,0.6398198097760045]
[null,"EUR/JPY",915.509424,0.6198931331403099,1246.359778,0.7825684480792992]
[null,"EUR/GBP",1940.01123,1.313585210775598,642.235221,0.4032487481314049]
[null,"EUR/CHF",370.733187,0.25102413019892894,314.179869,0.19726828227369794]
[null,"EUR/CAD",426.425886,0.28873376023781117,507.576946,0.31869907062425296]
[null,"EUR/NZD",251.059282,0.1699927066211572,315.804334,0.19828825666347574]
[null,"EUR/SEK",196.215148,0.13285764152145924,99.950547,0.06275727589346762]
[null,"EUR/OTHER ASIAN",67.595624,0.04576912268675273,159.521421,0.1001608308218163]
[null,"EUR/OTHER EUROPEAN",221.443109,0.14993954081934296,366.090003,0.2298617867505156]
[null,"EUR/OTHER",64.09432,0.04339838323859529,34.96168,0.0219518538248633]
[null,"RESIDUAL CURRENCIES",2892.816689,1.9587315585566136,3510.890925,2.204429660721084]
[null,"TOTALᵇ",147688.266744,"",159265.273352,""]
[]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days (Apr 2022 calculated on 18 trading days).\nb Totals and sub-totals may not sum due to rounding. \n",{"$nulls":4}," "]

{"sheet":"Table 5","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,8],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[25,0,25,5]],"flags":["formulas_cached_only"]}
["RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 5\n    Maturities By Instrument and Currencyᵃ ᵇ\n    Daily average (US$m)"]
[]
["","One day\nUS$m","Over 1 day and up to 7 days\nUS$m","Seven days to one month\nUS$m","One month to three months\nUS$m","Three months to six months\nUS$m",null,null,"Over six months\nUS$m"]
["Outright Forwards",6348.949474775422,3714.5785786763463,3459.6287906171247,4463.069231842018,2387.2933701931574,null,null,929.8904596847703]
["Against AUD",5305.432577913767,2132.336379741824,1785.3333622006803,1941.0039454097637,1549.6026204733873,null,null,420.23500151354415]
["Against USDᶜ",435.39114891692896,1454.8780963041702,1553.2977410251103,2338.8531105472257,731.3150151289876,null,null,479.1646010708188]
["Against EURᶜ",152.8063206107761,71.7399918081917,62.47741167953485,120.57416679537847,47.50042798995694,null,null,13.64803507421991]
["OTHER CURRENCIES",455.3194273339495,55.62411082216033,58.520275711799265,62.63800908965036,58.875306600825354,null,null,16.842822026187612]
["FX Swaps",34924.79188334953,43654.987786992046,5240.589509451002,7466.8813006798755,5206.09956311945,null,null,1724.9430874950235]
["Against AUD",16934.268920655242,18205.4938449488,3086.823923364698,2735.12743467489,3066.465022719765,null,null,995.8022180524091]
["Against USDᶜ",17729.917709835783,25306.555661007966,2093.196785513848,4564.675988606093,2003.251066505812,null,null,710.6492823613428]
["Against EURᶜ",220.23329913289095,104.48652581415757,35.865718993354065,78.82620792597423,45.66306966159366,null,null,17.219258617356704]
["OTHER CURRENCIES",40.37195372561251,38.451755221121424,24.703081579101745,88.25166947291876,90.72040423227955,null,null,1.272328463914872]
["Currency Swaps",0,123.95775327414378,354.0700749857997,684.7534581622824,278.1124554498149,null,null,2279.2931402889944]
["Against AUD",0,9.02929755,166.258352926575,309.3962119835141,270.3534145544819,null,null,1940.6652643468788]
["Against USDᶜ",0,95.0770083913358,187.8117220592247,375.3572461787683,7.759040895333,null,null,338.62787594211574]
["Against EURᶜ",0,0,0,0,0,null,null,0]
["OTHER CURRENCIES",0,19.851447332808,0,0,0,null,null,0]
["OTC Options",2.83086857058915,228.85993496317823,251.75492434982826,439.12787830974423,308.9844120889524,null,null,268.90771587474796]
["Against AUD",0.34153035558915,105.68491117362169,102.88735747781018,123.9709949045751,69.37527692820488,null,null,127.56765242099861]
["Against USDᶜ",2.489338215,71.11974163543594,137.51421146520877,298.41868606277774,234.45794960484596,null,null,136.8648510186919]
["Against EURᶜ",0,0.747615468873,11.315241466490326,16.42838627014303,5.0167392604875,null,null,4.063804816435455]
["OTHER CURRENCIES",0,51.30766668524761,0.038113940319,0.309811072248405,0.134446295414067,null,null,0.411407618622]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days. \nb Totals and sub-totals may not sum due to rounding. \nc 'Against USD' excludes AUD/USD turnover; 'Against EUR' excludes AUD/EUR and EUR/USD turnover."]

{"sheet":"Table 6","index":5,"n_rows":35,"n_cols":40,"rows_kept":35,"merged":[[0,14,1,25],[0,27,1,39],[1,0,2,12],[4,0,5,0],[4,1,4,12],[4,14,5,14],[4,15,4,25],[4,27,5,27],[4,28,4,39],[34,0,34,12],[34,14,34,25],[34,27,34,39]],"flags":["formulas_cached_only"]}
[{"$nulls":14},"RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 6b\nUSD Turnover by Instrument, Counterparty and Currencyᵃ ᵇ ᶜ\nDaily average (US$m)",{"$nulls":12},"RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 6c\nEUR Turnover by Instrument, Counterparty and Currencyᵃ ᵇ ᶜ\nDaily average (US$m)"]
["RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 2022\n\nTable 6a\nAUD Turnover by Instrument, Counterparty and Currencyᵃ ᵇ\nDaily average (US$m)"]
[]
[]
["","AUD Against",{"$nulls":12},"","USD Against",{"$nulls":11},"","EUR Against"]
[null,"\nUSD","\nEUR","\nJPY","\nGBP","\nCHF ","\nCAD","\nNZD","\nSEK","Oth\nASIAN","Oth\nEUROP.","\nOTHER","\nTOTAL",null,null,"\nEUR","\nJPY","\nGBP","\nCHF","\nCAD","\nNZD","\nSEK","Oth\nASIAN","Oth\nEUROP.","\nOTHER","\nTOTAL",null,null,"\nJPY","\nGBP","\n  CHF","\nCAD","\nNZD","\nSEK","Oth\nASIAN","Oth\nEUROP.","\nOTHER","\nTOTAL","\nRESIDUALS","GRAND TOTALᵈ"]
["Outright Spot",12290.53679806423,956.0017695405016,552.3050222021961,401.2734033048998,105.42508580339326,108.61111507784592,523.7384835927598,36.218935601420206,249.16938522385155,65.46980397202682,72.48200662699843,15361.231809010122,null,"Outright Spot",5562.6560080967165,3379.940456349589,2418.464817555157,629.1236131400343,1241.2245566294002,1987.373009315038,127.35969135326265,6188.586005183417,258.0093188401351,402.1394298705248,22194.876906333277,null,"Outright Spot",715.6271151232306,1674.139443479067,319.56599044243035,249.1715660190426,150.38073324619964,185.45556376612274,49.448943073235704,205.3897709197171,63.18885178656878,3612.3679778556143,1881.0864761481976,43049.56316934721]
["Financial Institutions - Local",1886.6673834737212,175.672688222402,105.6118203284418,112.41583626872918,33.24679691773904,37.26508001235365,153.02300745560473,5.67057951986526,113.95861326182178,7.518711280641561,15.254081115118481,2646.3045978564387,null,"Financial Institutions - Local",658.3131949868647,429.26859948662127,337.68806919676126,88.66117570568841,177.85299928857606,256.2007335607656,13.40730247870295,554.0987817894649,56.32306701292389,73.71759092435637,2645.5315144307256,null,"Financial Institutions - Local",28.64590813565836,52.1825333749386,45.66972486809651,4.082297752234065,12.790944223121064,21.661007866128813,3.130479829071504,27.434092677384665,1.44632590550175,197.04331463213535,83.00327286942245,5571.882699788722]
["Financial Institutions - Overseas",9271.85823760094,702.075323748744,437.1171133408858,256.2539304339607,67.93243952154879,57.81412377320198,317.61644322622334,30.124079180695773,109.59664729336268,56.32753739912181,53.614075446305556,11360.32995096499,null,"Financial Institutions - Overseas",4853.553473659723,2924.7846431982216,2064.1672425425973,537.6129958051076,1051.744035916263,1624.5259364606686,113.47543070221039,5557.320481167378,200.60424780309023,323.0519184761505,19250.84040573141,null,"Financial Institutions - Overseas",686.9221980931305,1618.5027978459304,273.47079882482967,245.06536638008663,129.32043038740863,163.2269113959969,46.15642381064005,177.17583953795682,61.50076742574137,3401.341533701721,1782.5747571271927,35795.08664752531]
["Non-financial Institutions - Local",1064.3665311954169,75.14344848660468,9.023391734547644,31.198298620137287,4.20527162458494,12.6239616740328,33.01854952294899,0.424276900859175,25.29422952775173,1.61375250927345,3.606534839747385,1260.5182466359051,null,"Non-financial Institutions - Local",19.286799608586783,2.3357251197735,6.284427078347691,0.16683255550416,5.15630011941135,7.502688309982866,0.13858969134192,8.603536033272999,0.145331489667,2.576737772486787,52.196967778375054,null,"Non-financial Institutions - Local",0.04931001675327,0.838877672834565,0.00792251621616,0.016325164295895,0.211128818326335,0.0016984557135,0.06039473227515,0.009057857991,0.16765397032566,1.362369204731535,1.932264798289098,1316.0098484173009]
["Non-financial Institutions - Overseas",67.64464579415116,3.11030908275087,0.55269679832094,1.40533798207257,0.0405777395205,0.9079496182575,20.080483387982746,0,0.31989514091535,0.00980278299,0.007315225827,94.07901355278862,null,"Non-financial Institutions - Overseas",31.50253984154277,23.551488544973026,10.325078737450932,2.682609073734135,6.471221305149783,99.14365098362089,0.338368481007375,68.563206193301,0.93667253445402,2.793182697531135,246.30801839276506,null,"Non-financial Institutions - Overseas",0.0096988776885,2.6152345853634,0.417544233288,0.007576722426,8.058229817343616,0.565946048283525,0.101644701249,0.77078084638464,0.074104485,12.62076031702668,13.576181353293196,366.58397361587356]
["Outright Forwards",10725.369995998872,738.6828397520484,329.6124682104064,290.76594176527226,72.023625244475,162.2363573812191,126.79294507201823,21.08219679868329,315.06949495349573,24.6587040015872,35.29274183730204,12841.587311015379,null,"Outright Forwards",1068.9943242134086,677.3976688440507,575.0052311843505,137.61446310245114,140.0544387781741,561.4802758401976,35.773842744300026,3368.7165443635013,76.24927122664461,131.6535880909551,6772.939648388034,null,"Outright Forwards",148.15417426828256,88.92850667915542,9.994939599894522,130.75531500397193,45.30279976784507,5.802375921269382,17.682839334022862,6.159001406442339,0.799097672738547,453.57904965362263,678.7289204502875,20746.834929507324]
["Financial Institutions - Local",1890.6182034639771,298.032754908,132.4359804532491,141.78524531366367,39.3733870898621,74.47751631414084,61.562774930053486,10.256677219692813,180.15575034913093,14.417792070013332,24.417011571004142,2867.5330936827877,null,"Financial Institutions - Local",448.0470815060997,74.48812944544936,162.91052486244953,95.08899279802404,48.574674608251975,63.418391304497774,29.186348486991424,478.05609091636416,27.188275612093868,78.57793100543077,1505.5364405456526,null,"Financial Institutions - Local",6.427308543660186,4.760360372815866,2.976174963897681,4.416555414726546,5.536706842525677,5.66752184223225,3.437389233919095,1.159138634579289,0.15717550136925,34.53833134972584,47.86709545594786,4455.474961034114]
["Financial Institutions - Overseas",7689.959058778309,381.54462372918334,178.77383379013213,127.41501058183415,22.14476476596766,76.51864421165983,50.59392537907317,8.989395872184273,112.83364262262046,7.869639603593586,7.382598683354622,8664.025138017912,null,"Financial Institutions - Overseas",566.2549414740869,601.5938052556213,404.15988457448657,42.28683051822411,83.2573175507982,460.8329268673382,5.941902217670601,2807.1265068309895,41.64437840914424,46.41614344680823,5059.514637145167,null,"Financial Institutions - Overseas",141.6598680387932,34.9480251147401,6.78066422046468,126.29612473466489,38.28743228982372,0.033369227205132,11.266976740059768,4.826501769934845,0.001172466086337,364.10013460177265,623.662234041272,14711.302143806124]
["Non-financial Institutions - Local",1137.1708443982677,59.04198340384098,18.368894202695945,21.26555558131641,10.505473388645235,11.24019685541844,10.737452585497365,1.836123706806207,19.94655043539085,2.272013536712283,1.753754577713775,1294.1388426723051,null,"Non-financial Institutions - Local",20.53459741844784,1.192410922050075,4.33604798583138,0.162627031203,6.518234259319419,16.212192099409762,0.644963709936,56.23402715221637,7.4143944525105,3.12489406987212,116.37438910079646,null,"Non-financial Institutions - Local",0.0666467432085,46.2371913090027,0.1130991237285,0.0426348545805,0.132587638016925,0.101484851832,2.923069030518,0.173361001928205,0.64074970528296,50.43082425809828,4.529407712063325,1465.4734637432632]
["Non-financial Institutions - Overseas",7.62188935831869,0.063477711024,0.0337597643292,0.300130288458,0,0,3.898792177394205,0,2.1335515463535,0.099258791268,1.7393770052295,15.890236642375095,null,"Non-financial Institutions - Overseas",34.15770381477417,0.12332322093,3.598773761583,0.076012755,1.7042123598045,21.01676556895188,0.000628329702,27.299919463931204,0.002222752896,3.534619568844,91.51418159641676,null,"Non-financial Institutions - Overseas",0.000350942620665,2.982929882596755,0.125001291803661,0,1.346072997478755,0,0.055404329526,0,0,4.509759444025836,2.67018324100437,114.58436092382206]
["FX Swaps",33455.94749136563,1393.5330380777882,308.33727453959676,295.08990760835997,48.27673294232689,114.43029891081325,292.2328385210759,13.569282387433773,137.78833564166007,11.929305262814122,6.974559759652485,36078.10906501715,null,"FX Swaps",14929.59480625364,8829.447560629971,4357.480582004806,1128.7670104741378,1646.878308818841,8993.330969586304,148.49481396728243,2723.5328552921483,204.4098971922765,92.4590526074184,43054.39585682683,null,"FX Swaps",47.94434983789132,168.34004224199035,22.71864347737503,46.25024293629777,51.99217233815187,4.957207863781992,0.463841478135945,9.89433664817325,0.106370287391004,352.6672071091885,260.9483999303965,79746.12052888356]
["Financial Institutions - Local",15667.659719324483,924.327198300119,146.1532854852918,151.0007316900272,23.162543011717474,40.38144057586657,90.9195147260086,6.102043057014177,75.02052974391967,4.970196805552524,5.43547948037094,17135.132682200372,null,"Financial Institutions - Local",5478.738882078801,2914.173589762045,1185.3758538097984,251.99444807703676,578.596187375026,2049.1580450972297,58.61086763655942,373.8921825283721,134.837004309278,42.350627030304686,13067.727687704451,null,"Financial Institutions - Local",31.384665678918825,145.78248312452507,0.481185031808754,7.226506319472258,13.528209368838528,0.507991150773561,0.437285102289945,6.17381837743125,0.0148375307535,205.53698168481168,52.615429672562755,30461.012781262198]
["Financial Institutions - Overseas",16769.655285818368,424.0622929169519,127.9188080066947,65.81257426465913,25.11025013004335,53.536965501509215,178.43488697317073,6.240232071194121,31.527967038499114,5.316002464961097,0.611070327587265,17688.22633551364,null,"Financial Institutions - Overseas",9400.635106802007,5887.9838285089845,3158.3220391447244,876.4897133063496,1060.709681449532,6895.787696866776,89.88394633072299,2211.2864396686914,67.82423557910501,48.850535191072794,29697.773222847965,null,"Financial Institutions - Overseas",16.5596841589725,15.243502961063285,22.222251919003774,39.02373661682551,37.04567214567683,4.449216713008431,0.020623500807,3.720518270742,0.014247821637504,138.29945410773684,166.92149692504213,47691.22050939438]
["Non-financial Institutions - Local",878.8730341635336,43.366132913863304,27.05126145837024,73.2860937270421,0.003939800566065,20.49373901566446,15.065370550468876,1.227007259225475,31.208681898861286,1.398650467032,0.92650658478378,1092.9004178394111,null,"Non-financial Institutions - Local",20.068566406580054,21.84819007189182,6.90399714113109,0,6.062259128680755,11.99112279935661,0,41.20572246528793,1.677205982088,0.98555141194965,110.74261540696591,null,"Non-financial Institutions - Local",0,6.743966200901475,0,0,0.0735730000005,0,0.005932875039,0,0.077284935,6.900757010940975,34.336545139404414,1244.8803353967226]
["Non-financial Institutions - Overseas",139.75945205924793,1.777413946854,7.21391958924,4.9905079266315,0,0.018153817773,7.81306627142769,0,0.03115696038,0.2444555252685,0.0015033669105,161.84962946373312,null,"Non-financial Institutions - Overseas",30.152250966253142,5.44195228704855,6.8786919091527,0.2828490907515,1.5101808656025,36.39410482294314,0,97.1485106297968,0.0714513218055,0.272338974091275,178.15233086744513,null,"Non-financial Institutions - Overseas",0,0.57008995550052,0.0152065265625,0,1.344717823636005,0,0,0,0,1.930014305699025,7.074928193387145,349.0069028302644]
["Currency Swaps",1895.5828877535494,53.25027630534066,3.529458750459642,0,0,1.163166577755,5.18301090610485,0,18.950800965665206,0,0,1977.6596012588748,null,"Currency Swaps",223.28961834564566,103.32942263640987,64.63654652092092,0,37.79409853973836,241.2740619141571,0,18.00519771139089,0,3.73130394,692.0602496082628,null,"Currency Swaps",0,0,0,0,0,0,0,0,0,0,19.851447332808,2689.5712981999454]
["Financial Institutions - Local",773.0953001360821,0.59209100270775,1.18572256768875,0,0,0.486525840255,4.61052990610485,0,0,0,0,779.9701694528385,null,"Financial Institutions - Local",170.54389790058895,13.29439446255375,61.2610327875,0,24.99674677506361,35.10545023760775,0,10.4565244875,0,3.73130394,319.38935059081405,null,"Financial Institutions - Local",0,0,0,0,0,0,0,0,0,0,0,1099.3595200436525]
["Financial Institutions - Overseas",1046.6946480620556,27.008358215473635,2.343736182770892,0,0,0.6766407375,0.572481,0,6.9689988277455,0,0,1084.2648630255458,null,"Financial Institutions - Overseas",52.74572044505673,90.03502817385613,3.37551373342092,0,0.35861181467475,205.03026160946783,0,7.54867322389089,0,0,359.0938090003673,null,"Financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,19.851447332808,1463.210119358721]
["Non-financial Institutions - Local",54.527739176547,18.281989238515276,0,0,0,0,0,0,11.981802137919704,0,0,84.79153055298198,null,"Non-financial Institutions - Local",0,0,0,0,0,1.1383500670815,0,0,0,0,1.1383500670815,null,"Non-financial Institutions - Local",0,0,0,0,0,0,0,0,0,0,0,85.92988062006349]
["Non-financial Institutions - Overseas",21.265200378864623,7.367837848644,0,0,0,0,0,0,0,0,0,28.633038227508624,null,"Non-financial Institutions - Overseas",0,0,0,0,12.43873995,0,0,0,0,0,12.43873995,null,"Non-financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,0,41.07177817750863]
["OTC Options",484.243686891498,6.271206607895502,4.2227065868715,1.72076319515646,1.0193934131745,0.0364705063905,10.670700573910104,0,2.09453927139366,0,2.61548781152022,512.8949548578105,null,"OTC Options",214.36956897396576,167.03522784312764,29.4659795007295,1.0013448046875,14.0876613315165,71.75970020702546,0,349.06205467760446,0,9.825906932163777,856.6074442708206,null,"OTC Options",3.78378468857025,8.6032377572505,18.4536131982384,0.2487619817865,3.383576910254268,0,0,0,0,34.47297453609992,52.20144561191469,1456.1768192766456]
["Financial Institutions - Local",65.40810817700387,0.72203402817,1.846428630501,0,0,0,0.0988595493795,0,0,0,0.0122599032465,68.08769028830086,null,"Financial Institutions - Local",33.05427182148,15.3004975057935,0.57687935562075,0,10.035275729661,5.827500270815223,0,27.414771112931476,0,0.8331834724395,93.04237926874144,null,"Financial Institutions - Local",0.24502477811175,0,4.78814064790425,0,0,0,0,0,0,5.033165426016,0,166.16323498305832]
["Financial Institutions - Overseas",302.7665698541779,3.940857170902197,2.37452397,0.01691728680096,0.954135,0,8.939777462397053,0,0.700153359087,0,1.2967476786264,320.9896817819915,null,"Financial Institutions - Overseas",178.09649623715532,151.63689234849465,16.87339551094279,1.0013448046875,3.024318274614,64.42091480500986,0,288.748060016482,0,8.271668001315536,712.0730899987016,null,"Financial Institutions - Overseas",3.4429254460965,8.6032377572505,13.31545152866565,0,3.383576910254268,0,0,0,0,28.745191642266917,52.05200714355369,1113.8599705665138]
["Non-financial Institutions - Local",115.53114626345373,1.253655223762305,0.0017539863705,1.701717328584,0.0652584131745,0.0364705063905,1.63206356213355,0,1.39438591230666,0,1.30648022964732,122.92293142582308,null,"Non-financial Institutions - Local",3.218800915330455,0.0978379888395,11.80573304260896,0,1.0280673272415,0.52014683582589,0,32.5784587227645,0,0.72105545840874,49.97010029101955,null,"Non-financial Institutions - Local",0.095834464362,0,0.3500210216685,0.2487619817865,0,0,0,0,0,0.694617467817,0.0656207936475,173.65326997830712]
["Non-financial Institutions - Overseas",0.5378625968625,0.354660185061,0,0.0021285797715,0,0,0,0,0,0,0,0.894651361695,null,"Non-financial Institutions - Overseas",0,0,0.209971591557,0,0,0.9911382953745,0,0.3207648254265,0,0,1.521874712358,null,"Non-financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,0.0838176747135,2.5003437487665]
["Total AUD Turnover",58851.68086007378,3147.7391302835745,1198.0069302895304,988.8500158736884,226.74483740336964,386.4774084540238,958.6179786658689,70.87041478753727,723.0725560560662,102.05781323642815,117.36479603547316,66771.48274115934,null,"Total USD Turnoverᶜ",21998.904325883377,13157.150336303148,7445.053156765965,1896.5064315213108,3080.0390640976707,11855.218016862724,311.62834806484506,12647.902657228062,538.6684872590563,639.8092814410621,73570.88010542722,null,"Total EUR Turnoverᶜ",915.5094239179748,1940.0112301574632,370.73318671793834,426.4258859410988,251.05928226245084,196.2151475511741,67.59562388539452,221.4431089743327,64.09431974669833,4453.087209154525,2892.816689473604,147688.2667452147]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days.\nb Totals and sub-totals may not sum due to rounding.",{"$nulls":13},"a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days.\nb Totals and sub-totals may not sum due to rounding.\nc USD turnover excludes AUD/USD turnover.\n",{"$nulls":12},"a Adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days.\nb Totals and sub-totals may not sum due to rounding.\nc EUR turnover excludes AUD/EUR and EUR/USD turnover.\nd Grand total is the sum of AUD turnover (Table 6a), USD turnover (Table 6b), EUR turnover (Table 6c) and Residuals (Table 6c)."]

{"sheet":"Table 7","index":6,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[1,1,1,11],[2,0,2,11],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,9],[4,10,4,11],[5,0,5,1],[5,6,5,8],[6,0,6,1],[6,6,6,8],[7,0,7,1],[7,6,7,8],[8,0,8,1],[8,6,8,8],[9,0,9,1],[9,6,9,8],[10,0,10,1],[10,6,10,8],[11,0,11,1],[11,6,11,8],[12,0,12,1],[12,6,12,8],[13,0,13,1],[13,6,13,8],[14,0,14,1],[14,6,14,8],[15,0,15,1],[15,6,15,8],[16,0,16,1],[16,6,16,8],[17,0,17,1],[17,6,17,8],[20,0,20,10]],"flags":["formulas_cached_only"]}
[]
[null,"RBA Semi-Annual Report of Foreign Exchange Turnover\nOct 2022\n\nTable 7\n    Settlement of Foreign Exchange Turnoverᵃ ᵇ ᶜ\n    Daily average (US$m)\n\n"]
["\n"]
[]
["",null,"All counterparties",null,"Reporting dealers",null,"Other financial institutions",{"$nulls":3},"Non-financial customers"]
["",null,"Total","o/w CLS eligible pairs","Total","o/w CLS eligible pairs","Total",null,null,"o/w CLS eligible pairs","Total","o/w CLS eligible pairs"]
["a) Total notional gross value of settlement obligations for all foreign exchange transactions",null,143999.13539828284,82581.83192592606,113700.45195363772,61903.331062431535,27876,null,null,18129.30679469859,4422.273127460997,2549.1940687959554]
["a1) Turnover to be settled with a single payment (ie non-deliverable)",null,2569.6351699120187,null,2059.290664117835,null,493,{"$nulls":3},17.63927189504435]
["a2) Turnover to be settled with at least two payments (ie spot, forwards and swaps)",null,70764.27653577137,31461.280718657927,53458.41443472761,20189.78667145964,13716,null,null,9285.854747097017,3589.506120743874,1985.6393001012711]
["a3) Turnover to be settled with four payments (ie swaps)",null,70665.22369259945,51120.55120726815,58182.74685479229,41713.54439097189,11667,null,null,8843.452047601575,815.127734822079,563.5547686946842]
["b) Bilateral netting",null,39670.30432517456,20913.6268210987,35777.32572739337,18526.20947453084,2629,null,null,2165.7618436721455,1263.9984380264766,221.65550289571448]
["b1) Actual value of settlement obligations after netting",null,5846.202872270165,1942.9312091045865,4267.872333067156,595.637254038296,1222,null,null,1191.6203477715874,355.944321180675,155.67360729470332]
["c) Payment versus payment - PvP (=c1+c2+c3)",null,63784.04236452747,62968.96339423081,46398.26595882666,45806.6373362311,14953,null,null,14806.102896608369,2432.553121646802,2356.223161391345]
["c1) Via CLS",null,54998.68624735242,54877.66316542623,41749.63287040484,41643.80966663265,12239,null,null,12224.020468123148,1009.986596784873,1009.8330306704254]
["c2) Via other PvP or equivalent settlement methods",null,3012.1241085535785,2543.680153393505,876.3587630637669,529.0745995222288,1367,null,null,1281.818005338961,768.3364026090841,732.7875485323153]
["c3) Via \"same clearer\" or \"on-us\" accounts",null,5773.232008621471,5547.620075411078,3772.274325358049,3633.7530700762136,1347,null,null,1300.264423146259,654.230122252845,613.6025821886043]
["d) Non-PvP",null,62428.42727121603,47380.1186965699,51399.75552145105,38374.714208038335,9503,null,null,7935.254124820343,1526.1067068582324,1070.150363711224]
["d1) Via \"same clearer\" or \"on-us\" accounts with exposure to settlement risk",null,2218.9939320424273,1063.1794675789833,1905.8970270303644,954.0394143019203,200,null,null,15.641135055000001,113.47755098706298,93.49891822206298]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for Oct 2022 calculated on 20 trading days. \nb Totals and sub-totals may not sum due to rounding. \nc This release includes settlement data for 21 survey participants. Future releases are expected to include settlement data for all survey participants."]