Please suggest a relevant data vendor for below requirement:
Need one minute update Data to Excel for NSE Stocks and futures. Data should not be live updating every tick or second.
The Excel should just update every one minute with the closing prices of the minute.
Thank you.
These days many brokers like Finvasia, fyers, dhan have APIs that provide data APIs and current-minute candle.
Running the APIs and receiving JSON then you can extract the data.
But you or someone familiar with excel VBA can do it quite easily. Most free brokers have API calling limit but it should usually work.
Z API is the best bcos you can fetch hundreds of quotes one shot but they are not free, else it will also serve your purpose.
Also, FYERS has new app Next, maybe kotak etc have NSET or something similar that gives app to excel data like in the old days of Z NEST called "Link to excel"