MarketXLS Blog

MarketXLS 9.3.5 (September 2023) added options order flow summary functions, unusual options activity scans, and historical option chains in Excel.

MarketXLS 9.3.4.9 adds end-of-day data for VIX, S&P 500, Nasdaq Composite, Dow Jones, and Nasdaq-100, plus the ExpirationNext and StrikeNext option functions.

MarketXLS Version 9.3.4.8 adds ThinkorSwim multileg strategies, dividend payout tracking, total returns, AI-powered Efficient Frontier, and more.

MarketXLS Version 9.3.4.7 introduces 18 new Implied Volatility functions, a Spreadsheet Builder, Top Options functions, and 100+ pre-built screeners.

MarketXLS Version 9.3.4.5 adds 35+ new growth, earnings and profitability functions including Altman Z-Score, Piotroski F-Score, and more.

How to connect MarketXLS to Interactive Brokers TWS (2021): install TWS and the TWS API, enable socket clients on port 7496, then use =ib functions in Excel.

A 2021 walkthrough of how MarketXLS read data from a running thinkorswim desktop platform using =tos functions in Excel.

MarketXLS 9.3.2 (August 2021) added historical data for mutual funds, fixed credential saving, and added a LiquidCash component to portfolio analytics.

MarketXLS version 9.3 (June 2021) added Guru Screen functions such as =gs_Lynch_Screen(), new templates, faster refresh-on-demand, and Options Scanner filters.

Jane Street Capital is a proprietary trading firm and market maker best known for ETF trading and its use of OCaml. How it operates and earns.

MarketXLS 9.2 (September 2020) added portfolio analytics functions that take a holdings-and-weights range as input, Benzinga news functions, and new templates.

MarketXLS 9.1 (June 2020) added a function Search and Help button, ETF holdings functions, historical volatility functions, and streaming improvements.