
In Progress
Posted
Paid on delivery
I need a comprehensive spreadsheet of historical stock prices from the NYSE and NASDAQ for the last 4 years (2023, 2024, 2025, and year-to-date 2026). Requirements: - Data accuracy and reliability (circa 100 checks on data validity will be done to ensure accuracy) - Organized format for easy analysis - Delivery in Excel or Google Sheets Data Needed: - Data set of companies that have had an IPO during these years. No other companies required. We require their ticker & company name, country of origin - Only trading data for the first 2 weeks after IPO - IPO date, IPO price, opening market price (i.e., for private investors which is different from opening market price) - Open/high/low/close/volume per day for the first two weeks - Sector of company - Industry of company - Market cap of company - Shares outstanding - Shares offered - Float % - Founded year - Number of employees - Lead underwriter - Co-underwriters - Venture backed? (if not possible to obtain ok) - Lock-up expiration date - Gross spread (%) - S&P 500 return that day - Nasdaq return that day - New York Stock Exchange return that day - VIX Ideal Skills: - Experience with financial data collection - Proficiency in spreadsheet software - Attention to detail
Project ID: 40555815
71 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, there! I can build a clean Excel dataset covering NYSE and NASDAQ IPOs from 2023 through YTD 2026, with first two weeks of trading data and company level IPO details. I’ve handled similar financial data collection projects involving IPO datasets, OHLCV prices, index returns, market cap, shares offered, underwriters, lockup dates, and validation checks. I’ll structure the workbook for easy filtering, analysis, and audit review, with source notes where needed so accuracy can be verified. Best regards, George
$140 USD in 7 days
3.6
3.6
71 freelancers are bidding on average $139 USD for this job

Hello Sir, competent freelance with proven unbelievable record is at your service. These are the very same crucial skills your Historical Stock Data Spreadsheet project requires. I have a keen eye for detail, which means I understand the importance of your 100 data checks to ensure accuracy. Furthermore, my familiarity with financial data collection and my comfort with spreadsheet software like Excel and Google Sheets means that you can rely on me to deliver a comprehensive dataset in a format that's not just structured but also user-friendly. I would wait for your reply to discuss further Waiting... Amaan Datahome
$100 USD in 1 day
8.4
8.4

As a seasoned data analyst with a particular focus on financial data, I am well-versed in the detailed requirements of collecting and organizing historical stock data. I have extensive experience using Excel for complex data tasks including web scraping, mining and analysis. My advanced proficiency in these areas ensures that I will not only meet your discerning standards for the accuracy and reliability of your dataset but also deliver it in an organized format that makes for easy analysis. Beyond just providing the stock prices you require, I can go above and beyond to provide you with a holistic understanding of each company's financial history after their IPO. This includes gathering data like sector, industry, market cap, float % and more. Such nuanced analysis rooted in meticulous attention to detail is essential when making informed judgments related to stocks. Lastly, my background in quick implementation will allow me to deliver on time without compromising quality. This is because I believe meeting deadlines is central to any successful project. Therefore, giving me the opportunity would be more than just hiring a freelancer- it would be an investment in accuracy and professionality that will elevate your stock analysis process. Thank you for considering my application and I look forward to discussing this project further!
$140 USD in 1 day
7.7
7.7

Sir, I can help you. I will collect historical data of stock as per your instruction. If need, I will provide initial sample. Honestly I can help you. Thank you so much. I will get notification once you send a message. Thank you.
$200 USD in 7 days
7.1
7.1

As-salamu alaykum! Greetings, esteemed client. Tackling comprehensive data analysis projects is both my passion and expertise, aligning perfectly with your project requirements. Delving into my decade-long experience in data analysis and entry, I have successfully contributed to numerous projects from diverse domains—finance included. This background has afforded me invaluable insight into the complexity of stock market data management, ensuring accuracy and reliability in every single step. Fluency in a range of spreadsheet software including Excel and Google Sheets is another feather in my cap that facilitates logical organization and enhanced extraction capabilities for easier analysis. In fact, I'd visualize the final layout of the spreadsheet as an intuitive interface that practically carries out half the analysis for you. My attention to detail is second nature, clocking in over 100 checks on data validity to meet your
$140 USD in 1 day
7.1
7.1

