{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introduction","Prerequisites","Index","Yahoo_Data","LineChart_1","LineChart2","Bar_Chart1","BarChart2","Pie_Chart1","Column_Chart1","Chart_with_Two_DataItems","DashBoard","Bar_Chart2"],"not_rendered":{"charts":11,"images":8,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Download from \nYAHOO - and\nCharting"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Prerequisites","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,5,6,11],[17,5,18,12]]}
[]
[]
[]
[null,null,null,null,null,"Activate internet connection "]
[]
[]
[]
[]
[null,null,null,null,null,"Open VBE"]
[]
[null,null,null,null,null,"TOOLS"]
[null,null,null,null,null,"References"]
[]
[null,null,null,null,null,"Activate WinHTTP Services, Version 5.1"]
[null,null,null,null,null,"Microsoft HTML Object Liabriary"]
[null,null,null,null,null,"Microsoft Internet Control"]
[]
[null,null,null,null,null,"Prior to connecting to web, we must activate internet"]

{"sheet":"Index","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,4,14,10]]}
["Introduction"]
["Prerequisites"]
["Index"]
["Yahoo_Data",null,null,null,"If sheet name consists of Multiple words, \njoin them with underscore\nsheetname = word1_word2"]
["LineChart_1"]
["LineChart2"]
["Bar_Chart1"]
["BarChart2"]
["Pie_Chart1"]
["Column_Chart1"]
["Chart_with_Two_DataItems"]
["DashBoard"]
["Bar_Chart2"]

{"sheet":"Yahoo_Data","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Ticker","Company Name","Previous Close","Open","Beta","Market Cap","PE Ratio (TTM)","EPS (TTM)"]
["AAPL","Apple Inc. (AAPL)",183.92,185.26,1.1499999999999999,911267,17.93,10.34]
["GOOG","Alphabet Inc. (GOOG)",1102.8900000000001,1110.53,1.31,784937,47.6,23.62]
["AMZN","Amazon.com, Inc. (AMZN)",1693.96,1705.38,1.7,824755,213.8,7.95]
["FB","Facebook, Inc. (FB)",192.73,194.74,0.81,574439,32.85,6.04]
["ISRG","Intuitive Surgical, Inc. (ISRG)",485.58,489.22,1.1000000000000001,55219,74.400000000000006,6.55]
["NVDA","NVIDIA Corporation (NVDA)",236.84,239.07,1.57,147337,40.35,6.02]
["BA","The Boeing Company (BA)",332.93,336.15,1.72,194104,22.14,15.05]
["V","Visa Inc. (V)",131.44999999999999,132.13,1.03,298542,33.72,3.95]
["VRTX","Vertex Pharmaceuticals Incorporated (VRTX)",167.73,168.38,1.92,43191,191.73,0.88]
[]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null," "," "]
[null,null,null,null,null," "]

