{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["dataset","right click","vba12","refresh command","diy"],"not_rendered":{"charts":0,"images":0,"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":"dataset","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"How to Automatically Update Stock Prices in Excel"]
[]
[null,"Stock Name","Price","Change","Change (%)","Last Trade Time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":273.24},{"$f":"_FV(B5,\"Change\")","v":7.34},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":2.7604000000000004E-2},{"$f":"_FV(B5,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.527"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":2246.33},{"$f":"_FV(B6,\"Change\")","v":90.48},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":4.197E-2},{"$f":"_FV(B6,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:55.314"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":102.26},{"$f":"_FV(B7,\"Change\")","v":3.51},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":3.5543999999999999E-2},{"$f":"_FV(B7,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.296"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":40.17},{"$f":"_FV(B8,\"Change\")","v":0.65},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":1.6447E-2},{"$f":"_FV(B8,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:59.570"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":7.8449999999999998},{"$f":"_FV(B9,\"Change\")","v":4.4999999999999998E-2},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":5.7689999999999998E-3},{"$f":"_FV(B9,\"Last trade time\",TRUE)","v":"2022-05-27T19:59:59.031"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":1.4843999999999999},{"$f":"_FV(B10,\"Change\")","v":5.012E-3},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":3.388E-3},{"$f":"_FV(B10,\"Last trade time\",TRUE)","v":"2022-05-26"}]

{"sheet":"right click","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Update Stock Prices Using Refresh Command"]
[]
[null,"Stock Name","Price","Change","Change (%)","Last Trade Time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":273.24},{"$f":"_FV(B5,\"Change\")","v":7.34},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":2.7604000000000004E-2},{"$f":"_FV(B5,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.527"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":2246.33},{"$f":"_FV(B6,\"Change\")","v":90.48},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":4.197E-2},{"$f":"_FV(B6,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:55.314"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":102.26},{"$f":"_FV(B7,\"Change\")","v":3.51},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":3.5543999999999999E-2},{"$f":"_FV(B7,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.296"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":40.17},{"$f":"_FV(B8,\"Change\")","v":0.65},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":1.6447E-2},{"$f":"_FV(B8,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:59.570"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":7.8449999999999998},{"$f":"_FV(B9,\"Change\")","v":0},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":0},{"$f":"_FV(B9,\"Last trade time\",TRUE)","v":"2022-05-27T19:59:59.031"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":1.4830000000000001},{"$f":"_FV(B10,\"Change\")","v":-1.3829999999999999E-3},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":-9.3170000000000004E-4},{"$f":"_FV(B10,\"Last trade time\",TRUE)","v":"2022-05-27"}]

{"sheet":"vba12","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Update Stock Prices in Excel Using VBA"]
[]
[null,"Stock Name","Price","Change","Change (%)","Last Trade Time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":273.24},{"$f":"_FV(B5,\"Change\")","v":7.34},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":2.7604000000000004E-2},{"$f":"_FV(B5,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.527"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":2246.33},{"$f":"_FV(B6,\"Change\")","v":90.48},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":4.197E-2},{"$f":"_FV(B6,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:55.314"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":102.26},{"$f":"_FV(B7,\"Change\")","v":3.51},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":3.5543999999999999E-2},{"$f":"_FV(B7,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.296"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":40.17},{"$f":"_FV(B8,\"Change\")","v":0.65},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":1.6447E-2},{"$f":"_FV(B8,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:59.570"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":7.8449999999999998},{"$f":"_FV(B9,\"Change\")","v":0},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":0},{"$f":"_FV(B9,\"Last trade time\",TRUE)","v":"2022-05-27T19:59:59.031"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":1.4830000000000001},{"$f":"_FV(B10,\"Change\")","v":-1.3829999999999999E-3},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":-9.3170000000000004E-4},{"$f":"_FV(B10,\"Last trade time\",TRUE)","v":"2022-05-27"}]

{"sheet":"refresh command","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Update Stock Prices by Right Clicking"]
[]
[null,"Stock Name","Price","Change","Change (%)","Last Trade Time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":273.24},{"$f":"_FV(B5,\"Change\")","v":7.34},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":2.7604000000000004E-2},{"$f":"_FV(B5,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.527"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":2246.33},{"$f":"_FV(B6,\"Change\")","v":90.48},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":4.197E-2},{"$f":"_FV(B6,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:55.314"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":102.26},{"$f":"_FV(B7,\"Change\")","v":3.51},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":3.5543999999999999E-2},{"$f":"_FV(B7,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.296"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":40.17},{"$f":"_FV(B8,\"Change\")","v":0.65},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":1.6447E-2},{"$f":"_FV(B8,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:59.570"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":7.8449999999999998},{"$f":"_FV(B9,\"Change\")","v":0},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":0},{"$f":"_FV(B9,\"Last trade time\",TRUE)","v":"2022-05-27T19:59:59.031"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":1.4830000000000001},{"$f":"_FV(B10,\"Change\")","v":-1.3829999999999999E-3},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":-9.3170000000000004E-4},{"$f":"_FV(B10,\"Last trade time\",TRUE)","v":"2022-05-27"}]

{"sheet":"diy","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Do It Yourself"]
[]
[null,"Stock Name","Price","Change","Change (%)","Last Trade Time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":273.24},{"$f":"_FV(B5,\"Change\")","v":7.34},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":2.7604000000000004E-2},{"$f":"_FV(B5,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.527"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":2246.33},{"$f":"_FV(B6,\"Change\")","v":90.48},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":4.197E-2},{"$f":"_FV(B6,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:55.314"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":102.26},{"$f":"_FV(B7,\"Change\")","v":3.51},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":3.5543999999999999E-2},{"$f":"_FV(B7,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:57.296"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":40.17},{"$f":"_FV(B8,\"Change\")","v":0.65},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":1.6447E-2},{"$f":"_FV(B8,\"Last trade time\",TRUE)","v":"2022-05-27T23:59:59.570"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":7.8449999999999998},{"$f":"_FV(B9,\"Change\")","v":0},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":0},{"$f":"_FV(B9,\"Last trade time\",TRUE)","v":"2022-05-27T19:59:59.031"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":1.4830000000000001},{"$f":"_FV(B10,\"Change\")","v":-1.3829999999999999E-3},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":-9.3170000000000004E-4},{"$f":"_FV(B10,\"Last trade time\",TRUE)","v":"2022-05-27"}]