{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["目次","銘柄管理","銘柄セット","取得元"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"目次","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"銘柄管理サンプル"]
[]
[null,null,"目次"]
[null,null,null,"1.","銘柄管理",null,null,"銘柄セットシートで指定した銘柄の各種情報を表示"]
[]
[null,null,null,"2.","銘柄セット",null,null,"銘柄管理シートでウォッチする銘柄をセット"]
[]
[null,null,"サンプルシートの利用方法"]
[null,null,null,"　① マーケットスピードⅡRSSに接続"]
[null,null,null,"　② 銘柄セットシートでボタンを押下し、ウォッチ銘柄をセット"]
[null,null,null,"　③ 銘柄管理シートに指定銘柄が反映。Excelの抽出や並び替えもご利用いただけます"]
[]
[null,null,"サンプルシート利用時の注意事項"]
[null,null,null,"・ 銘柄管理シートにはVBAマクロが組まれているため、セルの移動や列の削除等の更新は行わないでください。式が正常に反映しなくなります。"]
[null,null,null,"・ 不要な項目は右クリック⇒非表示で隠すことができます。"]
[null,null,null,"・ 取得元シートは更新/削除は行わないでください。銘柄取得が正常に動作しなくなります。（下記TOPIX100銘柄入替時を除く）"]
[null,null,null,"・TOPIX100ボタンで反映する銘柄は2021年11月1日時点の、TOPIX100組入銘柄です。"]
[null,null,null,"（TOPIX100の銘柄入替が発生した場合、取得元シートG列を修正することで入替を反映できます。）"]
[]
[null,null,"RSSの利用方法について"]
[null,null,null,"・MSII-RSSの利用方法についてはコチラ"]
[null,null,null,null,"オンラインヘルプ TOP"]

{"sheet":"銘柄管理","index":1,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["コード","銘柄名","株価","時刻","前日比 (円)","前日比率","保有数量","平均取得価額","時価評価額","評価損益額","評価損益率","始値","始値比率","高値","高値比率","安値","安値比率","後場始値","後場始値比率","VWAP","VWAP乖離率","出来高","売買代金(千円）","決算発表日","年初来高値","年初来安値"]

{"sheet":"銘柄セット","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,2,3,2],[5,2,6,2]]}
["手入力"]
[null,null,"銘柄セット画面"]
[null,null,"A列銘柄"," 指定銘柄をセットします。左側のA列手入力エリアに銘柄コードを半角入力して「A列銘柄」ボタンを押下（501行目 まで）"]
[null,null,null," ウェブサイトや、マーケットスピードⅡよりダウンロードしたCSVからの、コピー＆ペースト（値貼りでお願いします）でのセットも可能です。"]
[null,null,"保有銘柄"," 現物保有銘柄をセットします。「保有銘柄」ボタンを押下（500銘柄まで）"]
[null,null,"TOPIX100"," TOPIX100採用銘柄をセットします。「TOPIX100」ボタンを押下"]
[null,null,null,"※TOPIX100は2021年11月1日時点の銘柄です。銘柄入替が発生した場合、「取得元」シートG列を修正することで入替を反映できます。"]
[]
[null,null,"銘柄セットボタン"]
[]
[]
[]
[]
[]
[null,null,"　※銘柄セットをするとフィルターは解除されます"]

{"sheet":"取得元","index":3,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["銘柄コード ","保有数量","平均取得価額","時価評価額","評価損益額","評価損益率",1925,null,{"$f":"_xll.RssPositionList(A1:F1,)","v":"=RssPositionList(A1:F1,) => 接続待ち"}]
[null,null,null,null,null,null,1928]
[null,null,null,null,null,null,2413]
[null,null,null,null,null,null,2502]
[null,null,null,null,null,null,2503]
[null,null,null,null,null,null,2802]
[null,null,null,null,null,null,2914]
[null,null,null,null,null,null,3382]
[null,null,null,null,null,null,3402]
[null,null,null,null,null,null,3407]
[null,null,null,null,null,null,4063]
[null,null,null,null,null,null,4188]
[null,null,null,null,null,null,4452]
[null,null,null,null,null,null,4502]
[null,null,null,null,null,null,4503]
[null,null,null,null,null,null,4507]
[null,null,null,null,null,null,4519]
[null,null,null,null,null,null,4523]
[null,null,null,null,null,null,4528]
[null,null,null,null,null,null,4543]
[null,null,null,null,null,null,4568]
[null,null,null,null,null,null,4578]
[null,null,null,null,null,null,4661]
[null,null,null,null,null,null,4689]
[null,null,null,null,null,null,4901]
[null,null,null,null,null,null,4911]
[null,null,null,null,null,null,5020]
[null,null,null,null,null,null,5108]
[null,null,null,null,null,null,5401]
[null,null,null,null,null,null,5713]
[null,null,null,null,null,null,5802]
[null,null,null,null,null,null,6098]
[null,null,null,null,null,null,6178]
[null,null,null,null,null,null,6273]
[null,null,null,null,null,null,6301]
[null,null,null,null,null,null,6326]
[null,null,null,null,null,null,6367]
[null,null,null,null,null,null,6501]
[null,null,null,null,null,null,6502]
[null,null,null,null,null,null,6503]
[null,null,null,null,null,null,6586]
[null,null,null,null,null,null,6594]
[null,null,null,null,null,null,6645]
[null,null,null,null,null,null,6702]
[null,null,null,null,null,null,6752]
[null,null,null,null,null,null,6758]
[null,null,null,null,null,null,6861]
[null,null,null,null,null,null,6869]
[null,null,null,null,null,null,6902]
[null,null,null,null,null,null,6920]
[null,null,null,null,null,null,6954]
[null,null,null,null,null,null,6971]
[null,null,null,null,null,null,6981]
[null,null,null,null,null,null,7011]
[null,null,null,null,null,null,7201]
[null,null,null,null,null,null,7203]
[null,null,null,null,null,null,7267]
[null,null,null,null,null,null,7269]
[null,null,null,null,null,null,7270]
[null,null,null,null,null,null,7309]
[null,null,null,null,null,null,7733]
[null,null,null,null,null,null,7741]
[null,null,null,null,null,null,7751]
[null,null,null,null,null,null,7832]
[null,null,null,null,null,null,7974]
[null,null,null,null,null,null,8001]
[null,null,null,null,null,null,8002]
[null,null,null,null,null,null,8031]
[null,null,null,null,null,null,8035]
[null,null,null,null,null,null,8053]
[null,null,null,null,null,null,8058]
[null,null,null,null,null,null,8113]
[null,null,null,null,null,null,8267]
[null,null,null,null,null,null,8306]
[null,null,null,null,null,null,8308]
[null,null,null,null,null,null,8309]
[null,null,null,null,null,null,8316]
[null,null,null,null,null,null,8411]
[null,null,null,null,null,null,8591]
[null,null,null,null,null,null,8601]
[null,null,null,null,null,null,8604]
[null,null,null,null,null,null,8630]
[null,null,null,null,null,null,8697]
[null,null,null,null,null,null,8725]
[null,null,null,null,null,null,8750]
[null,null,null,null,null,null,8766]
[null,null,null,null,null,null,8801]
[null,null,null,null,null,null,8802]
[null,null,null,null,null,null,8830]
[null,null,null,null,null,null,9020]
[null,null,null,null,null,null,9021]
[null,null,null,null,null,null,9022]
[null,null,null,null,null,null,9202]
[null,null,null,null,null,null,9432]
[null,null,null,null,null,null,9433]
[null,null,null,null,null,null,9434]
[null,null,null,null,null,null,9735]
[null,null,null,null,null,null,9843]
[null,null,null,null,null,null,9983]
[null,null,null,null,null,null,9984]