{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Sheet2","Template_Features"],"not_rendered":{"charts":0,"images":2,"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 \nFrom Yahoo Finance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Sheet2","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["YAHOO CODE","n","J2","f6","p","d1","j1","j4"]
["Symbol","Name","Shares Oustanding","Float Shares","Previous Close","Last trade Date","Market Capitalisation","EBITDA"]
["AAPL"]
["DVMT"]
["FBK"]
["ZTO"]
["H"]
["VVV"]
["YHOO"]
["COUP"]
["E"]
["COUP"]
["DOX"]
["ZNGA"]
["YHOO"]
["JE.TO"]
["KOS"]
["KOOL"]
["F"]

{"sheet":"Template_Features","index":2,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[15,4,20,11],[23,3,24,6]]}
["YAHOO TAGS"]
[]
["Name","n"]
["Stock Exchange","x"]
["Market Capitalisation","j1","Company Details"]
["Shares Oustanding","J2"]
["Float Shares","f6"]
["Book Value","b4"]
["Ask","a"]
["Bid","b"]
["Ask Size","a5"]
["Bid Size","b6"]
["Last trade Date","d1"]
["Last trade Time","t1"]
["Last trade Price","l1","Trading Data"]
["Last trade Size","k3",null,null,"All these information compiled \nfrom YAHOO FINANCE"]
["Change","c1"]
["Change in Percent","p2"]
["Open","o"]
["Day's High","h"]
["Day's Low","g"]
["Day's Range","m"]
["Volume","v"]
["Average Daily Volume","a2",null,"Steps to Follow"]
["Previous Close","p"]
["52-week Range","w"]
["52-week High","k",null,"1)","Update the Yahoo Code symbols in first row from available dropdown, as per our requirement"]
["52-week Low","j",null,"2)","Bydefault 2nd row will be updated through lookup function"]
["Change From 52-week High","k4","Historical Performance","3)","Update the required symbols in FIRST COLUMN, as per your requirement"]
["Change From 52-week Low","j5"]
["% Change From 52-week High","k5",null,"Note:","Make sure company name doesn’t seperated by COMMA, as delimiter used as COMMA(,) in this program"]
["% Change From 52-week Low","j6"]
["Earnings/Share","e",null,"4)","Click on COMMAND BUTTON to execute the code"]
["EBITDA","j4"]
["P/E Ratio","r",null,"5)","This template is useful to ANALYSTS who intends to analyse the data, sector wise"]
["PEG Ratio","r5","Fundamental Analysis"]
["Dividend/Share","d",null,"6)","Through This dynamic template we can retrieve N number of companies Data, which were  added to first column"]
["Ex-Dividend Date","q"]
["Dividend Pay Date","r1"]
["Dividend Yield","y"]
["1 yr Target Price","t8"]
["50-day Moving Average","m3"]
["200-day Moving Average","m4"]
["Change From 200-day Moving Average","m5"]
["Percent Change From 200-day Moving Average","m6","Technical Analysis"]
["Change From 50-day Moving Average","m7"]
["Percent Change From 50-day Moving Average","m8"]