Nifty50 Minute OHLC Data -- 2

@axiomswb

Populating your Nifty 50 1-minute OHLC template, gap-free from 1 January 2020 through today's close, sourced exclusively from Zerodha's Kite historical API. Here is exactly how I will execute this: Kite Connect pulls 1-minute candles in batches capped at 60 days per request — I will loop these programmatically so no silent mid-range drop silently skips intervals between batches. Every fetched candle gets cross-referenced against your supplied timestamp list before anything touches the workbook. Missing rows get re-fetched, not left blank for you to discover during verification. All timestamps are locked to IST (UTC+5:30) at write time using pytz, eliminating the offset errors you listed as a verification criterion. One problem you may not have considered: Zerodha's API returns no candle for market holidays and pre-open periods — your template likely contains those timestamps. I will strip them automatically against NSE's official holiday calendar so your gap-detection check does not flag legitimate missing rows as errors. I will write only the four price columns into your exact .xlsx template using openpyxl — no reformatting, no extra columns — and deliver within 1 day for 6300 INR. Does your Zerodha account already have an active Kite Connect API subscription, or will you be providing credentials another way?

@ashinnd84

Hi, Your project "Nifty50 Minute OHLC Data -- 2" is a good fit -- Python backend and automation work is my main line of work. How I would run it: 1. Confirm the inputs, outputs and edge cases in writing first, so there is no ambiguity about what the script or service has to handle. 2. Build it in small reviewable pieces with tests around the parts that touch real data, rather than one large drop at the end. 3. Deliver clean, documented code with a requirements file and setup notes, so you or another developer can run and extend it without me. Matching your listed skills: API, Data Analysis, Data Collection, Data Management, Data Processing, Excel, PHP, Python, Visual Basic. My bid is ₹10625, within your ₹1500-12500 range. Let's connect to discuss this further -- happy to walk you through how I would structure it and answer anything you want covered first. Thanks for your time. Best regards, Ashish & Team

@ASSAMWEB

Greetings, I have reviewed your project description and recently worked on a similar project. I believe I can help you deliver this successfully. Let’s open a chat to discuss your requirements in detail and determine the best approach for your project. Regards

@mahads31

With my background in Web, Mobile, and SaaS Development as well as extensive knowledge of API and Data Management, I am well-equipped to create a robust, gap-free OHLC dataset for your Nifty 50 Index on Zerodha. My proficiency in PHP, Python, and automated data handling (n8n) will ensure swift and accurate extraction of the required Open, High, Low, Close values exclusively from the Kite Historical API ensuring it matches your predefined template, without any errors. Not only do I value clean programming and systematic organization but I always shoot for long-term reliability and growth - just what you're looking for! Having worked on similar financial datasets in the past, I've honed my skills at identifying missing intervals, correcting time zones (IST), and detecting outliers. Your final workbook will be meticulously validated before being returned to you in (.xlsx) format ready-to-use. By choosing me for this project not only will you get an accomplished developer who's adept at handling complex requirements but also a dedicated professional who genuinely believes in building long-lasting client relationships. I look forward to leveraging my expertise to deliver exceptional value that fuels your business growth. Thank you for considering me!

@prashanpatel557

Hello, I can prepare the complete 1-minute Nifty 50 OHLC dataset from Zerodha and populate your existing Excel template with Open, High, Low, and Close values while preserving the required workbook structure. I specialise in Python financial-data automation, Zerodha Kite API integration, Pandas, Excel processing, and trading-data validation. I’ll retrieve the historical data in API-safe batches, correctly handle IST timestamps, map every candle to your supplied timestamps, and validate the final dataset for missing intervals, duplicates, timezone issues, and obvious price anomalies. I’ll use Zerodha only, as requested, and will not substitute another market-data provider. The final deliverable will be the completed .xlsx workbook ready for immediate use. Estimated delivery: 3–5 working days. Before starting, please confirm: Do you already have active Zerodha Kite Connect historical-data API access, and can you share the Excel template so I can verify the timestamp structure and estimate the extraction volume? I’m ready to start with the template and API/data-access verification.

@Algokage

Hello, I hope you're doing well. I am an experienced data analyst with a strong background in financial markets and data manipulation. I have worked extensively with Zerodha's Kite historical API and am well-versed in creating clean, gap-free OHLC datasets. I understand the importance of accurate and reliable data, especially in the financial sector, and I am confident in my ability to deliver a high-quality dataset that meets your specific requirements. I will ensure that the final delivery is a well-documented Excel workbook, ready for immediate use. I am available to discuss the project further and can provide relevant samples or a quick demo if needed. Thanks, Adegoke M.

@alluankit01

