{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Portfolio","Example","Boot","Indices"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Portfolio","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Portfolio Value:",{"$f":"SUMPRODUCT(Portfolio[Quantity],Portfolio[Price])","v":30824.900000000005}]
[null,null,null,null,{"$f":"SUMPRODUCT(Portfolio[Quantity],Portfolio[Change])","v":-496.64000000000004},{"$f":"IF((E4-E5) = 0, 0,E5/(E4-E5))","v":-1.5856180762504012E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: Yahoo Finance. Quotes delayed."]
[null,"Symbol","Quantity","Price","Change","% Change","P&L","Total Value"]
[null,"GOOG",12,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":695.85},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-10.61},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-1.5018543158848341E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-127.32},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":8350.2000000000007}]
[null,"AMZN",15,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":552.94000000000005},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-6.56},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-1.1724754244861482E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-98.399999999999991},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":8294.1}]
[null,"AAPL",10,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":94.69},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-2.19},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-2.2605284888521884E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-21.9},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":946.9}]
[null,"JPM",50,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":56.12},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-2.4500000000000002},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-4.1830288543623015E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-122.50000000000001},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":2806}]
[null,"WMT",30,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":66.48},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":0.85},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":1.2951394179491085E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":25.5},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":1994.4}]
[null,"PFE",30,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":29.96},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-0.09},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-2.9950083194675539E-3},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-2.6999999999999997},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":898.80000000000007}]
[null,"WFC",50,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":48.1},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-1.0900000000000001},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-2.2158975401504369E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-54.500000000000007},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":2405}]
[null,"MSFT",30,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":51.18},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-1.47},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-2.792022792022792E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-44.1},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":1535.4}]
[null,"FB",30,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":105.46},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":-1.7},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":-1.5864128406121687E-2},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":-51},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":3163.7999999999997}]
[null,"LMT",2,{"$f":"StockQuote(Portfolio[[#This Row],[Symbol]])","v":215.15},{"$f":"StockChange(Portfolio[[#This Row],[Symbol]])","v":0.14000000000000001},{"$f":"IF(Portfolio[[#This Row],[Price]]=0,0,Portfolio[[#This Row],[Change]]/(Portfolio[[#This Row],[Price]]-Portfolio[[#This Row],[Change]]))","v":6.5113250546486214E-4},{"$f":"Portfolio[[#This Row],[Change]]*Portfolio[[#This Row],[Quantity]]","v":0.28000000000000003},{"$f":"Portfolio[[#This Row],[Price]]*Portfolio[[#This Row],[Quantity]]","v":430.3}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Portfolio[P&L])","v":-496.64000000000004},{"$f":"SUBTOTAL(109,Portfolio[Total Value])","v":30824.900000000005}]

