https://cdn.sheetsfinance.com/public-site/_nuxt/B2pvLtxW.js

1import{_ as E}from"./B18Vze0d.js";import{_ as F}from"./BC_l1C4W.js";import{_ as b}from"./1CFrmUJt.js";import{u as w,a as S,b as T,c as x}from"./CQQppSvx.js";import{_ as D,b as A,r as k}from"./CSaDzwHX.js";import{_ as C}from"./B14LZ2QV.js";import{_ as I}from"./CAXu2GR4.js";import{a9 as G,G as M,n as e,u as t,o as P}from"./1_UnC8sM.js";import{m as o}from"./wtOOnxcL.js";import{a as U}from"./C_VQUbXN.js";import{r as B}from"./I_0JyjVK.js";import{r as H}from"./hJMVosZ1.js";import{r as Y}from"./Cyru1Qqn.js";import"./BQDlzEBr.js";import"./Diu2ikUW.js";import"./km-KReuI.js";import"./BE7XORkx.js";import"./CTNo1cDx.js";import"./BazINwiL.js";import"./BuYjIP5U.js";import"./B9uaMrCp.js";import"./C69DkMM-.js";import"./Bp3YSIOJ.js";import"./BB_Ol6Sd.js";import"./Dn0JfAdr.js";import"./Cy2rLSA3.js";import"./CeDEOmSB.js";import"./zy1kb4uh.js";import"./BtWEPFAe.js";import"./ilbXuEuB.js";import"./B1ksYQxX.js";import"./DgDYcnaP.js";import"./BWH-oZIL.js";import"./CEOY9OkS.js";import"./DG_at8ek.js";import"./DZd7hEgs.js";import"./LD_GFEFA.js";import"./DJ6qzwXa.js";import"./C2n3FOin.js";import"./Cq9Fpw4b.js";import"./B3sxJKiA.js";/* empty css        */import"./CnXQnTpP.js";import"./DS4p2_UQ.js";const q={class:"flex-col overflow-x-hidden"},Me={__name:"etf",setup(Q){G({title:"ETF Data for Google Sheets and Excel",meta:[{property:"og:title",content:"ETF Data for Google Sheets and Excel"},{name:"description",content:"ETF holdings, sector and country weightings, expense ratios, AUM, exchange-timed live prices and 30+ years of history for 1000s of global ETFs — directly in your spreadsheet with =SF()."},{property:"og:description",content:"ETF holdings, sector and country weightings, expense ratios, AUM, exchange-timed live prices and 30+ years of history for 1000s of global ETFs — directly in your spreadsheet with =SF()."},{property:"og:image",content:"https://cdn.sheetsfinance.com/prod/media/growth_dash.webp"}]});const a=[{id:"holdings",label:"Holdings",formula:'=SF("SPY", "etfHoldings", "asset&sharesNumber&weightPercentage&marketValue")',targetRows:9,description:"Full constituent holdings with share counts, portfolio weights and market values.",grid:{headers:["Asset","Shares Number","Weight (%)","Market Value"],rows:[["AAPL","176,234,000","7.12%","43,602,110,600"],["MSFT","78,412,000","6.48%","39,684,205,120"],["NVDA","214,752,000","6.05%","37,051,884,900"],["AMZN","104,505,000","3.84%","23,515,667,300"],["META","21,493,000","2.51%","15,372,410,850"],["AVGO","61,284,000","2.14%","13,106,826,600"],["GOOGL","62,305,000","1.96%","12,005,962,500"],["BRK.B","23,164,000","1.72%","10,535,546,400"],["GOOG","51,908,000","1.65%","10,106,689,600"]]}},{id:"price",label:"Real-time price",formula:'=SF(A2:A9, "quote", "price&changePercentage&dayHigh&dayLow&volume")',formulaCell:"B1",references:[{range:"A2:A9",color:"amber"}],targetRows:8,description:"Batch live quotes for major ETFs alongside 30+ years of history through the same functions.",grid:{headers:["","Price","Change (%)","Day High","Day Low","Volume"],rows:[["SPY","598.21","+0.62%","599.84","595.10","77,493,201"],["QQQ","528.74","+0.81%","530.26","524.91","44,821,506"],["VTI","294.16","+0.55%","295.02","292.10","4,126,804"],["IWM","224.83","-0.18%","226.40","222.95","31,740,925"],["DIA","446.92","+0.34%","448.11","444.76","3,518,440"],["EFA","82.65","+0.27%","82.94","82.16","15,906,283"],["EEM","46.18","-0.11%","46.52","45.91","29,381,744"],["AGG","98.42","+0.06%","98.51","98.28","8,762,109"]]}},{id:"dividends",label:"Dividends",formula:'=SF_DIVIDEND("SCHD", TODAY()-1095, TODAY(), "date&dividend&adjDividend&yield&frequency&paymentDate")',targetRows:9,description:"Three years of SCHD distributions, including adjusted dividends, yield and payment dates.",grid:{headers:["Date","Dividend","Adj. Dividend","Yield","Frequency","Payment Date"],rows:[["25/06/2026","0.26","0.26","3.72%","Quarterly","30/06/2026"],["25/03/2026","0.25","0.25","3.68%","Quarterly","30/03/2026"],["10/12/2025","0.26","0.26","3.74%","Quarterly","15/12/2025"],["24/09/2025","0.26","0.26","3.65%","Quarterly","29/09/2025"],["25/06/2025","0.25","0.25","3.81%","Quarterly","30/06/2025"],["26/03/2025","0.25","0.25","3.76%","Quarterly","31/03/2025"],["11/12/2024","0.26","0.26","3.59%","Quarterly","16/12/2024"],["25/09/2024","0.25","0.25","3.48%","Quarterly","30/09/2024"],["26/06/2024","0.25","0.25","3.42%","Quarterly","01/07/2024"]]}},{id:"sectors",label:"Sector weightings",formula:'=SF("SPY", "etfSectors")',targetRows:9,description:"Sector exposure breakdown so you can see what an ETF really holds.",grid:{headers:["Industry","Exposure (%)"],rows:[["Technology","31.42%"],["Financial Services","13.54%"],["Healthcare","11.68%"],["Consumer Cyclical","10.36%"],["Communication Services","9.18%"],["Industrials","8.52%"],["Consumer Defensive","5.92%"],["Energy","3.24%"],["Utilities","2.42%"]]}},{id:"countries",label:"Country weightings",formula:'=SF("VT", "etfCountries")',targetRows:9,description:"Geographic exposure for global and international ETFs.",grid:{headers:["Country","Weight (%)"],rows:[["United States","62.80%"],["Japan","5.90%"],["United Kingdom","3.40%"],["China","2.90%"],["Canada","2.70%"],["France","2.30%"],["Switzerland","2.20%"],["Germany","2.00%"],["Taiwan","1.90%"]]}},{id:"info",label:"ETF profile",formula:'=SF("SPY", "etfInfo")',targetRows:9,description:"The complete ETF profile, including fund structure, costs, liquidity and issuer details.",columnWidths:["29%","39%","9%","9%","9%"],grid:{headers:["ETF Info for SPY"],rows:[["Name","SPDR S&P 500 ETF Trust"],["Asset Class","Equity"],["AUM ($B)","612.40"],["NAV","598.19"],["NAV Currency","USD"],["Avg. Volume","77,493,201"],["Expense Ratio","0.09%"],["Domicile","US"],["ETF Company","State Street Global Advisors"]]}}],{examples:n}=w("etf",a),i=[{icon:A,title:"Constituent holdings",description:"See what's inside any US-listed ETF — every holding, weight and position. Major UK and European funds included."},{icon:U,title:"Sector weightings",description:"Sector exposure breakdowns for supported funds, so you can see the real composition behind a ticker."},{icon:k,title:"Country weightings",description:"Geographic exposure for supported global and international ETFs, weighted by allocation."},{icon:B,title:"Profiles & expense ratios",description:"Asset class, expense ratio, AUM, inception date and issuer details for every fund."},{icon:H,title:"Real-time prices",description:"Second-accurate ETF quotes on major exchanges including US markets, with real-time to 15-minute data across 60+ global markets."},{icon:Y,title:"History, dividends & technicals",description:"30+ years of daily and intra-day pricing data, dividends and technical indicators."}],s=[{value:"1000s",label:"of global ETFs"},{value:"30+ yrs",label:"of historical data"},{value:o.markets,label:"exchanges covered"}],r=["See every constituent, weight and market value in one analysis sheet.","Compare sector and country exp

1osure without manually rebuilding fund data.","Track price, volume, yield and performance alongside the underlying portfolio."],d=[{icon:"holdings",name:"ETF holdings",description:"US & selected major global funds"},{icon:"sectors",name:"Sector exposure",description:"See what drives each fund"},{icon:"countries",name:"Country exposure",description:"Geographic allocation data"},{icon:"profiles",name:"Fund profiles",description:"AUM, issuer & expense ratios"},{icon:"distributions",name:"Distributions",description:"Dividends and payment history"},{icon:"technicals",name:"Prices & technicals",description:"Quotes, history & indicators"}],l={Basic:["Live ETF quotes based on exchange timing","3 years of daily price & dividend history","Daily ETF technical indicators","Batch data calls for 10 symbols","10,000 data calls per day"],Investor:["Everything in Basic","Holdings, sectors, countries & fund profiles","15 years of price & dividend history","Intra-day prices & technical indicators","Batch data calls for 2000 symbols","25,000 data calls per day"],Analyst:["Everything in Investor","30+ years of price & dividend history","Dividend & economic calendars","Pre/post-market quotes for US ETFs","Batch data calls for 5000 symbols","100,000 data calls per day"],default:["Full ETF holdings & weightings","Exchange-timed quotes & up to 30+ years of history","Works in Google Sheets and Excel"]},c=[{title:"Can I get the full holdings of an ETF?",content:["Yes. Holdings coverage is complete for US-listed ETFs, with major funds from the UK, Europe and other global markets also supported. For a covered fund, <code>etfHoldings</code> returns every constituent with its share count, portfolio weight and market value. We are continuously expanding international holdings coverage."]},{title:"Can I get dividend data for ETFs?",content:["Yes. <code>SF_DIVIDEND()</code> returns an ETF's distribution history, including ex-dates, payment dates, raw and adjusted amounts and yield. Market Data plans include 3 years of dividend history on Basic, 15 years on Investor and 30+ years on Analyst."]},{title:"Do you have sector and country breakdowns?",content:["Yes. <code>etfSectors</code> returns sector weightings and <code>etfCountries</code> returns geographic exposure for global and international ETFs."]},{title:"How current are ETF prices?",content:["US-listed ETF quotes are second-accurate. ETFs on other markets follow the timing of their exchange feed, ranging from real-time to a 15-minute delay."]},{title:"Can I analyse multiple ETFs in one call?",content:["Yes. Pass a range of ETF symbols into <code>SF()</code> to return a batch response in one formula. Basic supports batches of 10 symbols, Investor supports 2,000 and Analyst supports 5,000."]},{title:"Are expense ratios and AUM available?",content:["Yes. The <code>etfInfo</code> dataset includes asset class, expense ratio, assets under management, inception date and issuer details."]},{title:"Do you have pre-built ETF templates?",content:["Yes. Our free <a class='text-sf-green font-bold' href='/templates/sf-etf-analysis-template'>ETF Analysis template</a> is a pre-built Google Sheets dashboard for holdings, sector and country exposure, price history, dividends and performance. It runs on SheetsFinance functions, so you will need an active Market Data plan or trial to populate it with data."]},{title:"Does this work in both Google Sheets and Excel?",content:["Yes! SheetsFinance is available as an add-on for both Google Sheets and Microsoft Excel, with the same ETF functions in each."]}];return(V,j)=>{const u=E,p=F,m=b,h=S,g=D,f=C,y=T,v=I,_=x;return P(),M("div",q,[e(u,{"product-group":"data",variant:"centered-light","homepage-layout":"",heading:"ETF analysis, built into ",accent:"Google Sheets and Excel",description:"See what a fund really holds with constituent data, sector and country exposure, live prices on major markets, distributions and 30+ years of history.",examples:t(n)},null,8,["examples"]),e(p),e(m,{"full-width":"",eyebrow:"From holdings to dashboard",heading:"See the whole fund, not just the ticker",description:"Turn raw ETF data into a complete analysis dashboard with holdings, exposure and performance already laid out in the sheet.",bullets:r,image:"/img/templates/sf-etf-analysis-dashboard.png","image-alt":"ETF analysis dashboard in Google Sheets showing holdings, sector exposure and performance","template-to":"/templates/sf-etf-analysis-template"}),e(h,{heading:"Everything you need to analyse ETFs",subheading:"Price

1s, dividends, holdings, exposure, history and technicals — pulled straight into your sheet.",items:i,stats:s,theme:"dark"}),e(g,{heading:"ETF coverage across",highlight:t(o).marketsLabel,subheading:"Pricing, dividends, history and detailed ETF data across 60+ exchanges. Holdings and exposure covers US-listed ETFs in full, plus major UK and European funds.","feature-heading":"ETF datasets","feature-count":"6 core capabilities",features:d},null,8,["highlight"]),e(f,{group:"data",heading:"ETF data is included in every Market Data plan","most-popular":"Investor","tier-bullets":l,variant:"market-data"}),e(y,{heading:"Want to build an ETF analysis dashboard?",description:"Book a 20-minute live demo and we'll build a holdings, exposure and performance view with you."}),e(v,{collection:"etf"}),e(_,{faqs:c,"default-active":0,variant:"market-data"})])}}};export{Me as default};