Barchart adds real-time equity options data and analytics into Barchart for Excel

Rick Steves

Barchart for Excel has already gained recognition for providing extensive data across multiple asset classes like stocks, options, futures, currencies, and crypto.

Barchart has announced a significant enhancement to its Barchart for Excel service. This update integrates real-time equity options data and analytics, marking a pivotal advancement in the platform’s capabilities. Barchart for Excel, known for its seamless integration of market data into Microsoft Excel, now offers an even more comprehensive toolkit for market analysis.

This development is particularly timely, given the notable surge in equity options trading volumes in recent years. Brendan Hebert, Product Manager at Barchart, highlights the importance of this addition: “As equity options volumes have surged in recent years, our decision to incorporate real-time options into Barchart for Excel underscores our dedication to offering our users the most comprehensive and flexible platform for market analysis.”

Hebert noted that Barchart for Excel is designed to serve a broad spectrum of users, from novice traders to experienced analysts, with a diverse array of tools for informed and efficient decision-making.

Barchart for Excel’s expanded features include:

Real-Time Stock Quotes: Users have access to streaming updates, including live trades, bid/ask prices, and volume changes.
Real-Time Equity Options: The platform now offers real-time Greek calculations, such as Delta, Gamma, Theta, Vega, and Rho.
Historical Market Data: It provides extensive access to historical data, including daily, minute, and tick data.
Fundamental Data: Users can delve into extensive fundamental data, encompassing financial ratios, corporate actions, company profiles, and financial statements.
Options Analysis: The service includes comprehensive options analysis tools, such as IV Rank and Percentile, Most Active Options, Highest Implied Volatility, and Implied Volatility Curves.
Technical Study Data: A wide range of technical data fields are available, including indicators like Moving Averages, Stochastics, and Bollinger Bands.
Syncing with Watchlists and Portfolios: The platform allows users to instantly access their saved Watchlists and Portfolios from
Charting: Users can create custom charts using Excel’s native chart functionality and Barchart’s data, integrating and overlaying their own data sets.
Customizable Barchart Functions: The platform enables users to insert functions into Excel with pre-built Barchart arguments for easy data integration.
Building Financial Models: Users can combine price and fundamental data to create personalized financial forecasts.
Custom Worksheets and Reports: The service allows for the creation of unique worksheets and reports in Excel, tailored to individual needs and styles.

Barchart for Excel has already gained recognition for providing extensive data across multiple asset classes like stocks, options, futures, currencies, and crypto.

The integration of real-time equity options data reinforces Barchart’s commitment to evolving with market trends and user demands, ensuring that it remains a go-to resource for comprehensive market analysis. This enhancement not only broadens the scope of analysis capabilities for traders and investors but also solidifies Barchart’s position as a key player in the field of market data and trading technology.

Exclusive interview with Barchart CEO Mark Haraburda

In an exclusive interview with FinanceFeeds Editor-in-Chief Nikolai Isayev, Barchart CEO Mark Haraburda delved into the recent advancements in the company’s product suite and explained why options trading is on the rise.

While options on futures have seen growth, the main surge in popularity has been in equity options. This growth can be attributed to several factors, including increased education and awareness about options markets over the past two decades, the market volatility experienced during events like the COVID-19 pandemic, the accessibility of options trading through user-friendly apps, and the introduction of new products like short-dated options. These factors, combined with market volatility, have attracted new participants to options trading.

Haraburda also underscored how options on futures data, which Barchart has expanded into its Market Replay service, is a valuable and somewhat rare dataset.

Read this next

Retail FX

Revolut eyes Big Four auditor as board frustrated by BDO remarks

British fintech firm Revolut is reportedly considering a change in its auditing firm following a warning in its last annual accounts, as audited by BDO.

Institutional FX

Börse Group’s 360T taps Virtu for TCA and trading analytics

Virtu Financial and Deutsche Börse Group’s FX platform, 360T, have teamed up to improve the foreign exchange trading experience for their clients.

Digital Assets

Bybit Surpasses 20 Million Users Milestone Ahead of 5-Year Anniversary

Celebrating its 5th anniversary in December of this year, Bybit announced that it has surpassed 20 million registered users, highlighting its growth and position in the industry.

Digital Assets

Changpeng Zhao leaves Binance.US as SEC ramps up scrutiny

Changpeng ‘CZ’ Zhao has resigned from his position as chairman of the board for Binance.US, distancing himself from the governance of the American division of the cryptocurrency exchange.

Digital Assets

M2 granted full license to operate multilateral trading facility in UAE

Cryptocurrency exchange M2 has been approved as a fully regulated Multilateral Trading Facility (MTF) and custodian, now authorized to engage with UAE retail and institutional clients.

Digital Assets

Court approves Voyager’s $1.65 billion settlement with FTC

A New York federal judge has given the nod to a settlement that holds Voyager Digital and its former CEO, Stephen Ehrlich, accountable for misleading investors about the safety of their funds.

Retail FX

Financial Safety First: Why Regulated Brokers Are Your Best Compass

Picture yourself on the brink of the expansive financial trading universe, poised and ready to jump. But what ensures your descent into this financial abyss is controlled and secure? The unspoken hero here is regulation. It serves as a safeguard, setting rules and standards that help you navigate the market with a greater sense of security and less risk of unforeseen losses.

Industry News

Obituary: Campbell Adams, founder of ParFX and Pure Digital, passes away

Campbell Adams’ pioneering spirit and his contributions to the development of the FX industry as well as the digital asset trading space will be remembered and valued by industry peers and the broader financial community.

Inside View

Will Europe lead the way in crypto derivatives market structure?

The envisioned future market structure aims to provide direct access to regulated venues, offering 24/7 trading, lower initial margin requirements, and efficient risk management through remote custody agreements. This model is not just about addressing the current challenges but is also geared towards leveraging the best practices from the crypto markets.