MarketXLS Review

topleft Sometimes I just want stock market data in Excel, and I don’t want to spin my wheels hacking about with VBA.

I’ve written VBA code for scraping market data from Yahoo Finance, Google and other websites, sometimes even with moderately successful results.

But I’ve never been completely ecstatic with the solution because I have to deal with too many problems, including

  • ever-changing APIs,
  • functions that no longer work because data is in a different location on a web page,
  • slow updates for bulk data requests
  • and many other headaches

I don’t always have the time to rewrite existing code, or prototype new UDFs (I have a job, a wife, two-year old son and another kid on the way. I’m lucky if I have a spare hour each night before sleep – time is a precious commodity). And frankly, copying and pasting data from websites seems so clunky and archaic.

So I surveyed the market for professionally-developed stock market data add-ins for Excel, and I evaluated several.

I eventually ended up buying MarketXLS, developed and supported by a clever group of people at Technitya. It provides over 90 functions for scraping stock market data from Yahoo Finance, and offers lifetime updates as a part of the initial cost.

You can see me use MarketXLS in this video.

If you’re familiar with the Yahoo Finance API, you’ll know that you can extract many items of financial information for a company. So things like

  • Market capitalization
  • Last trade price, and ask/bid prices
  • EPS estimates
  • Price/book value
  • and more

You get data for stocks, mutual funds, bonds, and options.

Installing and Navigating MarketXLS

The software is sold as a digital download. After you install the add-in and start Excel, you’ll find a new tab.

MarketXLS addin tab v2

There’s a handy link to a website with the latest updates (MarketXLS is regularly updated). The add-in checks for updates every time you load Excel, but you can disable this behavior via the Settings menu.

“Refresh Selected” and “Refresh All” are pretty obvious – they update all data that MarketXLS has downloaded with the most recent values.

This is quick because MarketXLS is multi-threaded – so multiple links to Yahoo Finance are initiated (don’t worry – this doesn’t slow down your computer).

MarketXLS provides over 90 new functions. I won’t give them all here, but this spreadsheet lists them all. All the functions are listed in the Formulas > Insert Function menu under three categories.

  • Stock Quotes (89 functions)
  • Mutual Funds (5 functions)
  • Stock Options (8 functions)

The Insert Function window gives all the functions in MarketXLS
A fourth category lists functions that give license information etc,

Downloading Market Data

You give each of the functions a stock ticker symbol and hit enter.

So let’s say I wanted the EPS estimate for the current year for KKR & Co LP (a private equity firm). I simply type

=EPSEstimateCurrentYear(“KKR”)

into a cell and press enter.

EPS Estimate for KKR

The function retrieves the data from Yahoo Finance and places it in the cell. It doesn’t get any more complicated than this.

You’ll need the Yahoo ticker symbol. But fear not, I’ve assembled a comprehensive list of tickers in a spreadsheet.

All the functions are available via the command completion menu. Just type the first few letters of a function name, and all the matches appear.

command completionThat’s a real time-saver, and reduces the cognitive load on my rapidly decreasing brain mass.

Some data, like the last trade price, is continuously updated during normal stock exchange hours. You can refresh this data with the latest values by hitting Refresh in the MarketXLS tab, or by pressing Shift+F9.

You can also download option prices – the ask, bid and strike prices, expiration date, volume and open interest.

Downloading option prices from Yahoo Finance into Excel

I’ve already mentioned that MarketXLS is multi-threaded. It’ll open up multiple calls to Yahoo Finance at the same time. This mean retrieving data is fast. I’ve downloaded data for over 200 tickers – this took a few seconds.

A Final Few Words

In case it’s not clear, I’m pretty happy with MarketXLS. I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying/pasting data from websites.

The lifetime free updates means I never have to worry about outdated software.

You can buy MarketXLS here. I’ve negotiated a 20% discount with the developer.

Disclaimer. I purchased MarketXLS with my own money. I now sell MarketXLS as an affiliate, but this has not affected my opinion of the software. I have no other connection with the developer.

