Real-time Indian Stock Quotes in Excel/Sheets

Job ID: 38384547

Budget: ₹600 – ₹1,500 INR

I'm in need of an Excel/Google Sheet that can source real-time stock quotes and promoter percentages from Kotak securities API

- The sheet should provide accurate and up-to-date information, including real-time stock quotes and promoter %.
- It should also include other relevant stock metrics such as Market Capitalization (M.Cap), Returns (1D, 1W, 1M...10Y), Daily volumes, RSI, and dividend.
- The API chosen to source the real-time stock quotes and promoter % should be reliable and deliver results quickly.
- For example, I must be able to use a formula like =getquote("ticker") and the latest price should appear and must refresh automatically

Ideal Skills and Experience:
- Proficiency in Excel/Google Sheets
- Experience in integrating APIs with spreadsheets
- Familiarity with stock market APIs (e.g., Alpha Vantage, Intrinio, Yahoo Finance)
- Previous work involving stock market data would be a plus
- Ability to deliver the project as soon as possible.