Real Time functions with MarketXLS 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 MarketXLS menu, Settings/Help, and then click on settings. A form like the one shown below will appear.
Click on “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 is saved and everytime you open marketXLS its there. You can also click on “Test Connection” to test if your subscription is valid of 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 function that use Barchart’ 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 in build function browser like shown below to see all functions which are available.
Below is a quick description of the functions and their purpose.
=rt_Ask(“Symbol”) – Ask Price real time
=rt_AskSize(“Symbol”) – Ask Size real time
=rt_Bid(“Symbol”) – Bid price real time
=rt_BidSize(“Symbol”) – Bid size real time
=rt_Change(“Symbol”) – Returns the change in price from last session
=rt_Close(“Symbol”) – Returns the close price for the session
=rt_Close_Previous_Session(“Symbol”) – Returns the close price for the previous session
=rt_Exchange(“Symbol”) – Returns the exchange name
=rt_High(“Symbol”) – Returns the close price for the session
=rt_High_Previous_Session(“Symbol”) – Returns the high price for the previous session
=rt_Last(“Symbol”) – Returns the last price for the session
=rt_Last_Previous_Session (“Symbol”) – Returns the last price for the previous session.
=rt_Last_Size (“Symbol”) – Returns the last size for the sessio
=rt_Low(“Symbol”) – Returns the low price for the session
=rt_Low_Previous_Session(“Symbol”) – Returns the low price for the previous session
=rt_Open(“Symbol”)– Returns the Open price for the session
=rt_Open_Previous_Session(“Symbol”) – Returns the Open price for the previous session
=rt_Open_Interest(“Symbol”) – Returns the Open Interest for the session
=rt_Open_Interest_Previous_Session(“Symbol”) – Returns the Open Interest for the previous session
=rt_permission(“MSFT”) – Returns the type of permission you have on your subscription from barchart. “Delayed or real time”
=rt_timestamp(“MSFT”) – Returns the time stamp of the last quote
=rt_Volume(“MSFT”) – Returns the cumulative volume of trade in the session
=rt_Volume_Previous_Session(“MSFT”) – Returns the cumulative volume of trade in the previous session
=BarChart_Subscribed_Symbols() – this takes no arguments, it simply returns the symbols for whom the Barchart server is ready and pushing the data in your sheets
=BarChart_UnSubscribe_Symbol (“Symbol”) – it unsubscribes a symbol from Barchart server so the server will stop sending data to your sheet
To use the 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.