Hi there, I understand you need a comprehensive and highly accurate dataset of all NYSE and NASDAQ IPOs from 2023 through year-to-date 2026, including IPO details, company fundamentals, market metrics, and the first two weeks of trading data in a well-structured Excel or Google Sheets workbook. I am confident I can compile, validate, and organize this dataset to meet your accuracy requirements and facilitate further financial analysis. My approach would be to collect the data from reliable financial and exchange sources, cross-verify critical fields through multiple references, and organize everything into a standardized spreadsheet with consistent formatting and validation checks. I will compile company information, IPO details, daily trading data, market indices, VIX values, and all available fundamental metrics while ensuring the dataset is complete, well-structured, and easy to analyze. The deliverables will include a fully organized Excel or Google Sheets file containing all requested fields, validated data with consistent formatting, and clear column organization ready for filtering, analysis, and further research. Could you confirm whether market capitalization, shares outstanding, and employee count should reflect values at the IPO date or the most recently available figures where historical values are unavailable? I’m ready to start immediately. Warm Regards, Aneesa.
$100 USD in 1 day
7.1
7.1

AVAILABLE TO START IMMEDIATELY..,,. I will deliver a meticulously organized Excel or Google Sheet spreadsheet containing all specified historical IPO data points for NYSE/NASDAQ companies from 2023-2026 YTD, ensuring data accuracy and easy analysis via Python-assisted collection and validation. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$51 USD in 1 day
6.6
6.6

Hello, I have experience collecting, validating, and organizing large financial datasets in Excel and Google Sheets. I can compile a structured, accuracy-focused dataset covering IPOs on the NYSE and NASDAQ over the last four years, including trading data for the first two weeks after each IPO, company fundamentals, underwriting details, and relevant market indicators. Every dataset will be carefully verified to ensure consistency and reliability. Before I begin, could you please confirm whether you already have access to a financial data provider (such as Bloomberg, Refinitiv, FactSet, or PitchBook), or should I source the data entirely from publicly available and licensed sources? This will help determine the best approach and timeline. Best regards, Naresh
$200 USD in 1 day
6.2
6.2

Hi, I can definitely assist you in compiling a reliable and well-organized historical IPO stock dataset for NYSE and NASDAQ companies. I have experience working with large datasets, spreadsheets, and financial research, and I'll ensure the data is carefully verified for accuracy. I'll deliver everything in a clean Excel or Google Sheets format with all the required IPO details, trading data for the first two weeks, company information, and market indicators, making it easy to analyze and use. I have two quick questions: 1. Do you already have a preferred data source (such as Bloomberg, Refinitiv, or another provider), or should I use the most reliable publicly available sources? 2. Should the first two weeks include only trading days, or should I count calendar days after the IPO? Thanks, and I look forward to working with you!
$30 USD in 1 day
6.5
6.5

I have already created the similar project, please check the project details here - https://www.freelancer.in/portfolio-items/9809374-live-stock-market-analysis-tool I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can deliver a fast, accurate, and customized solution for your requirements. Let’s chat and discuss your project—I can start right away. Looking forward to working with you!
$80 USD in 1 day
5.9
5.9

Hello, I am an experienced financial data researcher who will compile NYSE/NASDAQ IPO data (2023–2026) with all required fields including ticker, company, country, IPO details, two‑week OHLCV, sector, industry, market cap, shares, float, founded year, employees, underwriters, lock‑up, gross spread, daily index returns, and VIX all verified and deduplicated with a sample provided first, and can start immediately upon confirmation of U.S.-only or global IPOs. Regards, Zafar
$100 USD in 1 day
6.4
6.4

Hello Sir I will create a spreadsheet for both of the listed companies for last 4 years with each and everything you are looking for Kindly consider me for a quick chat Thank you Amir
$250 USD in 4 days
6.0
6.0

Hi, I can deliver a highly accurate, well-structured Excel/Google Sheets dataset covering all NYSE and NASDAQ IPOs from 2023 through YTD 2026. The spreadsheet will include the first two weeks of trading data, IPO details, company fundamentals, underwriting information, market indicators, and all requested fields. I understand data accuracy is critical, and I'll thoroughly validate the dataset to ensure it passes your quality checks. I'm ready to start immediately and deliver clean, organized, and reliable data within your required format. Best regards, Farah
$100 USD in 2 days
5.0
5.0

