{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","Market_Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,15,3]]}
[]
[null,"Copyright © 2019 Saxo Bank A/S\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nYou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\nhttp://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and limitations under the License."]

{"sheet":"Market_Data","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["OpenAPI Market Data Checker Tool"]
[]
["Trade Level"]
[{"$f":"_xll.OpenAPIGet(\"root/v1/sessions/capabilities\",\"TradeLevel\")","v":"OrdersOnly"}]
[]
["UIC ",899]
["AssetType ","Stock"]
[]
[{"$f":"_xll.OpenAPIGetAutoResize(\"/openapi/ref/v1/instruments/?Uics=\"&Market_Data!B6&\"&AssetTypes=\"&Market_Data!B7&\"&IncludeNonTradable=True\",\"ExchangeId,Symbol,Description\",TRUE)","v":"ExchangeId"},"Symbol","Description"]
["LSE_SETS","VOD:xlon","Vodafone Group Plc"]
[]
[{"$f":"_xll.OpenAPISubscribe(\"/openapi/trade/v1/infoprices/subscriptions\",\"AssetType:\"&Market_Data!B7&\",Uics:\"&Market_Data!B6&\"\",\"quote,priceinfodetails\",\"Quote.Bid,PriceInfoDetails.LastTraded,Quote.Ask,PriceInfoDetails.LastClose,Quote.DelayedByMinutes,Quote.PriceTypeAsk,LastUpdated,Quote.ErrorCode,PriceSource\")","v":"Quote.Bid"},"PriceInfoDetails.LastTraded","Quote.Ask","PriceInfoDetails.LastClose","Quote.DelayedByMinutes","Quote.PriceTypeAsk","LastUpdated","Quote.ErrorCode","PriceSource"]
[{"$f":"_xll.OPENAPISUBSCRIBERTD(\"ExcelTrader_8176b4c1-7613-487e-94f1-4e49b8d0ba48\",\"Uic\",\"899\")","v":97.28},97.28,97.3,96.42,15,"OldIndicative","18/11/2022 09:09:56","None","LSE_SETS"]