{"sheet":"Example","index":1,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,22,8,23],[30,22,30,23]]}
[]
[]
[]
[null,null,null,"Examples of All Available Stock Functions"]
[]
[]
[]
[null,"Source: Yahoo Finance. Quotes delayed."]
[null,"Symbol","Name","Quote","Open","Previous Close","Bid","Ask","Change","Change in %","Day's Low","Day's High","Volume","Year Low","Year High","PE Ratio","EPS","Market Cap","Div. Yield","Div. Share","EBITDA",null,"Available Functions"]
[null,"ABT",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Abbott Laboratories Common Stoc"},{"$f":"StockQuote(B10)","v":38.39},{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":38.909999999999997},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":39.159999999999997},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockChange(B10)","v":-0.77},{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.97%"},{"$f":"StockDaysLow(B10)","v":38.299999999999997},{"$f":"StockDaysHigh(B10)","v":39.049999999999997},{"$f":"VALUE(StockVolume(B10))","v":6144311},{"$f":"StockYearLow(B10)","v":36},{"$f":"StockYearHigh(B10)","v":51.74},{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":13.12},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":2.93},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"57.27B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":2.7},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.04},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"4.81B"},null,"Function","Description"]
[null,"ALL",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Allstate Corporation (The) Comm"},63.73,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":64.31},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":64.44},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.71,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.10%"},63.56,64.31,1973511,54.12,72.510000000000005,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":12.62},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":5.05},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"24.28B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":2.06},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.32},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"3.98B"},null,"=StockAsk(symbol)","Returns the ask price."]
[null,"AMZN",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Amazon.com, Inc."},552.94000000000005,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":555.65},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":559.5},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-6.56,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.17%"},545.33000000000004,556.91,4050939,365.65,696.44,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":442.35},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":1.25},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"260.35B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"7.88B"},null,"=StockBid(symbol)","Returns the bid price."]
[null,"BA",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Boeing Company (The) Common Sto"},116.9,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":116.97},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":117.39},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.49,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-0.42%"},115.93,118.5,3762341,102.1,156.91,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":15.71},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":7.44},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"77.45B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":3.79},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":4.3600000000000003},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"9.00B"},null,"=StockChange(symbol)","Returns the change in stock price since last closed."]
[null,"CCE",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Coca-Cola Enterprises, Inc. Com"},49.03,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":49.17},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":49.38},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.35,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-0.71%"},48.86,49.53,1117294,41.03,53.79,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":19.3},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":2.54},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"11.15B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":2.4500000000000002},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.2},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"1.20B"},null,"=StockChangeInPercent(symbol)","Returns the change in stock price as a percent."]
[null,"DAL",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Delta Air Lines, Inc. Common St"},48.95,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":48.47},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":48.82},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},0.13,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"+0.27%"},48.45,49.45,9411450,34.61,52.77,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":8.69},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":5.63},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"38.00B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":1.1599999999999999},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0.54},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"8.22B"},null,"=StockDaysHigh(symbol)","Returns the highest trade price for the day."]
[null,"FB",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Facebook, Inc."},105.46,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":106.86},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":107.16},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-1.7,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.59%"},105.12,107.47,25321690,72,117.59,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":81.56},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":1.29},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"300.17B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"8.24B"},null,"=StockDaysLow(symbol)","Returns the lowest trade price for the day."]
[null,"GOOG",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Alphabet Inc."},695.85,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":701.45},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":706.46},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-10.61,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.50%"},693.58,708.4,2009295,515.17999999999995,789.87,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":29.49},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":23.59},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"478.97B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"24.42B"},null,"=StockDividendPerShare(symbol)","Returns the dividend per share."]
[null,"IBM",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"International Business Machines"},132.4,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":133.13999999999999},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":133.77000000000001},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-1.37,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.02%"},132.01,133.41,3439831,116.9,176.3,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":9.86},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":13.42},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"127.90B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":3.91},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":5.2},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"19.59B"},null,"=StockDividendYield(symbol)","Returns the dividend yield."]
[null,"LMT",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Lockheed Martin Corporation Com"},215.15,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":214.83},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":215.01},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},0.14000000000000001,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"+0.07%"},213.87,215.74,1282903,181.91,227.91,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":18.77},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":11.46},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"65.19B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":3.09},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":6.6},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"6.70B"},null,"=StockEBITDA(symbol)","Returns the earnings before interest, taxes, depreciation, and amortization."]
[null,"MSFT",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Microsoft Corporation"},51.18,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":52.34},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":52.65},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-1.47,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-2.79%"},50.98,52.37,28895295,39.72,56.85,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":36.22},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":1.41},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"404.80B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":2.78},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.44},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"30.46B"},null,"=StockEPS(symbol)","Returns the earnings per share."]
[null,"MSI",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Motorola Solutions, Inc. Common"},70.78,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":70.02},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":66.75},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},4.03,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"+6.04%"},69.31,72.709999999999994,4942161,56.4,72.97,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":28.3},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":2.5},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"12.50B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":2.48},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.64},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"1.26B"},null,"=StockMarketCapitalization(symbol)","Returns the market capitalization."]
[null,"NFLX",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Netflix, Inc."},89.12,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":91.4},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":91.93},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-2.81,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-3.06%"},89.05,92.49,12745180,58.46,133.27000000000001,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":318.29000000000002},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":0.28000000000000003},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"38.15B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"368.11M"},null,"=StockName(symbol)","Returns the name of the company, limited to 17 characters due to API."]
[null,"PRU",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Prudential Financial, Inc. Comm"},64.59,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":65.849999999999994},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":66.08},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-1.49,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-2.25%"},64.03,66.09,3313699,57.19,92.6,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":5.31},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":12.17},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"28.98B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":4.28},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":2.8},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"8.81B"},null,"=StockOpen(symbol)","Returns the open price."]
[null,"RHT",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Red Hat, Inc. Common Stock"},65.3,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":66.03},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":66.11},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.81,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.23%"},64.38,66.14,1290691,59.59,84.44,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":63.4},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":1.03},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"11.93B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"367.78M"},null,"=StockPERatio(symbol)","Returns the price to earnings ratio."]
[null,"S",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Sprint Corporation Common Stock"},2.95,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":3},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":3.02},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-7.0000000000000007E-2,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-2.32%"},2.95,3.08,9172299,2.1800000000000002,5.45,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":-0.42},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"11.72B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"7.86B"},null,"=StockPreviousClose(symbol)","Returns the closing price on the previous trading day."]
[null,"SRS",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"ProShares UltraShort Real Estat"},49.7,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":49.56},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":49.37},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},0.33,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"+0.67%"},48.68,49.78,114218,43.32,58.29,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":""},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":""},null,"=StockQuote(symbol)","Returns delayed stock quote."]
[null,"VB",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Vanguard Small-Cap ETF - DNQ"},100.88,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":101.52},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":101.73},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.85,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-0.84%"},100.83,101.83,1042074,90.03,125.51,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":""},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":""},null,"=StockVolume(symbol)","Returns the number of shares traded for the day."]
[null,"VWO",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Vanguard FTSE Emerging Markets"},30.76,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":31.12},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":31.44},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.68,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-2.16%"},30.76,31.14,15057247,27.98,45.08,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":3.79},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":""},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":4.8},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":1.54},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":""},null,"=StockYearHigh(symbol)","Returns the 52-week high."]
[null,"YHOO",{"$f":"StockName(Table3[[#This Row],[Symbol]])","v":"Yahoo! Inc."},30.67,{"$f":"StockOpen(Table3[[#This Row],[Symbol]])","v":31.2},{"$f":"StockPreviousClose(Table3[[#This Row],[Symbol]])","v":31.17},{"$f":"StockBid(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockAsk(Table3[[#This Row],[Symbol]])","v":0},-0.5,{"$f":"StockChangeInPercent(Table3[[#This Row],[Symbol]])","v":"-1.60%"},30.5,31.38,17072345,26.15,46.17,{"$f":"StockPERatio(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEPS(Table3[[#This Row],[Symbol]])","v":-4.6399999999999997},{"$f":"StockMarketCapitalization(Table3[[#This Row],[Symbol]])","v":"28.93B"},{"$f":"StockDividendYield(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockDividendPerShare(Table3[[#This Row],[Symbol]])","v":0},{"$f":"StockEBITDA(Table3[[#This Row],[Symbol]])","v":"474.68M"},null,"=StockYearLow(symbol)","Returns the 52-week low."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available Macros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RefreshStockQuote","Refreshes stock quotes on all sheets. Shortcut key: F9."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AutoRefresh","Enables auto refresh stock quotes at the first second of every minute."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StopAutoRefresh","Disables auto refresh stock quotes."]

{"sheet":"Boot","index":2,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Boot Stock Symbols"]
["ABT"]
["MSI"]
["S"]
["DAL"]
["ALL"]
["PFE"]
["IBM"]
["VWO"]
["BA"]
["YHOO"]
["FB"]
["PRU"]
["GOOG"]
["AMZN"]
["NFLX"]
["^DJI"]
["WFC"]
["RHT"]
["SRS"]
["LMT"]
["VB"]
["WMT"]
["JPM"]
["CCE"]
["AAPL"]
["MSFT"]

{"sheet":"Indices","index":3,"n_rows":85,"n_cols":3,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Inidices Reference"]
[]
[]
[]
[null,"Index","Symbol"]
[null,"AEX Amsterdam (Netherlands)","^AEX"]
[null,"All Ordinaries (Australia)","^AORD"]
[null,"Athens Composite (Greece)","GD.AT"]
[null,"ATX (Austria)","^ATX"]
[null,"CAC 40 (France)","^FCHI"]
[null,"CBOE Gold ","^GOX"]
[null,"CBOE Gold Bugs ","^HUI"]
[null,"Colombo All Shares (Sri Lanka)","^CSE"]
[null,"DAX (Germany)","^GDAXI"]
[null,"Dow Jones Industrial Average","^DJI"]
[null,"Euronext BEL-20 (Belgium)","^BFX"]
[null,"FTSE 100","^FTSE"]
[null,"FTSE MIB (Italy)","FTSEMIB.MI"]
[null,"Hang Seng (Hong Kong)","^HSI"]
[null,"Interactive Week Internet ","^IIX"]
[null,"IPC (Mexico)","^MXX"]
[null,"ISEQ 20 Price (Ireland)","^IETP"]
[null,"Jakarta Composite (Indonesia)","^JKSE"]
[null,"KOSPI Composite (South Korea)","^KS11"]
[null,"MERVAL (Argentina)","^MERV"]
[null,"Morgan Stanley Consumer ","^CMR"]
[null,"Morgan Stanley Cyclical ","^CYC"]
[null,"MSCI US REIT ","^RMZ"]
[null,"NASDAQ Bank ","^BANK"]
[null,"NASDAQ Biotechnology ","^NBI"]
[null,"NASDAQ Composite","^IXIC"]
[null,"NASDAQ Computer ","^IXCO"]
[null,"NASDAQ Financial 100 ","^IXF"]
[null,"NASDAQ Industrial ","^INDS"]
[null,"NASDAQ Insurance","^INSR"]
[null,"NASDAQ SIG Oil Exploration and Production ","^EPX"]
[null,"NASDAQ Telecommunications","^IXTC"]
[null,"NASDAQ Transportation ","^TRAN"]
[null,"NASDAQ-100","^NDX"]
[null,"Nikkei 225 (Japan)","^N225"]
[null,"NYSE AMEX Airline ","^XAL"]
[null,"NYSE AMEX Biotechnology ","^BTK"]
[null,"NYSE AMEX Composite ","^XAX"]
[null,"NYSE AMEX Computer Technology ","^XCI"]
[null,"NYSE AMEX Natural Gas ","^XNG"]
[null,"NYSE AMEX Oil ","^XOI"]
[null,"NYSE AMEX Pharmaceutical ","^DRG"]
[null,"NYSE AMEX Securities Broker/Dealer ","^XBD"]
[null,"NYSE ARCA Institutional ","^XII"]
[null,"NYSE ARCA Major Market ","^XMI"]
[null,"NYSE ARCA Networking ","^NWX"]
[null,"NYSE Composite","^NYA"]
[null,"NYSE TMT","^NYY"]
[null,"NYSE US 100","^NY"]
[null,"NZSE 50 (New Zealand)","^NZ50"]
[null,"PHLX Gold/Silver Sector ","^XAU"]
[null,"PHLX Housing Sector ","^HGX"]
[null,"PHLX Oil Service Sector ","^OSX"]
[null,"PHLX Semiconductor ","^SOX"]
[null,"PHLX Utility Sector","^UTY"]
[null,"RTSI (Russia)","RTS.RS"]
[null,"Russell 1000 ","^RUI"]
[null,"Russell 2000 Index","^RUT"]
[null,"Russell 3000","^RUA"]
[null,"S&P 100","^OEX"]
[null,"S&P 500 Index","^GSPC"]
[null,"S&P Mid-Cap 400 ","^MID"]
[null,"S&P Small-Cap 600","^SP600"]
[null,"S&P TSX Composite (Canada)","^GSPTSE"]
[null,"Straits Times (Singapore)","^STI"]
[null,"Swiss Market (Switzerland)","^SSMI"]
[null,"Taiwan Weighted","^TWII"]
[null,"Tel Aviv 100 (Israel)","^TA100"]
[null,"Wilshire 5000 Total Market ","^W5000"]
[null,"Wilshire US Large Cap Growth","^W5KLCG"]
[null,"Wilshire US Large Cap Value","^W5KLCV"]
[null,"Wilshire US Mid Cap Growth","^W5KMCG"]
[null,"Wilshire US Mid Cap Value","^W5KMCV"]
[null,"Wilshire US Real Estate Securities ","^WILRESI"]
[null,"Wilshire US REIT","^WILREIT"]
[null,"Wilshire US Small Cap Growth","^W5KSCG"]
[null,"Wilshire US Small Cap Value","^W5KSCV"]