14 thoughts on “MarketXLS Review

  1. Hi there, I was wondering if you must use Excel or can the spreadsheet be used by spreadsheets programs that can import/export Excel spreadsheets, such as Open Office and such.

  2. sir,
    Is your Market XLS applicable to BSE and NSE stocks of India? How many stocks quotes can I get in my Excel sheet at a time? What is time difference between real trade time and Market XLS download time?
    Is it applicable for stock Futures of BSE & NSE of India. I am trading with BSE & NSE from my House Desktop sometimes and Office computer sometimes and personal Laptop sometimes and in windows/android tab sometimes. In this scenario Can i use your single license Market XLS use on all these computers of-course all these are mine only but not at a time. Or should I buy more copies or licenses for using your Market XLS on all these computers / Tabs at a time??? please reply immediately. I am searching for this since long time and at last I found it on your web page. soon after receipt I will purchase.

    JanardhanaRao
    [email protected]

    1. Yahoo Finance only programmatic download of data for a specific set of tickers – not everything. Could you tell me what tickers you’re interested in, and I’ll test them?

      The delay is 15 minutes.

      I think the licensing is one license per computer (you can’t have one license on several computers).

    2. sir,
      Thanks for your immediate reply. my tickers are given below.
      FINCABLES.NS
      DIAPOWER.NS
      GIPCL.BO
      FEDDERLOY.NS
      CHAMBLFER.NS
      YESBANK.NS
      DALMIASUG.NS
      NITTAGELA.BO
      FSL.BO
      MANAKSIA.NS
      AARVEEDEN.NS
      IFBAGRO.NS
      DLINKINDI.NS
      MMFL.NS
      MARKSANS.NS
      TIRUMALCH.NS
      DEEPAKFER.NS
      ONMOBILE.NS
      SMARTLINK.NS
      INDORAMA.NS
      ARVINDREM.NS
      HBLPOWER.NS
      MCLEODRUS.NS
      PRAJIND.NS
      KPRMILL.NS
      KALPATPOW.NS
      VTL.NS
      INOXLEISU.NS
      JYOTISTRUC.BO
      COROMANDE.NS
      DPTL.NS
      APLLTD.NS
      ORIENTBEL.NS
      DISHMAN.NS
      NDL.BO
      BANSWRAS.NS
      JAYSYN.BO
      INDSILHYD.BO
      SABERORGA.NS
      GPIL.NS
      TVSMOTOR.NS
      ASSAMCO.NS
      MARALOVER.NS
      TIRUPATIINK.BO
      MADHAV.NS
      RSSOFTWARE.BO
      TVSSRICHA.NS
      MPSLTD.BO
      JAYAGROGN.NS
      HTMEDIA.NS
      ATULAUTO.BO
      DENISCHEM.BO
      UJAAS.BO
      TATACOMM.NS
      DIGJAM.NS
      HIMIN.BO
      AARTIDR.BO
      NIPPOBATR.NS
      TRF.NS
      BIRLAERI.BO
      TIL.BO
      BEML.NS
      MOSERBAER.NS
      ANDREWYU.BO
      KOPRAN.NS
      RANEHOLDI.NS
      BAJAJHIND.NS
      WELSPUNENT.BO
      TATAPOWER.NS
      TIIL.NS
      SMLISUZU.NS
      PEL.BO
      HEG.NS
      BODALCHEM.BO
      ALEMBICLTD.BO
      IGPL.NS
      TRENT.NS
      LANCOIN.NS
      GARWALLROP.BO
      MINDAIND.NS
      OMAXAUTO.NS
      PANAENERG.BO
      MUKANDLTD.NS
      MAITHANAL.BO
      SURYAROSN.NS
      TWL.NS
      ADANIPOWE.NS
      RPOWER.NS
      HDIL.NS
      DLF.NS
      TATAPOWER.NS
      IBREALEST.NS
      HAVELLS.NS
      PIPAVAVDOC.BO
      MASTEK.BO
      TALBROAUTO.BO
      JOSTS.BO
      EMPIND.BO
      MAX.BO
      BOROSIL.BO
      NESCO.BO
      EXCELINDUS.BO
      LIBERTSHOE.BO
      WALCHANNA.NS
      KEI.BO
      MHRIL.BO
      ADANIENT.NS
      HSIL.BO
      CLARIS.BO
      ZYDUSWELL.BO
      SOLARINDS.BO

      I will add one ticker per week days. Waiting for your reply.

      JanardhanaRao
      [email protected]

  3. Hello,
    Could you provide me with the financial places availables with MarketXLS
    European places are availables?
    thanks
    steph

  4. I think MarketXLS is the best thing since sliced bread and I find it easy to use, well documented, and sufficient to cover most of my needs. However, I need to use the function in VBA and can’t figure out how to do it.

    In my quest, I found a reference to the function, “Evaluate,” and actually used it as directed. It worked just fine. Problem is that I can’t find the reference, can’t find the worksheet where I tested it, and can’t replicate the syntax.

    Bottom line: I would like to use MarketXLS in Excel VBA (and in Access, for that matter) and need help in those areas.

    Anyone????

Leave a Reply to JanardhanaRao Cancel reply

Your email address will not be published. Required fields are marked *

What is 7 + 14 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)