{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Near real-time stockquote from Yahoo via JSON query:"]
[]
[null,"BHP.ax",{"$f":"StockName(B3)","v":"BHP Billiton Limited"},{"$f":"StockQuote(B3)","v":31.9},null,"Quoted prices will be delayed by an amount depending on Yahoo's service for that exchange,"]
[null,"CSL.ax",{"$f":"StockName(B4)","v":"CSL Limited"},{"$f":"StockQuote(B4)","v":143},null,"Prices will only refresh on recalculation."]
[null,null,null,null,null,"In general just opening a spreadsheet triggers recalculation, but that doesn't work reliably for external-source user-defined functions like this."]
[null,"^AXJO",null,{"$f":"StockQuote(B6)","v":6077.1},null,"You can force recalculation with CTRL-ALT-F9, or with code like the button uses,"]
[null,"^TNX",null,{"$f":"StockQuote(B7)/100","v":2.5520000000000001E-2},null,"or, as here, with similar code in a Workbook_Open() sub in the Workbook's code area."]
[]
[null,"BRK-A",{"$f":"StockName(B9)","v":"Berkshire Hathaway Inc."},{"$f":"StockQuote(B9)","v":315225},null,null,null,"Private Sub Refresh_prices_Click()",null,null,null,null,"Private Sub Workbook_Open()"]
[null,null,null,null,null,null,null,"    Application.CalculateFull",null,null,null,null,"    Application.CalculateFull"]
[null,null,null,null,null,null,null,"End Sub",null,null,null,null,"End Sub"]