{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Settings","CompsTable","SideBySide","Ticker Search","CompanyData","S&P 500","Top Index Funds","FundiesAdj","Adjustments","Other Notes","Account"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":20,"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":"Instructions","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,1,11,1],[8,1,9,1],[5,1,6,1]]}
["This spreadsheet is the personal work of Tim Baker, CFA and is not an official IEX Cloud product. All data is sourced via the IEX Cloud API. "]
["IEX Cloud Services LLC makes no promises or guarantees herein regarding results from particular products and services, and neither the information, nor any opinion expressed here, constitutes a solicitation or offer to buy or sell any securities or provide any investment advice or service."]
["Instructions","Links"]
["Sign up for an IEX Cloud account."]
["Go to the settings tab: Enter your IEX Cloud token into the settings TAB. "]
["Comps Table / Screener","Click here to go to CompsTable"]
["Enter your ticker list into the comps table.   You can copy and paste a list, and I incuded the list of S&P 500 firms.  Use the Refresh button and it will pull the data from the API, and populate the data."]
["If you want to add additional financial data, I included a lookup cell, and each of the blue header cells have a drop down (use the second one)","Click here for item lookup","----------------------->"]
["BONUS Side by Side View:","Click here to go to Side by Side View"]
["I also included a SidebySide view of the data.  Add a new ticker at the top (needs to be in the comps table), and copy the formulae from left to right in the expanded table.",null,"------------------------------------------------------------------------------------------------------->"]
["BONUS: S&P500 ticker list from Wikepedia, a few ETFs, and a ticker lookup tab, which hits the IEX Cloud search end point.","Click her to go to the S&P 500 ticker list"]
["I also pull a list of US companies and tickers for the S&P 500.  This data is not provided by IEX Cloud."]
["Note:  There are some hidden tabs which is where PowerQuery pulls data into from the IEX Cloud API."]
["Notes / about this spreadsheet","Links"]
["This spreadsheet can be used to screen thousands of U.S. listed companies. This is the personal work of Tim Baker, and is not an official IEX Cloud product. "]
["This spreadhseet is provided \"as is\" and may contain errors or differences to some calculation conventions used in financial analysis.  Do let me know via GitHub if you have any questions, or corrections.","https://github.com/timbaker-iex"]
["It is supplied free of charge. Should you make improvements to this spreadsheet, feel free to contribute it back to the Excel community at IEX Cloud. ","community@iexcloud.io "]
["In order to update this spreadsheet with different companies, you will need to sign up for an IEX Cloud account by signing up here:   NOTE this spreadsheet will function with a FREE account.  EACH COMPANY uses about 10,400 credits.  SUGGEST YOU EXPERIMENT WITH SANDBOX.","https://iexcloud.io/cloud-login#/register"]
["Additional information about Financial Statements endpoints can be found here: ","data-migration-updates-to-financial-statements"]
["This spreadsheet is formatted for Industrial (i.e. non-financial/bank) companies."]
["The fundamental data is sourced by IEX Cloud from the SEC website - linked here.  ","https://www.sec.gov/edgar/search/"]
["I make adjustments to this data, and do a rudimentary merger of various fields to combine \"similar\" financial items.  To view these adjustments hit Data/Queries & Connections and edit the FundiesAdj powerQuery.  Then select \"Advanced Editor\" to view the M Query code.  Each \"Rollup\" or adjustment is marked:  //Combine xbrl tems for Revenue.  Or go to the Adjustments TAB.","https://iexcloud.io/docs/api/#financials-as-reported"]
["SEC filings are typically 3 quarters (10-Q) and 1 annual (10-k) per year - so 4Q data is not available, nor trailing twelve months.  This spreadsheet is setup for 10-K (annual) reports, but can easily be adjusted to quarterly by editing the URL in the comps table (replace 10-K with 10-Q).  Valuation items will need to be adjusted to annualise the income statement data."]
["The spreadhseet will pick up the latest filing for each company, unless for some reason IEX Cloud has not processed the filing."]
["Want to know how I built this?  Go to this blog post, and watch the YouTube video (Intro to Fundamentals in Excel):","https://iexcloud.io/blog/an-introduction-to-fundamental-analysis-in-excel"]
["Go PAID: I highly recommend upgrading your account to a paid account to get you access to our full statement normalised fundamental data from New Constructs.  This data is fully normalised across almost 200 statement items, as well as 4 quarter, trailing 12m and full annual data going back 20 years.  And over 100 other endpoints and massively expanded available data.  AND CLOUD CASH IS INCLUDED SO PERFECT FOR REPEAT QUERIES","https://iexcloud.io/docs/api/#financials"]

{"sheet":"Settings","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Works with free accounts for a limited number of stocks.  Works best with a Paid account."]
[]
[]
["IEX Cloud Token",null,"< ----------- Enter your iexcloud token here"]
["Secret Token",null,"< ----------- Enter your secret iexcloud token here (prefix sk)"]
[]
["Scale in Millions","Y"]
[null,{"$f":"IF(B7=\"Y\",1000000,1)","v":1000000}]
[]
[]
["Your Account (requires Data/Refresh)"]
["creditLimit",{"$f":"VLOOKUP(Settings!A12,FetchAccount[],2,FALSE)","v":2000000000}]
["creditsUsed",{"$f":"VLOOKUP(Settings!A13,FetchAccount[],2,FALSE)","v":103542345}]
[]
[]
[]
["Base URLs (used in the comps table to construct the URLs)"]
["https://cloud.iexapis.com/stable/stock/"]
["https://cloud.iexapis.com/stable/data-points/"]
["https://cloud.iexapis.com/stable/account/metadata"]

{"sheet":"CompsTable","index":2,"n_rows":10,"n_cols":24,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,11,0,14],[0,15,0,17]]}
[null,null,null,null,null,null,null,null,null,null,null,"As Reported Fields lookup / dropdown ------->                                                  OR select column header (blue) and use right hand drop down",null,null,null,"OperatingIncomeLoss",null,null,null,null,null,null,"(do not delete)","(do not delete)"]
["Ticker","securityName","latestPrice","changePercent","week52high","%offhigh","week52low","%offLow","last-dividend-amount","last-dividend-payment-date","DividendYield","TTMeps","Trailing P/E","sharesOutstanding","marketcap","Revenues","OperatingIncomeLoss","NetIncome","EarningsPerShareBasic","EarningsPerShareDiluted","industry","website","URL_AsReported","URL_Company"]
["AAPL",{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(B$2,CompanyData[#Headers],0),FALSE)","v":"Apple Inc"},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&C$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&D$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&E$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52high]]-1","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&G$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52low]]-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&I$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&J$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&K$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&L$2&\"?token=\"&my_token)),\"\")","v":""},{"$f":"IFERROR(CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[TTMeps]],\"\")","v":""},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&N$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&O$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(P$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":274515},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(Q$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":66288},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(R$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":57411},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(S$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":3.31},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(T$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":3.28},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(U$2,CompanyData[#Headers],0),FALSE)","v":"Electronic Computer Manufacturing "},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(V$2,CompanyData[#Headers],0),FALSE)","v":"https://www.apple.com/"},{"$f":"\"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/\"&CompsTable[[#This Row],[Ticker]]&\"/10-K?last=1&token=\"&my_token","v":"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/AAPL/10-K?last=1&token="},{"$f":"\"https://cloud.iexapis.com/stable/stock/\"&CompsTable[[#This Row],[Ticker]]&\"/company/industry?token=\"&my_token","v":"https://cloud.iexapis.com/stable/stock/AAPL/company/industry?token="}]
["FB",{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(B$2,CompanyData[#Headers],0),FALSE)","v":"Facebook Inc - Class A"},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&C$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&D$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&E$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52high]]-1","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&G$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52low]]-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&I$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&J$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&K$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&L$2&\"?token=\"&my_token)),\"\")","v":""},{"$f":"IFERROR(CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[TTMeps]],\"\")","v":""},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&N$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&O$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(P$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":85965},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(Q$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":32671},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(R$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":29146},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(S$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":10.220000000000001},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(T$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":10.09},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(U$2,CompanyData[#Headers],0),FALSE)","v":"Data Processing, Hosting, and Related Services"},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(V$2,CompanyData[#Headers],0),FALSE)","v":"https://www.facebook.com"},{"$f":"\"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/\"&CompsTable[[#This Row],[Ticker]]&\"/10-K?last=1&token=\"&my_token","v":"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/FB/10-K?last=1&token="},{"$f":"\"https://cloud.iexapis.com/stable/stock/\"&CompsTable[[#This Row],[Ticker]]&\"/company/industry?token=\"&my_token","v":"https://cloud.iexapis.com/stable/stock/FB/company/industry?token="}]
["GME",{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(B$2,CompanyData[#Headers],0),FALSE)","v":"Gamestop Corporation - Class A"},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&C$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&D$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&E$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52high]]-1","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&G$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52low]]-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&I$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&J$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&K$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&L$2&\"?token=\"&my_token)),\"\")","v":""},{"$f":"IFERROR(CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[TTMeps]],\"\")","v":""},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&N$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&O$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(P$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":5089.8},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(Q$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":-237.8},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(R$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":-215.3},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(S$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":-3.31},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(T$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":-3.31},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(U$2,CompanyData[#Headers],0),FALSE)","v":"Electronics Stores "},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(V$2,CompanyData[#Headers],0),FALSE)","v":"http://news.gamestop.com/"},{"$f":"\"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/\"&CompsTable[[#This Row],[Ticker]]&\"/10-K?last=1&token=\"&my_token","v":"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/GME/10-K?last=1&token="},{"$f":"\"https://cloud.iexapis.com/stable/stock/\"&CompsTable[[#This Row],[Ticker]]&\"/company/industry?token=\"&my_token","v":"https://cloud.iexapis.com/stable/stock/GME/company/industry?token="}]
["TSLA",{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(B$2,CompanyData[#Headers],0),FALSE)","v":"Tesla Inc"},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&C$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/quote/\"&D$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&E$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52high]]-1","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&G$2&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"+CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[week52low]]-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&I$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&J$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&K$2&\"?token=\"&my_token),\"\"\"\",\"\")),\"\")","v":""},{"$f":"IFERROR(VALUE(_xlfn.WEBSERVICE(datapoints&CompsTable[[#This Row],[Ticker]]&\"/\"&L$2&\"?token=\"&my_token)),\"\")","v":""},{"$f":"IFERROR(CompsTable[[#This Row],[latestPrice]]/CompsTable[[#This Row],[TTMeps]],\"\")","v":""},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&N$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&CompsTable[[#This Row],[Ticker]]&\"/stats/\"&O$2&\"?token=\"&my_token))/1000000","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(P$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":31536},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(Q$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":1994},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(R$2,FundiesAdj[#Headers],0),FALSE)/Millions,\"\")","v":862},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(S$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":0.74},{"$f":"IFERROR(VLOOKUP(CompsTable[[#This Row],[Ticker]],FundiesAdj[],MATCH(T$2,FundiesAdj[#Headers],0),FALSE),\"\")","v":0.64},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(U$2,CompanyData[#Headers],0),FALSE)","v":"Automobile Manufacturing "},{"$f":"VLOOKUP(CompsTable[[#This Row],[Ticker]],CompanyData[],MATCH(V$2,CompanyData[#Headers],0),FALSE)","v":"https://www.tesla.com/"},{"$f":"\"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/\"&CompsTable[[#This Row],[Ticker]]&\"/10-K?last=1&token=\"&my_token","v":"https://cloud.iexapis.com/stable/time-series//REPORTED_FINANCIALS/TSLA/10-K?last=1&token="},{"$f":"\"https://cloud.iexapis.com/stable/stock/\"&CompsTable[[#This Row],[Ticker]]&\"/company/industry?token=\"&my_token","v":"https://cloud.iexapis.com/stable/stock/TSLA/company/industry?token="}]
[]
[]
["^ add tickers here.  You can insert new rows too."]
["to remove tickers, delete rows from table.  Do not remove top row!"]

{"sheet":"SideBySide","index":3,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"Section","Item","AAPL","GME","FB","TSLA","Add ticker (must be included in your comps table)"]
[null,null,null,{"$f":"SUBSTITUTE(_xlfn.WEBSERVICE(\"https://cloud.iexapis.com/stable/stock/\"&D1&\"/stats/companyName?token=\"&my_token),\"\"\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(_xlfn.WEBSERVICE(\"https://cloud.iexapis.com/stable/stock/\"&E1&\"/stats/companyName?token=\"&my_token),\"\"\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(_xlfn.WEBSERVICE(\"https://cloud.iexapis.com/stable/stock/\"&F1&\"/stats/companyName?token=\"&my_token),\"\"\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(_xlfn.WEBSERVICE(\"https://cloud.iexapis.com/stable/stock/\"&G1&\"/stats/companyName?token=\"&my_token),\"\"\"\",\"\")","v":{"$error":"#VALUE!"}},"Copy column across"]
[null,"Income Statement"]
[null,null,"Revenues",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C4,FundiesAdj[#Headers],0))/Millions","v":274515},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C4,FundiesAdj[#Headers],0))/Millions","v":5089.8},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C4,FundiesAdj[#Headers],0))/Millions","v":85965},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C4,FundiesAdj[#Headers],0))/Millions","v":31536}]
[null,null,"CostOfGoods",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C5,FundiesAdj[#Headers],0))/Millions","v":169559},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C5,FundiesAdj[#Headers],0))/Millions","v":3830.3},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C5,FundiesAdj[#Headers],0))/Millions","v":16692},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C5,FundiesAdj[#Headers],0))/Millions","v":24906}]
[null,null,"PreTaxProfit",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C6,FundiesAdj[#Headers],0))/Millions","v":67091},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C6,FundiesAdj[#Headers],0))/Millions","v":-269.89999999999998},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C6,FundiesAdj[#Headers],0))/Millions","v":33180},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C6,FundiesAdj[#Headers],0))/Millions","v":1154}]
[null,null,"NetIncome",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C7,FundiesAdj[#Headers],0))/Millions","v":57411},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C7,FundiesAdj[#Headers],0))/Millions","v":-215.3},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C7,FundiesAdj[#Headers],0))/Millions","v":29146},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C7,FundiesAdj[#Headers],0))/Millions","v":862}]
[]
[null,null,"OperatingIncome",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH(\"OperatingIncomeLoss\",FundiesAdj[#Headers],0))/Millions","v":66288},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH(\"OperatingIncomeLoss\",FundiesAdj[#Headers],0))/Millions","v":-237.8},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH(\"OperatingIncomeLoss\",FundiesAdj[#Headers],0))/Millions","v":32671},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH(\"OperatingIncomeLoss\",FundiesAdj[#Headers],0))/Millions","v":1994}]
[null,null,"EBITDA",{"$f":"IF(D11<>0,D9+D11,\"N/A\")","v":77344},{"$f":"IF(E11<>0,E9+E11,\"N/A\")","v":-157.80000000000001},39533,3564]
[null,null,"DepreciationDepletionAndAmmortisation",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C11,FundiesAdj[#Headers],0))/Millions","v":11056},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C11,FundiesAdj[#Headers],0))/Millions","v":80},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C11,FundiesAdj[#Headers],0))/Millions","v":6862},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C11,FundiesAdj[#Headers],0))/Millions","v":1570}]
[]
[]
[null,"Balance Sheet"]
[null,null,"CashAndCashEquivalents",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C15,FundiesAdj[#Headers],0))/Millions","v":39789},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C15,FundiesAdj[#Headers],0))/Millions","v":635},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C15,FundiesAdj[#Headers],0))/Millions","v":17954},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C15,FundiesAdj[#Headers],0))/Millions","v":19384}]
[null,null,"AccountsReceivableNetCurrent",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C16,FundiesAdj[#Headers],0))/Millions","v":16120},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C16,FundiesAdj[#Headers],0))/Millions","v":105.3},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C16,FundiesAdj[#Headers],0))/Millions","v":11330},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C16,FundiesAdj[#Headers],0))/Millions","v":1886}]
[null,null,"OtherAssetsCurrent",{"$f":"D18-D15","v":103924},{"$f":"E18-E15","v":916.2},57716,7333]
[null,null,"AssetsCurrent",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C18,FundiesAdj[#Headers],0))/Millions","v":143713},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C18,FundiesAdj[#Headers],0))/Millions","v":1551.2},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C18,FundiesAdj[#Headers],0))/Millions","v":75670},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C18,FundiesAdj[#Headers],0))/Millions","v":26717}]
[null,null,"PP&E",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C19,FundiesAdj[#Headers],0))/Millions","v":36766},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C19,FundiesAdj[#Headers],0))/Millions","v":201.2},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C19,FundiesAdj[#Headers],0))/Millions","v":45633},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C19,FundiesAdj[#Headers],0))/Millions","v":12747}]
[null,null,"Other LT Assets",{"$f":"D21-D18-D19","v":143409},{"$f":"E21-E18-E19","v":720.19999999999982},38013,12684]
[null,null,"Assets",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C21,FundiesAdj[#Headers],0))/Millions","v":323888},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C21,FundiesAdj[#Headers],0))/Millions","v":2472.6},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C21,FundiesAdj[#Headers],0))/Millions","v":159316},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C21,FundiesAdj[#Headers],0))/Millions","v":52148}]
[]
[null,"Liabilities"]
[null,null,"ShortTermDebt",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C24,FundiesAdj[#Headers],0))/Millions","v":8773},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C24,FundiesAdj[#Headers],0))/Millions","v":121.7},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C24,FundiesAdj[#Headers],0))/Millions","v":0},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C24,FundiesAdj[#Headers],0))/Millions","v":1758}]
[null,null,"AccountsPayableCurrent",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C25,FundiesAdj[#Headers],0))/Millions","v":42296},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C25,FundiesAdj[#Headers],0))/Millions","v":341.8},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C25,FundiesAdj[#Headers],0))/Millions","v":1331},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C25,FundiesAdj[#Headers],0))/Millions","v":6051}]
[null,null,"DeferredRevenueCurrent",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C26,FundiesAdj[#Headers],0))/Millions","v":6643},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C26,FundiesAdj[#Headers],0))/Millions","v":348.2},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C26,FundiesAdj[#Headers],0))/Millions","v":382},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C26,FundiesAdj[#Headers],0))/Millions","v":1458}]
[null,null,"OtherCurrentLiabilities(calculated)",{"$f":"+D28-D24-D25-D26","v":47680},{"$f":"+E28-E24-E25-E26","v":531},{"$f":"+F28-F24-F25-F26","v":13268},{"$f":"+G28-G24-G25-G26","v":4981}]
[null,null,"LiabilitiesCurrent",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C28,FundiesAdj[#Headers],0))/Millions","v":105392},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C28,FundiesAdj[#Headers],0))/Millions","v":1342.7},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C28,FundiesAdj[#Headers],0))/Millions","v":14981},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C28,FundiesAdj[#Headers],0))/Millions","v":14248}]
[null,null,"LongTermDebt",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C29,FundiesAdj[#Headers],0))/Millions","v":0},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C29,FundiesAdj[#Headers],0))/Millions","v":362.7},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C29,FundiesAdj[#Headers],0))/Millions","v":0},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C29,FundiesAdj[#Headers],0))/Millions","v":8462}]
[null,null,"OtherLongTermLiabilities (calculated)",{"$f":"+D31-D28-D29","v":153157},{"$f":"+E31-E28-E29","v":330.50000000000006},{"$f":"+F31-F28-F29","v":16045},{"$f":"+G31-G28-G29","v":5708}]
[null,null,"Liabilities",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C31,FundiesAdj[#Headers],0))/Millions","v":258549},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C31,FundiesAdj[#Headers],0))/Millions","v":2035.9},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C31,FundiesAdj[#Headers],0))/Millions","v":31026},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C31,FundiesAdj[#Headers],0))/Millions","v":28418}]
[]
[null,null,"StockholdersEquity",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C33,FundiesAdj[#Headers],0))/Millions","v":65339},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C33,FundiesAdj[#Headers],0))/Millions","v":436.7},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C33,FundiesAdj[#Headers],0))/Millions","v":128290},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C33,FundiesAdj[#Headers],0))/Millions","v":22225}]
[null,null,"LiabilitiesAndStockholdersEquity",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C34,FundiesAdj[#Headers],0))/Millions","v":323888},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C34,FundiesAdj[#Headers],0))/Millions","v":2472.6},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C34,FundiesAdj[#Headers],0))/Millions","v":159316},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C34,FundiesAdj[#Headers],0))/Millions","v":52148}]
[]
[null,"CashFlow"]
[null,null,"NetCashProvidedByUsedInFinancingActivities",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C37,FundiesAdj[#Headers],0))/Millions","v":-86820},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C37,FundiesAdj[#Headers],0))/Millions","v":-55.4},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C37,FundiesAdj[#Headers],0))/Millions","v":-10292},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C37,FundiesAdj[#Headers],0))/Millions","v":9973}]
[null,null,"NetCashProvidedByUsedInInvestingActivities",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C38,FundiesAdj[#Headers],0))/Millions","v":-4289},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C38,FundiesAdj[#Headers],0))/Millions","v":36.9},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C38,FundiesAdj[#Headers],0))/Millions","v":-30059},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C38,FundiesAdj[#Headers],0))/Millions","v":-3132}]
[null,null,"NetCashProvidedByUsedInOperatingActivities",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C39,FundiesAdj[#Headers],0))/Millions","v":80674},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C39,FundiesAdj[#Headers],0))/Millions","v":123.7},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C39,FundiesAdj[#Headers],0))/Millions","v":38747},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C39,FundiesAdj[#Headers],0))/Millions","v":5943}]
[]
[]
[null,"Ratios"]
[null,null,"EBIT Margin",{"$f":"+D9/D4","v":0.24147314354406862},{"$f":"+E9/E4","v":-4.6720892765924005E-2},{"$f":"+F9/F4","v":0.3800500203571221},{"$f":"+G9/G4","v":6.3229325215626589E-2}]
[null,null,"Net Margin",{"$f":"+D7/D4","v":0.20913611278072236},{"$f":"+E7/E4","v":-4.230028684820622E-2},{"$f":"+F7/F4","v":0.3390449601582039},{"$f":"+G7/G4","v":2.7333840690005072E-2}]
[null,null,"Return on Equity",{"$f":"D7/D33","v":0.87866358530127486},{"$f":"E7/E33","v":-0.49301580032058623},{"$f":"F7/F33","v":0.22718840127835374},3.8785151856017996E-2]
[null,null,"Days Revenue Outstanding (DRO/DSO)",{"$f":"+D16/D4*365","v":21.433437152796749},{"$f":"+E16/E4*365","v":7.551279028645526},{"$f":"+F16/F4*365","v":48.106206014075497},{"$f":"+G16/G4*365","v":21.828703703703702}]
[]
[null,"Valuation"]
[null,null,"Latest Price",{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&D1&\"/quote/latestPrice\"&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&E1&\"/quote/latestPrice\"&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&F1&\"/quote/latestPrice\"&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&G1&\"/quote/latestPrice\"&\"?token=\"&my_token))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"C58","v":"WeightedAverageNumberOfSharesOutstandingBasic"},{"$f":"D58","v":17352.118999999999},{"$f":"E58","v":65},{"$f":"F58","v":2851},{"$f":"G58","v":933}]
[null,null,"Market Cap (current),bn",{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&D$1&\"/stats/\"&\"marketcap\"&\"?token=\"&my_token))/1000000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&E$1&\"/stats/\"&\"marketcap\"&\"?token=\"&my_token))/1000000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&F$1&\"/stats/\"&\"marketcap\"&\"?token=\"&my_token))/1000000000","v":{"$error":"#VALUE!"}},{"$f":"VALUE(_xlfn.WEBSERVICE(Stock&G$1&\"/stats/\"&\"marketcap\"&\"?token=\"&my_token))/1000000000","v":{"$error":"#VALUE!"}}]
[null,null,"Enterprise Value (bn)",{"$f":"(D51*1000+D29+D24-D15)/1000","v":{"$error":"#VALUE!"}},{"$f":"(E51*1000+E29+E24-E15)/1000","v":{"$error":"#VALUE!"}},{"$f":"(F51*1000+F29+F24-F15)/1000","v":{"$error":"#VALUE!"}},{"$f":"(G51*1000+G29+G24-G15)/1000","v":{"$error":"#VALUE!"}}]
[null,null,"P/E",{"$f":"+D49/D61","v":{"$error":"#VALUE!"}},{"$f":"+E49/E61","v":{"$error":"#VALUE!"}},{"$f":"+F49/F61","v":{"$error":"#VALUE!"}},{"$f":"+G49/G61","v":{"$error":"#VALUE!"}}]
[null,null,"EV/EBITDA",{"$f":"+D52*1000/D10","v":{"$error":"#VALUE!"}},{"$f":"+E52*1000/E10","v":{"$error":"#VALUE!"}},{"$f":"+F52*1000/F10","v":{"$error":"#VALUE!"}},{"$f":"+G52*1000/G10","v":{"$error":"#VALUE!"}}]
[null,null,"P/BV",{"$f":"D51/D33*1000","v":{"$error":"#VALUE!"}},{"$f":"E51/E33*1000","v":{"$error":"#VALUE!"}},{"$f":"F51/F33*1000","v":{"$error":"#VALUE!"}},{"$f":"G51/G33*1000","v":{"$error":"#VALUE!"}}]
[]
[null,"Share Data (from filing)"]
[null,null,"WeightedAverageNumberOfSharesOutstandingBasic",{"$f":"IF(INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions>0,INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions,D7/D60)","v":17352.118999999999},{"$f":"IF(INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions>0,INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions,E7/E60)","v":65},{"$f":"IF(INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions>0,INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions,F7/F60)","v":2851},{"$f":"IF(INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions>0,INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C58,FundiesAdj[#Headers],0))/Millions,G7/G60)","v":933}]
[null,null,"WeightedAverageNumberOfDilutedSharesOutstanding",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C59,FundiesAdj[#Headers],0))/Millions","v":17528.214},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C59,FundiesAdj[#Headers],0))/Millions","v":65},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C59,FundiesAdj[#Headers],0))/Millions","v":2888},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C59,FundiesAdj[#Headers],0))/Millions","v":1083}]
[null,null,"EarningsPerShareBasic",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C60,FundiesAdj[#Headers],0))","v":3.31},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C60,FundiesAdj[#Headers],0))","v":-3.31},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C60,FundiesAdj[#Headers],0))","v":10.220000000000001},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C60,FundiesAdj[#Headers],0))","v":0.74}]
[null,null,"EarningsPerShareDiluted",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C61,FundiesAdj[#Headers],0))","v":3.28},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C61,FundiesAdj[#Headers],0))","v":-3.31},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C61,FundiesAdj[#Headers],0))","v":10.09},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C61,FundiesAdj[#Headers],0))","v":0.64}]
[]
[null,"Reference Data"]
[null,null,"dateFiled",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C64,FundiesAdj[#Headers],0))","v":"2020-10-30"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C64,FundiesAdj[#Headers],0))","v":"2021-03-23"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C64,FundiesAdj[#Headers],0))","v":"2021-01-28"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C64,FundiesAdj[#Headers],0))","v":"2021-02-08"}]
[null,null,"periodEnd",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C65,FundiesAdj[#Headers],0))","v":"2020-09-26"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C65,FundiesAdj[#Headers],0))","v":"2021-01-30"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C65,FundiesAdj[#Headers],0))","v":"2020-12-31"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C65,FundiesAdj[#Headers],0))","v":"2020-12-31"}]
[null,null,"subkey",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C66,FundiesAdj[#Headers],0))","v":"10-K"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C66,FundiesAdj[#Headers],0))","v":"10-K"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C66,FundiesAdj[#Headers],0))","v":"10-K"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C66,FundiesAdj[#Headers],0))","v":"10-K"}]
[null,null,"date",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C67,FundiesAdj[#Headers],0))","v":"2020-10-30"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C67,FundiesAdj[#Headers],0))","v":"2021-03-23"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C67,FundiesAdj[#Headers],0))","v":"2021-01-28"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C67,FundiesAdj[#Headers],0))","v":"2021-02-08"}]
[null,null,"updated",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C68,FundiesAdj[#Headers],0))","v":"2021-02-11"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C68,FundiesAdj[#Headers],0))","v":"2021-03-24"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C68,FundiesAdj[#Headers],0))","v":"2021-02-11"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C68,FundiesAdj[#Headers],0))","v":"2021-02-11"}]
[null,null,"updated",{"$f":"INDEX(FundiesAdj[],MATCH(D$1,FundiesAdj[Ticker],0),MATCH($C69,FundiesAdj[#Headers],0))","v":"2021-02-11"},{"$f":"INDEX(FundiesAdj[],MATCH(E$1,FundiesAdj[Ticker],0),MATCH($C69,FundiesAdj[#Headers],0))","v":"2021-03-24"},{"$f":"INDEX(FundiesAdj[],MATCH(F$1,FundiesAdj[Ticker],0),MATCH($C69,FundiesAdj[#Headers],0))","v":"2021-02-11"},{"$f":"INDEX(FundiesAdj[],MATCH(G$1,FundiesAdj[Ticker],0),MATCH($C69,FundiesAdj[#Headers],0))","v":"2021-02-11"}]

{"sheet":"Ticker Search","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"search"]
["Token","Base_Url","string","Full_URL"]
[{"$f":"+my_token","v":0},"https://cloud.iexapis.com/stable/search/",{"$f":"C8","v":"SONO"},{"$f":"+search[[#This Row],[Base_Url]]&search[[#This Row],[string]]&\"?token=\"&search[[#This Row],[Token]]","v":"https://cloud.iexapis.com/stable/search/SONO?token=0"}]
[]
[null,"Powerquery:",null,"= Json.Document(Web.Contents(Excel.CurrentWorkbook(){[Name=\"search\"]}[Content]{0}[Full_URL]))"]
["Only works with a paid account"]
[]
["Co name or ticker ------>",null,"SONO"]
[]
["Results"]
[]
["Recommended","symbol","cik","securityName","securityType","region","exchange","sector","currency"]
[null,"PHBA-GB","0001450681","Sonova Holding AG - ADR","ad","DE","BER","Manufacturing","EUR"]
[null,"0QPY-LN","0001450681","Sonova Holding AG","cs","GB","LON","Manufacturing","CHF"]
[null,"PHBA-GS","0001450681","Sonova Holding AG - ADR","ad","DE","STU","Manufacturing","EUR"]
[null,"PHBA-GF","0001450681","Sonova Holding AG - ADR","ad","DE","FRA","Manufacturing","EUR"]
[null,"SOON-SE","0001450681","Sonova Holding AG","cs","CH","SWX","Manufacturing","CHF"]
[null,"SONVF","0001450681","Sonova Holding AG","cs","US","PINX","Manufacturing","USD"]
[null,"066910-KQ",null,"Sonokong Co Ltd","cs","KR","KRKSDQ","Manufacturing","KRW"]
[null,"SOONE-SE","0001450681","Sonova Holding AG (Buyback)","cs","CH","SWX","Manufacturing","CHF"]
[null,"SONVY","0001450681","Sonova Holding AG - ADR","ad","US","PINX","Manufacturing","USD"]

{"sheet":"CompanyData","index":5,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["symbol","companyName","exchange","industry","website","description","CEO","securityName","issueType","sector","primarySicCode","employees","tags","address","address2","state","city","zip","country","phone"]
["AAPL","Apple Inc","NASDAQ/NGS (GLOBAL SELECT MARKET)","Electronic Computer Manufacturing ","https://www.apple.com/","Apple Inc. is an American multinational technology company headquartered in Cupertino, California, that designs, develops, and sells consumer electronics, computer software, and online services. It is considered one of the Big Five companies in the U.S. information technology industry, along with Amazon, Google, Microsoft, and Facebook. Its hardware products include the iPhone smartphone, the iPad tablet computer, the Mac personal computer, the iPod portable media player, the Apple Watch smartwatch, the Apple TV digital media player, the AirPods wireless earbuds, the AirPods Max headphones, and the HomePod smart speaker line. Apple's software includes iOS, iPadOS, macOS, watchOS, and tvOS operating systems, the iTunes media player, the Safari web browser, the Shazam music identifier, and the iLife and iWork creativity and productivity suites, as well as professional applications like Final Cut Pro X, Logic Pro, and Xcode. Its online services include the iTunes Store, the iOS App Store, Mac App Store, Apple Arcade, Apple Music, Apple TV+, iMessage, and iCloud. Other services include Apple Store, Genius Bar, AppleCare, Apple Pay, Apple Pay Cash, and Apple Card. Apple was founded by Steve Jobs, Steve Wozniak, and Ronald Wayne in April 1976 to develop and sell Wozniak's Apple I personal computer, though Wayne sold his share back within 12 days. It was incorporated as Apple Computer, Inc., in January 1977, and sales of its computers, including the Apple I and Apple II, grew quickly.","Timothy Cook","Apple Inc","cs","Manufacturing",3571,147000,"[List]","1 Apple Park Way",null,"California","Cupertino","95014-0642","US",14089961010]
["FB","Facebook Inc","NASDAQ/NGS (GLOBAL SELECT MARKET)","Data Processing, Hosting, and Related Services","https://www.facebook.com","Founded in 2004, Facebook's mission is to give people the power to build community and bring the world closer together. People use Facebook's apps and technologies to connect with friends and family, find communities and grow businesses.","Mark Zuckerberg","Facebook Inc - Class A","cs","Information",7374,52534,"[List]","1601 Willow Rd",null,"California","Menlo Park","94025-1452","US",16506187714]
["GME","Gamestop Corporation","NEW YORK STOCK EXCHANGE, INC.","Electronics Stores ","http://news.gamestop.com/","","George Sherman","Gamestop Corporation - Class A","cs","Retail Trade",5734,null,"[List]","625 Westport Pkwy",null,"Texas","Grapevine","76051-6740","US",18174242000]
["TSLA","Tesla Inc","NASDAQ/NGS (GLOBAL SELECT MARKET)","Automobile Manufacturing ","https://www.tesla.com/","Tesla’s mission is to accelerate the world’s transition to sustainable energy. Since its founding in 2003, Tesla has broken new barriers in developing high-performance automobiles that are not only the world’s best and highest-selling pure electric vehicles—with long range and absolutely no tailpipe emissions—but also the safest, highest-rated cars on the road in the world. Beyond the flagship Model S sedan and the falcon-winged door Model X sports utility vehicle, Tesla also offers a smaller, simpler and more affordable mid-sized sedan, Model 3, which it is expected will truly propel electric vehicles into the mainstream.  In addition, with the opening of the Gigafactory and the acquisition of SolarCity, Tesla now offers a full suite of energy products that incorporates solar, storage, and grid services. As the world’s only fully integrated sustainable energy company, Tesla is at the vanguard of the world’s inevitable shift towards a sustainable energy platform.","Elon Musk","Tesla Inc","cs","Manufacturing",3711,48016,"[List]","3500 Deer Creek Rd",null,"California","Palo Alto","94304-1317","US",16506815000]

{"sheet":"S&P 500","index":6,"n_rows":506,"n_cols":6,"rows_kept":506,"cut":false,"hidden":false,"merged":[]}
["Symbol","Security","Headquarters Location","Date first added","CIK","Founded"]
["A","Agilent Technologies","Santa Clara, California","2000-06-05",1090872,"1999"]
["AAL","American Airlines Group","Fort Worth, Texas","2015-03-23",6201,"1934"]
["AAP","Advance Auto Parts","Raleigh, North Carolina","2015-07-09",1158449,"1932"]
["AAPL","Apple Inc.","Cupertino, California","1982-11-30",320193,"1977"]
["ABBV","AbbVie Inc.","North Chicago, Illinois","2012-12-31",1551152,"2013 (1888)"]
["ABC","AmerisourceBergen","Chesterbrook, Pennsylvania","2001-08-30",1140859,"1985"]
["ABMD","Abiomed","Danvers, Massachusetts","2018-05-31",815094,"1981"]
["ABT","Abbott Laboratories","North Chicago, Illinois","1964-03-31",1800,"1888"]
["ACN","Accenture","Dublin, Ireland","2011-07-06",1467373,"1989"]
["ADBE","Adobe Inc.","San Jose, California","1997-05-05",796343,"1982"]
["ADI","Analog Devices, Inc.","Norwood, Massachusetts","1999-10-12",6281,"1965"]
["ADM","Archer-Daniels-Midland Co","Chicago, Illinois","1981-07-29",7084,"1902"]
["ADP","Automatic Data Processing","Roseland, New Jersey","1981-03-31",8670,"1949"]
["ADSK","Autodesk Inc.","San Rafael, California","1989-12-01",769397,"1982"]
["AEE","Ameren Corp","St. Louis, Missouri","1991-09-19",1002910,"1902"]
["AEP","American Electric Power","Columbus, Ohio","1957-03-04",4904,"1906"]
["AES","AES Corp","Arlington, Virginia","1998-10-02",874761,"1981"]
["AFL","Aflac","Columbus, Georgia","1999-05-28",4977,"1955"]
["AIG","American International Group","New York, New York","1980-03-31",5272,"1919"]
["AIZ","Assurant","New York, New York","2007-04-10",1267238,"1892"]
["AJG","Arthur J. Gallagher & Co.","Rolling Meadows, Illinois","2016-05-31",354190,"1927"]
["AKAM","Akamai Technologies","Cambridge, Massachusetts","2007-07-12",1086222,"1998"]
["ALB","Albemarle Corporation","Charlotte, North Carolina","2016-07-01",915913,"1994"]
["ALGN","Align Technology","San Jose, California","2017-06-19",1097149,"1997"]
["ALK","Alaska Air Group","Seattle, Washington","2016-05-13",766421,"1985"]
["ALL","Allstate Corp","Northfield Township, Illinois","1995-07-13",899051,"1931"]
["ALLE","Allegion","Dublin, Ireland","2013-12-02",1579241,"1908"]
["ALXN","Alexion Pharmaceuticals","Boston, Massachusetts","2012-05-25",899866,"1992"]
["AMAT","Applied Materials Inc.","Santa Clara, California","1995-03-16",6951,"1967"]
["AMCR","Amcor plc","Warmley, Bristol, United Kingdom","2019-06-07",1748790,"2019 (1860)"]
["AMD","Advanced Micro Devices","Santa Clara, California","2017-03-20",2488,"1969"]
["AME","Ametek","Berwyn, Pennsylvania","2013-09-23",1037868,"1930"]
["AMGN","Amgen Inc.","Thousand Oaks, California","1992-01-02",318154,"1980"]
["AMP","Ameriprise Financial","Minneapolis, Minnesota","2005-10-03",820027,"1894"]
["AMT","American Tower Corp.","Boston, Massachusetts","2007-11-19",1053507,"1995"]
["AMZN","Amazon.com Inc.","Seattle, Washington","2005-11-18",1018724,"1994"]
["ANET","Arista Networks","Santa Clara, California","2018-08-28",1596532,"2004"]
["ANSS","ANSYS, Inc.","Canonsburg, Pennsylvania","2017-06-19",1013462,"1969"]
["ANTM","Anthem","Indianapolis, Indiana","2002-07-25",1156039,"2014 (1946)"]
["AON","Aon plc","London, United Kingdom","1996-04-23",315293,"1982 (1919)"]
["AOS","A.O. Smith Corp","Milwaukee, Wisconsin","2017-07-26",91142,"1916"]
["APA","APA Corporation","Houston, Texas","1997-07-28",6769,"1954"]
["APD","Air Products & Chemicals","Allentown, Pennsylvania","1985-04-30",2969,"1940"]
["APH","Amphenol Corp","Wallingford, Connecticut","2008-09-30",820313,"1932"]
["APTV","Aptiv PLC","Dublin, Ireland","2012-12-24",1521332,"1994"]
["ARE","Alexandria Real Estate Equities","Pasadena, California","2017-03-20",1035443,"1994"]
["ATO","Atmos Energy","Dallas, Texas","2019-02-15",731802,"1906"]
["ATVI","Activision Blizzard","Santa Monica, California","2015-08-31",718877,"2008"]
["AVB","AvalonBay Communities","Arlington, Virginia","2007-01-10",915912,"1978"]
["AVGO","Broadcom Inc.","San Jose, California","2014-05-08",1730168,"1961"]
["AVY","Avery Dennison Corp","Glendale, California","1987-12-31",8818,"1990"]
["AWK","American Water Works","Camden, New Jersey","2016-03-04",1410636,"1886"]
["AXP","American Express","New York, New York","1976-06-30",4962,"1850"]
["AZO","AutoZone Inc","Memphis, Tennessee","1997-01-02",866787,"1979"]
["BA","Boeing Company","Chicago, Illinois","1957-03-04",12927,"1916"]
["BAC","Bank of America Corp","Charlotte, North Carolina","1976-06-30",70858,"1998 (1923 / 1874)"]
["BAX","Baxter International Inc.","Deerfield, Illinois","1972-09-30",10456,"1931"]
["BBY","Best Buy Co. Inc.","Richfield, Minnesota","1999-06-29",764478,"1966"]
["BDX","Becton Dickinson","Franklin Lakes, New Jersey","1972-09-30",10795,"1897"]
["BEN","Franklin Resources","San Mateo, California",null,38777,"1947"]
["BF.B","Brown-Forman Corp.","Louisville, Kentucky","1982-10-31",14693,"1870"]
["BIIB","Biogen Inc.","Cambridge, Massachusetts","2003-11-13",875045,"1978"]
["BIO","Bio-Rad Laboratories","Hercules, California","2020-06-22",12208,"1952"]
["BK","The Bank of New York Mellon","New York, New York","1995-03-31",1390777,"1784"]
["BKNG","Booking Holdings Inc","Norwalk, Connecticut","2009-11-06",1075531,"1996"]
["BKR","Baker Hughes Co","Houston, Texas","2017-07-07",1701605,"2017"]
["BLK","BlackRock","New York, New York","2011-04-04",1364742,"1988"]
["BLL","Ball Corp","Broomfield, Colorado","1984-10-31",9389,"1880"]
["BMY","Bristol-Myers Squibb","New York, New York","1957-03-04",14272,"1989"]
["BR","Broadridge Financial Solutions","Lake Success, New York","2018-06-18",1383312,"1962"]
["BRK.B","Berkshire Hathaway","Omaha, Nebraska","2010-02-16",1067983,"1839"]
["BSX","Boston Scientific","Marlborough, Massachusetts","1995-02-24",885725,"1979"]
["BWA","BorgWarner","Auburn Hills, Michigan","2011-12-19",908255,"1880"]
["BXP","Boston Properties","Boston, Massachusetts","2006-04-03",1037540,"1970"]
["C","Citigroup Inc.","New York, New York","1988-05-31",831001,"1998"]
["CAG","Conagra Brands","Chicago, Illinois","1983-08-31",23217,"1919"]
["CAH","Cardinal Health Inc.","Dublin, Ohio","1997-05-27",721371,"1971"]
["CARR","Carrier Global","Palm Beach Gardens, Florida","2020-04-03",1783180,"2020 (1915)"]
["CAT","Caterpillar Inc.","Deerfield, Illinois","1957-03-04",18230,"1925"]
["CB","Chubb Limited","Zurich, Switzerland","2010-07-15",896159,"1985"]
["CBOE","Cboe Global Markets","Chicago, Illinois","2017-03-01",1374310,"1973"]
["CBRE","CBRE Group","Dallas, Texas","2006-11-10",1138118,"1906"]
["CCI","Crown Castle","Houston, Texas","2012-03-14",1051470,"1994"]
["CCL","Carnival Corp.","Miami, Florida","1998-12-22",815097,"1972"]
["CDNS","Cadence Design Systems","San Jose, California","2017-09-18",813672,"1988"]
["CDW","CDW","Lincolnshire, Illinois","2019-09-23",1402057,"1984"]
["CE","Celanese","Irving, Texas","2018-12-24",1306830,"1918"]
["CERN","Cerner","North Kansas City, Missouri","2010-04-30",804753,"1979"]
["CF","CF Industries Holdings Inc","Deerfield, Illinois","2008-08-27",1324404,"1946"]
["CFG","Citizens Financial Group","Providence, Rhode Island","2016-01-29",759944,"1828"]
["CHD","Church & Dwight","Ewing, New Jersey","2015-12-29",313927,"1847"]
["CHRW","C. H. Robinson Worldwide","Eden Prairie, Minnesota","2007-03-02",1043277,"1905"]
["CHTR","Charter Communications","Stamford, Connecticut","2016-09-08",1091667,"1993"]
["CI","Cigna","Bloomfield, Connecticut","1976-06-30",1739940,"1982"]
["CINF","Cincinnati Financial","Fairfield, Ohio","1997-12-18",20286,"1950"]
["CL","Colgate-Palmolive","New York, New York","1957-03-04",21665,"1806"]
["CLX","The Clorox Company","Oakland, California","1969-03-31",21076,"1913"]
["CMA","Comerica Inc.","Dallas, Texas","1995-12-01",28412,"1849"]
["CMCSA","Comcast Corp.","Philadelphia, Pennsylvania","2002-11-19",1166691,"1963"]
["CME","CME Group Inc.","Chicago, Illinois","2006-08-11",1156375,"1848"]
["CMG","Chipotle Mexican Grill","Newport Beach, California","2011-04-28",1058090,"1993"]
["CMI","Cummins Inc.","Columbus, Indiana","1965-03-31",26172,"1919"]
["CMS","CMS Energy","Jackson, Michigan","1999-05-03",811156,"1886"]
["CNC","Centene Corporation","St. Louis, Missouri","2016-03-30",1071739,"1984"]
["CNP","CenterPoint Energy","Houston, Texas","1985-07-31",1130310,"1882"]
["COF","Capital One Financial","Tysons Corner, Virginia","1998-07-01",927628,"1994"]
["COG","Cabot Oil & Gas","Houston, Texas","2008-06-23",858470,"1989"]
["COO","The Cooper Companies","San Ramon, California","2016-09-23",711404,"1958"]
["COP","ConocoPhillips","Houston, Texas","1957-03-04",1163165,"2002"]
["COST","Costco Wholesale Corp.","Issaquah, Washington","1993-10-01",909832,"1976"]
["CPB","Campbell Soup","Camden, New Jersey","1957-03-04",16732,"1869"]
["CPRT","Copart Inc","Dallas, Texas","2018-07-02",900075,"1982"]
["CRM","Salesforce.com","San Francisco, California","2008-09-15",1108524,"1999"]
["CSCO","Cisco Systems","San Jose, California","1993-12-01",858877,"1984"]
["CSX","CSX Corp.","Jacksonville, Florida","1967-09-30",277948,"1980"]
["CTAS","Cintas Corporation","Mason, Ohio","2001-03-01",723254,"1929"]
["CTLT","Catalent","Somerset, New Jersey","2020-09-21",1596783,"2007"]
["CTSH","Cognizant Technology Solutions","Teaneck, New Jersey","2006-11-17",1058290,"1994"]
["CTVA","Corteva","Wilmington, Delaware","2019-06-03",1755672,"2019"]
["CTXS","Citrix Systems","Fort Lauderdale, Florida","1999-12-01",877890,"1989"]
["CVS","CVS Health","Woonsocket, Rhode Island","1957-03-04",64803,"1996"]
["CVX","Chevron Corp.","San Ramon, California","1957-03-04",93410,"1879"]
["CZR","Caesars Entertainment","Reno, Nevada","2021-03-22",1590895,"1973"]
["D","Dominion Energy","Richmond, Virginia",null,715957,"1983"]
["DAL","Delta Air Lines Inc.","Atlanta, Georgia","2013-09-11",27904,"1929"]
["DD","DuPont de Nemours Inc","Wilmington, Delaware","2019-04-02",1666700,"2017"]
["DE","Deere & Co.","Moline, Illinois","1957-03-04",315189,"1837"]
["DFS","Discover Financial Services","Riverwoods, Illinois","2007-07-02",1393612,"1985"]
["DG","Dollar General","Goodlettsville, Tennessee","2012-12-03",29534,"1939"]
["DGX","Quest Diagnostics","Secaucus, New Jersey","2002-12-12",1022079,"1967"]
["DHI","D. R. Horton","Arlington, Texas","2005-06-22",882184,"1978"]
["DHR","Danaher Corp.","Washington, D.C.",null,313616,"1969"]
["DIS","The Walt Disney Company","Burbank, California","1976-06-30",1744489,"1923"]
["DISCA","Discovery, Inc. (Series A)","New York, New York","2010-03-01",1437107,"1985"]
["DISCK","Discovery, Inc. (Series C)","New York, New York","2014-08-07",1437107,"1985"]
["DISH","Dish Network","Meridian, Colorado","2017-03-13",1001082,"1980"]
["DLR","Digital Realty Trust Inc","Austin, Texas","2016-05-18",1297996,"2004"]
["DLTR","Dollar Tree","Chesapeake, Virginia","2011-12-19",935703,"1986"]
["DOV","Dover Corporation","Downers Grove, Illinois","1985-10-31",29905,"1955"]
["DOW","Dow Inc.","Midland, Michigan","2019-04-01",1751788,"2019"]
["DPZ","Domino's Pizza","Ann Arbor, Michigan","2020-05-12",1286681,"1960"]
["DRE","Duke Realty Corp","Indianapolis, Indiana","2017-07-26",783280,"1972"]
["DRI","Darden Restaurants","Orlando, Florida",null,940944,"1938"]
["DTE","DTE Energy Co.","Detroit, Michigan","1957-03-04",936340,"1995"]
["DUK","Duke Energy","Charlotte, North Carolina","1976-06-30",1326160,"1904"]
["DVA","DaVita Inc.","Denver, Colorado","2008-07-31",927066,"1979"]
["DVN","Devon Energy","Oklahoma City, Oklahoma","2000-08-30",1090012,"1971"]
["DXC","DXC Technology","Tysons Corner, Virginia","2017-04-04",1688568,"2017"]
["DXCM","DexCom","San Diego, California","2020-05-12",1093557,"1999"]
["EA","Electronic Arts","Redwood City, California","2002-07-22",712515,"1982"]
["EBAY","eBay Inc.","San Jose, California","2002-07-22",1065088,"1995"]
["ECL","Ecolab Inc.","St. Paul, Minnesota","1989-01-31",31462,"1923"]
["ED","Consolidated Edison","New York, New York",null,1047862,"1823"]
["EFX","Equifax Inc.","Atlanta, Georgia","1997-06-19",33185,"1899"]
["EIX","Edison Int'l","Rosemead, California","1957-03-04",827052,"1886"]
["EL","Estée Lauder Companies","New York, New York","2006-01-05",1001250,"1946"]
["EMN","Eastman Chemical","Kingsport, Tennessee","1994-01-01",915389,"1920"]
["EMR","Emerson Electric Company","Ferguson, Missouri","1965-03-31",32604,"1890"]
["ENPH","Enphase Energy","Fremont, California","2021-01-07",1463101,"2006"]
["EOG","EOG Resources","Houston, Texas","2000-11-02",821189,"1999"]
["EQIX","Equinix","Redwood City, California","2015-03-20",1101239,"1998"]
["EQR","Equity Residential","Chicago, Illinois","2001-12-03",906107,"1969"]
["ES","Eversource Energy","Hartford, Connecticut",null,72741,"1966"]
["ESS","Essex Property Trust, Inc.","San Mateo, California","2014-04-02",920522,"1971"]
["ETN","Eaton Corporation","Dublin, Ireland",null,1551182,"1911"]
["ETR","Entergy Corp.","New Orleans, Louisiana","1957-03-04",65984,"1913"]
["ETSY","Etsy","Brooklyn, New York","2020-09-21",1370637,"2005"]
["EVRG","Evergy","Kansas City, Missouri","2018-06-05",1711269,"1909"]
["EW","Edwards Lifesciences","Irvine, California","2011-04-01",1099800,"1958"]
["EXC","Exelon Corp.","Chicago, Illinois","1957-03-04",1109357,"2000"]
["EXPD","Expeditors","Seattle, Washington","2007-10-10",746515,"1979"]
["EXPE","Expedia Group","Seattle, Washington","2007-10-02",1324424,"1996"]
["EXR","Extra Space Storage","Salt Lake City, Utah","2016-01-19",1289490,"1977"]
["F","Ford Motor Company","Dearborn, Michigan","1957-03-04",37996,"1903"]
["FANG","Diamondback Energy","Midland, Texas","2018-12-03",1539838,"2007"]
["FAST","Fastenal Co","Winona, Minnesota","2008-09-15",815556,"1967"]
["FB","Facebook, Inc.","Menlo Park, California","2013-12-23",1326801,"2004"]
["FBHS","Fortune Brands Home & Security","Deerfield, Illinois","2016-06-22",1519751,"2011 (1969)"]
["FCX","Freeport-McMoRan Inc.","Phoenix, Arizona",null,831259,"1912"]
["FDX","FedEx Corporation","Memphis, Tennessee","1980-12-31",1048911,"1971"]
["FE","FirstEnergy Corp","Akron, Ohio",null,1031296,"1997"]
["FFIV","F5 Networks","Seattle, Washington","2010-12-20",1048695,"1996"]
["FIS","Fidelity National Information Services","Jacksonville, Florida","2006-11-10",1136893,"1968"]
["FISV","Fiserv Inc","Brookfield, Wisconsin","2001-04-02",798354,"1984"]
["FITB","Fifth Third Bancorp","Cincinnati, Ohio",null,35527,"1858"]
["FLIR","FLIR Systems","Wilsonville, Oregon","2009-01-02",354908,"1978"]
["FLT","FleetCor Technologies Inc","Norcross, Georgia","2018-06-20",1175454,"2000"]
["FMC","FMC Corporation","Philadelphia, Pennsylvania","2009-08-19",37785,"1883"]
["FOX","Fox Corporation (Class B)","New York, New York","2015-09-18",1754301,"2019"]
["FOXA","Fox Corporation (Class A)","New York, New York","2013-07-01",1754301,"2019"]
["FRC","First Republic Bank","San Francisco, California","2019-01-02",1132979,"1985"]
["FRT","Federal Realty Investment Trust","Rockville, Maryland","2016-02-01",34903,"1962"]
["FTNT","Fortinet","Sunnyvale, California","2018-10-11",1262039,"2000"]
["FTV","Fortive Corp","Everett, Washington","2016-07-01",1659166,"2016"]
["GD","General Dynamics","Falls Church, Virginia","1957-03-04",40533,"1899"]
["GE","General Electric","Boston, Massachusetts",null,40545,"1892"]
["GILD","Gilead Sciences","Foster City, California","2004-07-01",882095,"1987"]
["GIS","General Mills","Golden Valley, Minnesota","1969-03-31",40704,"1856"]
["GL","Globe Life Inc.","McKinney, Texas","1989-04-30",320335,"1900"]
["GLW","Corning Inc.","Corning, New York",null,24741,"1851"]
["GM","General Motors","Detroit, Michigan","2013-06-06",1467858,"1908"]
["GNRC","Generac Holdings","Waukesha, Wisconsin","2021-03-22",1474735,"1959"]
["GOOG","Alphabet Inc. (Class C)","Mountain View, California","2006-04-03",1652044,"1998"]
["GOOGL","Alphabet Inc. (Class A)","Mountain View, California","2014-04-03",1652044,"1998"]
["GPC","Genuine Parts","Atlanta, Georgia","1973-12-31",40987,"1925"]
["GPN","Global Payments Inc.","Atlanta, Georgia","2016-04-25",1123360,"2000"]
["GPS","Gap Inc.","San Francisco, California","1986-08-31",39911,"1969"]
["GRMN","Garmin Ltd.","Schaffhausen, Switzerland","2012-12-12",1121788,"1989"]
["GS","Goldman Sachs Group","New York, New York","2002-07-22",886982,"1869"]
["GWW","Grainger (W.W.) Inc.","Lake Forest, Illinois","1981-06-30",277135,"1927"]
["HAL","Halliburton Co.","Houston, Texas","1957-03-04",45012,"1919"]
["HAS","Hasbro Inc.","Pawtucket, Rhode Island","1984-09-30",46080,"1923"]
["HBAN","Huntington Bancshares","Columbus, Ohio",null,49196,"1866"]
["HBI","Hanesbrands Inc","Winston-Salem, North Carolina","2015-03-20",1359841,"2000"]
["HCA","HCA Healthcare","Nashville, Tennessee","2015-01-27",860730,"1968"]
["HD","Home Depot","Atlanta, Georgia","1988-03-31",354950,"1978"]
["HES","Hess Corporation","New York, New York","1984-05-31",4447,"1919"]
["HFC","HollyFrontier Corp","Dallas, Texas","2018-06-18",48039,"1947"]
["HIG","Hartford Financial Svc.Gp.","Hartford, Connecticut","1957-03-04",874766,"1810"]
["HII","Huntington Ingalls Industries","Newport News, Virginia","2018-01-03",1501585,"2011"]
["HLT","Hilton Worldwide Holdings Inc","Tysons Corner, Virginia","2017-06-19",1585689,"1919"]
["HOLX","Hologic","Marlborough, Massachusetts","2016-03-30",859737,"1985"]
["HON","Honeywell Int'l Inc.","Charlotte, North Carolina","1964-03-31",773840,"1906"]
["HPE","Hewlett Packard Enterprise","Houston, Texas","2015-11-02",1645590,"2015"]
["HPQ","HP Inc.","Palo Alto, California","1974-12-31",47217,"1939 (2015)"]
["HRL","Hormel Foods Corp.","Austin, Minnesota","2009-03-04",48465,"1891"]
["HSIC","Henry Schein","Melville, New York","2015-03-17",1000228,"1932"]
["HST","Host Hotels & Resorts","Bethesda, Maryland","2007-03-20",1070750,"1993"]
["HSY","The Hershey Company","Hershey, Pennsylvania","1957-03-04",47111,"1894"]
["HUM","Humana Inc.","Louisville, Kentucky",null,49071,"1961"]
["HWM","Howmet Aerospace","Pittsburgh, Pennsylvania","1964-03-31",4281,"2016"]
["IBM","International Business Machines","Armonk, New York","1957-03-04",51143,"1911"]
["ICE","Intercontinental Exchange","Atlanta, Georgia","2007-09-26",1571949,"2000"]
["IDXX","Idexx Laboratories","Westbrook, Maine","2017-01-05",874716,"1983"]
["IEX","IDEX Corporation","Lake Forest, Illinois","2019-08-09",832101,"1988"]
["IFF","International Flavors & Fragrances","New York, New York","1976-03-31",51253,"1958 (1889)"]
["ILMN","Illumina Inc","San Diego, California","2015-11-19",1110803,"1998"]
["INCY","Incyte","Wilmington, Delaware","2017-02-28",879169,"1991"]
["INFO","IHS Markit","London, United Kingdom","2017-06-02",1598014,"1959"]
["INTC","Intel Corp.","Santa Clara, California","1976-12-31",50863,"1968"]
["INTU","Intuit Inc.","Mountain View, California","2000-12-05",896878,"1983"]
["IP","International Paper","Memphis, Tennessee","1957-03-04",51434,"1898"]
["IPG","Interpublic Group","New York, New York","1992-10-01",51644,"1961 (1930)"]
["IPGP","IPG Photonics Corp.","Oxford, Massachusetts","2018-03-07",1111928,"1990"]
["IQV","IQVIA Holdings Inc.","Durham, North Carolina","2017-08-29",1478242,"1982"]
["IR","Ingersoll Rand","Milwaukee, Wisconsin","2020-03-03",1699150,"1859"]
["IRM","Iron Mountain Incorporated","Boston, Massachusetts","2009-01-06",1020569,"1951"]
["ISRG","Intuitive Surgical Inc.","Sunnyvale, California","2008-06-02",1035267,"1995"]
["IT","Gartner Inc","Stamford, Connecticut","2017-04-05",749251,"1979"]
["ITW","Illinois Tool Works","Glenview, Illinois","1986-02-28",49826,"1912"]
["IVZ","Invesco Ltd.","Atlanta, Georgia","2008-08-21",914208,"1935"]
["J","Jacobs Engineering Group","Dallas, Texas","2007-10-26",52988,"1947"]
["JBHT","J. B. Hunt Transport Services","Lowell, Arkansas","2015-07-01",728535,"1961"]
["JCI","Johnson Controls International","Cork, Ireland","2010-08-27",833444,"1885"]
["JKHY","Jack Henry & Associates","Monett, Missouri","2018-11-13",779152,"1976"]
["JNJ","Johnson & Johnson","New Brunswick, New Jersey","1973-06-30",200406,"1886"]
["JNPR","Juniper Networks","Sunnyvale, California","2006-06-02",1043604,"1996"]
["JPM","JPMorgan Chase & Co.","New York, New York","1975-06-30",19617,"2000 (1799 / 1871)"]
["K","Kellogg Co.","Battle Creek, Michigan",null,55067,"1906"]
["KEY","KeyCorp","Cleveland, Ohio","1994-03-01",91576,"1825"]
["KEYS","Keysight Technologies","Santa Rosa, California","2018-11-06",1601046,"2014"]
["KHC","Kraft Heinz Co","Chicago, Illinois; Pittsburgh, Pennsylvania","2015-07-06",1637459,"2015 (1869)"]
["KIM","Kimco Realty","New Hyde Park, New York","2006-04-04",879101,"1958"]
["KLAC","KLA Corporation","Milpitas, California",null,319201,"1975/1977 (1997)"]
["KMB","Kimberly-Clark","Irving, Texas","1957-03-04",55785,"1872"]
["KMI","Kinder Morgan","Houston, Texas","2012-05-25",1506307,"1997"]
["KMX","Carmax Inc","Richmond, Virginia","2010-06-28",1170010,"1993"]
["KO","Coca-Cola Company","Atlanta, Georgia","1957-03-04",21344,"1886"]
["KR","Kroger Co.","Cincinnati, Ohio","1957-03-04",56873,"1883"]
["KSU","Kansas City Southern","Kansas City, Missouri","2013-05-24",54480,"1887"]
["L","Loews Corp.","New York, New York",null,60086,"1959"]
["LB","L Brands Inc.","Columbus, Ohio","1983-09-30",701985,"1963"]
["LDOS","Leidos Holdings","Reston, Virginia","2019-08-09",1336920,"1969"]
["LEG","Leggett & Platt","Carthage, Missouri",null,58492,"1883"]
["LEN","Lennar Corp.","Miami, Florida","2005-10-04",920760,"1954"]
["LH","Laboratory Corp. of America Holding","Burlington, North Carolina","2004-11-01",920148,"1978"]
["LHX","L3Harris Technologies","Melbourne, Florida","2008-09-22",202058,"2019 (1895)"]
["LIN","Linde plc","Guildford, Surrey, United Kingdom","1992-07-01",1707925,"1879"]
["LKQ","LKQ Corporation","Chicago, Illinois","2016-05-23",1065696,"1998"]
["LLY","Lilly (Eli) & Co.","Indianapolis, Indiana","1970-12-31",59478,"1876"]
["LMT","Lockheed Martin Corp.","Bethesda, Maryland","1984-07-31",936468,"1995"]
["LNC","Lincoln National","Radnor, Pennsylvania","1976-06-30",59558,"1905"]
["LNT","Alliant Energy","Madison, Wisconsin","2016-07-01",352541,"1917"]
["LOW","Lowe's Cos.","Mooresville, North Carolina","1984-02-29",60667,"1904/1946/1959"]
["LRCX","Lam Research","Fremont, California","2012-06-29",707549,"1980"]
["LUMN","Lumen Technologies","Monroe, Louisiana","1999-03-25",18926,"1983 (1877)"]
["LUV","Southwest Airlines","Dallas, Texas","1994-07-01",92380,"1967"]
["LVS","Las Vegas Sands","Las Vegas, Nevada","2019-10-03",1300514,"1988"]
["LW","Lamb Weston Holdings Inc","Eagle, Idaho","2018-12-03",1679273,"2016 (1950)"]
["LYB","LyondellBasell","Rotterdam, Netherlands","2012-09-05",1489393,"2007"]
["LYV","Live Nation Entertainment","Beverly Hills, California","2019-12-23",1335258,"2010"]
["MA","Mastercard Inc.","Harrison, New York","2008-07-18",1141391,"1966"]
["MAA","Mid-America Apartments","Memphis, Tennessee","2016-12-02",912595,"1977"]
["MAR","Marriott International","Bethesda, Maryland",null,1048286,"1927"]
["MAS","Masco Corp.","Livonia, Michigan","1981-06-30",62996,"1929"]
["MCD","McDonald's Corp.","Chicago, Illinois","1970-06-30",63908,"1940"]
["MCHP","Microchip Technology","Chandler, Arizona","2007-09-07",827054,"1989"]
["MCK","McKesson Corp.","Irving, Texas",null,927653,"1833"]
["MCO","Moody's Corp","New York, New York",null,1059556,"1909"]
["MDLZ","Mondelez International","Chicago, Illinois","2012-10-02",1103982,"2012"]
["MDT","Medtronic plc","Dublin, Ireland","1986-10-31",1613103,"1949"]
["MET","MetLife Inc.","New York, New York",null,1099219,"1868"]
["MGM","MGM Resorts International","Paradise, Nevada","2017-07-26",789570,"1986"]
["MHK","Mohawk Industries","Calhoun, Georgia","2013-12-23",851968,"1878"]
["MKC","McCormick & Co.","Hunt Valley, Maryland",null,63754,"1889"]
["MKTX","MarketAxess","New York, New York","2019-07-01",1278021,"2000"]
["MLM","Martin Marietta Materials","Raleigh, North Carolina","2014-07-02",916076,"1993"]
["MMC","Marsh & McLennan","New York, New York","1987-08-31",62709,"1905"]
["MMM","3M Company","St. Paul, Minnesota","1976-08-09",66740,"1902"]
["MNST","Monster Beverage","Corona, California","2012-06-28",865752,"2012 (1935)"]
["MO","Altria Group Inc","Richmond, Virginia","1957-03-04",764180,"1985"]
["MOS","The Mosaic Company","Tampa, Florida","2011-09-26",1285785,"2004 (1865 / 1909)"]
["MPC","Marathon Petroleum","Findlay, Ohio","2011-07-01",1510295,"2009 (1887)"]
["MPWR","Monolithic Power Systems","Kirkland, Washington","2021-02-12",1280452,"1997"]
["MRK","Merck & Co.","Kenilworth, New Jersey","1957-03-04",310158,"1891"]
["MRO","Marathon Oil Corp.","Houston, Texas","1991-05-01",101778,"1887"]
["MS","Morgan Stanley","New York, New York",null,895421,"1935"]
["MSCI","MSCI Inc","New York, New York","2018-04-04",1408198,"1969"]
["MSFT","Microsoft Corp.","Redmond, Washington","1994-06-01",789019,"1975"]
["MSI","Motorola Solutions Inc.","Chicago, Illinois",null,68505,"1928 (2011)"]
["MTB","M&T Bank","Buffalo, New York","2004-02-23",36270,"1856"]
["MTD","Mettler Toledo","Columbus, Ohio","2016-09-06",1037646,"1945"]
["MU","Micron Technology","Boise, Idaho","1994-09-27",723125,"1978"]
["MXIM","Maxim Integrated Products","San Jose, California","2018-12-03",743316,"1983"]
["NCLH","Norwegian Cruise Line Holdings","Miami, Florida","2017-10-13",1513761,"2011 (1966)"]
["NDAQ","Nasdaq, Inc.","New York, New York","2008-10-22",1120193,"1971"]
["NEE","NextEra Energy","Juno Beach, Florida","1976-06-30",753308,"1984 (1925)"]
["NEM","Newmont Corporation","Denver, Colorado","1969-06-30",1164727,"1921"]
["NFLX","Netflix Inc.","Los Gatos, California","2010-12-20",1065280,"1997"]
["NI","NiSource Inc.","Merrillville, Indiana",null,1111711,"1912"]
["NKE","Nike, Inc.","Washington County, Oregon","1988-11-30",320187,"1964"]
["NLOK","NortonLifeLock","Tempe, Arizona","2003-03-25",849399,"1982"]
["NLSN","Nielsen Holdings","New York, New York","2013-07-09",1492633,"1923"]
["NOC","Northrop Grumman","West Falls Church, Virginia","1985-06-30",1133421,"1994 (Northrop 1939, Grumman 1930)"]
["NOV","NOV Inc.","Houston, Texas","2005-03-14",1021860,"1841"]
["NOW","ServiceNow","Santa Clara, California","2019-11-21",1373715,"2003"]
["NRG","NRG Energy","Princeton, New Jersey","2010-01-29",1013871,"1992"]
["NSC","Norfolk Southern Corp.","Norfolk, Virginia","1957-03-04",702165,"1881/1894 (1980)"]
["NTAP","NetApp","Sunnyvale, California","1999-06-25",1002047,"1992"]
["NTRS","Northern Trust Corp.","Chicago, Illinois",null,73124,"1889"]
["NUE","Nucor Corp.","Charlotte, North Carolina","1985-04-30",73309,"1940"]
["NVDA","Nvidia Corporation","Santa Clara, California","2001-11-30",1045810,"1993"]
["NVR","NVR, Inc.","Reston, Virginia","2019-09-26",906163,"1980"]
["NWL","Newell Brands","Atlanta, Georgia","1989-04-30",814453,"1903"]
["NWS","News Corp (Class B)","New York, New York","2015-09-18",1564708,"2013 (1980)"]
["NWSA","News Corp (Class A)","New York, New York","2013-08-01",1564708,"2013 (1980)"]
["NXPI","NXP Semiconductors","Eindhoven, Netherlands","2021-03-22",1413447,"1953"]
["O","Realty Income Corporation","San Diego, California","2015-04-07",726728,"1969"]
["ODFL","Old Dominion Freight Line","Thomasville, North Carolina","2019-12-09",878927,"1934"]
["OKE","Oneok","Tulsa, Oklahoma","2010-03-15",1039684,"1906"]
["OMC","Omnicom Group","New York, New York",null,29989,"1986"]
["ORCL","Oracle Corp.","Austin, Texas","1989-08-31",1341439,"1977"]
["ORLY","O'Reilly Automotive","Springfield, Missouri","2009-03-27",898173,"1957"]
["OTIS","Otis Worldwide","Farmington, Connecticut","2020-04-03",1781335,"2020 (1853)"]
["OXY","Occidental Petroleum","Houston, Texas","1982-12-31",797468,"1920"]
["PAYC","Paycom","Oklahoma City, Oklahoma","2020-01-28",1590955,"1998"]
["PAYX","Paychex Inc.","Penfield, New York",null,723531,"1971"]
["PBCT","People's United Financial","Bridgeport, Connecticut","2008-11-13",1378946,"1842"]
["PCAR","Paccar","Bellevue, Washington","1980-12-31",75362,"1905"]
["PEAK","Healthpeak Properties","Long Beach, California","2008-03-31",765880,"1985"]
["PEG","Public Service Enterprise Group (PSEG)","Newark, New Jersey","1957-03-04",788784,"1903"]
["PENN","Penn National Gaming","Wyomissing, Pennsylvania","2021-03-22",921738,"1972"]
["PEP","PepsiCo Inc.","Purchase, New York","1957-03-04",77476,"1898"]
["PFE","Pfizer Inc.","New York, New York","1957-03-04",78003,"1849"]
["PFG","Principal Financial Group","Des Moines, Iowa","2002-07-22",1126328,"1879"]
["PG","Procter & Gamble","Cincinnati, Ohio","1957-03-04",80424,"1837"]
["PGR","Progressive Corp.","Mayfield Village, Ohio","1997-08-04",80661,"1937"]
["PH","Parker-Hannifin","Cleveland, Ohio","1985-11-30",76334,"1917"]
["PHM","PulteGroup","Atlanta, Georgia","1984-04-30",822416,"1956"]
["PKG","Packaging Corporation of America","Lake Forest, Illinois","2017-07-26",75677,"1959"]
["PKI","PerkinElmer","Waltham, Massachusetts","1985-05-31",31791,"1937"]
["PLD","Prologis","San Francisco, California","2003-07-17",1045609,"1983"]
["PM","Philip Morris International","New York, New York","2008-03-31",1413329,"2008 (1847)"]
["PNC","PNC Financial Services","Pittsburgh, Pennsylvania","1988-04-30",713676,"1845"]
["PNR","Pentair plc","Worsley, UK","2012-10-01",77360,"1966"]
["PNW","Pinnacle West Capital","Phoenix, Arizona",null,764622,"1985"]
["POOL","Pool Corporation","Covington, Louisiana","2020-10-07",945841,"1993"]
["PPG","PPG Industries","Pittsburgh, Pennsylvania","1957-03-04",79879,"1883"]
["PPL","PPL Corp.","Allentown, Pennsylvania",null,922224,"1920"]
["PRGO","Perrigo","Dublin, Ireland","2011-12-19",1585364,"2013 (1887)"]
["PRU","Prudential Financial","Newark, New Jersey","2002-07-22",1137774,"1875"]
["PSA","Public Storage","Glendale, California","2005-08-19",1393311,"1972"]
["PSX","Phillips 66","Houston, Texas","2012-05-01",1534701,"2012 (1917)"]
["PVH","PVH Corp.","New York, New York","2013-02-15",78239,"1881"]
["PWR","Quanta Services Inc.","Houston, Texas","2009-07-01",1050915,"1997"]
["PXD","Pioneer Natural Resources","Irving, Texas","2008-09-24",1038357,"1997"]
["PYPL","PayPal","San Jose, California","2015-07-20",1633917,"1998"]
["QCOM","Qualcomm","San Diego, California",null,804328,"1985"]
["QRVO","Qorvo","Greensboro, North Carolina","2015-06-11",1604778,"2015"]
["RCL","Royal Caribbean Group","Miami, Florida","2014-12-05",884887,"1997"]
["RE","Everest Re Group Ltd.","Hamilton, Bermuda","2017-06-19",1095073,"1973"]
["REG","Regency Centers Corporation","Jacksonville, Florida","2017-03-02",910606,"1963"]
["REGN","Regeneron Pharmaceuticals","Tarrytown, New York","2013-05-01",872589,"1988"]
["RF","Regions Financial Corp.","Birmingham, Alabama","1998-08-28",1281761,"1971"]
["RHI","Robert Half International","Menlo Park, California","2000-12-05",315213,"1948"]
["RJF","Raymond James Financial","St. Petersburg, Florida","2017-03-20",720005,"1962"]
["RL","Ralph Lauren Corporation","New York, New York","2007-02-02",1037038,"1967"]
["RMD","ResMed","San Diego, California","2017-07-26",943819,"1989"]
["ROK","Rockwell Automation Inc.","Milwaukee, Wisconsin",null,1024478,"1903"]
["ROL","Rollins, Inc.","Atlanta, Georgia","2018-10-01",84839,"1948"]
["ROP","Roper Technologies","Sarasota, Florida","2009-12-23",882835,"1981"]
["ROST","Ross Stores","Dublin, California","2009-12-21",745732,"1982"]
["RSG","Republic Services Inc","Phoenix, Arizona","2008-12-05",1060391,"1998 (1981)"]
["RTX","Raytheon Technologies","Waltham, Massachusetts",null,101829,"1922"]
["SBAC","SBA Communications","Boca Raton, Florida","2017-09-01",1034054,"1989"]
["SBUX","Starbucks Corp.","Seattle, Washington",null,829224,"1971"]
["SCHW","Charles Schwab Corporation","Westlake, Texas","1997-06-02",316709,"1971"]
["SEE","Sealed Air","Charlotte, North Carolina","1957-03-04",1012100,"1960"]
["SHW","Sherwin-Williams","Cleveland, Ohio","1964-06-30",89800,"1866"]
["SIVB","SVB Financial","Santa Clara, California","2018-03-19",719739,"1983"]
["SJM","JM Smucker","Orrville, Ohio","2008-11-06",91419,"1897"]
["SLB","Schlumberger Ltd.","Curaçao, Kingdom of the Netherlands","1965-03-31",87347,"1926"]
["SNA","Snap-on","Kenosha, Wisconsin","1982-09-30",91440,"1920"]
["SNPS","Synopsys Inc.","Mountain View, California","2017-03-16",883241,"1986"]
["SO","Southern Company","Atlanta, Georgia","1957-03-04",92122,"1945"]
["SPG","Simon Property Group Inc","Indianapolis, Indiana","2002-06-26",1063761,"2003"]
["SPGI","S&P Global Inc.","New York, New York",null,64040,"1917"]
["SRE","Sempra Energy","San Diego, California",null,1032208,"1998"]
["STE","Steris","Dublin, Ireland","2019-12-23",1757898,"1985"]
["STT","State Street Corp.","Boston, Massachusetts",null,93751,"1792"]
["STX","Seagate Technology","Dublin, Ireland","2012-07-02",1137789,"1979"]
["STZ","Constellation Brands","Victor, New York","2005-07-01",16918,"1945"]
["SWK","Stanley Black & Decker","New Britain, Connecticut","1982-09-30",93556,"1843"]
["SWKS","Skyworks Solutions","Woburn, Massachusetts","2015-03-12",4127,"2002"]
["SYF","Synchrony Financial","Stamford, Connecticut","2015-11-18",1601712,"2003"]
["SYK","Stryker Corp.","Kalamazoo, Michigan","2000-12-12",310764,"1941"]
["SYY","Sysco Corp.","Houston, Texas","1986-12-31",96021,"1969"]
["T","AT&T Inc.","Dallas, Texas","1983-11-30 (1957-03-04)",732717,"1983 (1885)"]
["TAP","Molson Coors Beverage Company","Denver, Colorado","1976-06-30",24545,"2005 (Molson 1786, Coors 1873)"]
["TDG","TransDigm Group","Cleveland, Ohio","2016-06-03",1260221,"1993"]
["TDY","Teledyne Technologies","Thousand Oaks, California","2020-06-22",1094285,"1960"]
["TEL","TE Connectivity Ltd.","Schaffhausen, Switzerland","2011-10-17",1385157,"2007"]
["TER","Teradyne","North Reading, Massachusetts","2020-09-21",97210,"1960"]
["TFC","Truist Financial","Charlotte, North Carolina","1997-12-04",92230,"1872"]
["TFX","Teleflex","Wayne, Pennsylvania","2019-01-18",96943,"1943"]
["TGT","Target Corp.","Minneapolis, Minnesota","1976-12-31",27419,"1902"]
["TJX","TJX Companies Inc.","Framingham, Massachusetts","1985-09-30",109198,"1987"]
["TMO","Thermo Fisher Scientific","Waltham, Massachusetts","2004-08-03",97745,"2006 (1902)"]
["TMUS","T-Mobile US","Bellevue, Washington","2019-07-15",1283699,"1994"]
["TPR","Tapestry, Inc.","New York, New York",null,1116132,"2017"]
["TRMB","Trimble Inc.","Sunnyvale, California","2021-01-21",864749,"1978"]
["TROW","T. Rowe Price Group","Baltimore, Maryland",null,1113169,"1937"]
["TRV","The Travelers Companies","New York, New York","2002-08-21",86312,"1853"]
["TSCO","Tractor Supply Company","Brentwood, Tennessee","2014-01-24",916365,"1938"]
["TSLA","Tesla, Inc.","Palo Alto, California","2020-12-21",1318605,"2003"]
["TSN","Tyson Foods","Springdale, Arkansas",null,100493,"1935"]
["TT","Trane Technologies plc","Dublin, Ireland","2010-11-17",1466258,"1871"]
["TTWO","Take-Two Interactive","New York, New York","2018-03-19",946581,"1993"]
["TWTR","Twitter, Inc.","San Francisco, California","2018-06-07",1418091,"2006"]
["TXN","Texas Instruments","Dallas, Texas",null,97476,"1930"]
["TXT","Textron Inc.","Providence, Rhode Island","1978-12-31",217346,"1923"]
["TYL","Tyler Technologies","Plano, Texas","2020-06-22",860731,"1966"]
["UA","Under Armour (Class C)","Baltimore, Maryland","2016-04-08",1336917,"1996"]
["UAA","Under Armour (Class A)","Baltimore, Maryland","2014-05-01",1336917,"1996"]
["UAL","United Airlines Holdings","Chicago, Illinois","2015-09-03",100517,"1967"]
["UDR","UDR, Inc.","Highlands Ranch, Colorado","2016-03-07",74208,"1972"]
["UHS","Universal Health Services","King of Prussia, Pennsylvania","2014-09-20",352915,"1979"]
["ULTA","Ulta Beauty","Bolingbrook, Illinois","2016-04-18",1403568,"1990"]
["UNH","UnitedHealth Group Inc.","Minnetonka, Minnesota","1994-07-01",731766,"1977"]
["UNM","Unum Group","Chattanooga, Tennessee","1994-03-01",5513,"1999"]
["UNP","Union Pacific Corp","Omaha, Nebraska","1957-03-04",100885,"1862"]
["UPS","United Parcel Service","Atlanta, Georgia","2002-07-22",1090727,"1907"]
["URI","United Rentals, Inc.","Stamford, Connecticut","2014-09-20",1067701,"1997"]
["USB","U.S. Bancorp","Minneapolis, Minnesota",null,36104,"1968"]
["V","Visa Inc.","San Francisco, California","2009-12-21",1403161,"1958"]
["VAR","Varian Medical Systems","Palo Alto, California","2007-02-12",203527,"1948"]
["VFC","VF Corporation","Denver, Colorado","1979-06-30",103379,"1899"]
["VIAC","ViacomCBS","New York, New York",null,813828,"2019 (1952)"]
["VLO","Valero Energy","San Antonio, Texas",null,1035002,"1980"]
["VMC","Vulcan Materials","Birmingham, Alabama","1999-06-30",1396009,"1909"]
["VNO","Vornado Realty Trust","New York, New York",null,899689,"1982"]
["VRSK","Verisk Analytics","Jersey City, New Jersey","2015-10-08",1442145,"1971"]
["VRSN","Verisign Inc.","Dulles, Virginia","2006-02-01",1014473,"1995"]
["VRTX","Vertex Pharmaceuticals Inc","Cambridge, Massachusetts","2013-09-23",875320,"1989"]
["VTR","Ventas Inc","Chicago, Illinois","2009-03-04",740260,"1998"]
["VTRS","Viatris","Pittsburgh, Pennsylvania","2004-04-23",1792044,"1961"]
["VZ","Verizon Communications","New York, New York","1983-11-30",732712,"1983 (1877)"]
["WAB","Westinghouse Air Brake Technologies Corp","Wilmerding, Pennsylvania","2019-02-27",943452,"1999 (1869)"]
["WAT","Waters Corporation","Milford, Massachusetts",null,1000697,"1958"]
["WBA","Walgreens Boots Alliance","Deerfield, Illinois","1979-12-31",1618921,"2014"]
["WDC","Western Digital","San Jose, California","2009-07-01",106040,"1970"]
["WEC","WEC Energy Group","Milwaukee, Wisconsin","2008-10-31",783325,"1896"]
["WELL","Welltower Inc.","Toledo, Ohio","2009-01-30",766704,"1970"]
["WFC","Wells Fargo","San Francisco, California","1976-06-30",72971,"1852"]
["WHR","Whirlpool Corp.","Benton Harbor, Michigan",null,106640,"1911"]
["WLTW","Willis Towers Watson","London, United Kingdom","2016-01-05",1140536,"2016"]
["WM","Waste Management Inc.","Houston, Texas",null,823768,"1968"]
["WMB","Williams Companies","Tulsa, Oklahoma","1975-03-31",107263,"1908"]
["WMT","Walmart","Bentonville, Arkansas","1982-08-31",104169,"1962"]
["WRB","W. R. Berkley Corporation","Greenwich, Connecticut","2019-12-05",11544,"1967"]
["WRK","WestRock","Atlanta, Georgia",null,1732845,"2015"]
["WST","West Pharmaceutical Services","Exton, Pennsylvania","2020-05-22",105770,"1923"]
["WU","Western Union Co","Englewood, Colorado","2006-09-29",1365135,"1851"]
["WY","Weyerhaeuser","Federal Way, Washington",null,106535,"1900"]
["WYNN","Wynn Resorts Ltd","Paradise, Nevada","2008-11-14",1174922,"2002"]
["XEL","Xcel Energy Inc","Minneapolis, Minnesota","1957-03-04",72903,"1909"]
["XLNX","Xilinx","San Jose, California","1999-11-08",743988,"1984"]
["XOM","Exxon Mobil Corp.","Irving, Texas","1957-03-04",34088,"1999"]
["XRAY","Dentsply Sirona","Charlotte, North Carolina","2008-11-14",818479,"2016 (1969)"]
["XYL","Xylem Inc.","White Plains, New York","2011-11-01",1524472,"2011"]
["YUM","Yum! Brands Inc","Louisville, Kentucky","1997-10-06",1041061,"1997"]
["ZBH","Zimmer Biomet","Warsaw, Indiana","2001-08-07",1136869,"1927"]
["ZBRA","Zebra Technologies","Lincolnshire, Illinois","2019-12-23",877212,"1969"]
["ZION","Zions Bancorp","Salt Lake City, Utah","2001-06-22",109380,"1873"]
["ZTS","Zoetis","Parsippany, New Jersey","2013-06-21",1555280,"1952"]

{"sheet":"Top Index Funds","index":7,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Ticker","Fund Name","Issuer","Segment"]
["SPY","SPDR S&P 500 ETF Trust","State Street Global Advisors","Equity: U.S. - Large Cap"]
["GLD","SPDR Gold Trust","State Street Global Advisors","Commodities: Precious Metals Gold"]
["XLF","Financial Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Financials"]
["XLK","Technology Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Technology"]
["DIA","SPDR Dow Jones Industrial Average ETF Trust","State Street Global Advisors","Equity: U.S. - Large Cap"]
["XLV","Health Care Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Health Care"]
["XLE","Energy Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Energy"]
["MDY","SPDR S&P Midcap 400 ETF Trust","State Street Global Advisors","Equity: U.S. - Mid Cap"]
["XLY","Consumer Discretionary Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Consumer Cyclicals"]
["XLI","Industrial Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Industrials"]
["SDY","SPDR S&P Dividend ETF","State Street Global Advisors","Equity: U.S. - High Dividend Yield"]
["XLC","Communication Services Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Telecommunications"]
["BIL","SPDR Bloomberg Barclays 1-3 Month T-Bill ETF","State Street Global Advisors","Fixed Income: U.S. - Government, Treasury Investment Grade U…"]
["XLU","Utilities Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Utilities"]
["XLP","Consumer Staples Select Sector SPDR Fund","State Street Global Advisors","Equity: U.S. Consumer Non-cyclicals"]
["SPDW","SPDR Portfolio Developed World ex-US ETF","State Street Global Advisors","Equity: Developed Markets Ex-U.S. - Total Market"]
["JNK","SPDR Bloomberg Barclays High Yield Bond ETF","State Street Global Advisors","Fixed Income: U.S. - Corporate, Broad-based High Yield"]
["SPYV","SPDR Portfolio S&P 500 Value ETF","State Street Global Advisors","Equity: U.S. - Large Cap Value"]
["SPYG","SPDR Portfolio S&P 500 Growth ETF","State Street Global Advisors","Equity: U.S. - Large Cap Growth"]
["SPLG","SPDR Portfolio S&P 500 ETF","State Street Global Advisors","Equity: U.S. - Large Cap"]
[]
["Source:  etf.com"]
[]
["Full list:","https://en.wikipedia.org/wiki/List_of_American_exchange-traded_funds"]

{"sheet":"FundiesAdj","index":8,"n_rows":5,"n_cols":57,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Ticker","Revenues","CostOfGoods","PreTaxProfit","OperatingIncomeLoss","NetIncome","DirectCostsOfLeasedAndRentedPropertyOrEquipment","NetIncomeLossAvailableToCommonStockholdersBasic","NetIncomeLossAvailableToCommonStockholdersDiluted","DepreciationDepletionAndAmmortisation","DepreciationAmortizationAndOther","CashAndCashEquivalents","AccountsReceivableNetCurrent","OtherAssetsCurrent","AssetsCurrent","Assets","DeferredRevenueCurrent","PP&E","AccountsPayableCurrent","ShortTermDebt","LiabilitiesCurrent","LongTermDebt","Liabilities","StockholdersEquity","LiabilitiesAndStockholdersEquity","NetCashProvidedByUsedInFinancingActivities","NetCashProvidedByUsedInInvestingActivities","NetCashProvidedByUsedInOperatingActivities","WeightedAverageNumberOfSharesOutstandingBasic","WeightedAverageNumberOfDilutedSharesOutstanding","EarningsPerShareBasic","EarningsPerShareDiluted","CommonStockDividendsPerShareCashPaid","CommonStockParOrStatedValuePerShare","CommonStockSharesAuthorized","CommonStockSharesIssued","CommonStockValue","PreferredStockParOrStatedValuePerShare","PreferredStockSharesAuthorized","PreferredStockSharesIssued","PreferredStockValue","EntityPublicFloat","TreasuryStockIssuedForEmployeeCompensationAndStockOptionPlansNetOfCashProceeds","TreasuryStockShares","TreasuryStockValue","dateFiled","formFiscalQuarter","formFiscalYear","periodEnd","periodStart","reportLink","version","id","key","subkey","date","updated"]
["AAPL",274515000000,169559000000,67091000000,66288000000,57411000000,null,null,null,11056000000,null,39789000000,16120000000,11264000000,143713000000,323888000000,6643000000,36766000000,42296000000,8773000000,105392000000,null,258549000000,65339000000,323888000000,-86820000000,-4289000000,80674000000,17352119000,17528214000,3.31,3.28,null,1.0000000000000001E-5,50400000000,16976763000,null,0,0,0,0,null,null,null,null,"2020-10-30",null,null,"2020-09-26",null,null,null,"REPORTED_FINANCIALS","AAPL","10-K","2020-10-30","2021-02-11"]
["FB",85965000000,16692000000,33180000000,32671000000,29146000000,null,29146000000,null,6862000000,null,17954000000,11330000000,null,75670000000,159316000000,382000000,45633000000,1331000000,null,14981000000,null,31026000000,128290000000,159316000000,-10292000000,-30059000000,38747000000,2851000000,2888000000,10.220000000000001,10.09,null,6.0000000000000002E-6,null,null,0,0,0,0,0,null,null,null,null,"2021-01-28",null,null,"2020-12-31",null,null,null,"REPORTED_FINANCIALS","FB","10-K","2021-01-28","2021-02-11"]
["GME",5089800000,3830300000,-269900000,-237800000,-215300000,null,null,null,80000000,null,635000000,105300000,null,1551200000,2472600000,348200000,201200000,341800000,121700000,1342700000,362700000,2035900000,436700000,2472600000,-55400000,36900000,123700000,65000000,65000000,-3.31,-3.31,null,1E-3,300000000,65300000,100000,0,0,0,0,null,null,null,null,"2021-03-23",null,null,"2021-01-30",null,null,null,"REPORTED_FINANCIALS","GME","10-K","2021-03-23","2021-03-24"]
["TSLA",31536000000,24906000000,1154000000,1994000000,862000000,null,690000000,null,1570000000,null,19384000000,1886000000,null,26717000000,52148000000,1458000000,12747000000,6051000000,1758000000,14248000000,8462000000,28418000000,22225000000,52148000000,9973000000,-3132000000,5943000000,933000000,1083000000,0.74,0.64,null,1E-3,2000000000,960000000,1000000,1E-3,100000000,0,0,null,null,null,null,"2021-02-08",null,null,"2020-12-31",null,null,null,"REPORTED_FINANCIALS","TSLA","10-K","2021-02-08","2021-02-11"]

{"sheet":"Adjustments","index":9,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Income Statement Item Rollups","Balance Sheet Item Rollups","Cashflow Item Rollup"]
[]
["Revenues. xbrl items:","Cash. xbrl items:","NetCashProvidedByUsedInFinancingActivities xbrl items"]
["RevenueFromContractWithCustomerExcludingAssessedTax","CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents","NetCashProvidedByUsedInFinancingActivities"]
["RevenueFromContractWithCustomerIncludingAssessedTax","CashAndCashEquivalentsAtCarryingValue","NetCashProvidedByUsedInFinancingActivitiesContinuingOperations"]
["RegulatedAndUnregulatedOperatingRevenue",null,"    "]
["RevenuesNetOfInterestExpense","Deferred Revenue. xbrl items: "]
[null,"DeferredRevenueCurrent","NetCashProvidedByUsedInOperatingActivities xbrl items"]
["CostOfGoods. xbrl items:","ContractWithCustomerLiabilityCurrent","NetCashProvidedByUsedInOperatingActivities"]
["CostOfGoodsAndServicesSold",null,"NetCashProvidedByUsedInOperatingActivitiesContinuingOperation"]
["CostOfRevenue","AccountsReceivableNetCurrent. xbrl items:","    "]
[null,"AccountsReceivableNetCurrent","NetCashProvidedByUsedInInvestingActivities xbrl items"]
["PreTaxProfit. xbrl items:","ReceivablesNetCurrent","NetCashProvidedByUsedInInvestingActivities"]
["IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLoss",null,"NetCashProvidedByUsedInInvestingActivitiesContinuingOperations"]
["IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontroll","PP&E. xbrl items:"]
["IncomeLossFromContinuingOperationsAfterNoncontrollingInterestBeforeIncomeTaxes","PropertyPlantAndEquipmentNet"]
["IncomeLossFromContinuingOperationsBeforeIncomeTaxes","PropertyPlantandEquipmentandFinanceLeaseRightofUseAssetafterAccumulatedDepreciat"]
[null,"PropertyPlantAndEquipmentAndFinanceLeaseRightOfUseAssetAfterAccumulatedDepreci.1"]
["OperatingIncome. xbrl items:"]
["OperatingIncomeLoss","ShortTermDebt. xbrl items:"]
["IncomeLossFromContinuingOperations","ShortTermBorrowings"]
[null,"LongTermDebtCurrent"]
["NetIncome. xbrl items:","DebtCurrent"]
["ProfitLoss"]
["NetIncomeLoss","Liabilities. xbrl items:"]
[null,"Liabilities"]
["Depreciation. xbrl items:","[LiabilitiesAndStockholdersEquity]-[StockholdersEquityRolled]"]
["DepreciationDepletionAndAmortization"]
["DepreciationAndAmortization","StockHoldersEquity. xbrl items:"]
["DepreciationAmortizationAndOther","StockholdersEquity"]
["DepreciationAndImpairmentOnDispositionOfPropertyAndEquipment","StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest"]
["DepreciationAmortizationAndAccretionNet"]
[]
["Above are the adjustments to the iXBRL reporting items to help create a standardised view of the data.  This is imperfect but better than nothing!"]
["For proper adjustments subscribe to the paid API and use the Financials end point, with data from New Constructs."]

{"sheet":"Other Notes","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Updating your Queries Automatically"]
["1. From the ribbon select Data -> Queries & Connections."]
["2. Right-click on the query and select Properties… from the menu."]
["3. Tick the Refresh Every n Minutes option and enter a time interval."]
["4. Click OK to close the Query Properties dialog box."]

{"sheet":"Account","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"account"]
["Token","Column1","Secret_Token","Base_Url","Full_URL"]
[{"$f":"+my_token","v":0},null,{"$f":"+Secret_Token","v":0},"https://cloud.iexapis.com/stable/account/metadata?token=",{"$f":"+account[[#This Row],[Base_Url]]&account[[#This Row],[Secret_Token]]","v":"https://cloud.iexapis.com/stable/account/metadata?token=0"}]
[]
[null,null,null,"Powerquery:","= Json.Document(Web.Contents(Excel.CurrentWorkbook(){[Name=\"account\"]}[Content]{0}[Full_URL]))"]
[]
["Name","Value"]
["payAsYouGoEnabled",true]
["effectiveDate",1548195850000]
["subscriptionTermType","annual"]
["tierName","scale"]
["messageLimit",2000000000]
["creditLimit",2000000000]
["messagesUsed",103542345]
["creditsUsed",103542345]
["circuitBreaker",22222222222223]