{"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 2023 \n    \n  Table 1\nForeign Exchange Turnover by Instrumentᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Oct 2023","Apr 2023"]
[null,"","US$m","US$m"]
[null,"Outright Spot",41556.62367231034,42592.29440056434]
[null,"Outright Forwards",21597.60824201775,25651.07603687852]
[null,"FX Swaps",86085.73494865642,98299.42248365097]
[null,"TRADITIONAL FOREIGN  EXCHANGE TURNOVERᵇ",149241,166545]
[null,"Currency Swaps",4267.181668025585,4386.583543083897]
[null,"OTC Options",820.7085302141093,599.018980123803]
[null,"TOTAL TURNOVER",154330,171532]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated on 21 trading days (Apr 2023 calculated on 17 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 2023\n\nTable 2\nForeign Exchange Turnover by Instrument and Counterpartyᵃ ᵇ\nDaily average (US$m) "]
[]
["","Oct 2023","Apr 2023"]
["","US$m","US$m"]
["Outright Spot",41556.62367231034,42592.29440056434]
["Financial Institutions - Local",5600.272645763588,5508.443202864478]
["Financial Institutions - Overseas",34506.52251067526,35351.251877310795]
["Non-financial Institutions - Local",1358.5852390754785,1431.020174689942]
["Non-financial Institutions - Overseas",91.24327679601181,301.5791456991219]
["Outright Forwards",21597.60824201775,25651.07603687852]
["Financial Institutions - Local",5101.44344398355,6456.588912531934]
["Financial Institutions - Overseas",14538.318899979602,17195.23320255776]
["Non-financial Institutions - Local",1825.422930598798,1778.7421040211714]
["Non-financial Institutions - Overseas",132.42296745580134,220.51181776765407]
["FX Swaps",86085.73494865642,98299.42248365097]
["Financial Institutions - Local",24951.176907053778,18673.550580421816]
["Financial Institutions - Overseas",59285.53868903166,77250.52640143516]
["Non-financial Institutions - Local",1353.1451802685026,1707.2761503031213]
["Non-financial Institutions - Overseas",495.87417230248934,668.0693514908796]
["Currency Swaps",4267.181668025585,4386.583543083897]
["Financial Institutions - Local",1564.1377711310197,1477.1783111836655]
["Financial Institutions - Overseas",2641.419452601604,2721.7889034259324]
["Non-financial Institutions - Local",41.60343425731433,116.79836220954536]
["Non-financial Institutions - Overseas",20.021010035646977,70.81796626475385]
["OTC Options",820.7085302141093,599.018980123803]
["Financial Institutions - Local",49.89917631189301,38.34266075263961]
["Financial Institutions - Overseas",567.0739555700762,430.1702496997354]
["Non-financial Institutions - Local",179.2780780016451,110.41457922463681]
["Non-financial Institutions - Overseas",24.45732033049498,20.09149044679116]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated \n   on 21 trading days (Apr 2023 calculated on 17 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 2023\n\nTable 3\nForeign Exchange Turnover by Currencyᵃ\nDaily average (US$m)"]
[null,"","Oct 2023"," Proportion of Totalᵇ","Apr 2023"," Proportion of Totalᵇ"]
[null,"","US$m","%","US$m","%"]
[null,"AUD",79175.10719897554,51.30318576740528,84302.66509698868,49.14793546492618]
[null,"USD",139404.65097507776,90.33019289561821,154560.6485750244,90.10790789167798]
[null,"EUR",27124.298718390026,17.575763206268977,27612.630211762254,16.09799365302673]
[null,"OTHER CURRENCIES",62951.657230005076,40.790858130707534,76467.13247605877,44.64616299036912]
[null,"TOTAL",154327.8570612242,"",171528.39544430154,""]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated on 21 trading days (Apr 2023 calculated on 17 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 2023 \n\nTable 4\nForeign Exchange Turnover by Currency Pairᵃ ᵇ\nDaily average (US$m)"]
[]
[null,"","Oct 2023","Proportion of Total","Apr 2023"," Proportion of Total"]
[null,"","US$m","%","US$m","%"]
[null,"AUD/USD",71334.737909,46.22285261228247,75191.123821,43.83596291767996]
[null,"AUD/EUR",2426.922798,1.5725759718420302,3469.299194,2.022580101084309]
[null,"AUD/JPY",1819.036077,1.1786829102933785,1534.682773,0.8947106215327151]
[null,"AUD/GBP",1021.648464,0.6619987366222423,1138.077792,0.6634923559104159]
[null,"AUD/CHF",284.790962,0.1845363289710119,327.109855,0.1907030344156514]
[null,"AUD/CAD",322.035672,0.20866982677839646,479.519199,0.2795567449652735]
[null,"AUD/NZD",1062.231624,0.688295453736612,1141.995798,0.665776529320779]
[null,"AUD/SEK",57.137039,0.03702315323241732,52.906754,0.03084431231484115]
[null,"AUD/OTHER ASIAN",597.271309,0.3870145807596623,725.122076,0.42274171230633384]
[null,"AUD/OTHER EUROPEAN",119.615996,0.07750771524853112,108.670499,0.06335423281809413]
[null,"AUD/OTHER",129.679349,0.08402847772890583,134.157336,0.0782129020977375]
[null,"EUR/USD",20484.667733,13.273473838817823,19649.771434,11.455695940551182]
[null,"USD/JPY",9785.174777,6.340511015540304,16041.726807,9.352228105025446]
[null,"USD/GBP",9771.294538,6.331517021024775,8724.619119,5.086399308006502]
[null,"USD/CHF",2017.939089,1.3075663249845972,1849.876014,1.0784663432489066]
[null,"USD/CAD",2843.41345,1.8424499012359807,2387.097442,1.391663132971764]
[null,"USD/NZD",10766.885632,6.976631333476143,15346.755579,8.947064151737731]
[null,"USD/SEK",484.590687,0.31400078782177315,635.908926,0.37073099433276907]
[null,"USD/OTHER ASIAN",10048.361202,6.511048227688576,13279.667636,7.741964589286129]
[null,"USD/OTHER EUROPEAN",899.322511,0.5827350474027069,722.480241,0.42120153874315747]
[null,"USD/OTHER",968.263447,0.6274067854238926,731.621556,0.42653086918796873]
[null,"EUR/JPY",1336.341857,0.8659109783866138,1653.267866,0.9638450016985534]
[null,"EUR/GBP",1232.415027,0.7985693901735917,765.899497,0.44651469805249705]
[null,"EUR/CHF",464.490311,0.300976323941571,575.531537,0.3355313477418886]
[null,"EUR/CAD",129.562718,0.08395290420496718,347.955317,0.20285581060515553]
[null,"EUR/NZD",218.432223,0.1415377801258926,284.219765,0.16569837563103487]
[null,"EUR/SEK",140.000782,0.09071646860531664,161.992373,0.09444055754080548]
[null,"EUR/OTHER ASIAN",171.001954,0.11080433387499793,240.730337,0.140344306477108]
[null,"EUR/OTHER EUROPEAN",444.091684,0.28775860201601017,364.194025,0.21232287753467288]
[null,"EUR/OTHER",76.37163,0.049486613405001253,99.768869,0.058164637254715594]
[null,"RESIDUAL CURRENCIES",2870.12861,1.859760554353804,3362.646009,1.9604019499259042]
[null,"TOTALᵇ",154327.857061,"",171528.395446,""]
[]
[]
[null,"a Adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated on 21 trading days (Apr 2023 calculated on 17 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 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",3568.0587034130335,4429.315540109674,4230.144148223768,5544.66484551556,3557.4766167927355,null,null,1424.0729187143863]
["Against AUD",2707.641141047526,2679.8432585948926,2416.465600366255,3339.785231132935,2499.1971742748665,null,null,532.3773561493256]
["Against USDᶜ",667.235472908559,1639.8228860272243,1649.5250782176195,2038.705875923296,960.1702807482525,null,null,871.5212571312679]
["Against EURᶜ",127.77830417583773,29.83453185083273,112.44425467350675,91.76023020071541,14.829448810939166,null,null,6.815649024451625]
["OTHER CURRENCIES",65.40378528111069,79.81486363672428,51.709214966386334,74.41350825861389,83.27971295867731,null,null,13.358656409341188]
["FX Swaps",47766.3973879113,34781.97624275364,6119.920949988842,8634.525603912085,5333.278056200784,null,null,2508.662356587402]
["Against AUD",22565.11029517491,18461.000891676656,3928.0260027908303,4673.36330781695,3338.929155837994,null,null,1538.7757189978722]
["Against USDᶜ",24375.065551872496,16091.91552789779,2133.145244005493,3909.4238806978137,1824.7117667536804,null,null,939.743466729545]
["Against EURᶜ",479.1427844135233,180.47390802300959,45.68708263458985,21.467844043078124,61.37002708015297,null,null,29.256079151560467]
["OTHER CURRENCIES",347.07875645036995,48.58591515618379,13.062620557928016,30.270571354243856,108.26710652895633,null,null,0.8870917084243819]
["Currency Swaps",2.4378500815475705,88.24007320208443,846.4949264258474,279.13479611465715,981.7436327648561,null,null,3560.7807995151015]
["Against AUD",0,85.85695530415164,391.7824434758389,246.95497425350672,981.7436327648561,null,null,2949.1081431604553]
["Against USDᶜ",2.4378500815475705,2.3831178979327863,447.560710154239,32.17982186115042,0,null,null,607.3154182771651]
["Against EURᶜ",0,0,0,0,0,null,null,4.357238077481271]
["OTHER CURRENCIES",0,0,7.151772795769571,0,0,null,null,0]
["OTC Options",10.715532478815286,104.54114981719033,111.58786528202144,283.7326508296624,155.48686528307357,null,null,187.87651871133477]
["Against AUD",10.474701194270443,62.41297311864961,68.84237322532044,146.1795953403802,84.48877429435669,null,null,117.53395504008304]
["Against USDᶜ",0.2408312845448435,37.59561614163688,38.27888754548082,129.09956549723844,62.52986245715473,null,null,64.85868446241932]
["Against EURᶜ",0,4.5325605569038485,2.7484922663784497,8.32416337486643,8.338459098602955,null,null,2.5198979591562147]
["OTHER CURRENCIES",0,0,1.7181122448417139,0.12932661717733773,0.12976943295921348,null,null,2.9639812496761775]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated on 21 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 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\nOct 2023\n\nTable 6c\nEUR Turnover by Instrument, Counterparty and Currencyᵃ ᵇ ᶜ\nDaily average (US$m)"]
["RBA Semi-Annual Report on Foreign Exchange Turnover\nOct 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",14747.408023093885,639.6841994752904,542.0465178499666,257.7901074647304,43.47408717039249,119.41183830189289,396.2325614303811,25.72903400152159,153.09059973294205,95.20434897298283,86.14828384006844,17106.219601334054,null,"Outright Spot",3962.7540780876825,2950.1770679134847,1927.5950120858704,646.6539692917424,1397.0512242840762,2699.624022763696,110.91358812253745,4722.941859502485,362.6592779107096,534.8219634261425,19315.192063388426,null,"Outright Spot",777.4902513552692,1093.822005141612,404.881139549104,69.22626678024444,102.01012021267628,136.68701307666265,79.22755833194897,395.01462262299174,72.00525707578316,3130.3642341462923,2004.8477734415692,41556.62367231034]
["Financial Institutions - Local",2903.1527496836684,107.99935481734582,91.27377651913619,79.58355972265595,14.467453823672288,23.910662000517306,101.4779825534512,2.4419301202168104,37.39803026513374,3.450545085087983,6.531651264712298,3371.6876958555977,null,"Financial Institutions - Local",416.73831269683586,392.9305971599501,375.9134628817409,61.863821775292465,154.495591186587,140.76263457967283,13.042126492325005,256.27281539026865,60.427610741058224,69.9298283712428,1942.3768012749738,null,"Financial Institutions - Local",25.610150659865063,58.89914126972937,9.573240186433328,3.0678637354140603,19.6128693211124,11.799107964064243,4.141256420255026,60.25886450634569,1.756150160510741,194.7186442237299,91.48950440928652,5600.272645763588]
["Financial Institutions - Overseas",10813.952948255625,459.773951664269,439.934956028735,146.3929939721585,27.030507873720307,80.65193394052517,253.38188025317646,22.289059614556002,88.3825195464533,89.38824408060444,67.86975627635687,12489.04875150618,null,"Financial Institutions - Overseas",3523.6471710370615,2544.206876432491,1517.7947425216662,583.9901703877197,1226.105454377006,2498.4320623953026,97.26212520553302,4448.255414846422,301.4541058277773,445.96648779556887,17187.11461082655,null,"Financial Institutions - Overseas",749.7554534109252,1034.2863957521547,395.29368441268775,66.10961494088554,81.71075466958982,124.88594043885183,74.70366772459452,334.6214524743773,69.54552571535041,2930.912489539417,1899.4466588031194,34506.52251067526]
["Non-financial Institutions - Local",1009.4005281857345,71.05180953287368,10.394119863548704,31.55055798484392,1.9445538025167755,14.770772432117665,38.38408395978821,0.9623300352328822,25.877691938155536,2.364417537560651,11.57034792173302,1218.2712131941057,null,"Non-financial Institutions - Local",19.02194303089201,9.391363609122443,30.926010168942526,0.48045103809778716,14.12413614328242,30.266742982213774,0.6017715599472264,3.5750316871351493,0.7522143837496691,18.134824720957184,127.2744893243402,null,"Non-financial Institutions - Local",2.123338308385882,0.3652246402687794,0.00990589423702715,0.0476819998027016,0.45070934721110195,0.0013292058701915258,0.16211785628217004,0.1336591977894274,0.6888803470409267,3.9828467968882078,9.056689760144407,1358.5852390754785]
["Non-financial Institutions - Overseas",20.90179696885748,0.8590834608018791,0.443665438546689,0.2629957850720592,0.0315716704831126,0.07846992873274754,2.9886146639652047,0.03571423151589655,1.4323579831994624,0.0011422697297528742,0.17652837726625012,27.211940778170536,null,"Non-financial Institutions - Overseas",3.3466513228934174,3.6482307119211668,2.9607965135207532,0.3195260906325803,2.3260425772007447,30.162582806506794,0.007564864732184102,14.838597578659375,0.025346958124379777,0.7908225383736677,58.42616196256506,null,"Non-financial Institutions - Overseas",0.0013089760930891238,0.27124347945912936,0.004309055745858775,0.0011061041421479734,0.23578687476297558,0.0006354678764042756,0.22051633081725197,0.0006464444793411714,0.014700852881077852,0.7502535862572761,4.8549204690189445,91.24327679601181]
["Outright Forwards",10874.43685809189,671.8874611425716,650.6339402151686,389.2758164721453,178.58573963014467,144.4506610310117,173.0646965488313,25.228532907429525,302.7500124880763,16.941490293987716,35.40621523566275,13462.66142405692,null,"Outright Forwards",1411.5984018271022,647.168088033252,775.5999615922785,62.55976074180225,155.2793357369846,1176.6691274799896,6.1589775776173505,3038.528432312089,26.524882012598606,167.7903441962032,7467.8773115099175,null,"Outright Forwards",153.6006201815983,25.164856966392577,8.809637667943672,35.63940826268332,43.16503448950263,0.440090405465888,42.64475399120455,11.761466644916311,2.8803622860173457,324.1062308957246,342.9632755551896,21597.60824201775]
["Financial Institutions - Local",2805.403823941466,357.2023016632559,231.8445368221028,190.42005626449887,118.20706546203834,92.28584166121433,57.85022201259876,15.102442219522354,203.68805728757323,14.613874458606919,27.52727344903168,4114.145495241909,null,"Financial Institutions - Local",88.07035168919039,104.74780912623989,159.18881087569062,18.510536124112594,43.97696912513346,34.88414319511946,1.65274839601798,324.88578988300145,4.206662656790341,72.38584342836364,852.5096644996598,null,"Financial Institutions - Local",50.385448257463764,8.763595454608689,2.0113347466804203,1.0703382451077752,2.6922135819265627,0.007843951669207823,5.29799098884395,5.712737758135691,0.8351518439809504,76.77665482841701,58.01162941356456,5101.44344398355]
["Financial Institutions - Overseas",6689.321546261408,271.3934300502112,374.72231615607643,170.8634993327456,57.640649641174036,45.338533987381204,96.24208662710221,9.197091797562198,80.5554942443732,1.2034848553016941,4.803317086008721,7801.281450039345,null,"Financial Institutions - Overseas",1230.7228890437548,538.959180779231,507.0337852648074,43.81016731629251,94.14095430523484,1086.7533019366713,4.155005017842041,2647.359593489258,20.782050461236103,66.7491344764086,6240.466062090736,null,"Financial Institutions - Overseas",102.4352644935968,14.9254457192499,6.425334991472327,34.21589323530982,37.742675928038786,0.3283136949938212,33.16425020905401,5.603218671915627,0.4292431842131477,235.26964012784424,261.3017477216767,14538.318899979602]
["Non-financial Institutions - Local",1369.0092269895015,42.43412045432865,44.04572907576064,27.438701819597412,2.624428591846739,6.826285382416145,14.199371655771108,0.9289988903449735,18.292635801067778,1.1241309800791037,2.9880362730143406,1529.9116659137283,null,"Non-financial Institutions - Local",67.77137197049667,2.709913572670723,106.52322732614465,0.23809480116360937,6.2688360626532535,38.46227096089053,0.35105023029640825,30.073357491080777,1.5320762880176861,25.93705740304667,279.86725610646096,null,"Non-financial Institutions - Local",0,0.14835338429053396,0.06104504211601097,0.16136225043406274,0.6223721512922101,4.309118040760202e-05,0.0020246069663930246,0.0005199929416040162,0.01743149349586928,1.0131520127170917,14.6308565658916,1825.422930598798]
["Non-financial Institutions - Overseas",10.70226089951459,0.8576089747758695,0.021358161228775225,0.5535590553034382,0.11359593508554304,0,4.773016253359215,0,0.21382515506215108,0,0.08758842760800956,17.32281286193759,null,"Non-financial Institutions - Overseas",25.033789123660483,0.7511845551104651,2.8541381256358456,0.0009625002335397755,10.892576243963042,16.569411387308342,0.00017393346092180135,36.209691448749325,0.004092606554475073,2.71830888838428,95.03432881306072,null,"Non-financial Institutions - Overseas",0.7799074305377061,1.3274624082434565,0.3119228876749142,0.19181453183166053,2.1077728282450794,0.1038896676224514,4.180488186340199,0.4449902219233892,1.5985357643273783,11.046783926746235,9.019041854056791,132.42296745580134]
["FX Swaps",41922.368074358885,1090.6557003514606,619.304786271679,372.80700070888196,62.7156939723995,57.45219240097772,450.53628001177617,6.179472237657234,130.3482940248061,7.470156388067256,8.119262200405029,44727.956912927,null,"FX Swaps",14851.11856153176,5769.107740747624,6973.388540901915,1304.429728664958,1282.841043920508,6599.334192381345,367.4652037382763,2229.982015670927,498.4884094391914,239.49040646989087,40115.645843466395,null,"FX Swaps",402.7499754159127,109.76059188450897,44.77532547115113,16.633369602863525,73.18116663728186,2.823330778540456,40.91331134283129,36.01971213627097,1.4749232435691206,728.3317065129299,513.8004857500979,86085.73494865642]
["Financial Institutions - Local",13181.375901815785,643.9730671145097,289.24547370680165,189.360970796518,40.54934042726913,29.144213023329797,180.71334765355388,5.120342706162069,68.73025154937031,4.352461943899221,4.148862766787412,14636.714233503988,null,"Financial Institutions - Local",2832.7453987317986,1275.2289046018755,2987.3990974904764,524.9514942506199,402.8783967453576,1159.7993960716685,167.52157948580057,292.60882848490047,342.3509575269156,81.96160004985285,10067.445653439267,null,"Financial Institutions - Local",56.82457037671341,27.96629322225342,16.72182635967404,12.811698748552073,53.53781153370421,0.07288901830490738,0.11359338188360453,9.237807277256472,0.6292807568277548,177.91577067516988,69.10124943535283,24951.176907053778]
["Financial Institutions - Overseas",27705.731254757597,369.8957737525216,209.71976742960243,134.31989912429668,21.76149784261909,7.840954288556271,213.66889326449416,0.09174535171141461,26.56050815886988,1.9061546942781222,1.2979544605272118,28692.794403125074,null,"Financial Institutions - Overseas",11856.104076182357,4477.954133869534,3966.007972519145,779.0071110563146,871.7693127881711,5339.818254514952,199.25819140491348,1901.099707162296,153.42083415761437,153.79160191949987,29698.231195574797,null,"Financial Institutions - Overseas",311.8935742351852,75.9828228811417,28.05349911147709,3.8216708543114493,17.981830408294265,2.7504417602355486,38.74560152509019,26.650057598859114,0.31730875644946877,506.19680713104407,388.3162832007393,59285.53868903166]
["Non-financial Institutions - Local",867.5805932752545,72.18687883500598,116.19716884326,48.15911319294996,0.4048557025112821,20.467025089091653,45.65970488160237,0.9673841797837499,34.955423414637764,1.211539749889913,2.672444973090406,1210.4621321370776,null,"Non-financial Institutions - Local",14.544925434889228,14.60314302128693,10.911408673272787,0.1721581182085213,2.256339051416777,23.212620154799264,0,22.89234671077373,2.680714409795106,2.447747909007622,93.72140348344996,null,"Non-financial Institutions - Local",1.109851538045362,5.712574997370117,0,0,1.1722411684906184,0,2.0323297005027423,0,0.008164469414786326,10.035161873823627,38.92648277415151,1353.1451802685026]
["Non-financial Institutions - Overseas",167.6803245102508,4.599980649423196,4.142376292014899,0.9670175951173196,0,0,10.494334212125755,0,0.1021109019281657,0,0,187.98614416086014,null,"Non-financial Institutions - Overseas",147.72416118271613,1.3215592549267279,9.070062219021057,0.2989652398151257,5.936995335562493,76.50392163992491,0.6854328475622058,13.38113331295693,0.03590334486631515,1.2894565915305487,256.24759096888243,null,"Non-financial Institutions - Overseas",32.92197926596866,0.09890078374373078,0,0,0.4892835267927756,0,0.021786735354761298,0.13184726015538387,0.5201692608771108,34.18396683289242,17.456470339854327,495.87417230248934]
["Currency Swaps",3358.4462624183466,16.67102892365043,2.373037552634693,1.5498884387315712,0,0,20.44192213063445,0,8.389889359256005,0,0,3407.8720288232535,null,"Currency Swaps",165.50460255032178,326.7883096954994,86.2841999297479,0,3.465027932294161,235.64361372563184,0,21.2750952852145,11.154933091567642,2.074833581598072,852.1906157918753,null,"Currency Swaps",2.3954615664820915,1.1476754460894325,0,0,0,0,0,0,0,3.543137012571524,3.5758863978847857,4267.181668025585]
["Financial Institutions - Local",1297.734477185983,0.7758665020173141,1.4242212517166868,1.5498884387315712,0,0,1.2700285714,0,3.5681755100935706,0,0,1306.322657459942,null,"Financial Institutions - Local",117.7026300336859,9.790725687539037,30.462996029899713,0,0,63.45951864151562,0,18.7794891424135,11.154933091567642,2.074833581598072,253.4251262082195,null,"Financial Institutions - Local",0.8141010649732483,0,0,0,0,0,0,0,0,0.8141010649732483,3.5758863978847857,1564.1377711310197]
["Financial Institutions - Overseas",2005.791349500142,15.895162421633115,0.9488163009180062,0,0,0,19.17189355923445,0,2.4108569245812164,0,0,2044.2180787065085,null,"Financial Institutions - Overseas",47.801972516635864,313.85210781789135,55.821203899848186,0,3.465027932294161,172.18409508411622,0,2.495606142801,0,0,595.6200133935868,null,"Financial Institutions - Overseas",1.5813605015088432,0,0,0,0,0,0,0,0,1.5813605015088432,0,2641.419452601604]
["Non-financial Institutions - Local",39.19257733273312,0,0,0,0,0,0,0,2.4108569245812164,0,0,41.60343425731433,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,41.60343425731433]
["Non-financial Institutions - Overseas",15.72785839948854,0,0,0,0,0,0,0,0,0,0,15.72785839948854,null,"Non-financial Institutions - Overseas",0,3.145476190069006,0,0,0,0,0,0,0,0,3.145476190069006,null,"Non-financial Institutions - Overseas",0,1.1476754460894325,0,0,0,0,0,0,0,1.1476754460894325,0,20.021010035646977]
["OTC Options",432.0786908044983,8.02440842512597,4.677795215980484,0.22565114561443075,0.015441098114622626,0.7209802469184361,21.95616359030808,0,2.6925131820475645,0,0.00558812571416,470.39723183432204,null,"OTC Options",93.69208937416194,91.93357109107136,8.426823304367382,4.295629965277064,4.776817704085656,55.614675930866845,0.052917857120499526,35.63379944636219,0.4950087550757854,24.085898725261192,319.0072321536499,null,"OTC Options",0.10554862733050265,2.5198979591562147,6.024208448708681,8.063673469198285,0.0759020479945096,0.05034756123242878,8.216330187819466,1.2958827244515712,0.011087107487879149,26.36287813337954,4.94118809275778,820.7085302141093]
["Financial Institutions - Local",27.20757486800814,0.03325491193092187,0.10625467253616105,0.00013175035094275034,0,0,0.007146843845110648,0,0,0,0,27.354363046671278,null,"Financial Institutions - Local",0.5276533427114496,12.894022751581618,1.4537872841261432,0.7100064489666429,0.7151453776403702,2.916951743689407,0,3.047840030798101,0,0.17871116324314246,22.444118142756874,null,"Financial Institutions - Local",0,0,0,0,0,0.05034756123242878,0,0.05034756123242878,0,0.10069512246485755,0,49.89917631189301]
["Financial Institutions - Overseas",227.7007894022891,4.800853625622593,4.325126176341773,0.07089066498813376,0,0.6045831008740046,20.109508975122964,0,2.5373107011882388,0,0.00558812571416,260.154650772141,null,"Financial Institutions - Overseas",92.17666618097026,79.03954833948974,6.957374481489438,3.585623516310421,4.061672326445286,38.85364678049198,0.052917857120499526,30.282372279258244,0.4950087550757854,21.83128745519422,277.33611797184585,null,"Financial Institutions - Overseas",0,2.5198979591562147,6.024208448708681,8.063673469198285,0,0,8.216330187819466,1.2455351632191425,0.011087107487879149,26.08073233558967,3.5024544904996877,567.0739555700762]
["Non-financial Institutions - Local",173.73923379556138,0.9871605204268464,0.24641436710254935,0.12832891816544303,0.015441098114622626,0.11639714604443145,1.8395077713400072,0,0.15520248085932561,0,0,177.22768609761462,null,"Non-financial Institutions - Local",0.9425869511769478,0,0.000162926504302049,0,0,0,0,0,0,1.0020933990187277,1.9448432766999775,null,"Non-financial Institutions - Local",0.10554862733050265,0,0,0,0,0,0,0,0,0.10554862733050265,0,179.2780780016451]
["Non-financial Institutions - Overseas",3.431092738639673,2.2031393671456083,0,0.026299812109911197,0,0,0,0,0,0,0,5.6605319178951925,null,"Non-financial Institutions - Overseas",0.045182899303289246,0,0.015498612247498475,0,0,13.844077406685456,0,2.3035871363058424,0,1.0738067078050986,17.282152762347184,null,"Non-financial Institutions - Overseas",0,0,0,0,0.0759020479945096,0,0,0,0,0.0759020479945096,1.4387336022580919,24.45732033049498]
["Total AUD Turnover",71334.7379087675,2426.922798318099,1819.0360771054293,1021.6484642301037,284.79096187105125,322.0356719808007,1062.231623711931,57.13703914660835,597.2713087871281,119.61599565503779,129.67934940185037,79175.10719897554,null,"Total USD Turnoverᶜ",20484.66773337103,9785.174777480932,9771.29453781418,2017.9390886637798,2843.4134495779485,10766.88563228153,484.59068729555156,10048.361202217078,899.3225112091429,968.2634463990959,68069.91306631027,null,"Total EUR Turnoverᶜ",1336.3418571465927,1232.415027397759,464.49031113690745,129.56271811498956,218.4322233874553,140.00078182190143,171.00195385380428,444.0916841286306,76.3716297128575,4212.708186700898,2870.1286092374994,154327.8570612242]
[]
[]
["a Adjusted for reporting dealer double counting. Daily average for Oct 2023 calculated on 21 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 2023 calculated on 21 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 2023 calculated on 21 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\nOct 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,180514.49967768067,171481.53884348393,142945.98030170114,135861.73923017067,32046.463972801765,null,null,30488.699522825595,5522.055403177751,5131.10009048766]
["    Turnover to be settled with a single payment",null,2135.353227151435,"",1622.0302066109634,"",490.5909747253832,null,null,"",22.732045815088604,""]
["    Turnover to be settled with at least two payments",null,87272.7944526321,82076.91191139359,67157.60718129849,62914.26564437832,15324.423306716735,null,null,14722.231056558228,4790.763964616857,4440.415210457031]
["    Turnover to be settled with four payments",null,91106.35199789713,89404.62693209035,74166.34291379168,72947.47358579235,16231.449691359645,null,null,15766.468466267364,708.5593927458052,690.6848800306291]
["Turnover settled",null,"148,446","143,571","119,897","116,124","24,266",null,null,"23,424","4,283","4,024"]
["    With risk mitigation",null,124235.7282552247,122856.26541815732,102082.55984362037,101197.72961563365,18845.42283318318,null,null,18384.972241999665,3307.745578421142,3273.5635605239927]
["    Via CLS (PvP)",null,90835.54611474504,90832.64702989906,77013.9829079086,77012.61440540396,11752.802327172147,null,null,11751.271744830803,2068.7608796642967,2068.7608796642967]
["    Via other PvP or equivalent settlement methods",null,6197.72141483126,5407.376595108404,1716.0026121733417,1205.531764280323,3617.7651514647528,null,null,3361.466674180072,863.9536511931649,840.378156648009]
["    Via \"same clearer\" or \"on-us\" accounts",null,27202.460725648394,26616.241793149846,23352.574323538436,22979.583445949367,3474.855354546279,null,null,3272.233822988789,375.03104756368066,364.42452421168707]
["    Without risk mitigation",null,24210.734349834278,20715.094904162062,17814.525138597703,14926.253179595447,5420.86861075244,null,null,5038.623336844546,975.3406004841352,750.2183877220681]
["    Via \"same clearer\" or \"on-us\" accounts with exposure to settlement risk",null,8465.855339855625,6987.360802722915,7998.81551376624,6592.674259076683,375.7086233818355,null,null,310.13087233618177,91.33120270755009,84.55567131005105]
[]
[]
["a Not adjusted for reporting dealer double counting. Daily average for October 2023 calculated on 21 trading days. \nb Totals and sub-totals may not sum due to rounding. "]