Need to use query function for Live FUTURES price in Excel

Hello, So Im new to this API world & have a very basic requirement of getting live data in excel for Nifty & Banknifty Futures (3months) in Excel file. (Using Query function or anything else)
Im currently using NSE website API for getting this data but its not consistent & need something more reliable.
  • rajista
    you can use a RTD function that will retrieve data from an RTD server for use in the workbook.
  • pratiks
    As you only need data for 6 contracts
    Subscribe to them using pi software
    Use link to excel feature to import the data in excel
Sign In or Register to comment.