https://marketxls.com/_next/static/chunks/pages/crypto-data-in-excel-d0dde59bb7c44f22.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[35405,31040,91067],{35736:function(e,t,a){(window.__NEXT_P=window.__NEXT_P||[]).push(["/crypto-data-in-excel",function(){return a(20656)}])},53595:function(e,t,a){"use strict";var s=a(30100);t.DF={prefix:s.prefix,iconName:s.iconName,icon:[s.width,s.height,s.aliases,s.unicode,s.svgPathData]},t.AG=t.DF,s.prefix,s.iconName,s.width,s.height,s.aliases,s.unicode,s.svgPathData,s.aliases},30100:function(e,t){"use strict";Object.defineProperty(t,"__esModule",{value:!0});var a="right-long",s=["long-arrow-alt-right"],r="f30b",n="M504.3 273.6l-112.1 104c-6.992 6.484-17.18 8.218-25.94 4.406c-8.758-3.812-14.42-12.45-14.42-21.1L351.9 288H32C14.33 288 .0002 273.7 .0002 255.1S14.33 224 32 224h319.9l0-72c0-9.547 5.66-18.19 14.42-22c8.754-3.809 18.95-2.075 25.94 4.41l112.1 104C514.6 247.9 514.6 264.1 504.3 273.6z";t.definition={prefix:"fas",iconName:a,icon:[512,512,s,r,n]},t.faRightLong=t.definition,t.prefix="fas",t.iconName=a,t.width=512,t.height=512,t.ligatures=s,t.unicode=r,t.svgPathData=n,t.aliases=s},44335:function(e,t,a){"use strict";a.d(t,{Z:function(){return M}});var s,r=a(94184),n=a.n(r),i=a(9351),c=a(23004),o=a(67216),l=a(30099);function d(e){if((!s&&0!==s||e)&&c.Z){var t=document.createElement("div");t.style.position="absolute",t.style.top="-9999px",t.style.width="50px",t.style.height="50px",t.style.overflow="scroll",document.body.appendChild(t),s=t.offsetWidth-t.clientWidth,document.body.removeChild(t)}return s}var h=a(32092),m=a(78146),x=a(35654),p=a(76852),u=a(94305),g=a(67294),j=a(16664),y=a(61432),f=a(41818),N=a(85242),D=(0,N.Z)("modal-body"),_=a(87163),v=a(98814),w=a(85893);let Z=g.forwardRef((e,t)=>{let{bsPrefix:a,className:s,contentClassName:r,centered:i,size:c,fullscreen:o,children:l,scrollable:d,...h}=e;a=(0,v.vE)(a,"modal");let m="".concat(a,"-dialog"),x="string"==typeof o?"".concat(a,"-fullscreen-").concat(o):"".concat(a,"-fullscreen");return(0,w.jsx)("div",{...h,ref:t,className:n()(m,s,c&&"".concat(a,"-").concat(c),i&&"".concat(m,"-centered"),d&&"".concat(m,"-scrollable"),o&&x),children:(0,w.jsx)("div",{className:n()("".concat(a,"-content"),r),children:l})})});Z.displayName="ModalDialog";var b=(0,N.Z)("modal-footer"),k=a(30785);let C=g.forwardRef((e,t)=>{let{bsPrefix:a,className:s,...r}=e;return a=(0,v.vE)(a,"modal-header"),(0,w.jsx)(k.Z,{ref:t,...r,className:n()(s,a)})});C.displayName="ModalHeader",C.defaultProps={closeLabel:"Close",closeButton:!1};let E=(0,a(41085).Z)("h4");var B=(0,N.Z)("modal-title",{Component:E});function T(e){return(0,w.jsx)(f.Z,{...e,timeout:null})}function S(e){return(0,w.jsx)(f.Z,{...e,timeout:null})}let I=g.forwardRef((e,t)=>{let{bsPrefix:a,className:s,style:r,dialogClassName:f,contentClassName:N,children:D,dialogAs:Z,"aria-labelledby":b,"aria-describedby":k,"aria-label":C,show:E,animation:B,backdrop:I,keyboard:M,onEscapeKeyDown:L,onShow:R,onHide:A,container:H,autoFocus:P,enforceFocus:X,restoreFocus:U,restoreFocusOptions:O,onEntered:G,onExit:W,onExiting:F,onEnter:Y,onEntering:z,onExited:J,backdropClassName:K,manager:V,...Q}=e,[q,$]=(0,g.useState)({}),[ee,et]=(0,g.useState)(!1),ea=(0,g.useRef)(!1),es=(0,g.useRef)(!1),er=(0,g.useRef)(null),[en,ei]=(0,h.Z)(),ec=(0,x.Z)(t,ei),eo=(0,m.Z)(A),el=(0,v.SC)();a=(0,v.vE)(a,"modal");let ed=(0,g.useMemo)(()=>({onHide:eo}),[eo]);function eh(){return V||(0,y.t)({isRTL:el})}function em(e){if(!c.Z)return;let t=eh().getScrollbarWidth()>0,a=e.scrollHeight>(0,o.Z)(e).documentElement.clientHeight;$({paddingRight:t&&!a?d():void 0,paddingLeft:!t&&a?d():void 0})}let ex=(0,m.Z)(()=>{en&&em(en.dialog)});(0,p.Z)(()=>{(0,l.Z)(window,"resize",ex),null==er.current||er.current()});let ep=()=>{ea.current=!0},eu=e=>{ea.current&&en&&e.target===en.dialog&&(es.current=!0),ea.current=!1},eg=()=>{et(!0),er.current=(0,u.Z)(en.dialog,()=>{et(!1)})},ej=e=>{e.target===e.currentTarget&&eg()},ey=e=>{if("static"===I){ej(e);return}if(es.current||e.target!==e.currentTarget){es.current=!1;return}null==A||A()},ef=(0,g.useCallback)(e=>(0,w.jsx)("div",{...e,className:n()("".concat(a,"-backdrop"),K,!B&&"show")}),[B,K,a]),eN={...r,...q};return eN.display="block",(0,w.jsx)(_.Z.Provider,{value:ed,children:(0,w.jsx)(j.Z,{show:E,ref:ec,backdrop:I,container:H,keyboard:!0,autoFocus:P,enforceFocus:X,restoreFocus:U,restoreFocusOptions:O,onEscapeKeyDown:e=>{M?null==L||L(e):(e.preventDefault(),"static"===I&&eg())},onShow:R,onHide:A,onEnter:(e,t)=>{e&&em(e),null==Y||Y(e,t)},onEntering:(e,t)=>