Hi, I can populate your Excel template with clean 1-minute OHLC data for the Nifty 50 index from 1 January 2020 to the latest available trading day, using Zerodha-backed data only. The best solution is to first review your timestamp template, confirm IST formatting, and connect to Zerodha Kite historical API or the approved Zerodha-backed source. Then I’ll fetch the OHLC candles, map Open, High, Low, and Close values against each required timestamp, and run checks for missing intervals, duplicate rows, timezone issues, and obvious price outliers. I’m comfortable with Python, Zerodha Kite API, historical market data extraction, Excel automation, OHLC data cleaning, timestamp matching, gap detection, and financial dataset preparation. Deliverables will include: * Completed Excel workbook * Nifty 50 1-minute OHLC data * Open, High, Low, Close columns only * IST timestamp alignment * Gap and duplicate checks * Outlier review * Same template structure preserved * Final .xlsx delivery I’ll focus on accuracy, clean timestamp matching, and a gap-free dataset so the final workbook is ready for immediate analysis and verification. Best regards Ankit

@rohank2502

Gap-free Nifty 1-minute OHLC from 2020 to today, in your exact timestamp template, verified for missing candles before I hand it over. That is a clean data job. Your data has to be complete and correctly stamped or it is useless for analysis, so I treat the gaps and the timezone as the real work. I authenticate to your Zerodha Kite feed, pull the 1-minute OHLC for the full range, and map it straight into your template, OHLC only, IST timestamps aligned. Then I run a gap check across every trading session and flag or fill missing candles per your rule, so you get a continuous series, not a file with holes. Delivered as a verified .xlsx with a short note on any gaps found and how they were handled. Send me your template and Kite access and I return a verified sample month first. Which years matter most, and how do you want gaps handled, skipped or forward-filled?

@shaun4014

I've recently helped a client achieve a clean and efficient data retrieval process for financial datasets, ensuring accuracy and reliability throughout. I will help you achieve your goal of obtaining a gap-free OHLC dataset for the Nifty 50 index, providing a seamless and professional experience in delivering the required data. I understand that you need the data sourced exclusively from Zerodha, with a focus on the four essential price columns, ensuring everything is integrated smoothly into your provided Excel template. With extensive experience in data collection and analysis, I have the skills to deliver a modern and responsive dataset tailored to your specifications. My services include data verification to guarantee accuracy and adherence to your requirements. I can get started quickly and would be happy to discuss the project further. Regards, Shaun Kelly.

@ZohaibSathio

Hi, saw your post about filling a Nifty 50 one minute OHLC sheet from January 2020 to the current session, Zerodha only. The real work is the gaps: holidays, halts and short sessions. How I would run it: pull in sixty day windows through the Kite historical API, stamp to IST, then reconcile against your template so every timestamp gets a value or a flagged reason. Do you have an active Kite Connect subscription I can use? Are expiry day sessions included? I write Python data pulls like this often. On Freelancer I delivered a parser that pulled structured fields out of messy text into a REST API, paid same day. Happy to start with 2020 alone so you can check the file. Regards, Zohaib

@CliveMSoftware

I'll pull 1-minute OHLC data for Nifty50 from Zerodha's Kite API covering January 1, 2020 to today, then map each candle to your pre-formatted Excel template with zero gaps and proper IST timestamps. I'll validate the dataset for missing intervals and obvious outliers before delivery, ensuring the file is clean and ready to use immediately. Fast turnaround with verification included.

@JohanEngelb

THE ACCURACY OF YOUR DATA IS CRUCIAL I would love to help with your OHLC data needs. With experience in data extraction from Zerodha's API, I can ensure a clean and precise dataset. Could you clarify if you have a specific deadline for this project? Also, do you have any preferences for how to handle potential outliers? The worst-case scenario is a quick chat to ensure we're aligned on your requirements. Regards, Johan Engelb

@LibraWS

Hi there, I'll populate your Excel template with clean, gap-free Nifty 50 minute OHLC data from January 1, 2020 through today using Zerodha's Kite historical API as your source. I'll deliver the completed .xlsx file with Open, High, Low, and Close columns accurately filled against every required timestamp in IST. My approach: I'll pull data directly from Zerodha, validate for missing intervals and timezone consistency, then cross-check for outliers before handover. Since I'm building my reputation on this platform, I'm offering milestone-based payment—you only release funds once you've verified the file meets your standards. This removes your risk entirely. I'm based in Zadar, Croatia and can turn this around quickly. If anything needs adjustment after delivery, I'll revise it at no extra cost until you're satisfied. Ready to get started.

@tinyopsezr

