{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Disclaimer","Overview","Converter1","Converter2","Referential_Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,0,7,6],[14,0,17,7],[5,0,5,6]]}
[]
[]
[]
[]
[]
["CAC TRF converter version 1.2"]
[]
["Update date: 06 March 2019"]
[]
[]
[]
[]
[]
["Disclaimer:"]
["This publication is for information purposes only and is not a recommendation to engage in investment activities. The content of this publication is provided “as is” without representation or warranty of any kind. Whilst all reasonable care has been taken to ensure the accuracy of the content, Euronext does not guarantee its accuracy or completeness. Euronext will not be held liable for any loss or damages of any nature ensuing from using, trusting or acting on information provided. The creation of rights and obligations in respect of financial products that are traded on the exchanges operated by Euronext’s subsidiaries shall depend solely on the applicable rules of the market operator. Those wishing either to trade in any products available at Euronext or to offer and sell them to others should consider both their legal and regulatory position in the relevant jurisdiction and the risks associated with such products before doing so. Potential users of Euronext contracts should familiarise themselves with the full contract specifications of the product concerned and any associated information. All proprietary rights and interest in or connected with this publication shall vest in Euronext. No part of it may be redistributed or reproduced in any form without the prior written permission of Euronext.\n© 2019, Euronext N.V. - All rights reserved."]

{"sheet":"Overview","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["If you know 1) the customised index level 2) the basis price (in bps), and you want to know about the TAM price/Order Entry price, please use Converter1"]
[]
[]
[]
[]
["If you know 1) the TAM price/Clearing price 2) the customised index level, and you want to know about the basis price (in bps), please use Converter2"]
[]
[]
[]
[]
["If there is an issue loading the data, please try the following steps:"]
["1) Save & Close Excel completely."]
["2) From the Windows Start Menu, select Stop API Process."]
["3) From the Windows Start Menu, select All Programs > Bloomberg > API Environment Diagnostics. The API Environment Diagnostic tool appears."]
["4) Click the \"Start\" button. The diagnostic tool tests your add-in."]
["5) If any red icons appear, click the \"Repair\" button. The diagnostic tool attempts to resolve the issues."]
["6) When the repair completes, re-open Excel."]
[]
[]
["In case of questions or comments, please click this button and drop us an email:"]
[]
[null,"yli@euronext.com;calliot@euronext.com;tmeynadier@euronext.com"]
[]
["Or by phone:"]
["Yiyang Li: +33 (0)1 70 47 28 42"]
["Charlotte Alliot: +33 (0)1 70 48 28 43"]
["Thibault Meynadier: +33(0)1 70 48 28 47"]

