Stock Tracker: NSE/BSE on Sheets

I need a sophisticated solution to keep track of specific stock market data from both the National Stock Exchange (NSE) and Bombay Stock Exchange (BSE) and display this information within Google Sheets. This data should be updated every 10 seconds, reflecting not just the current prices of stocks but also their trading volume and percentage changes. This project demands precision and reliability, without the use of the native GOOGLEFINANCE function in Google Sheets, which does not meet my requirements for update frequency or detail. **Key Requirements:** - Real-time data fetching from NSE and BSE, updated on a 10-second interval. - Integration with Google Sheets to display stock prices, volumes, and percentage changes. - A custom solution not relying on the GOOGLE FINANCE function due to its limitations. **Ideal Skills and Experience:** - Proficiency in APIs, particularly those relevant to stock market data. - Strong familiarity with Google Sheets, including script writing (Google Apps Script). - Experience in financial markets, specifically the NSE and BSE, to understand the nuances of the data. - Ability to implement a solution that is efficient, given the high frequency of updates required. - Knowledge in handling and displaying real-time data feeds within a cloud-based spreadsheet. The final solution should be seamless, requiring minimal manual intervention to maintain, and must be robust enough to handle the dynamic nature of stock market data.