{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","Description","SEME Generator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["February 2022 \nThis document is the property of Clearstream Banking AG, Frankfurt (“Clearstream Banking” or “CBF”) and may only be changed with prior written consent obtained from Clearstream Banking. The information in this document is subject to change without notice and does not represent any obligation on the part of Clearstream Banking, a subsidiary or other affiliate of Clearstream International S.A.\n© Copyright Clearstream Banking AG, Frankfurt (2022). All rights reserved.\nClearstream Banking AG, Frankfurt, is a Deutsche Börse Group company."]

{"sheet":"Description","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Field Name","Description","Lenght","Type"]
["Leg Type","A (already matched)\nD (delivering)\nR (receiving)",1,"Alphanumeric"]
["WKN","Wertpapierkennnummer",6,"Alphanumeric"]
["Stock Exchange Code","B = Berlin\nD = Düsseldorf\nE = Xetra\nF = Frankfurt\nG = Tradegate\nH = Hamburg\nI = Hannover\nM = München\nS = Stuttgart\nX = INVESTRO",1,"Alphanumeric"]
["Date","Input Day (IDAY)*",8,"Date"]
["Trade Number","Trade Number",7,"Numeric"]
[]
["*If the stock exchange or its provider does not present an Input Date (IDAY), the Trade Date will be used for the calculation."]
[]
["The SEME Generator is designed to determine the initial reference only."]
[]
["Once the data has been entered, click the button \"Generate\" to see the results."]

{"sheet":"SEME Generator","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Leg Type","WKN","Stock Exchange Code","Date","Trade Number","SEME","Err"]
["R",310209,"S","2021-08-09",4,"SR310209S2QQDTHG"]
["D",310209,"S","2021-08-09",14,"SD310209S2QQDTHQ"]
["A",310209,"S","2022-02-02",432,"SA310209S3KC3QNK"]
["R",310209,"S","2021-08-09",4555,"SR310209S2QQDWZV"]
["D",310209,"S","2021-08-09",46551,"SD310209S2QQETEF"]
["A",310209,"S","2022-02-02",476555,"SA310209S3KCDY17"]