Live stock quotes in Excel
adtechnityaMSN_Stock_Options_FunctionsOptionResult_0screen1Screenshot 2stock-quotes-from-yahoo-financeYahoo Funcitons in Action

MarketXLS Core

$96.00

Live stock market data for Excel

Buy product

Category:

Product Description

MarketXLS is the ultimate tool for real-time stock quotes and financial data, straight into Excel.

  • Do you want a rock-solid, stable Excel add-in that gives you live market data?
  • Do you need data for stock screening, identifying undervalued or overvalued stocks, and more?
  • Do you want fanatical support and all future updates for free?

MarketXLS links to the Yahoo Finance API, and is robust, solid tool that gives you essential market information for your chosen ticker. Use the data for stock screening, identifying undervalued or overvalued stocks, and more.

Watch this video for a live demo.

You get over new functions that let you download

  • last trade price
  • bid and ask prices
  • EPS estimates for the current year and next year
  • Book value and EBIDTA
  • Market cap
  • and much more

The functions are easy-to-use. You don’t need any special training.

  • You just give the function a ticker symbol
  • MarketXLS then links to the web and downloads the data, straight into a cell

For example, let’s say you wanted the market capitalization of Apple. You’d simply enter =MarketCapitalization(“AAPL”) into a cell and hit Enter.

This add-in also gives option prices (open, bid, ask, strike, expiration date and volume) and mutual fund data.

Here’s a list of the new functions you get.

CategoryFunction
StocksAsk("Symbol")
StocksYHOO_Price("Symbol")
StocksAverageDailyVolume("Symbol")
StocksAskSize("Symbol")
StocksBid("Symbol")
StocksAsk_Real_time("Symbol")
StocksBid_Real_time("Symbol")
StocksBookValue("Symbol")
StocksBidSize("Symbol")
StocksChange_PercentChange("Symbol")
StocksChange("Symbol")
StocksCommission("Symbol")
StocksChange_Real_time("Symbol")
StocksAfterHoursChange_Real_time("Symbol")
StocksDividendPerShare("Symbol")
StocksLastTradeDate("Symbol")
StocksTradeDate("Symbol")
StocksEarningsPerShare("Symbol")
StocksEPSEstimateCurrentYear("Symbol")
StocksEPSEstimateNextYear("Symbol")
StocksEPSEstimateNextQuarter("Symbol")
StocksFloatShares("Symbol")
StocksDaysLow("Symbol")
StocksHoldingsGainPercent("Symbol")
StocksAnnualizedGain("Symbol")
StocksHoldingsGain("Symbol")
StocksHoldingsGainPercent_Real_time("Symbol")
StocksHoldings_GainReal_time("Symbol")
StocksDaysHigh("Symbol")
StocksMoreInfo("Symbol")
StocksOrderBook_Real_time("Symbol")
StocksFiftyTwo_weekLow("Symbol")
StocksMarketCapitalization("Symbol")
StocksMarketCap_Real_time("Symbol")
StocksEBITDA("Symbol")
StocksChangeFrom52_weekLow("Symbol")
StocksPercentChangeFrom52_weekLow("Symbol")
StocksFiftyTwo_weekHigh("Symbol")
StocksLastTrade_Real_time_WithTime("Symbol")
StocksChangePercent_Real_time("Symbol")
StocksLastTradeSize("Symbol")
StocksChangeFrom52_weekHigh("Symbol")
StocksPercentChangeFrom52_weekHigh("Symbol")
StocksLastTrade_WithTime("Symbol")
StocksLastTrade_PriceOnly("Symbol")
StocksHighLimit("Symbol")
StocksLowLimit("Symbol")
StocksDaysRange("Symbol")
StocksDaysRange_Real_time("Symbol")
StocksFifty_dayMovingAverage("Symbol")
StocksTwoHundred_dayMovingAverage("Symbol")
StocksChangeFrom200_dayMovingAverage("Symbol")
StocksPercentChangeFrom200_dayMovingAverage("Symbol")
StocksChangeFrom50_dayMovingAverage("Symbol")
StocksPercentChangeFrom50_dayMovingAverage("Symbol")
StocksName("Symbol")
StocksNotes("Symbol")
StocksOpen("Symbol")
Stocksn Open1("Symbol", Optional ByVal dtDate As String = "")
StocksPreviousClose("Symbol")
StocksPricePaid("Symbol")
StocksChangeinPercent("Symbol")
StocksPricePerSales("Symbol")
StocksPricePerBook("Symbol")
StocksEx_DividendDate("Symbol")
StocksPERatio("Symbol")
StocksDividendPayDate("Symbol")
StocksPERatio_Real_time("Symbol")
StocksPEGRatio("Symbol")
StocksPrice_EPSEstimateCurrentYear("Symbol")
StocksPrice_EPSEstimateNextYear("Symbol")
StocksTheSymbol("Symbol")
StocksSharesOwned("Symbol")
StocksShortRatio("Symbol")
StocksLastTradeTime("Symbol")
StocksTradeLinks("Symbol")
StocksTickerTrend("Symbol")
StocksOneyrTargetPrice("Symbol")
StocksVolume("Symbol")
StocksHoldingsValue("Symbol")
StocksHoldingsValue_Real_time("Symbol")
StocksFiftyTwo__weekRange("Symbol")
StocksDaysValueChange("Symbol")
StocksDaysValueChange_Real_time("Symbol")
StocksStockExchange("Symbol")
StocksDividendYield("Symbol")
StocksQuoteTime("Symbol")
StocksQuoteDate("Symbol")
StocksShares_Outstanding("Symbol")
Mutual FundsYHOO_MF_NetAssets("Symbol")
Mutual FundsYHOO_MF_Price("Symbol")
Mutual FundsYHOO_MF_PreviousClose("Symbol")
Mutual FundsYHOO_MF_Yield("Symbol")
Mutual FundsYHOO_MF_YTDReturn("Symbol")
OptionsYHOO_Option_PreviousClose("Symbol")
OptionsYHOO_Option_Open("Symbol")
OptionsYHOO_Option_Bid("Symbol")
OptionsYHOO_Option_Ask("Symbol")
OptionsYHOO_Option_StrikePrice("Symbol")
OptionsYHOO_Option_OpenInterest("Symbol")
OptionsYHOO_Option_Volume("Symbol")
OptionsYHOO_Option_ExpirationDate("Symbol")

System Requirements:
All versions of Excel (including 2016), only on Windows machines.

Reviews

There are no reviews yet.

Be the first to review “MarketXLS Core”

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