
Closed
Posted
Paid on delivery
I need a brand-new Google Sheet that streams real-time information from the NSE. The sheet must pull both stock prices and indices data and refresh itself every minute without manual intervention. I am open to the technical route you prefer—Apps Script, an authorised API connection, or another reliable method—as long as the update frequency is consistent and the sheet stays within Google’s execution limits. Please set up any triggers, helper tables, or API keys required and leave clear inline comments so I can adjust the ticker list later on. Acceptance criteria • A fresh Google Sheet delivered in my Drive • Live stock-price and indices columns updating every 60 seconds during market hours • No #N/A or #REF errors after one full trading day of testing • A short note inside the sheet (or a separate doc) explaining how to add or remove symbols and restart the trigger if needed If you have implemented similar live feeds for NSE before, let me know—it will speed up our go-live.
Project ID: 40628021
45 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
45 freelancers are bidding on average ₹7,537 INR for this job

Having been in the data analytics and science field for over eight years, I have deep expertise in transforming complex data sets into actionable business insights. I specialize not only in leveraging tools like PowerBI, Looker, Python, and SQL to clean, analyze and present data but also in crafting standout data stories that drive results. My experience with similar projects mean I'm well-versed with APIs like the one needed for sourcing real-time NSE data for your Google Sheet. Additionally, my proficiency in JavaScript, PHP, and API Integration beyond the scope of this project ensures I am fully equipped to navigate any challenges that might arise during execution. This leads me to another added advantage - as much as a professionally crafted Sheet is central to your objective - I bring along a range of complementary skill sets such as machine learning & data science, ETL & Data Engineering among others. As a result of this inclusive knowledge base, you'll get more than just a seamlessly functioning NSE data sheet; you'll benefit from enhanced insights and futureproofing capabilities. Over my career, I have worked across varying industries including finance, healthcare, e-commerce and SaaS - designing solutions that optimized performance, analyzed trends and predicted future outcomes. Supporting advancements in your organization through powerful integration of technology-driven data solutions is my forte.
₹10,000 INR in 4 days
6.6
6.6

Hi, I can build a Google Sheet that streams live NSE stock prices and indices, refreshing every minute during market hours using Google Apps Script with a reliable API integration while staying within Google's execution limits. The solution will include automated triggers, clean and well-commented scripts, easy symbol management, and documentation for adding/removing tickers or restarting the trigger. I'll ensure the sheet is stable, error-free, and easy to maintain. I focus on reliable, scalable solutions and clear communication throughout the project. Looking forward to discussing your requirements.
₹15,000 INR in 7 days
6.0
6.0

Hey, I can create a Google Sheet that fetches live NSE stock prices and index data with automatic 60-second refreshes during market hours using Google Apps Script and a reliable data source/API. The solution will include configurable ticker lists, automated triggers, clean helper functions, error handling to avoid #N/A or #REF issues, and well-commented code so you can easily add or remove symbols in the future. I'll deliver the completed Google Sheet in your Drive, configure all required triggers and integrations, test it thoroughly for stability during trading hours, and include a simple setup guide explaining how to manage symbols, API settings (if applicable), and restart the automation whenever needed. Best Regards, Mahad
₹2,000 INR in 3 days
5.2
5.2

With my 9+ years in web and mobile development, I have successfully built multiple data streaming solutions, including real-time feeds for exchange markets using JavaScript and PHP. I will establish a Google Sheet for you that will reliably update every 60 seconds during market hours with minimal fuss. We can employ either Apps Script or an authorized API connection based on your preference, guaranteeing reliable refresh and execution rates that adhere to Google's limits. To prevent #N/A or #REF errors entirely, I'll create comprehensive trigger systems and helper tables and provide clear inline comments for easy management. Furthermore, I will include a short note in the sheet or separate documentation that explains how to effortlessly manage the ticker list, add or remove symbols, and restart triggers if needed, ensuring a seamless user experience for you. Finally, to alleviate any concerns about ongoing support after project completion: our team offers free three months support to ensure any bumps encountered during real-time testing are smoothed out in no time. This is backed by our exemplary reviews and reputation for providing good quality work to our clients. So, let's join hands now to turn your vision of a real-time NSE data sheet into a satisfying reality!
₹17,000 INR in 7 days
5.4
5.4

