Barchart launches Microsoft Excell add-in

Rick Steves

“Whether looking to perform their own analysis, add other data sources, build macros or anything else leveraging the powerful features of Excel, we now provide that ability.”

Barchart.com has launched a Microsoft Excel add-in that allows users to access extensive sets of price, technical, and fundamental market data across stocks, options, futures, currencies and crypto.

Named Barchart for Excel is the latest move by the provider of market data and trading technology to active traders and investors.

The Excel add-in also allows users to access their saved data such as Watchlists, Portfolios and Custom Views inside of Excel, as well as popular Lists, such as Today’s Top Stocks, Unusual Options Activity and Most Active Futures.

Chris Harrison, Chief Technology Officer at Barchart, said: “Barchart.com attracts millions of traders and investors from around the world and many of them are looking for the ability to do more with the market data we offer. Whether looking to perform their own analysis, add other data sources, build macros or anything else leveraging the powerful features of Excel, we now provide that ability.

“We’ve built a product that caters to a wide range of users, from basic to advanced. If you are simply looking for the flexibility to work with our dynamic stock or options lists in Excel, or want to perform a correlation analysis between different financial data sets, the product provides for that and much more,” added Harrison.

Brendan Hebert, Product Manager at Barchart, commented: “Barchart for Excel offers a long list of features and extensive sets of data across stocks, options, indexes, futures, currencies and crypto. And, we are already working on adding more features, such as built-in Excel functions specific to Barchart data–providing our users with a very efficient process for quickly accessing the market data they need.

“Other features will be released soon, like a Stock Screener directly inside of Excel which offers hundreds of fields to screen from.”

Built for a wide range of users, including traders, investors, brokers, analysts, and financial advisors, Barchart for Excel features:

  • Real-Time Stock Quotes: Work directly in Excel with real-time streaming updates, including tick-by-tick trades, and dynamic bid/ask and volume updates.
  • Historical Market Data: Get extensive and instant access to daily, minute and tick historical data.
  • Fundamental Data: Quickly analyze hundreds of fundamental data series, including financial ratios, corporate actions, company profiles, balance sheets, income statements, and cash flow data across U.S., Canadian, European and Australian stocks.
  • Options Analysis: View the latest Unusual Options Activity, chart options strategies, access historical option prices and greeks, analyze implied volatility rankings, and build volatility skews.
  • Technical Study Data: Access moving averages, stochastics, bollinger bands and hundreds of additional technical data fields, including technical study data as a timeseries.
  • Sync your Watchlists and Portfolios: Instantly access your saved Watchlists and Portfolios from Barchart.com.
    Charting: Build your own charts using Excel’s native chart functionality and Barchart’s data, as well as integrate and overlay your own data sets.
  • Apply Excel Functions: Apply Excel functions to Barchart data, such as STDEV, Moving Averages and logical arguments.
  • Build Financial Models: Combine price and fundamental data such as current share prices, P/E ratios, EPS, Dividends and EBITDA, to create your own financial forecasts.
  • Custom Worksheets and Reports: Create your own custom Worksheets in Excel with unique formats, styling and data tables. Plus, leverage Excel features like Macros and Pivot Tables to create your own financial analysis reports.

Barchart offers a free 14-day trial to test the data, software, and technology solution to power a trader’s operation from front to back office.

 

Read this next

Retail FX

Scope Markets launches unleveraged trading

“Whilst our traditional contract for difference (CFD) products continue to prove incredibly popular, the Invest account is unleveraged and only allows ‘long’ positions to be taken, a combination that significantly reduces the risk of capital losses.”

blockdag

Unlocking Profit Potential: Earn Returns with DecodeEX Experience Bonus!

DecodeEX, the innovative brokerage subsidiary of Decode Global, announced its experience bonus campaign, offering every user the opportunity to maximize their strategic trading potential with up to $10,000 in experience bonus. 

Market News

Pretiorates’ Thoughts 28 – Precious metals and base metals out of control

Ten days ago we mentioned in Pretiorates’ Thoughts 26: Chapter 2 should start with Precious Metals.

Retail FX

Webull launches discount brokerage in Malaysia

“Making investing more inclusive and accessible to all, Webull Malaysia brings best-in-class tools and information to empower investors of all levels with knowledge and skills to help them make better investment decisions and achieve their investment goals.”

Digital Assets

Hidden Road adds OKX’s Nitro Spreads into prime brokerage

“Hidden Road continually seeks to increase market access and capital efficiency through expanded prime brokerage offerings. Integrating OKX’s Nitro Spreads product builds upon this philosophy by extending our counterparties’ ability to execute risk-managed arbitrage strategies.”

blockdag

Dev Release 31: BlockDAG’s SHA-3 Upgrades Propel Crypto Mining Innovation as Miner Sales Approach 5800 Units

Learn about BlockDAG’s 31st Development Release, which includes advanced SHA-3 updates and a significant increase in miner sales, driving advancements.

blockdag

BlockDAG Dominates 2024 Crypto Trends: Surpasses $28M in Presales Amid Strategic Partnerships

Explore BlockDAG, Shiba Inu, and Kaspa Killer’s rise in 2024’s crypto market, focusing on BlockDAG’s $28M presales, strategic partnerships, and innovative technology.

blockdag

BlockDAG’s $30 by 2030 Valuation Prediction and Roadmap Reveal Gains Traction From Filecoin and XLM Investors

Discover why BDAG’s $30 price prediction by 2030 outshines Filecoin Investors’ hopes and XLM’s recent surge with a booming presale and clear roadmap.

blockdag

BlockDAG Captures $28 Million in Presale, Drawing Investors Away from Ethereum and Bitcoin

Explore how BlockDAG’s revamped dashboard led to a $28 million presale boost, while Ethereum sees a downturn and Bitcoin struggles with hash rate reductions.

<