{"sheet":"Converter1","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,20,3],[0,0,0,3],[19,0,19,3],[11,1,12,2]]}
["Input"]
[]
["Step 1: Load data ==>"]
[]
[]
["Step 2: Choose the maturity ==>","2031-12-19"]
[]
[]
["Step 3: What is the customised index level/hedge price ==>","Customised CAC 40 Index level",7000]
["Step 4: What is the basis price ==>","Basis price in BPS",15]
[]
[null,"Below 3 values are loaded with today's value; if you are calculating a trade from a previous date, please manually update the below three values. The result will be updated automatically."]
[]
["Accrued distribution - real time",{"$f":"_xll.BDP(\"TRCA Index\",\"ACCRUED_DISTRIBUTIONS\")","v":988.14}]
["Accrued funding - real time",{"$f":"_xll.BDP(\"TRCA Index\",\"ACCRUED_FUNDING\")","v":-75.689059999999998}]
["DaysToMaturity -  real time",{"$f":"VLOOKUP(B6,Referential_Data!C:G,5,0)","v":3254}]
[]
[]
[]
["Result"]
["TAM price/TRF price/Clearing notation ==>",{"$f":"C10*B16/360/10000*C9+C9+B14-B15","v":8158.7373933333338},null,null,"This is the price to be entered for a TAM trade"]

{"sheet":"Converter2","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,3],[19,0,19,3],[20,1,20,3],[11,1,12,2]]}
["Input"]
[]
["Step 1: Load data ==>"]
[]
[]
["Step 2: Choose the maturity ==>","2031-12-19"]
[]
[]
["Step 3: What is the TAM price traded ==>","TAM price",5442.9860547777771]
["Step 4: What is the customised index level/hedge price ==>","Customised CAC 40 Index level",5080]
[]
[null,"Below 3 values are loaded with today's value; if you are calculating a trade from a previous date, please manually update the below three values. The result will be updated automatically."]
[]
["Accrued distribution - real time",{"$f":"_xll.BDP(\"TRCA Index\",\"ACCRUED_DISTRIBUTIONS\")","v":988.14}]
["Accrued funding - real time",{"$f":"_xll.BDP(\"TRCA Index\",\"ACCRUED_FUNDING\")","v":-75.689059999999998}]
["DaysToMaturity -  real time",{"$f":"VLOOKUP(B6,Referential_Data!C:G,5,0)","v":3254}]
[]
[]
[]
["Result"]
["TAIC price/Basis price/Trading notation ==>",{"$f":"10000*(C9-C10-B14+B15)*360/(C10*B16)","v":-152.63073060896599}]

{"sheet":"Referential_Data","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"COUNTA(B3:B102)+6","v":31},"FUT_CHAIN_LAST_TRADE_DATES","Last tradable date","Expiry + 2 BD","Date of Today","T + 2 BD","DaysToMaturity"]
["TRCA Index",{"$f":"_xll.BDS($A3,B$2,\"cols=2;rows=25\")","v":"TRCH3 Index"},"2023-03-17",{"$f":"_xll.BADDPERIODS(C3, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-03-21"},{"$f":"TODAY()","v":"2023-01-23"},{"$f":"_xll.BADDPERIODS(E3, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},{"$f":"D3-F3","v":55}]
[null,"TRCM3 Index","2023-06-16",{"$f":"_xll.BADDPERIODS(C4, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-06-20"},{"$f":"TODAY()","v":"2023-01-23"},{"$f":"_xll.BADDPERIODS(E4, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},{"$f":"D4-F4","v":146}]
[null,"TRCU3 Index","2023-09-15",{"$f":"_xll.BADDPERIODS(C5, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-09-19"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E5, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},237]
[null,"TRCZ3 Index","2023-12-15",{"$f":"_xll.BADDPERIODS(C6, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-12-19"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E6, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},328]
[null,"TRCH4 Index","2024-03-15",{"$f":"_xll.BADDPERIODS(C7, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2024-03-19"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E7, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},419]
[null,"TRCM4 Index","2024-06-21",{"$f":"_xll.BADDPERIODS(C8, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2024-06-25"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E8, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},517]
[null,"TRCU4 Index","2024-09-20",{"$f":"_xll.BADDPERIODS(C9, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2024-09-24"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E9, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},608]
[null,"TRCZ4 Index","2024-12-20",{"$f":"_xll.BADDPERIODS(C10, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2024-12-24"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E10, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},699]
[null,"TRCH5 Index","2025-03-21",{"$f":"_xll.BADDPERIODS(C11, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2025-03-25"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E11, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},790]
[null,"TRCM5 Index","2025-06-20",{"$f":"_xll.BADDPERIODS(C12, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2025-06-24"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E12, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},881]
[null,"TRCU5 Index","2025-09-19",{"$f":"_xll.BADDPERIODS(C13, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2025-09-23"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E13, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},972]
[null,"TRCZ5 Index","2025-12-19",{"$f":"_xll.BADDPERIODS(C14, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2025-12-23"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E14, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1063]
[null,"TRCH6 Index","2026-03-20",{"$f":"_xll.BADDPERIODS(C15, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2026-03-24"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E15, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1154]
[null,"TRCM6 Index","2026-06-19",{"$f":"_xll.BADDPERIODS(C16, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2026-06-23"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E16, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1245]
[null,"TRCU6 Index","2026-09-18",{"$f":"_xll.BADDPERIODS(C17, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2026-09-22"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E17, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1336]
[null,"TRCZ6 Index","2026-12-18",{"$f":"_xll.BADDPERIODS(C18, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2026-12-22"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E18, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1427]
[null,"TRCH7 Index","2027-03-19",{"$f":"_xll.BADDPERIODS(C19, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2027-03-23"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E19, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1518]
[null,"TRCM7 Index","2027-06-18",{"$f":"_xll.BADDPERIODS(C20, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2027-06-22"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E20, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1609]
[null,"TRCU7 Index","2027-09-17",{"$f":"_xll.BADDPERIODS(C21, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2027-09-21"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E21, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1700]
[null,"TRCZ7 Index","2027-12-17",{"$f":"_xll.BADDPERIODS(C22, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2027-12-21"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E22, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1791]
[null,"TRCH8 Index","2028-03-17",{"$f":"_xll.BADDPERIODS(C23, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2028-03-21"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E23, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},1882]
[null,"TRCZ8 Index","2028-12-15",{"$f":"_xll.BADDPERIODS(C24, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2028-12-19"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E24, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},2155]
[null,"TRCZ9 Index","2029-12-21",{"$f":"_xll.BADDPERIODS(C25, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2029-12-27"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E25, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},2528]
[null,"TRCZ0 Index","2030-12-20",{"$f":"_xll.BADDPERIODS(C26, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2030-12-24"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E26, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},2890]
[null,"TRCZ1 Index","2031-12-19",{"$f":"_xll.BADDPERIODS(C27, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2031-12-23"},"2023-01-23",{"$f":"_xll.BADDPERIODS(E27, \"CDR\", \"FR\", \"NumberOfPeriods\", \"2\", \"Per\", \"WD\", \"BusDayAdj\", \"-1\")","v":"2023-01-25"},3254]