Hello, TinyOps Studio can populate your supplied template from buyer-authorized Zerodha data and return the same .xlsx within two days. I will: - Read the workbook's exact timestamp grid. - Retrieve Nifty 50 one-minute OHLC from 1 January 2020 through the current completed trading day using the approved Zerodha source. - Map only Open, High, Low, and Close in IST while preserving the workbook layout and formulas. - Check for missing or duplicate intervals, OHLC inconsistencies, timezone drift, and obvious outliers. - Include a short validation summary with the completed workbook. One point to confirm at award: the Zerodha access provided must permit the full requested historical window. With that access available, I can complete the fixed scope for 6,500 INR with a 50% milestone.

@davrondiyorov

Happy to pull January 2020 first and send it to you free, before you decide anything, so you can check it against your own terminal rather than take my word for it. The part that decides this job isn't pulling the candles, it's making the file line up with your template exactly. Your sheet lists every timestamp, and a 1-minute series going back to January 2020 will contain rows the market never produced: exchange holidays, the odd halt. I'd populate everything that genuinely exists and hand you a short note listing every timestamp that stayed empty and why, so a real gap is distinguishable from a day the market was closed. One thing to settle first: Kite historical data comes out of your own Zerodha account, so I'd need the API key with the historical add-on active, or a session you set up. After that it's mechanical: 60-day windows, roughly forty calls, rate limited and retried, every timestamp kept in IST. You'd get your workbook back, the same series as a CSV, and the pull script with a short README. I'll send a one-page note covering scope and payment before we start. Rs 5,500, three days from the point I have access. Davron

@nanisem

I recently helped a client take their initial idea and turn it into a refined, high-quality digital experience that felt modern, intuitive, and ready to present to real users. I can help you bring your vision to life with a clean, user-friendly solution that not only looks professional but also works smoothly and supports your overall goals. I understand you're looking for something that feels clean, professional, and seamless, with a strong focus on usability and a well-integrated experience that flows naturally. I specialize in creating modern interfaces, strong visual designs, and engaging user experiences that are both functional and visually appealing. You can check out my similar project: Culture City Web Application - [Link]. I am very interested in chatting with you about your project by helping you build your business and achieve your goals. The only thing you will lose is some time on a free consultation. Kind Regards, Nanise Mostert

@VutomiM1

We recently helped a business achieve a similar goal, and the results exceeded their expectations. I'd love to help you do the same. I'll build a solution that's reliable, professional, and designed to help your business grow. Your project stood out because you're focused on creating a clean, professional, user-friendly solution, and that's exactly the kind of work I enjoy. We have 75+ 5-star reviews on similar projects and rank in the top 1% among 75 million users! I will utilize the Zerodha Kite historical API to ensure you receive a gap-free OHLC dataset for the Nifty 50 index, formatted precisely as you need it. I'd be happy to share a few ideas for your project and answer any questions you have. Regards, VutomiM1

@Datdek2

Hi, filling a gap-free 1-minute OHLC series for the Nifty 50 across 6+ years is exactly the kind of data-engineering task I do daily — the hard part isn't the download, it's making sure no interval is missing and the timestamps are IST-correct. My process: 1. Rebuild the full expected timestamp list from your template and cross-check it against NSE trading sessions (lunch break, half-days, holidays) to find every gap 2. Pull data through Zerodha's Kite historical API (authenticated, rate-limited so we don't hit blocks) into the exact template you provided 3. Populate Open / High / Low / Close per row and auto-flag any interval with missing or outlying prices for your review 4. Deliver the .xlsx back in your original structure, ready to use — no extra fields I can show you a verified sample batch (e.g. Jan–Jun 2020) within the first day so you can confirm the format before I complete the full series. Questions: - Will you provide a Zerodha Kite API key and access token, or should I use my own Zerodha account? - Is the template already limited to trading hours only, or do I handle session/holiday filtering myself? - Need just the NIFTY 50 index, or individual constituents too? Milestone suggestion: 50% on a sample batch verified, 50% on final delivery.

@adrianldata

Pulling 4+ years of 1-minute OHLC data creates a massive dataset. Attempting to align this manually in Excel to ensure there are zero gaps is inefficient and prone to misalignment errors. I am a Data Engineer. I build automated data extraction and cleaning pipelines using Python and vectorization libraries like Pandas and Polars. My Execution Plan: Programmatic Extraction: I will write a Python script to pull the precise historical tick data for the Nifty 50 from a reliable financial API (like yfinance or NSE). Algorithmic Alignment: The script will cross-reference the extracted data against your specific timestamp template. Gap Resolution: I will use programmatic logic (forward-filling or interpolation, depending on your strict requirements) to ensure any missing minutes due to trading halts or API drops are handled perfectly without throwing off the timeline. Send me the Excel template and I will run the extraction and alignment script. Best regards