how to display the live prices in google spread sheet using kiteconnect api

 To display live prices in a Google Spreadsheet using the KiteConnect API, you will need to perform the following steps:


Create a new spreadsheet in Google Sheets and name it as you wish.

Go to the KiteConnect developer website and create an account. You will need to provide your personal and professional details, and also generate an API key.

Once you have created an account, you can use the API key to access the KiteConnect API.

Use the =IMPORTDATA() function in Google Sheets to import the live prices into your spreadsheet. The function takes the URL of the API endpoint as an argument.

For example, if you want to import the live prices of Nifty 50 index, the formula would be:
=IMPORTDATA("https://api.kite.trade/instruments/Nifty 50")

You can also use the =IMPORTJSON() function to import data in JSON format.

Once the data is imported, you can use various functions in Google Sheets to analyze and display the data as you wish.

To refresh the data you can use the =IMPORTDATA() function with the same URL again.

Please be aware that the KiteConnect API requires a subscription, and you need to check the usage limits and fees of your plan, and also the usage of the API is subject to the terms and conditions of the provider.

here are more detailed steps on how to display live prices in a Google Spreadsheet using the KiteConnect API:

Create a new spreadsheet in Google Sheets and name it as you wish. You can also create a new sheet within an existing spreadsheet if you prefer.

Go to the KiteConnect developer website and create an account. You will need to provide your personal and professional details, and also generate an API key. The API key will be used to authenticate your requests to the API.

Once you have created an account, you can use the API key to access the KiteConnect API. You can use the API to retrieve a variety of market data such as stock prices, index data, and historical data. You will need to refer to the KiteConnect API documentation to understand the available endpoints and data fields.

Use the =IMPORTDATA() function in Google Sheets to import the live prices into your spreadsheet. The function takes the URL of the API endpoint as an argument. You can use the endpoint that return the live prices of the stocks or index you need.

For example, if you want to import the live prices of Nifty 50 index, the formula would be:
=IMPORTDATA("https://api.kite.trade/instruments/Nifty 50")

You can also use the =IMPORTJSON() function to import data in JSON format, this function allows to import and parse JSON data from a web service.

Once the data is imported, you can use various functions in Google Sheets to analyze and display the data as you wish. you can use functions like =AVERAGE(), =MAX(), =MIN(), =COUNT(), =SUM(), etc to analyze the data.

To refresh the data you can use the =IMPORTDATA() function with the same URL again. You can also use the =IMPORTJSON() function with the same URL to refresh the data.

You can also use the =QUERY() function to filter and sort the data, and also you can use the =VLOOKUP() function to look up the values from other sheets.

To set the data to be automatically refreshed, you can go to the "Data" menu, and then click on the "Refresh" option and select "Refresh every" and set the refresh time.

Remember to check the usage limits and fees of your plan, and also the usage of the API is subject to the terms and conditions of the provider.

Comments

Post a Comment

Popular posts from this blog

Osmania university PGECET counselling 2011 schedule

Image
PGECET 2011 Web Counseling for admission to M.Tech, M.Pharmacy and Pharma.D Courses for the year 2011-12 will be conducted from 9th November 2011. Detailed information of certificate verification, exercise of web options, seats allotment, download of allotment order and fee details will be released by the APSCHE of Osmania University. Admission to M.E./ M.Tech./M.Pharm./ M.Arch./ M.Planning./ Pharm.D courses in Andhra Pradesh will be done based on the ranks in PGECET 2011-12. Candidates have to exercise web options through http://pgecet.apsche.ac.in PGEC/PGECET 2013-Final Phase Counseling Schedule:-- --> Candidates who got their certificates already verified need not appear. Certificates to be produced, list of Help Line Centers,processing fee and fee particulars, instructions to exercise options and vacancies in various colleges are available on the web site http://pgecet.apsche.ac.in Web options: All the eligible Candidates (including those appeared in
Read more

I Registered TGMC 2010

Image
Hello friends in this post i want to share my experience of the great mind challenge 2010 which was organised by the IBM . This contest is all about the project development. It is very helpful for engineering students.i am studying B.Tech final year,as i have to submit the academic project, i will submit the same project which i will develop in TGMC.. Its very strang thing that the same project for academic and also for the contest.  I suggest you too go to the IBM's TGMC website and register.you will also get the participation certificate..it worth's more.. .they will also provide you the software , and more materials.. Its free..all you need is good team of members between 2-4 and with a faculty to guide you. All the development and submission process takes place throw online... I will inform you more about this..as i was just get started...!!                                                                                                             yours           
Read more

Ancient indian maps

Image
Ancient indian maps 1760 india map, 1857, 3200BC india map, Ancient indian maps, ancient maps, indus civilization map, map of india, political divisions of British Indian Empire 1909 Imperial Gazetteer of India, world map,     ancient indus civilization map 3200BC Ancient india map the map of dwapara yuga ancient india city places at buddha times ancient india map of 600BC ancient indian map of 500BC LiveJournal Tags: ancient maps,map of india,world map,vintage maps,old maps,old maps of the world,geography maps,ancient history maps,political indian map,ancient india history,american indian maps,antique maps,historical maps,historic maps,ancient history in india,antique map,ancient history map,india ancient history,about ancient india,india is a subcontinent of,subcontinent of india,ancient history india,ashoka the king,maps ancient,india in the british empire,the mauryan dynasty,history ancient india,the ancient india,facts about in
Read more