Home MARKETXLS A POWERFUL MICROSOFT EXCEL FINANCIAL ANALYSIS TOOL WITH STOCK QUOTES

MARKETXLS A POWERFUL MICROSOFT EXCEL FINANCIAL ANALYSIS TOOL WITH STOCK QUOTES

What does it do?

Microsoft Excel is the at the core of financial and stock market analysis. However, there is lot desired when it comes to collecting right information, creating charts, performing complex calculations (with arrays), a database etc.

MarketXLS aims to fill these gaps and turns MS Excel into a powerful investing research tool. Along with access to reliable stock data, MarketXLS is packed with many powerful tools/utilities any stock trader/investor will appreciate.

 

Stock Quotes in Excel

  • Live Stock Quotes in Excel  with formulas like = Ask(“MSFT”)
  • 160 functions – download list here
  •  Auto Refresh  at 1 or 5 minutes
  • Handle 1500+ symbols in a sheet with 100+ metrics
  •  Lightening fast refreshes 
  • Multiple fail proof data sources
  • Data delivered after multiple checks on our redundant Servers
  • Easy to use functions that take only symbol as argument
  • Pricing for  Futures, Options, and ETFs 
  • No workbook limitations with live stock quotes in excel.
  • All versions of Excel®™ (2007, 2010, 2013, 2016) supported
  • Trusted by more than 1000 investors
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase

Stock Quotes in Excel formulae

Stock Quotes in Excel formulae

Stock Quotes in Excel formulae

Stock Quotes in Excel formulae

Stock Quotes in Excel formulae

 

Historical Data

 

  • Professional-grade Historical Stock data in Excel for  all US stocks 
  • Nicely designed user interface to get data in easily
  •  History to 1996 , reliable data source (Quotemedia data)
  • Get data for multiple stocks and indices at one go
  • Retrieved data gets formatted nicely
  • Get  Minute by Minute data  updates
  • All stocks on NASDAQ, AMEX, NYSE and ARCA covered
  • Data include open, high, low, close, volume, dividends, splits
  • Use Excel functions to get historical pricing for stocks and indices on specific dates
  • Data Includes  dividend, splits , pricing and adjustments history
  •  Most reliable US End of the day stock pricing data 
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase

Our stock prices data comes from reputed and reliable sources. The data can be download with a few clicks using MarketXLS user interface and it can also be accessed using easy to use Excel formulas like =close_historical(“GOOG”, Today()-30) . Historical data formulas are also available to get the historical pricing of indices as well for easier comparison between individual stocks, sector indices, and other economic indicators.
Stock Historical Data in Excel

 

Stock Historical Data in Excel

Stock Historical Data in Excel

Stock Historical Data in Excel

Stock Historical Data in Excel

Stock Historical Data in Excel

 

Technical Analysis

 

  • Perform Technical Analysis in Excel with  120+ Technical Indicators 
  •  Run groups  of indicators on your data
  • Customize everything including time period, MA types etc
  • Run with default inputs for no prompts
  •  Discover patterns  in data and see its impact
  • Annotate patterns on Candle Stick Charts with a click
  • Run “ Pattern Scan Report ” – for actionable insights
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase

 
Stock Historical Data in Excel
 
 
 
Stock Historical Data in Excel
 
Stock Historical Data in Excel
 

Data Visualization

  • Ready made  stunning stock charts in Excel 
  • Make your own charts with any dataset in Excel
  •  Zoom in – Zoom out  of charts with dynamic dates handling
  • Exports charts in multiple formats
  •  Annotate Candlestick patterns  on chart
  • Auto-identification of data series, no settings needed
  • Maximize chart windows without distortion of clarity
  • Open multiple charts in Excel at a time
  • Much more interactive and dynamic than native charts in excel
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase

 

Stock Screener

 

  • Stock Screener in Excel : Screen markets by  10 years key fundamentals 
  •  Build complex filter criteria  with an unlimited number of filter conditions, combined by logical operators
  • Search through financial statements
  • Tree-like or Text-based filter editing style
  •  Filter by comparing fields , indicators in history
  • Copy and paste screened stocks to excel sheet
  • Get 10 history of a key ratio, attribute for any stock
  • Save your screen formulas as text in Excel sheets
  • Choose columns to show or hide to copy paste in Excel
  • Screener formula histories stored in memory to revert to one if needed with a single click
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase


 

 

 

Portfolio Manager

 

  • Better stock portfolio management in Excel
  •  Import transactions  from your trading accounts
  • Add  transactions in bulk 
  • Deal with  Tax, commissions and splits  with ease
  • Monitor performance real time in  dashboard 
  • Compare portfolio returns with  dynamic charts 
  • View portfolios with Excel’s pivot table like interface
  • See holding returns, expected returns, average daily return, variation etc
  • See optimized portfolio allocation (Efficient frontier)
  • Unlimited portfolios/transactions
  • For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
    Purchase

 

 

Utilities and Apps

  • Ever growing collection of utilities and apps to save you time and get you what you need while researching stocks with ease
    Market News Channels
  • Proprietry news channels and market summary within MarketXLS from in Excel
    Useful Collection of Lists
  • Ever updating symbol lists for various exchanges at click of a button
    Symbol Lookup
  • Find ticker symbol by text, keyword, industry or name of company
    Market Movers
  • Top 100 gainers, losers, and most busy stocks in NYSE, NYSE Market and NASDAQ
    Dividend History
  • Get dividend history of any US stock at click of a button
    Option Chains
  • Get option chain pricing for any symbol.

For 10% Discount Use Coupon Code "StockMarketSquawk" upon Checkout
Purchase

0