Hello! I can create a well-organized and accurate historical stock data spreadsheet tailored to your specific requirements. Whether you need daily, weekly, monthly, or yearly stock prices, trading volume, adjusted closing prices, or other financial metrics, I will compile the data into a clean, easy-to-use spreadsheet with consistent formatting and attention to detail. I have experience working with financial data, Excel, and Google Sheets to organize, clean, and analyze historical market information. I can retrieve data from reliable sources, structure it according to your preferred format, apply formulas where needed, and ensure the spreadsheet is accurate, complete, and ready for analysis, reporting, or investment research. I am committed to delivering high-quality work on time while maintaining clear communication throughout the project. Share the stock ticker(s), date range, and any specific columns or formatting requirements, and I will begin immediately. I look forward to providing a professional historical stock data spreadsheet that meets your expectations.
$150 USD in 3 days
4.9
4.9

Hi there, I am A.R.M. MASUD with a strong background in data science. I propose to conduct an econometric analysis aimed at Econometrics, Finance, Accounting Analysis "examining the impact of education on income levels using cross-sectional data. This project will involve data cleaning and preparation, Model specification and estimation using appropriate Econometrics, Finance, and accounting techniques (such as OLS, panel data, probit/logit, or time series methods). Provide visualizations (regression plots, residual plots) and interpret the results using diagnostic tests to ensure robustness. The analysis will be performed using statistical software such as SPSS, STATA, R, or Python, and findings will be summarized in a clear, concise report with actionable insights or policy recommendations. The project will be completed within your timeframe and will include all relevant datasets, code, and documentation. https://www.freelancer.com.bd/projects/excel/Finance-Excel-Sheet-Population/reviews https://www.freelancer.com.bd/projects/python/Python-Financial-Modeling-Aid-39392137 Don't hesitate to get in touch with us for any further clarifications or modifications to the proposal. Thanks A.R.M MASUD
$100 USD in 2 days
4.7
4.7