{"sheet":"LineChart_1","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!C1","v":"Previous Close"}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!C3","v":1102.8900000000001}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!C4","v":1693.96}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!C5","v":192.73}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!C6","v":485.58}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!C7","v":236.84}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!C8","v":332.93}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"LineChart2","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!D1","v":"Open"}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!D5","v":194.74}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!D6","v":489.22}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!D7","v":239.07}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!D8","v":336.15}]
[null,{"$f":"Yahoo_Data!A9","v":"V"},{"$f":"Yahoo_Data!D9","v":132.13}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"Bar_Chart1","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!C1","v":"Previous Close"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!C2","v":183.92}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!C3","v":1102.8900000000001}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!C4","v":1693.96}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!C5","v":192.73}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"BarChart2","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!C1","v":"Previous Close"}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!C6","v":485.58}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!C7","v":236.84}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!C8","v":332.93}]
[null,{"$f":"Yahoo_Data!A9","v":"V"},{"$f":"Yahoo_Data!C9","v":131.44999999999999}]
[null,{"$f":"Yahoo_Data!A10","v":"VRTX"},{"$f":"Yahoo_Data!C10","v":167.73}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"Pie_Chart1","index":8,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!G1","v":"PE Ratio (TTM)"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!G2","v":17.93}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!G3","v":47.6}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!G4","v":213.8}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!G5","v":32.85}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!G6","v":74.400000000000006}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!G7","v":40.35}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!G8","v":22.14}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"Column_Chart1","index":9,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!H1","v":"EPS (TTM)"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!H2","v":10.34}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!H3","v":23.62}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!H4","v":7.95}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!H5","v":6.04}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!H6","v":6.55}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!H7","v":6.02}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!H8","v":15.05}]
[null,{"$f":"Yahoo_Data!A9","v":"V"},{"$f":"Yahoo_Data!H9","v":3.95}]
[null,{"$f":"Yahoo_Data!A10","v":"VRTX"},{"$f":"Yahoo_Data!H10","v":0.88}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"Chart_with_Two_DataItems","index":10,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!C1","v":"Previous Close"},{"$f":"Yahoo_Data!G1","v":"PE Ratio (TTM)"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!C2","v":183.92},{"$f":"Yahoo_Data!G2","v":17.93}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!C3","v":1102.8900000000001},{"$f":"Yahoo_Data!G3","v":47.6}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!C4","v":1693.96},{"$f":"Yahoo_Data!G4","v":213.8}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!C5","v":192.73},{"$f":"Yahoo_Data!G5","v":32.85}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!C6","v":485.58},{"$f":"Yahoo_Data!G6","v":74.400000000000006}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!C7","v":236.84},{"$f":"Yahoo_Data!G7","v":40.35}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]

{"sheet":"DashBoard","index":11,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!C1","v":"Previous Close"},null,null,null,null,null,null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!G1","v":"PE Ratio (TTM)"}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!C3","v":1102.8900000000001},null,null,null,null,null,null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!G3","v":47.6}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!C4","v":1693.96},null,null,null,null,null,null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!G4","v":213.8}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!C5","v":192.73},null,null,null,null,null,null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!G5","v":32.85}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!C6","v":485.58},null,null,null,null,null,null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!G6","v":74.400000000000006}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!C7","v":236.84},null,null,null,null,null,null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!G7","v":40.35}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!C8","v":332.93},null,null,null,null,null,null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!G8","v":22.14}]
[null,null,null,null,null,null,null,null,null,{"$f":"Yahoo_Data!A9","v":"V"},{"$f":"Yahoo_Data!G9","v":33.72}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!H1","v":"EPS (TTM)"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!H2","v":10.34}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!H3","v":23.62}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!H4","v":7.95}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!H5","v":6.04}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!H6","v":6.55}]

{"sheet":"Bar_Chart2","index":12,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,6]]}
[]
[null,{"$f":"Yahoo_Data!A1","v":"Ticker"},{"$f":"Yahoo_Data!F1","v":"Market Cap"}]
[null,{"$f":"Yahoo_Data!A2","v":"AAPL"},{"$f":"Yahoo_Data!F2","v":911267}]
[null,{"$f":"Yahoo_Data!A3","v":"GOOG"},{"$f":"Yahoo_Data!F3","v":784937}]
[null,{"$f":"Yahoo_Data!A4","v":"AMZN"},{"$f":"Yahoo_Data!F4","v":824755}]
[null,{"$f":"Yahoo_Data!A5","v":"FB"},{"$f":"Yahoo_Data!F5","v":574439}]
[null,{"$f":"Yahoo_Data!A6","v":"ISRG"},{"$f":"Yahoo_Data!F6","v":55219}]
[null,{"$f":"Yahoo_Data!A7","v":"NVDA"},{"$f":"Yahoo_Data!F7","v":147337}]
[null,{"$f":"Yahoo_Data!A8","v":"BA"},{"$f":"Yahoo_Data!F8","v":194104}]
[]
[]
[]
[]
[null,"Note: Market cap in mIllions"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Report Writing:"]