{"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  Apr 2023 \n    \n  Table 1\nForeign Exchange Turnover by Instrumentᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Apr 2023","Oct 2022"]
[null,"","US$m","US$m"]
[null,"Outright Spot",36818.03552821825,43049.85944118268]
[null,"Outright Forwards",24937.928232826438,20746.834929507324]
[null,"FX Swaps",86591.33039723682,73813.76989526427]
[null,"TRADITIONAL FOREIGN  EXCHANGE TURNOVERᵇ",148349,137611]
[null,"Currency Swaps",3314.3036545563245,2689.5712981999454]
[null,"OTC Options",637.8079756148727,1456.1768192766456]
[null,"TOTAL TURNOVER",152302,141758]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 trading days (Oct 2022 calculated on 20 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\nApr 2023\n\nTable 2\nForeign Exchange Turnover by Instrument and Counterpartyᵃ ᵇ\nDaily average (US$m) "]
[]
["","Apr 2023","Oct 2022"]
["","US$m","US$m"]
["Outright Spot",36818.03552821825,43049.85944118268]
["Financial Institutions - Local",4983.438073885289,5571.882699788722]
["Financial Institutions - Overseas",30107.02046436424,35795.38291936078]
["Non-financial Institutions - Local",1437.9046443816999,1316.0098484173009]
["Non-financial Institutions - Overseas",289.67234558702506,366.58397361587356]
["Outright Forwards",24937.928232826438,20746.834929507324]
["Financial Institutions - Local",6570.691052605504,4455.474961034114]
["Financial Institutions - Overseas",15366.524089394667,14711.302143806124]
["Non-financial Institutions - Local",1810.833069984258,1465.4734637432632]
["Non-financial Institutions - Overseas",1189.8800208420103,114.58436092382206]
["FX Swaps",86591.33039723682,73813.76989526427]
["Financial Institutions - Local",21859.260899245102,24528.662147642906]
["Financial Institutions - Overseas",62457.19633198355,47691.22050939438]
["Non-financial Institutions - Local",1745.7063198374317,1244.8803353967226]
["Non-financial Institutions - Overseas",529.1668461707252,349.0069028302644]
["Currency Swaps",3314.3036545563245,2689.5712981999454]
["Financial Institutions - Local",1220.1677192766529,1099.3595200436525]
["Financial Institutions - Overseas",1912.4267002306904,1463.210119358721]
["Non-financial Institutions - Local",116.79836220954536,85.92988062006349]
["Non-financial Institutions - Overseas",64.9108728394361,41.07177817750863]
["OTC Options",637.8079756148727,1456.1768192766456]
["Financial Institutions - Local",82.30585339780225,166.16323498305832]
["Financial Institutions - Overseas",428.2360304378753,1113.8599705665138]
["Non-financial Institutions - Local",117.0292525757668,173.65326997830712]
["Non-financial Institutions - Overseas",10.236839203428337,2.5003437487665]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated \n   on 17 trading days (Oct 2022 calculated on 20 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\nApr 2023\n\nTable 3\nForeign Exchange Turnover by Currencyᵃ\nDaily average (US$m)"]
[null,"","Apr 2023"," Proportion of Totalᵇ","Oct 2022"," Proportion of Totalᵇ"]
[null,"","US$m","%","US$m","%"]
[null,"AUD",73903.72361633512,48.52524926482826,65859.48294187515,46.4596802034569]
[null,"USD",136834.41498067192,89.845596000205,126490.33312462628,89.23089224653344]
[null,"EUR",24715.80015341551,16.22841589755939,27546.150378770417,19.43205868414564]
[null,"OTHER CURRENCIES",68963.59548242544,45.400738837407346,63535.61517330148,44.87736886586403]
[null,"TOTAL",152299.5239303212,"",141756.21238343086,""]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 trading days (Oct 2022 calculated on 20 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\nApr 2023 \n\nTable 4\nForeign Exchange Turnover by Currency Pairᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Apr 2023","Proportion of Total","Oct 2022"," Proportion of Total"]
[null,"","US$m","%","US$m","%"]
[null,"AUD/USD",65481.888823,42.99546520866782,57939.507582,40.87264085884752]
[null,"AUD/EUR",3330.938457,2.1870970907279927,3147.73913,2.220529934531247]
[null,"AUD/JPY",1300.823776,0.8541220237979924,1198.00693,0.8451177622971825]
[null,"AUD/GBP",1059.179074,0.6954579020927762,989.023495,0.6976932286641603]
[null,"AUD/CHF",292.044001,0.19175634530544045,226.744837,0.1599540741036276]
[null,"AUD/CAD",462.587728,0.3037355049262839,386.477408,0.2726352528089092]
[null,"AUD/NZD",989.437515,0.6496655337374895,958.617979,0.6762440692311584]
[null,"AUD/SEK",47.442328,0.031150673867332633,70.870415,0.04999457435348281]
[null,"AUD/OTHER ASIAN",697.915221,0.45825174170243876,723.072556,0.510081740933856]
[null,"AUD/OTHER EUROPEAN",107.126966,0.07033965913862472,102.057813,0.07199530185314063]
[null,"AUD/OTHER",134.339726,0.08820758104561872,117.364796,0.08279340568421029]
[null,"EUR/USD",17530.682796,11.510661585785904,19945.324039,14.070158692764727]
[null,"USD/JPY",12774.284878,8.387606571983083,11431.675415,8.06432058454997]
[null,"USD/GBP",9024.07218,5.925213649601036,7054.81744,4.976725408681849]
[null,"USD/CHF",1988.125633,1.305405021458206,1784.332737,1.258733361322916]
[null,"USD/CAD",2390.495905,1.569601692350535,2936.0851,2.071221465827497]
[null,"USD/NZD",12071.798327,7.9263532910229175,11260.532343,7.943590022464402]
[null,"USD/SEK",671.577184,0.44095816367876467,311.653195,0.21985152520876275]
[null,"USD/OTHER ASIAN",13345.571704,8.762713999287865,12647.927505,8.92230914784657]
[null,"USD/OTHER EUROPEAN",745.542825,0.48952406795266973,538.668487,0.3799963881289476]
[null,"USD/OTHER",810.374725,0.5320927499342859,639.809281,0.45134479134915295]
[null,"EUR/JPY",1199.666588,0.7877021260913609,915.509424,0.6458337229926229]
[null,"EUR/GBP",728.276926,0.47818726363785397,1940.01123,1.3685546456137818]
[null,"EUR/CHF",526.475866,0.3456845119570759,370.733187,0.26152870535293393]
[null,"EUR/CAD",341.905768,0.224495624926498,426.425886,0.300816365529633]
[null,"EUR/NZD",226.074258,0.14844055461943637,251.059282,0.17710637000052856]
[null,"EUR/SEK",161.737417,0.10619692880821069,196.215148,0.13841731850964376]
[null,"EUR/OTHER ASIAN",219.187509,0.14391870923054273,67.595624,0.04768441739812117]
[null,"EUR/OTHER EUROPEAN",355.529951,0.23344127534529402,221.443109,0.15621404189557658]
[null,"EUR/OTHER",95.324616,0.06259022585368741,64.09432,0.04521446991492741]
[null,"RESIDUAL CURRENCIES",3189.095256,2.0939627214649685,2892.816689,2.0406983513389396]
[null,"TOTALᵇ",152299.523927,"",141756.212382,""]
[]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 trading days (Oct 2022 calculated on 20 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\nApr 2023\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",4104.340976460962,6536.396778077257,4486.854869734224,6135.071431969152,2998.0159796565163,null,null,1235.5449678114865]
["Against AUD",3205.071710154287,3592.03622440004,2277.5081713961827,3069.4577800908332,2261.282970466565,null,null,608.8706732730111]
["Against USDᶜ",416.25431702005653,2791.4350613799425,2107.9241744742817,2819.5872876606236,630.2837658425505,null,null,540.7015231071603]
["Against EURᶜ",236.04946413188094,46.71829147531547,45.25281802162805,69.43672502412652,47.98040345051187,null,null,10.80857330312449]
["OTHER CURRENCIES",246.96548515473802,106.20720082195956,56.169705842131705,176.58963919356947,58.46883989688893,null,null,75.16419812819062]
["FX Swaps",33488.25802682147,43562.51484285952,5487.901967292379,8910.714733290952,4770.789576716488,null,null,1960.6965046711348]
["Against AUD",18506.063711727613,22161.218342835244,2979.5415044828724,3715.452128551004,2741.0531098517404,null,null,1210.5087729170518]
["Against USDᶜ",14814.28144481182,21201.412754282166,2465.1007383801507,4929.764086613475,1841.9052142533233,null,null,731.0867961108299]
["Against EURᶜ",157.12757333296526,183.63486490438106,36.828904178153486,145.71985155542524,115.8730202486001,null,null,4.718887152799375]
["OTHER CURRENCIES",10.785296949073617,16.248880837727068,6.430820251202676,119.778666571047,71.95823236282438,null,null,14.382048490453686]
["Currency Swaps",0.11048143159434018,2.74482941162e-09,683.6165342431788,1232.8792100916191,317.47707020718866,null,null,2211.796519624818]
["Against AUD",0.11048143159434018,0,462.62025290128537,829.062126190688,277.01180016134845,null,null,1574.6464637387962]
["Against USDᶜ",0,2.74482941162e-09,220.99628134189342,403.81708390093127,40.46527004584019,null,null,637.1500558860217]
["Against EURᶜ",0,0,0,0,0,null,null,0]
["OTHER CURRENCIES",0,0,0,0,0,null,null,0]
["OTC Options",5.853857697143958,68.20016884509303,164.027136678106,190.56339561324035,89.64369002377006,null,null,150.26255273085323]
["Against AUD",2.1123085808676403,26.484795736788648,79.6195784291534,65.43757543490507,52.513969903082106,null,null,66.64927129073538]
["Against USDᶜ",3.7415491162763184,41.69903641132314,80.87155109535044,118.0214043300275,34.360509082507434,null,null,82.80726444933383]
["Against EURᶜ",0,0.01633669698124462,1.648472871901164,4.285154271979559,0.14439561705618167,null,null,0.787612456682254]
["OTHER CURRENCIES",0,0,1.8875342817009844,2.819261576328217,2.624815421124339,null,null,0.018404534101765017]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 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\nApr 2023\n\nTable 6b\nUSD Turnover by Instrument, Counterparty and Currencyᵃ ᵇ ᶜ\nDaily average (US$m)",{"$nulls":12},"RBA Semi-Annual Report on Foreign Exchange Turnover\nApr 2023\n\nTable 6c\nEUR Turnover by Instrument, Counterparty and Currencyᵃ ᵇ ᶜ\nDaily average (US$m)"]
["RBA Semi-Annual Report on Foreign Exchange Turnover\nApr 2023\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",9339.371522604784,820.7658451384805,608.8749670478196,335.648914321237,127.40761881105075,200.54480212423366,366.6904482202347,7.317131765819839,233.59756404747853,73.47575144195098,101.60391000011845,12215.298475523208,null,"Outright Spot",4463.086027584059,3281.188632025301,1788.046983385012,539.3923676822386,1057.2469882118014,1970.655815682812,103.03983714986447,5648.997005947129,217.8817068571399,441.5340150453379,19511.069379570697,null,"Outright Spot",846.0427388376288,534.2235383690964,500.24935758904707,117.4287985697118,71.56493971342228,159.56550077655137,182.28777942446388,343.03359459021965,79.70808499065912,2834.1043328608002,2257.681482132031,36818.15367008674]
["Financial Institutions - Local",1805.3844900451502,214.71736526498898,94.18064308389008,155.2763193140897,25.594885792186133,50.46981394807103,90.12823590727592,4.283128142675843,111.04842796047683,7.803117297958483,22.246632818676392,2581.13305957544,null,"Financial Institutions - Local",441.33435086324454,346.2495677723855,358.43466506770835,98.7633335965372,138.09963331280062,206.69176729003243,13.936659174639185,374.4166052880052,41.975279092546266,87.59906143323525,2107.5009228911345,null,"Financial Institutions - Local",39.37300908416214,45.194943686998855,15.595656176137771,5.204318974182902,7.8958313304759535,16.68361614390521,7.597415789731616,48.981790441074125,3.5205940307291432,190.0471756573977,104.75691576131663,4983.438073885289]
["Financial Institutions - Overseas",6378.993122938056,518.7868966988906,501.07062101383326,143.71978193287634,98.69341042275327,138.786104270687,203.3916574076397,1.633946063616918,89.76267886526806,62.566048591553425,74.57951843281738,8211.983786637993,null,"Financial Institutions - Overseas",3966.411000953673,2909.308401529056,1403.7597639052885,439.5245474242625,904.6654659054017,1665.6388170112668,88.76418109379327,5231.574825472707,174.6519190294629,347.30476493102924,17131.60368725594,null,"Financial Institutions - Overseas",802.7359620895348,486.1239138979919,484.28836589289466,112.19862512851941,57.46723273063879,141.75910546792048,173.78727835879172,291.9528957081072,75.83802162004643,2626.1514008944455,2137.3997314443423,30107.138606232722]
["Non-financial Institutions - Local",1110.0265925177384,82.07639758734997,12.491974356105153,34.383161461182866,3.0285652164450005,10.394305283539518,52.43591291598343,1.3884654215588361,31.126718925227017,2.973836111343327,4.654166405031023,1344.9800962015045,null,"Non-financial Institutions - Local",38.15646581574059,2.635423848650656,8.02663102812567,0.5991040621383921,5.808419107802319,16.46756555128362,0.11404491916486409,10.609117585669976,0.6684257100380021,3.5981022991140335,86.68329992772813,null,"Non-financial Institutions - Local",1.8609246322525226,0.6781477045462131,0.02387767788895883,0.007720832239769433,0.1324068501668078,0.0797759877991472,0.6703863964494164,0.013575957801937225,0.3494693398835468,3.816285379028319,2.424962873438887,1437.9046443816999]
["Non-financial Institutions - Overseas",44.967317103838774,5.185185587250922,1.1317285939910888,2.2696516130880746,0.09075737966635061,0.8945786219361207,20.73464198933562,0.01159213796824181,1.659738296506629,0.13274944109573683,0.12359234359364898,77.2015331082712,null,"Non-financial Institutions - Overseas",17.18420995140061,22.995238875209033,17.825923383889602,0.50538259930048,8.673469885796852,81.85766583022908,0.22495196226714653,32.39645760074693,0.5860830250927138,3.032086381959456,185.2814694958919,null,"Non-financial Institutions - Overseas",2.0728430316792856,2.2265330795595006,0.3414578421256632,0.018133634769714593,6.069468802140721,1.043003176926531,0.23269887949112636,2.0853324832363684,0,14.089470929928911,13.099872052933017,289.67234558702506]
["Outright Forwards",11936.914272943379,993.4725535976161,447.5916355853943,450.4229307049471,103.66325796753284,187.63377668667027,242.67447345990794,30.352653453601107,314.74165584517635,23.55472949521059,16.641293220336863,14747.663232959772,null,"Outright Forwards",1204.6499416520112,871.5123177877774,705.164651800879,161.5417075406792,172.6955519535119,1562.8684341098572,12.103621073891363,4160.113334617183,33.89694476453221,169.17156317594345,9053.718068476266,null,"Outright Forwards",88.38778139912839,91.75563913227147,2.9419784467398125,159.9391811475629,45.60654394214087,0.9562683258168919,26.712966329673343,5.741138562987283,14.248471495809445,436.2899687821304,700.256962608271,24937.928232826438]
["Financial Institutions - Local",3265.481133440902,533.3554522928135,186.2773922371193,332.242063007101,92.04004600089078,106.34489969867957,106.11142586574321,20.972676235098263,212.018758686667,16.135079577002127,12.376177396995976,4883.355104439012,null,"Financial Institutions - Local",258.5203867912827,63.94901885110689,219.65001271705,91.88439726215708,109.54134402545264,83.765415772513,5.8057685286693586,619.4180676094368,8.701281526304733,90.40933051573215,1551.6450235997054,null,"Financial Institutions - Local",0.6165351156435555,14.932661038319205,0.6155575530169893,12.239092604825986,0.964969886542692,0.5388380014553633,0.41574724089200554,2.504127303270013,1.2428830357315759,34.07041177969739,101.62051278708893,6570.691052605504]
["Financial Institutions - Overseas",6433.965533021408,403.7034179681291,239.65754170691335,98.91784095352612,8.071014373222724,73.07331982892966,98.8801165592259,7.673800328972212,82.40205455640128,5.783282983068709,1.471387522185,7453.599309801983,null,"Financial Institutions - Overseas",888.6170976243204,794.9264335371982,473.10701284629386,68.52695295752169,49.16631054914292,1147.984392179795,5.931593101970231,3453.928358298054,21.99763295169825,42.2850841384452,6946.4708681844395,null,"Financial Institutions - Overseas",85.246394124721,67.41456412387619,1.6840777598764516,147.4514091728863,43.8748586369562,0.27130353107717936,18.990843903793408,2.771743574853481,12.458822030850566,380.16401685889076,586.2898945493537,15366.524089394667]
["Non-financial Institutions - Local",1467.059119455,55.558011815260215,21.656701641361607,16.696591554187155,3.552197593419348,8.215557159061051,31.24803042276185,1.7061768895306337,17.877986366157145,1.6274897945050937,2.559705956974683,1627.7575686482187,null,"Non-financial Institutions - Local",36.92932270401239,4.055767746377394,6.324950707961199,0.2925868420650103,9.266658363689302,16.702510532983712,0.2748963982975194,57.842000960225754,3.168888625607479,29.723338586413295,164.58092146763306,null,"Non-financial Institutions - Local",2.1704265532501177,4.811972430189474,0.507683175393947,0.24310194048759556,0.24262304146397964,0.13665710148724258,5.816472919716517,0.30340789043752214,0.5467664292273042,14.7791114816537,3.7154683867523577,1810.833069984258]
["Non-financial Institutions - Overseas",770.4084870260683,0.8556715214131836,0,2.566435190132799,0,0,6.434900612176991,0,2.442856235950914,0.008877140634661414,0.23402234418120366,782.9512500705581,null,"Non-financial Institutions - Overseas",20.583134532395558,8.581097653094915,6.082675529573978,0.8377704789354097,4.7212390152270345,314.41611562456535,0.09136304495425399,28.924907749466612,0.02914166092174602,6.753809935352807,391.0212552244877,null,"Non-financial Institutions - Overseas",0.354425605513709,4.596441539886595,0.13465995845242434,0.005577429363023608,0.5240923771779936,0.009469691797106645,1.489902265271412,0.16185979442626683,0,7.276428661888532,8.631086885076021,1189.8800208420103]
["FX Swaps",41769.5768726954,1392.8629243307907,238.44001967898572,265.11770492084526,60.97312375391453,73.6215371781974,347.50051266110944,9.772542459792263,148.98236256175494,10.09648547233619,16.094523016835222,44333.038608729956,null,"FX Swaps",11573.172146271821,8258.921804180465,6372.50083991208,1284.1002251427706,1126.9693247185926,8172.316697118933,556.4337261887215,3464.679715960067,493.7641742056014,154.26788193930295,41457.12653563835,null,"FX Swaps",261.8196499834441,102.29774843322438,22.95708040809599,63.73383903298804,108.90277457915039,1.1514578829197017,10.186762625418748,4.941085066107644,1.368059133711365,577.3584571450604,223.80679572343487,86591.33039723682]
["Financial Institutions - Local",12647.765825896959,646.6989226450038,157.80062158035696,180.65443035026468,38.8767050410116,33.38706810350155,128.1033806475502,6.37461357068741,101.01182978767085,9.375726386483622,8.737857457267262,13958.786981466757,null,"Financial Institutions - Local",2174.4120607193654,728.3408632082954,1928.0231617117267,227.81288617209512,256.4374536118378,1318.8143569342467,190.64710968692776,513.524590450658,202.1536343063442,73.03342302834534,7613.199539829842,null,"Financial Institutions - Local",152.77968595124264,58.538770751508906,17.00134076135051,4.608569881016815,2.8694334820624308,1.0830126145314276,0.3823377529715257,4.170406277213062,1.235960847693582,242.6695183195909,44.60485962891192,21859.260899245102]
["Financial Institutions - Overseas",27841.95871588096,641.8541151767097,47.31955276904897,39.04469041018006,21.529964720639523,20.28223897086213,174.05327182449764,0.7182183126160124,17.92126358704407,0.401550710098054,4.806344731217242,28809.88992709387,null,"Financial Institutions - Overseas",9173.080514292886,7446.199945803421,4394.398991743691,1055.877913850178,861.6964332119668,6755.492148635154,365.7020852836873,2833.1843378449553,286.1333961772687,78.97603220946236,33250.741799052674,null,"Financial Institutions - Overseas",108.84384853046197,36.77956437408316,5.9230258876564,58.934241751558346,100.26319138553285,0.06844526838827396,6.414010756217181,0.770678788894582,0,317.99700674279273,78.56759909421433,62457.19633198355]
["Non-financial Institutions - Local",1185.5447955887953,95.52468247457242,15.236536900815297,44.36496091284996,0.5664539922634074,19.79393504339832,35.782057470762034,2.679710576488839,29.76263956841702,0.3150793962193539,2.3140107063452833,1431.8848626309273,null,"Non-financial Institutions - Local",39.67330135676046,57.86548670981437,43.76796856721064,0.0006542554631949198,3.3671988338302126,30.103307237821728,0.08453121810637886,37.61643734635441,5.400751811475028,1.4184926373541178,219.29812997419054,null,"Non-financial Institutions - Local",0,6.84791406858314,0,0.16739902674319834,0.13961805180423942,0,0.6298336368670426,0,0.13209828601778292,7.9168630700154035,86.60646416229847,1745.7063198374317]
["Non-financial Institutions - Overseas",94.30753532868417,8.785204034504867,18.083308428764468,1.053623247550583,0,0.15829506043540184,9.56180271829956,0,0.2866296186230008,0.004128979535158793,0.23631012200543597,132.47683753840263,null,"Non-financial Institutions - Overseas",186.00626990280924,26.515508458934182,6.310717889451273,0.408770865034291,5.468239060957723,67.90688431171054,0,80.35435031809926,0.07639191051345501,0.8399340641411368,373.8870667816511,null,"Non-financial Institutions - Overseas",0.19611550173945502,0.13149923904916744,0.03271375908908123,0.023628373669671972,5.630531659750879,0,2.760580479362999,0,0,8.775069012661254,14.027872838010158,529.1668461707252]
["Currency Swaps",2181.3159909152428,105.74553814067977,1.978862873824252,7.751482560494493,0,0,24.72920818796042,0,0,0,0,2321.5210826782018,null,"Currency Swaps",210.59537326221442,297.90539528571156,147.58663645517572,0,22.989910538378698,297.51921649638774,0,14.025815774612866,0,2.160224065641873,992.7825718781229,null,"Currency Swaps",0,0,0,0,0,0,0,0,0,0,0,3314.3036545563245]
["Financial Institutions - Local",883.9865977944237,13.174265746982513,0.6583993831713013,4.452096568882935,0,0,8.250240484017747,0,0,0,0,910.5215999774782,null,"Financial Institutions - Local",175.79844768968212,3.477064422978662,50.26965145377979,0,5.522344740185418,58.801158259836086,0,13.617228667070671,0,2.160224065641873,309.64611929917464,null,"Financial Institutions - Local",0,0,0,0,0,0,0,0,0,0,0,1220.1677192766529]
["Financial Institutions - Overseas",1222.9833848276,16.78714716412134,1.3204634906529507,0,0,0,16.478967703942672,0,0,0,0,1257.5699631863172,null,"Financial Institutions - Overseas",27.791856288488788,291.43052359860275,97.31698500139593,0,17.467565798193277,220.44121925015037,0,0.4085871075421948,0,0,654.8567370443733,null,"Financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,0,1912.4267002306904]
["Non-financial Institutions - Local",37.714850988357874,75.78412522957592,0,3.299385991611558,0,0,0,0,0,0,0,116.79836220954536,null,"Non-financial Institutions - Local",0,0,0,0,0,0,0,0,0,0,0,null,"Non-financial Institutions - Local",0,0,0,0,0,0,0,0,0,0,0,116.79836220954536]
["Non-financial Institutions - Overseas",36.63115730486115,0,0,0,0,0,0,0,0,0,0,36.63115730486115,null,"Non-financial Institutions - Overseas",7.005069284043515,2.99780726413011,0,0,0,18.276838986401327,0,0,0,0,28.27971553457495,null,"Non-financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,0,64.9108728394361]
["OTC Options",254.71016379734144,18.091595937195397,3.938290868319217,0.23804141231139175,0,0.787612456682254,7.842872908066063,0,0.5936390640676331,0,0,286.2022164439834,null,"OTC Options",79.17930750740624,64.75672834461076,10.773068545655827,3.0913330292671444,10.594129964110055,68.43816350131075,0,57.75583087999398,0,43.24104037996977,337.8296021523245,null,"OTC Options",3.4164177321817766,0,0.327449878903037,0.8039491536634986,0,0.06419041519396297,0,1.8141340253002187,0,6.4261412052424935,7.350015813322252,637.8079756148727]
["Financial Institutions - Local",30.46242315514668,0.6562030397654877,0.10037862815667868,0,0,0,0.43614455261172436,0,0,0,0,31.65514937568057,null,"Financial Institutions - Local",3.5422045413162393,15.238199057102863,1.047805095309219,0,3.571622713273347,12.861834128027814,0,11.845586734196466,0,2.0876210436047713,50.194873312830715,null,"Financial Institutions - Local",0,0,0.327449878903037,0,0,0.06419041519396297,0,0.06419041519396297,0,0.455830709290963,0,82.30585339780225]
["Financial Institutions - Overseas",126.24238155490436,10.883699216236211,3.829371764504,0,0,0.787612456682254,7.390630029434312,0,0.07505757690143124,0,0,149.20875259866256,null,"Financial Institutions - Overseas",64.10380264127176,49.5185292875079,8.226339202537313,3.0913330292671444,6.671492794861177,48.62290520416701,0,45.86262556922074,0,39.876770091268305,265.97379782010137,null,"Financial Institutions - Overseas",3.279618269715418,0,0,0.787612456682254,0,0,0,1.7499436101062558,0,5.8171743365039275,7.236305682607453,428.2360304378753]
["Non-financial Institutions - Local",97.66862290312872,6.526813948833122,0.008540475658537987,0.23326619676732,0,0,0.016098326020027774,0,0.5185814871662019,0,0,104.97192333757393,null,"Non-financial Institutions - Local",11.533300324818235,0,0.012093868014274183,0,0.14048564632167604,0.04500019830963938,0,0,0,0.09641197870323485,11.82729201616706,null,"Non-financial Institutions - Local",0.1367994624663586,0,0,0.01633669698124462,0,0,0,0,0,0.15313615944760323,0.07690106257821641,117.0292525757668]
["Non-financial Institutions - Overseas",0.33673618416170037,0.02487973236057659,0,0.004775215544071783,0,0,0,0,0,0,0,0.36639113206634877,null,"Non-financial Institutions - Overseas",0,0,1.486830379795021,0,0.21052880965385398,6.9084239708062976,0,0.04761857657677781,0,1.180237266393455,9.833639003225406,null,"Non-financial Institutions - Overseas",0,0,0,0,0,0,0,0,0,0,0.036809068136582974,10.236839203428337]
["Total AUD Turnover",65481.88882295614,3330.9384571447627,1300.823776054343,1059.1790739198352,292.04400053249816,462.58772844578357,989.4375154372785,47.44232767921321,697.9152215184774,107.12696640949775,134.33972623729053,73903.72361633512,null,"Total USD Turnoverᶜ",17530.682796277513,12774.284877623866,9024.072180098803,1988.1256333949555,2390.4959053863945,12071.7983269093,671.5771844124773,13345.571703178986,745.5428258272735,810.374724606196,71352.52615771577,null,"Total EUR Turnoverᶜ",1199.666587952383,728.2769259345923,526.4758663227859,341.90576790392623,226.07425823471354,161.73741740048192,219.18750837955596,355.5299522446148,95.32461562017993,3854.1788999932337,3189.095256277059,152299.5239303212]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 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 Apr 2023 calculated on 17 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 Apr 2023 calculated on 17 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":20,"n_cols":12,"rows_kept":20,"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],[19,0,19,6]],"flags":["formulas_cached_only"]}
[]
[null,"RBA Semi-Annual Report of Foreign Exchange Turnover\nApr 2023\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"]
["Total notional gross value of settlement obligations for all foreign exchange transactions",null,168269.00368032407,154248.40852033216,124000.89993655922,112901.706366692,36955.758176431555,null,null,34660.94347351552,7312.345567333272,6685.758680124627]
["Turnover to be settled with a single payment ",null,2140.61749947749,"",1341.8226107790895,"",735.1385398186598,null,null,"",63.65634887974085,""]
["Turnover to be settled with at least two payments",null,87597.36882658623,77713.0303604492,57850.34323057789,49763.72068423319,23719.028839491268,null,null,22434.132872650647,6027.996756517076,5515.176803565362]
["Turnover to be settled with four payments",null,78531.01735426033,76535.37815988295,64808.73409520224,63137.98568245881,12501.590797121631,null,null,12226.810600864877,1220.6924619364547,1170.581876559265]
["Turnover settled c",null,132229.3307183209,119309.80699187462,92921.62854386962,82318.89086839909,33374.07500716013,null,null,31406.91739680813,5933.6271672911735,5583.998726667389]
["With risk mitigation",null,71247.27139660878,70208.4115253652,49474.9766896068,48801.437222052446,18841.12026685649,null,null,18516.183435084546,2931.1744401454835,2890.790868228214]
["Via CLS (PvP)",null,57150.01450128244,57128.73785464951,44099.37557587664,44086.20626580094,11511.99262964613,null,null,11503.885293088906,1538.6462957596689,1538.6462957596689]
["Via other PvP or equivalent settlement methods",null,7385.942002687597,7046.347835957651,334.8908905771817,164.35021765796023,6271.682281126893,null,null,6117.342056733413,779.3688309835228,764.6555615662775]
["Via \"same clearer\" or \"on-us\" accounts",null,6711.314892638734,6033.3258347580395,5040.710223152975,4550.880738593547,1057.4453560834675,null,null,894.9560852622246,613.1593134022916,587.4890109022679]
["Without risk mitigation",null,60982.05932171215,49101.39546650941,43446.65185426282,33517.45364634665,14532.954740303638,null,null,12890.733961723583,3002.4527271456896,2693.2078584391743]
["Via \"same clearer\" or \"on-us\" accounts with exposure to settlement risk",null,18414.96510511941,13469.2785036998,14391.089458644085,9883.308676478857,2271.160019425406,null,null,1888.6823943483646,1752.7156270499174,1697.2874328725786]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for Apr 2023 calculated on 17 trading days. \nb Totals and sub-totals may not sum due to rounding. \nc Figures represent turnover settled in April and may include some turnover from March that was settled in April and some turnover from April that settled later.\n"]