Hello, I can build a Google Sheets solution that pulls real-time NSE stock and index data and automatically updates every 60 seconds during market hours. I have experience with Google Sheets automation, Apps Script, Python, REST APIs, and financial market-data integrations. I’ll set up the required API connection, triggers, helper logic, and a configurable ticker list so you can easily add or remove symbols later. The solution will include error handling, retry logic, timestamp tracking, and protection against common #N/A / #REF! issues. I’ll also test it through a complete market session and provide clear instructions for maintaining or restarting the automation. If the API approach is more reliable than direct NSE scraping, I’ll use an authorized/reliable market-data API rather than depending on fragile website scraping. One question before starting: Do you already have an NSE-authorized/third-party market-data API subscription, or should I recommend a suitable API that supports the required stock and index data? I’m ready to start immediately and deliver a clean, maintainable Google Sheet with automatic 60-second updates and full setup documentation.
₹10,000 INR in 7 days
5.2
5.2

Hi, I hope you're doing well. I have carefully reviewed your project, Real-Time NSE Data Sheet , and I'm confident I can deliver a high quality solution tailored to your requirements. I'm a Full Stack Developer with 7+ years of experience building websites, SaaS platforms, AI powered applications, automation tools, web scrapers, lead generation systems, and custom software. I focus on delivering reliable, high quality solutions that meet business objectives while maintaining accuracy, performance, and scalability. I'd be happy to discuss your project in more detail and recommend the best approach before we get started. I look forward to working with you. Best regards, Abdul Salam Full Stack Developer | Technical Fixes | AI Automation | Lead Generation & Extraction Expert | Websites Dev
₹3,000 INR in 7 days
4.7
4.7

Hi, how are you doing? I have considerable experience building real-time data sheets and automated updates, including NSE-style feeds and Google Sheets with timed triggers. I’ve set up Apps Script paths and API connections to keep stock and index data refreshing every minute while staying within Google’s limits, with clear inline comments and a simple guide for adding symbols. I can deliver a fresh sheet in your Drive, ready to test during market hours, plus a note on how to restart triggers or adjust symbols. Let me know further if interested.
₹12,500 INR in 5 days
3.9
3.9

A Google Sheet that streams NSE stock and index data on a 60-second refresh, no manual touch, and stays inside Google's execution quotas. The catch most builds hit is that NSE's public endpoints throttle or block scripts without proper headers/cookies, and Apps Script has a 6-minute execution cap plus a daily trigger quota — so the architecture has to respect both. My approach: Apps Script pulling from a stable data source (NSE's official endpoints with proper session handling, or a mirror like Yahoo Finance / NSEpy for reliability), a time-driven trigger firing every minute during market hours only (9:15–15:30 IST) so we don't waste quota on nights and weekends, and results written to named ranges so your formulas downstream never break. Structure: one config sheet where you edit the ticker list (add/remove symbols in a single column), one live data sheet the script writes to, and a small log sheet for trigger runs so if something breaks you can see the last successful pull. Inline comments through the script explain every function and the exact line to change if NSE modifies their endpoint later.
₹10,000 INR in 4 days
3.9
3.9

Hi, for a reliable 60-second refresh without hitting Google's execution limits, I'd use Apps Script with a time-driven trigger calling an NSE-compatible data source (via a free API like Yahoo Finance/NSE unofficial endpoints, or a paid feed if you want guaranteed uptime), writing into a helper sheet and referencing it from your display tabs. That split avoids #N/A flicker on the visible sheet while the fetch runs. To hit your "no #N/A after a full trading day" criterion, I'd add basic retry/error handling in the script so a single failed fetch doesn't blank a cell, plus a status cell showing last successful update time so you can spot issues fast. Quick question: do you have a specific data source in mind (paid NSE API, or is a delayed/unofficial free feed acceptable), and roughly how many tickers on the list? That affects refresh reliability and script structure.
₹5,500 INR in 7 days
4.0
4.0

I can deliver a Google Sheet that pulls live NSE stock and index data every 60 seconds with a stable refresh flow and without manual interaction. The main concern in this type of setup is avoiding Apps Script execution limits and intermittent API failures that usually cause #N/A or stale data after several hours of runtime, so the implementation needs proper caching, retry handling, and controlled refresh scheduling. My approach would be: - Create a clean Google Sheet structure with configurable ticker lists - Use Apps Script connected to a reliable NSE-compatible data source or authorized API - Implement time-based triggers for automatic refresh during market hours - Add validation and fallback handling to prevent broken references and failed updates - Leave inline comments and a short maintenance guide so symbols can be added or removed easily The solution will be designed to remain lightweight and stable for continuous operation across a full trading session. I can also structure the helper tables and script in a way that keeps future expansion simple if you later want alerts, historical snapshots, or additional indicators. Estimated delivery includes setup, testing, and validation of the refresh cycle before handoff.
₹12,108.53 INR in 3 days
3.8
3.8

Hello, I can build a brand-new Google Sheet with a live NSE data feed that automatically updates stock prices and index values every minute while keeping the solution reliable and easy to maintain. What I’ll deliver * A new Google Sheet created and shared with you * Real-time NSE stock and index data * Automatic refresh every 60 seconds during market hours * Clean, well-documented Apps Script code with inline comments * Configurable symbol list so you can easily add or remove tickers * Setup of triggers and any required helper sheets or configuration * A short user guide explaining: * How to add or remove symbols * How to restart or modify the trigger * Basic troubleshooting steps The implementation will be designed to minimize execution time, handle API errors gracefully, and avoid common issues such as #N/A and #REF! errors. My experience I have experience building automation solutions using Google Apps Script, Python, APIs, and spreadsheet integrations, including real-time data pipelines, dashboards, and automated reporting systems. This allows me to deliver a solution that is both robust and easy to maintain. I can start immediately and will ensure the final solution is fully tested before handover. I look forward to discussing your preferred data source and getting your live dashboard up and running. Best regards, Soumalya Bhaduri
₹9,000 INR in 7 days
3.5
3.5

Readymade setups Completed projects till now 1) Python + DhanAPI +Excel + VBA option scalping strategy 2) Python 21 EMA and 9 EMA crossover strategy on DhanAPI 3) Google sheet + FyersAPI trading 4) Google sheet + Algomojo + Upstox 5) Tradetron Banknifty option scalping strategy 6) Excel 2600 NSE 10 years data 7) Copytrading using python 8) Tradetron Supertrend + MACD Crossover Strategy 9) Dhan option chain with Greeks in Google spreadsheet via Google Appscript 10) Backtesting of Nifty options for wait and trade strategy 11) Trigger orders for Dhan Nifty options 12) Shoonya API:- Wait and trade strategy 13) Tradetron: RSI + ADX + EMA strategy 14) Python Moving avarage channel trading Algo 15) Kotak Neo: Turtle scalping strategy for options 16) Fyers Filtered option chain in Excel 17) Binance Bitcoin tradingview strategy python bot 18) Fyers Tradingview python bot 19) Dhan Python order manager I can deliver any project in Trading. Readymade setups for Python available
₹7,000 INR in 7 days
3.3
3.3