1{null==z||z(e,t),(0,i.ZP)(window,"resize",ex)},onEntered:G,onExit:e=>{null==er.current||er.current(),null==W||W(e)},onExiting:F,onExited:e=>{e&&(e.style.display=""),null==J||J(e),(0,l.Z)(window,"resize",ex)},manager:eh(),transition:B?T:void 0,backdropTransition:B?S:void 0,renderBackdrop:ef,renderDialog:e=>(0,w.jsx)("div",{role:"dialog",...e,style:eN,className:n()(s,a,ee&&"".concat(a,"-static"),!B&&"show"),onClick:I?ey:void 0,onMouseUp:eu,"aria-label":C,"aria-labelledby":b,"aria-describedby":k,children:(0,w.jsx)(Z,{...Q,onMouseDown:ep,className:f,contentClassName:N,children:D})})})})});I.displayName="Modal",I.defaultProps={show:!1,backdrop:!0,keyboard:!0,autoFocus:!0,enforceFocus:!0,restoreFocus:!0,animation:!0,dialogAs:Z};var M=Object.assign(I,{Body:D,Header:C,Title:B,Footer:b,Dialog:Z,TRANSITION_DURATION:300,BACKDROP_TRANSITION_DURATION:150})},31040:function(e,t,a){"use strict";var s=a(94184),r=a.n(s),n=a(67294),i=a(98814),c=a(85893);let o=n.forwardRef((e,t)=>{let{bsPrefix:a,variant:s,animation:n="border",size:o,as:l="div",className:d,...h}=e;a=(0,i.vE)(a,"spinner");let m="".concat(a,"-").concat(n);return(0,c.jsx)(l,{ref:t,...h,className:r()(d,m,o&&"".concat(m,"-").concat(o),s&&"text-".concat(s))})});o.displayName="Spinner",t.Z=o},20656:function(e,t,a){"use strict";a.r(t);var s=a(85893),r=a(9008),n=a.n(r),i=a(61482),c=a.n(i),o=a(81986),l=a(26548),d=a(84091),h=a(7644),m=a(4727),x=a(84414),p=a(12083),u=a(67294),g=a(92814),j=a(39),y=a(61356),f=a(53595);let N=["AGI","APPC","ATM","AUTO","BTC","BUSD","DFI","DMD","LUN","LUN","LYM","MTH","MTL","NCT","OMG","PIRL","PPC","RSR","STAK","SUB","SUTER","SXP","TRB","XPM","XPR","XRP","XST","XVG"];t.default=()=>{let[e,t]=(0,u.useState)();return(0,u.useEffect)(()=>{t(!0)},[]),(0,s.jsxs)("div",{className:c().wrapper,children:[(0,s.jsxs)(n(),{children:[(0,s.jsx)("title",{children:"Crypto Data in Excel - MarketXLS"}),(0,s.jsx)("meta",{name:"description",content:"Get cryptocurrency prices, historical data, and technical indicators in Excel with MarketXLS formulas such as =Last, =Bid, =Ask, and =Close_Historical."}),(0,s.jsx)("meta",{property:"og:title",content:"Crypto Data in Excel - MarketXLS"}),(0,s.jsx)("meta",{property:"og:description",content:"Get cryptocurrency prices, historical data, and technical indicators in Excel with MarketXLS formulas such as =Last, =Bid, =Ask, and =Close_Historical."}),(0,s.jsx)("meta",{property:"og:image",content:"https://marketxls.com/images/homeLaptop9.png"}),(0,s.jsx)("meta",{property:"og:image:width",content:"1080"}),(0,s.jsx)("meta",{property:"og:image:height",content:"700"}),(0,s.jsx)("meta",{property:"og:image:type",content:"image/png"}),(0,s.jsx)("meta",{property:"og:type",content:"article"}),(0,s.jsx)("meta",{property:"og:article:published_time",content:"2015-09-26 06:18:48"}),(0,s.jsx)("meta",{property:"og:article:modified_time",content:"2021-06-26 13:33:56"}),(0,s.jsx)("meta",{name:"twitter:card",content:"summary"}),(0,s.jsx)("meta",{name:"twitter:title",content:"Crypto Data in Excel - MarketXLS"}),(0,s.jsx)("meta",{name:"twitter:description",content:"Get cryptocurrency prices, historical data, and technical indicators in Excel with MarketXLS formulas such as =Last, =Bid, =Ask, and =Close_Historical."}),(0,s.jsx)("meta",{name:"twitter:image",content:"https://marketxls.com/images/homeLaptop9.png"}),(0,s.jsx)("link",{rel:"canonical",href:"".concat("https://marketxls.com").concat(m.U.cryptoDataInExcel)}),(0,s.jsx)("meta",{property:"og:locale",content:"en_US"}),(0,s.jsx)("meta",{property:"og:url",content:"".concat("https://marketxls.com").concat(m.U.cryptoDataInExcel)}),(0,s.jsx)("meta",{property:"og:site_name",content:"MarketXLS"}),(0,s.jsx)("meta",{name:"twitter:card",content:"summary"}),(0,s.jsx)("meta",{name:"twitter:site",content:"@marketxls"}),(0,s.jsx)("meta",{name:"twitter:creator",content:"@marketxls"}),(0,s.jsx)("script",{id:"JSON-LD-crypto-data-in-excel-web-page",type:"application/ld+json",dangerouslySetInnerHTML:{__html:JSON.stringify({"@context":"https://schema.org/","@type":"WebPage",url:"".concat("https://marketxls.com").concat(m.U.cryptoDataInExcel),name:"Crypto Data in Excel - MarketXLS",description:"Get cryptocurrency prices, historical data, and technical indicators in Excel with MarketXLS formulas such as =Last, =Bid, =Ask, and =Close_Historical."})}})]}

1),(0,s.jsx)("div",{className:c().whiteAndGreyBackground,children:(0,s.jsxs)("div",{children:[(0,s.jsx)("div",{className:c().headerWrapper,children:(0,s.jsx)(o.Z,{children:(0,s.jsxs)(l.Z,{className:"align-items-center",children:[(0,s.jsxs)(d.Z,{lg:6,children:[(0,s.jsx)("h1",{className:c().title,children:(0,s.jsx)("strong",{children:"Discover Crypto Data in Excel"})}),(0,s.jsx)("br",{}),(0,s.jsx)("p",{className:c().description,children:"MarketXLS puts cryptocurrency data in Excel through the same formulas it uses for stocks. Type a crypto symbol into =Last(), =Bid(), or =Ask() for the current price, =Close_Historical() for the price on a past date, and technical indicator functions such as =SimpleMovingAverage() for trend analysis."}),(0,s.jsx)("br",{}),(0,s.jsx)(h.Z,{variant:"dark",className:c().getStartedBtn1,href:m.U.pricing,children:"Get Started"}),(0,s.jsx)("br",{}),(0,s.jsx)("br",{}),(0,s.jsx)("br",{}),(0,s.jsxs)(l.Z,{children:[(0,s.jsxs)(d.Z,{children:[(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItem,children:"1200+"})}),(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItemDesc,children:"Cryptocurrencies"})})]}),(0,s.jsxs)(d.Z,{children:[(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItem,children:"9600+"})}),(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItemDesc,children:"Unique combinations"})})]}),(0,s.jsxs)(d.Z,{children:[(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItem,children:"17"})}),(0,s.jsx)(l.Z,{children:(0,s.jsx)(d.Z,{className:c().highlightedItemDesc,children:"Exchanges"})})]})]})]}),(0,s.jsx)(d.Z,{lg:6,className:c().cloudWrapper,children:e?(0,s.jsx)(p.ZJ,{containerProps:{style:{background:"url(".concat("/images/icons/sphere/sphere-background.svg",") no-repeat"),backgroundPosition:"center",backgroundSize:"cover",maxWidth:500,maxHeight:500}},options:{interval:30,initial:[.2,-.2],zoom:1.15,wheelZoom:!1,outlineColour:"rgba(0,0,0,0)"},children:null==N?void 0:N.map((e,t)=>(0,s.jsx)("a",{onClick:e=>e.preventDefault(),children:(0,s.jsx)("img",{src:"/images/icons/sphere/crypto/".concat(e,".svg"),width:42,height:42,alt:e+" icon"})},t))}):null})]})})}),(0,s.jsxs)(o.Z,{children:[(0,s.jsxs)(l.Z,{xs:1,md:2,className:c().newMethodology,children:[(0,s.jsx)(d.Z,{className:"".concat(c().middleRowcols," d-flex justify-content-center align-items-center"),children:(0,s.jsx)(j.default,{imgSrc:x.T.CryptoGrow,className:"d-flex justify-content-center align-items-center",alt:"MarketXLS Crypto data in Excel"})}),(0,s.jsx)(d.Z,{className:"d-flex align-items-center",children:(0,s.jsxs)("div",{children:[(0,s.jsx)("h2",{className:c().secondaryHeaderTitle,children:"How MarketXLS picks the exchange for a crypto price"}),(0,s.jsx)("br",{}),(0,s.jsxs)("p",{className:c().secondaryHeaderDesc,children:["To get a price from a specific exchange, add the exchange name to the end of the crypto symbol. If you leave the exchange off, MarketXLS finds where the token is listed and returns the price from that listing.",(0,s.jsx)("br",{}),(0,s.jsx)("br",{}),"You can also download the full list of available cryptocurrencies into Excel."]}),(0,s.jsxs)("a",{href:m.U.pricing,className:"colorDark",children:["Try Now ",(0,s.jsx)(g.G,{icon:f.AG,className:c().arrowRight})]})]})})]}),(0,s.jsxs)(l.Z,{children:[(0,s.jsxs)(d.Z,{xs:12,md:8,children:[(0,s.jsx)("h2",{className:c().whatCanYouDoTitle,children:"What you can do with crypto data"}),(0,s.jsxs)(l.Z,{xs:1,md:2,children:[(0,s.jsxs)(d.Z,{children:[(0,s.jsx)("div",{className:c().whatCanYouDoDescription,children:"Crypto symbols work in the standard MarketXLS functions"}),(0,s.jsxs)(l.Z,{xs:1,children:[(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Intraday prices"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"=Last(), =Bid(), and =Ask() return the current crypto price, bid, and ask."})]})}),(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Volume averages"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"Average trading volume for a crypto symbol."})]})})]})]}),(0,s.jsx)(d.Z,{children:(0,s.jsxs)(l.Z,{xs:1,children:[(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Technical Indicators"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"Technical indicator functions such as =SimpleMovingAverage() and =ExponentialMovingAverage() accept crypto symbols."})]})}),(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Historical Data"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"=Close_Historical() returns a crypto's closing price on a specific past date."})]})})]})})]})]}),(0,s.jsx)(d.Z,{xs:12,md:4,children:(0,s.jsxs)(l.Z,{xs:1,children:[(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Analytical results"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"Drawdown and return functions (such as =StockReturn()) also work on crypto symbols."})]})}),(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Range of Data"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"Get the minimum, maximum, high, and low of a crypto price series over a date range."})]})}),(0,s.jsx)(d.Z,{children:(0,s.jsxs)("div",{className:c().messageBox,children:[(0,s.jsx)("h5",{className:c().msgBoxTitle,children:"Download Data"}),(0,s.jsx)("div",{className:c().msgBoxDescription,children:"Download historical crypto prices for a date range you choose."})]})})]})})]})]}),(0,s.jsx)(y.default,{className:"mb-3"})]})})]})}},61482:function(e){e.exports={bigText:"CryptoDataInExcel_bigText__MFBR0",headerWrapper:"CryptoDataInExcel_headerWrapper__0gYsY",title:"CryptoDataInExcel_title__b9isE",description:"CryptoDataInExcel_description__O8MmY",newMethodology:"CryptoDataInExcel_newMethodology__NxcWB",highlightedItem:"CryptoDataInExcel_highlightedItem__QZjmo",highlightedItemDesc:"CryptoDataInExcel_highlightedItemDesc__SnxKw",secondaryHeaderTitle:"CryptoDataInExcel_secondaryHeaderTitle__Jf4kp",secondaryHeaderDesc:"CryptoDataInExcel_secondaryHeaderDesc__VQjvh",getStartedBtn1:"CryptoDataInExcel_getStartedBtn1__asROm",cloudWrapper:"CryptoDataInExcel_cloudWrapper__vu3J_",messageBox:"CryptoDataInExcel_messageBox__nghHp",msgBoxDescription:"CryptoDataInExcel_msgBoxDescription__1yKnB",msgBoxTitle:"CryptoDataInExcel_msgBoxTitle__wRvUN",whatCanYouDoTitle:"CryptoDataInExcel_whatCanYouDoTitle__p9iTd",whatCanYouDoDescription:"CryptoDataInExcel_whatCanYouDoDescription__dPddh"}}},function(e){e.O(0,[38523,92814,12083,61356,75120,92888,49774,40179],function(){return e(e.s=35736)}),_N_E=e.O()}]);