Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Real-Time functions using Barchart.com’s data Subscription

To start using real-time functions, you will need to subscribe to Barchart.com data. You can do so by going to the MarketXLS menu, Settings/Help, and then click on settings. A form like the one shown below will appear.

Real time functions - Data subscriptions

Click on the “Get Subscription Here” button and you will be diverted to the page where you can buy the subscription from barchart. Once, you have the subscription enter the username and password in the fields in the form and then click on Save. This will make sure that your username and password are saved and every time you open marketXLS it's there. You can also click on “Test Connection” to test if your subscription is valid or not.

Once, you have the subscription saved and tested you are ready to start using the functions that use this data subscription.

All real-time functions that use Barchart’s data subscription in MarketXLS start with =”rt_”, where “rt” stands for real-time. So, to start using them quickly simply start typing rt_ and you will see a list of functions appear. You can also use Excel’s inbuilt function browser like shown below to see all functions which are available.


Real time functions. Insert function: BarChart subscribed symbols

Below is a quick description of the functions and their purpose.

  • - Ask Price real time'
  • - Ask Size real time
  • - Bid price real time
  • - Bid size real-time
  • - Returns the change in price from the last session
  • - Returns the close price for the session
  • - Returns the close price for the previous session
  • - Returns the exchange name
  • - Returns the close price for the session
  • - Returns the high price for the previous session
  • - Returns the last price for the session
  • - Returns the last price for the previous session.
  • - Returns the last size for the sessio
  • - Returns the low price for the session
  • - Returns the low price for the previous session
  • - Returns the Open price for the session
  • - Returns the Open price for the previous session
  • - Returns the Open Interest for the session
  • - Returns the Open Interest for the previous session
  • - Returns the type of permission you have on your subscription from barchart. “Delayed or real-time”
  • - Returns the timestamp of the last quote
  • - Returns the cumulative volume of trade in the session
  • - Returns the cumulative volume of trade in the previous session
  • - this takes no arguments, it simply returns the symbols for whom the Barchart server is ready and pushing the data in your sheets
  • - it unsubscribes a symbol from Barchart server so the server will stop sending data to your sheet

To use these functions simply type them in Excel cells with the symbol and the data will keep refreshing automatically as soon as a new quote is available from the exchanges.