The main challenge here is not creating the Google Sheet itself, but building a reliable data pipeline that can refresh consistently during market hours while handling API limits, missing values, and NSE data changes. I can set up a Google Sheets solution using Apps Script with an appropriate market data source/API integration, including scheduled triggers, symbol management, and structured helper tables where needed. The sheet would automatically update stock prices and index values at the required interval, with error handling to prevent broken formulas or incomplete data from affecting the output. I’d also organize the sheet so adding or removing tickers is simple, and include clear notes explaining the setup, trigger management, and any API configuration required for future maintenance. Before implementation, I’d like to confirm which NSE symbols and indices you need initially and whether you already have access to a preferred authorised data provider/API, or if you need recommendations for the data source as well.
₹25,000 INR in 5 days
3.1
3.1

Hi, At first glance, this looks straightforward but there’s usually one part that causes issues later. I’ve handled similar work before and can help you avoid that. Regards, Rajesh
₹7,000 INR in 7 days
2.4
2.4

Hello, As an experienced Senior Full Stack Developer and Project Manager, I bring over a decade of expertise in several of the key areas this project requires. My proficiencies in API Integration, Google Sheets, JavaScript, PHP, and Scripting align perfectly with your project. I'm no stranger to building applications that heavily depend on pulling data and automation as well as delivering clean, maintainable code. Having worked extensively with REST API and API connections in the past, like integrating OpenAI API, I am confident in my ability to set up an authorised API connection that will guarantee real-time streaming of stock prices and indices without a hitch. I know how frustrating #N/A or #REF errors can be for data-dependent projects like this one, which is why I am committed to ensuring your Google Sheet remains error-free even after intensive use. Moreover, my experience working on trading-related applications means I can customise your sheet with any number of symbols you need to track without a hitch. The comprehensive note explaining how to modify this feature will keep your task simple and straightforward from the get-go. By choosing me for this project, you can be assured of timely delivery, clear communication along every step, and a quality output that's built for durability and scalability. Let's discuss your specific needs and get started on making your NSE Data Sheet vision come true! Thanks!
₹8,160 INR in 6 days
2.6
2.6

