Real Time functions with MarketXLS using Barchart.com’s data Subcription

Discussion in 'Formulae' started by marketxls, Apr 10, 2017.

Real Time functions with MarketXLS using Barchart.com’s data Subcription

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    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.

    052516_1409_UsingRealTi1[1].png

    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.

    052516_1409_UsingRealTi2[1].png

    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.
     
    #1 marketxls, Apr 10, 2017
    Last edited: Apr 10, 2017
  2. Chris

    Chris New Member

    Joined:
    Jul 20, 2017
    Messages:
    2
    Likes Received:
    0
    Hi.

    How much is the paid subscription from Barchart?
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    Hi Chris,

    It's 55 a month for 100 streaming symbols + the exchange fee. We are working to add more integrations.

    Kind regards
     
  4. Chris

    Chris New Member

    Joined:
    Jul 20, 2017
    Messages:
    2
    Likes Received:
    0
    Thank you very much!

    How much is the exchange fee?
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    Just wanted to let you know that barchart has reduced their prices for MarketXLS. The new pricing is already reflected in pricing page (its now $39 for 100 symbols) . Just wanted to highlight here that Barchart subscription is an Optional Addon in case you want very low latency data, otherwise, the data is bundled in MarketXLS.
     

Share This Page