MarketXLS is an excel add-in that allows users to access and analyze stock market data directly in Microsoft Excel.
The software includes a variety of tools for performing financial analysis and research, such as stock quotes, historical data, financial ratios, and technical indicators. It also allows users to build and backtest custom trading strategies, and create custom financial reports and charts.
MarketXLS is built for those who want to do their own custom investment research easily in excel, without having to find data, export it, and then import it into Excel.
This MarketXLS review will walk through the main features of the program to help you make an informed decision.
MarketXLS Review: Features
The add-in has quite a few powerful features for investment research.
Stock screener: You can pull in over a billion market data points into excel to analyze. Then you can use their built-in stock screener right in excel to filter through technical and fundamental factors. They also include their own proprietary stock ranks.
Real-time quotes: The advantage of using excel for market research is that you have full control over the data, but, traditionally, one of the disadvantages is that you don’t have access to real-time data. That’s one of the main benefits of MarketXLS. You can have full control while not missing out on the latest moves.
Collaboration tools: MarketXLS comes with tools that allow you to seamlessly work together with a team. Build and share custom templates, and watchlists, and even share your custom stock screens.
Education resources: Another feature of MarketXLS is its wealth of educational resources on using the platform and getting the most out of it. They have blogs, videos, made-for-you templates, and public screens that other users have shared.
MarketXLS has 3 pricing options. For each, you can choose a monthly billing option or an annual billing option, but the annual options are 25% cheaper than if you pay monthly.
Standard: $56/month for the annual subscription ($675/year), or $75/month if paid monthly.
Under the standard option, you do have access to the most common data sources, such as stocks, ETFs, options, mutual funds, and even Forex or Crypto. However, the main drawback of the standard plan is that the data is all on a 15-minute delay.
You also get access to most of the core features, such as the spreadsheet builder, rankings, portfolio templates, and key ratios.
Advanced: $94/month billed annually ($1125/Year), or $125 billed monthly.
The advanced plan provides real-time data on everything except Forex, which is on a 15-minute delay. The advanced plan also adds powerful options trading features, like filters, screeners, and real-time tracking.
Premium: $150/month billed annually ($1800/Year), or $200/month.
The premium plan gives users access to the full suite of features and real-time data. This is geared mostly toward professional investors. You get VIP support, historic options data on expired contracts, and more.
They also offer a 30-day money-back guarantee on the annual option for all plans.
MarketXLS is unique in that it allows you to analyze your trades directly in excel, but it’s not the only option for those wanting powerful market analysis. Here are some of the most popular alternatives:
Trade Ideas is a stock scanning tool with advanced features for in-depth analysis. It costs between $84 and $167/month.
TrendSpider focuses on technical analysis with cutting-edge machine-learning algorithms. It costs between $39 and $119/month, and they have a 7-day free trial available.
TC2000 is a stock charting program that has been around for over 25 years. They have some features available for free, and their paid plans go up to $89.98 per month.
MarketXLS Pros and Cons
- Great for custom analysis
- Convenient for users of Excel
- Wide range of data
- Must be comfortable with excel
- It is a paid tool with no free trial
Is MarketXLS Right for You?
This program is best for those who want full control over their data. You can build custom formulas and Macros to perform just about any kind of function you can dream of.
If you’re already an excel whiz, this is a great tool to add extreme power to your market research. However, if you’re not comfortable with excel, don’t have access to it, or if you prefer to use an analysis that is already done for you, this may not be the program you’re looking for.
Another reason to use MarketXLS is the wide range of data it offers. You can pull in data on most types of assets, and get thousands of data points on each. But you may not get as much benefit if you have a more narrow set of data you’re after.
MarketXLS is great for advanced securities analysis, and you can try it out for one month with minimal cost to see if it’s the right fit.