Being a computer science graduate and a PhD holder in Artificial Intelligence, I possess the right skill set and experience to deliver upon your real-time NSE data sheet project. With almost two decades of professional experience in academia, software engineering, and technology leadership, my expertise is quite broad. I have worked on several projects to construct AI-driven solutions, build customized SaaS applications, implement API integrations, develop responsive web and mobile applications, and deploy systems for efficient database management – just to name a few overlapping skills with this project. Specifically, I have deep knowledge integrating various APIs with Google Sheets, such as stock data from Alpha Vantage API. Understanding the intricacies of how the NSE works will enable me to set up available triggers and help tables efficiently for a smooth user experience. I can assure you that my implementation will not exceed Google's execution limits while maintaining a consistent update frequency every 60 seconds during market hours. Finally, I understand the importance of detailed documentation and would provide you with clear inline comments inside the sheet or a separate document explaining how to add or remove symbols, restart the trigger if needed, and minimize any possible errors like #N/A or #REF after an entire trading day testing. Don't hesitate to inquire further about my competency in these kinds of live feed projects—let's ensure we go live quickly!
₹1,500 INR in 7 days
2.5
2.5

When pulling NSE data every 60 seconds the API often returns a temporary 429 error if too many symbols are requested at once. I'll batch the ticker list into one request, parse the JSON, and write the values to the sheet, keeping the script under the 30-second limit. A time-driven trigger will fire each minute and include a small retry so the sheet never shows #N/A. A common mistake is relying on the built-in =GOOGLEFINANCE function, which stops updating after a few hours and hits quota limits. Instead I’ll use Apps Script fetch with the NSE API key, write the data to hidden helper rows, and reference those cells in your columns. I'm ready to start right away and will leave clear comments so you can tweak the symbol list or restart the trigger yourself.
₹7,000 INR in 4 days
0.0
0.0

For your brand-new Google Sheet needing real-time NSE stock prices and indices, updated every 60 seconds without manual intervention, I can build exactly that. I will deliver a fresh Google Sheet directly in your Drive, pulling live stock prices and indices that refresh every minute. This includes setting up the necessary API connections, triggers, and helper tables to ensure consistent updates within Google’s execution limits, with no #N/A or #REF errors after testing. I’ll also provide clear inline comments and a short note explaining how to easily adjust ticker symbols and restart triggers if needed for that zeeodha or any other broker API is needed. I've previously built automation solutions integrating external data into Google Sheets, such as an AI agent for lead research and enrichment. Beyond stock prices and indices, are there specific market segments or derivatives you might want to track in the future? Let's discuss how this setup can best serve your needs.
₹9,000 INR in 5 days
0.0
0.0

Hello, I'm bharghav, with 10 years of experience in Software Architecture, specializing in JavaScript and PHP solutions. My expertise lies in designing robust systems that integrate seamlessly with various platforms. I understand you need a real-time Google Sheet for NSE stock prices and indices, updating every minute. I will leverage JavaScript (Google Apps Script) to establish a reliable connection, ensuring consistent updates without manual intervention. I’ll implement necessary triggers, helper tables, and API keys, providing clear inline comments for easy ticker list adjustments. Please initiate a chat so we can discuss the specifics and get this project started. Best regards,
₹8,750 INR in 3 days
0.1
0.1

“Live stock-price and indices columns updating every 60 seconds during market hours” is the key part I’ll design around, so the Sheet refreshes reliably without hitting Google execution limits. I’d set this up as a fresh Google Sheet using Apps Script with either an authorised NSE-compatible API or another stable market-data endpoint, plus trigger control, helper tables, error handling, and inline comments for managing tickers. I’ve set up an n8n workflow that processes 5k+ submissions/day with rule-based routing and alerts, so I’m comfortable building automations that run cleanly at scale without manual intervention. One question: do you already have a preferred NSE data/API source, or should I recommend the most reliable option based on your symbol and indices list? If you share the tickers/indices you need, I can confirm the route, create the milestone, and start immediately.
₹10,173.89 INR in 3 days
0.0
0.0

Mumbai, India
Member since Aug 5, 2026
€12-18 EUR / hour
$250-750 USD
$250-750 USD
₹1500-12500 INR
₹100-400 INR / hour
$30-70 USD
₹12500-37500 INR
₹75000-150000 INR
₹750-1250 INR / hour
$30-250 USD
$30-250 USD
$30-250 AUD
£18-36 GBP / hour
$250-750 USD
£250-750 GBP
$10-30 USD
€12-18 EUR / hour
$30-250 USD
₹1000-1001 INR / hour
$20-35 USD