I would like to use Excel sheet for calculations. Can i get the real time data exported to my excel sheet for this purpose ?
Ideally brokers should not give live data on to any other frontend except the one which is approved from regulators. It is against compliance.
For this purpose one can contact registered data vendors like neotradeanlytics or esignal to get data on to any other third party frontend including excel. Data vendors pay lakhs per annum and get license from exchanges to provide this facility.
Check out the below link to fetch live intraday data in Excel sheet:
Hi,
Kite Connect for Excel that’ll let you analyse and trade from Excel sheets
Refer https://kite.trade/forum/discussion/852/kite-connect-for-excel-3rd-party-library