{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DatastreamRequests","DatastreamResponses","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"DatastreamRequests","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Enter Datastream UserID:",null,null,null,null,null,null,"Usage Steps:"]
["Enter Datastream Password:",null,null,null,null,null,null,"1. Fill username in B1 and password in B2."]
["Token:",null,null,null,null,null,null,"2. Click Get Token. This will get a token and fill B3 with token and B4 with token expiry."]
["Token Expiry:",null,null,null,null,null,null,"3. Click Get Data. This will get results for the first request row (i.e. 13) and fill response in DatastreamResponses sheet."]
[null,null,null,null,null,null,null,"4. Click Get Data Bundle. This will get results for all rows starting from 13 and fill response in DatastreamResponses sheet."]
[null,null,null,null,null,null,null,"5. See the request heading comments for different types of series/DataTypes/Dates/Properties you can enter."]
[]
[]
[]
[]
[]
["Series/Expression","Data Types","Date Kind","Start","End","Frequency","Properties"]
["VOD","PH,PL","TimeSeries","-60D","-10D","D"]
["BARC","P,MV,NAME","Snapshot","-2Y"]
["VOD,BARC,MKS","P,MV","TimeSeries","2011-01-01","2012-12-31","M","IsSymbolSet"]
["MKS,BARC,VOD","NAME,ISIN","Snapshot",null,null,null,"IsSymbolSet"]
["VOD(PL)+BARC(PH)",null,"TimeSeries","BDATE",null,"Y","IsExpression"]
["LFTSE100","MNEM,PL","Snapshot",null,null,null,"IsList"]

{"sheet":"DatastreamResponses","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}