⭐Hello⭐ I carefully reviewed your requirements and understand that you need a highly accurate Excel/Google Sheets dataset covering IPO companies listed on NYSE and NASDAQ from 2023, 2024, 2025, and YTD 2026, with detailed IPO profile data and the first two weeks of post-IPO trading performance. ⭐ Compile IPO company data including ticker, company name, country, sector, industry, IPO date, IPO price, and exchange ⭐ Collect daily OHLCV trading data for the first two weeks after each IPO ⭐ Add company fundamentals such as market cap, shares outstanding, shares offered, float %, founded year, and employees ⭐ Include underwriting details such as lead underwriter, co-underwriters, lock-up date, gross spread, and venture-backed status where available ⭐ Add benchmark data including S&P 500, Nasdaq, NYSE, and VIX returns for matching trading days ⭐ Organize everything in a clean spreadsheet structure for filtering, validation, and analysis ⭐ Cross-check data carefully to support your planned accuracy review I have strong experience with financial data research, spreadsheet structuring, data validation, and market analysis. I can build the workbook with clear tabs for IPO master data, daily trading data, benchmark returns, and source notes. Portfolio: [https://www.freelancer.com/u/baselnasser9](https://www.freelancer.com/u/baselnasser9) Please review my previous feedback. My aim is 100% satisfaction, so quality is my priority. Best regards, Bassel Nasser
$140 USD in 1 day
4.2
4.2

As a multidisciplinary technology professional, I bring a unique blend of data science, full-stack engineering, and financial proficiency that makes me an ideal fit for your comprehensive historical stock data spreadsheet project. Over the years, I've honed my skills in data analysis, preprocessing, and software automation to provide solutions like what you're in need of. Having used Python extensively for web scraping and data collection, which aligns with your project's main requirements, my ability to gather accurate and reliable data sets will ensure the integrity of your spreadsheet. Furthermore, as an AWS Certified Solutions Architect and with experience in working with large datasets, I understand the critical need for an organized format for easy analysis. Rest assured that not only would I deliver a well-structured Excel or Google Sheets spreadsheet but also leverage my proficiency with these tools to format the data elements you requested in a consistent and intuitive manner.
$100 USD in 7 days
4.4
4.4

With a diverse range of skills and extensive experience in financial data management and analysis, I am confident I can create the comprehensive historical stock data spreadsheet you need. A majority of my skillset revolves around data management, processing, and analysis which is exactly what you're looking for in a freelancer for this project. Moreover, as an advanced Excel specialist, I can efficiently handle functions like formulas, VBA, pivot tables, power query - all to ensure the accuracy and reliability your project requires. I understand the importance of data validity and your specified 100 checks will not be a problem for me. My attention to detail is almost meticulous and I leave no room for errors or inconsistencies in the final deliverables. Organized formats come naturally to me as I have a keen understanding of how crucial it is for ease-of-access when conducting analysis. Additionally, my familiarity with financial analyses makes me well-versed not just in managing spreadsheets but understanding their implications as well. My adeptness at Google Sheets further widens the scope of my abilities to accommodate your preferences. While numbers might be overwhelming for some, they make perfect sense to me and I am eager to incorporate this enthusiasm into completing your project successfully!
$140 USD in 7 days
3.3
3.3

Hey! I can help you with this data extraction project! I have institutional access to Bloomberg Terminal and Refinitiv so it won’t be an issue. Let’s discuss further details in chat. Regards, Taha
$140 USD in 7 days
3.8
3.8

Hello I can assist you in compiling a highly accurate and well-structured historical IPO dataset, delivering a professional spreadsheet tailored for detailed financial analysis. With extensive experience in financial research, data collection, and spreadsheet creation, I'll ensure every data point is verified from reliable sources to meet your strict validation requirements. I'll gather all NYSE and NASDAQ IPOs from 2023 through YTD 2026, including the complete first two weeks of trading data, company fundamentals, IPO details, market indicators, and underwriting information. Every record will be carefully organized in Excel or Google Sheets for easy filtering and analysis. Accuracy is my priority, and I understand your planned validation checks. I'll cross-reference multiple trusted financial sources to minimize discrepancies and deliver a clean, reliable dataset within the agreed timeline. I’m ready to get started immediately. Thanks Brian
$100 USD in 4 days
3.4
3.4

To pass your 100-point data validity check with 100% accuracy, I will write a custom Python data pipeline using Yahoo Finance and the SEC EDGAR database, rather than collecting this manually. Here is how I will extract the specific columns: 1. IPO Tickers & Company Profiles: I will pull the master list of all NYSE/NASDAQ IPOs from 2023 to 2026 YTD. Trading Data (First 2 Weeks): A Python script will query the Yahoo Finance API to pull the daily Open/High/Low/Close/Volume for the first 10 trading days post-IPO, along with index returns (S&P 500, Nasdaq, NYSE) and VIX on those exact dates. 2. SEC EDGAR Extraction: To get the highly specific underwriting data (Lead underwriter, Co-underwriters, Gross spread %, Lock-up expiration, Shares offered), my script will parse the official Form S-1 and S-1/A filings from the SEC database for each ticker. 3. Macro Validation: I will write a validation script to double-check that the market caps, shares outstanding, and employee counts reflect the figures at the time of the IPO rather than current values, and cross-verify index dates. I will deliver this in a single, consolidated Google Sheet. Tab 1 will contain the master IPO metadata (one row per company), and Tab 2 will contain the daily trading data (10 rows per company) mapped via ticker symbol. I am an automation developer based in Kochi. I can write the extraction script today and share a sample of the first 5 companies for your validation. Salaj Augustine
$222.22 USD in 4 days
3.4
3.4

Huskvarna, Sweden
Payment method verified
Member since Oct 5, 2017
$8-15 USD / hour
$8-15 USD / hour
$10-30 USD
$2-8 USD / hour
₹6000-9000 INR
₹1500-12500 INR
€1500-3000 EUR
₹600-1500 INR
$250-750 USD
$8-15 USD / hour
₹12500-37500 INR
$250-750 AUD
₹12500-37500 INR
$8-15 USD / hour
£2-5 GBP / hour
₹12500-37500 INR
$250-750 AUD
$15-25 USD / hour
$15-25 USD / hour
₹2000-20000 INR