
Closed
Posted
I need a robust yet straightforward way to pull equity and option-chain information from Massive, Yahoo Finance, or any other reliable market data API you propose, and deliver it straight into my Excel model (or a clean CSV that drops in seamlessly). The data set must include: • Historical OHLC prices and volume • Key market statistics such as market-cap, short interest, basic fundamentals • Full options chains with greeks when available I have no hard preference on the raw download format—as long as the end result is refreshable in Excel without manual clean-up. What I expect from you 1. A well-commented script or low-maintenance workflow (Python, VBA, Power Query, or similar) that authenticates, fetches, and aggregates the fields above. 2. Mapping logic that keeps column names and data types consistent so my existing formulas keep working. 3. An easy way for me to specify tickers and date ranges. 4. Brief documentation showing how to refresh or extend the feed. If you already have experience wrangling market data APIs, this should be a quick engagement; if not, please outline how you intend to bridge any gaps before delivery.
Project ID: 40203054
14 proposals
Remote project
Active 13 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
14 freelancers are bidding on average ₹979 INR/hour for this job

With my wealth of experience in data analysis and Excel VBA, I can certainly provide a robust solution to your stock data integration needs. Having successfully completed more than 50 projects, I'm comfortable working with market data APIs and understand the importance of clean, error-free data for reliable financial modeling. For this project, I intend to leverage my proficiency in Python, VBA or Power Query to automate the complex process involved in fetching data from your preferred API and delivering it seamlessly into your Excel model or a CSV format. My primary focus will be on creating well-commented scripts and mapping logics that ensure consistency in column names and data types to support your existing formulas. To make the process hassle-free for you, I'll develop an intuitive way for you to specify tickers and date ranges, ensuring that even someone without deep technical know-how can efficiently refresh or extend the feed with ease. Additionally, I'll provide concise documentation that elucidates the IO operations we've performed setting out how they can be replicated going forward. In summary, with my sharp analytical skills, in-depth knowledge of Excel, and proven record in handling data from market APIs, I am confident that I can convert your vision into a reality. Let's collaborate to create a straightforward yet powerful solution that enhances your trading analysis while minimising tedious manual labour!
₹1,000 INR in 40 days
5.0
5.0

As a seasoned Full-Stack Developer with a strong background in data-driven platforms, I am more than equipped to deliver on your stock-data integration project. I have hands-on experience handling financial APIs and leveraging data analytics tools like Excel and Visual Basic to process and present complex market data. With a meticulous approach to software development, I will not only create a robust script or workflow for you but ensure that it's well-documented. Incorporating my skills in Python, VBA, Power Query, among others, I will facilitate easy authentication, fetching, and aggregation of all the required market information straight into your Excel model or as pristine CSV files. Furthermore, being well versed with column mapping strategies, all your existing formulas will retain functionality while interacting with the rich stock dataset. My proficiency with strategic planning and systematic problem-solving makes me an invaluable asset. In the unlikely event that specific tickers or date ranges pose a challenge, I'll work hand-in-hand with you to resolve them efficiently. Lastly, the fact that I bring dual-professionalism as a Biostatistician can harmoniously strengthen your project by offering not just technical proficiency but also rigorous procedural criteria.
₹1,000 INR in 40 days
4.5
4.5

Hello, With 5+ years of experience in market data API integration, I can deliver a seamless solution for your Excel-ready stock data needs. I'll create a Python script with clear comments, ensuring easy authentication and data retrieval from reliable sources like Yahoo Finance or similar. The script will handle historical OHLC, volume, market stats, and options chains with greeks, mapping data consistently for your Excel model. I'll provide a user-friendly interface for ticker and date range selection, along with brief documentation for refreshing the feed. My approach focuses on efficiency and low maintenance. Please message me for samples of similar projects. Thanks, Adegoke. M
₹750 INR in 3 days
1.3
1.3

Hi there, I can build a streamlined workflow that feeds historical prices, fundamentals, and option chains directly into your Excel model. My goal is to give you a "one-click" refresh so you can focus on analysis rather than data wrangling. My Proposed Technical Stack: Data Source: I recommend using the Yahoo Finance API (via the yfinance library) or Alpha Vantage, as they offer the best balance of reliability for OHLC, Greeks, and fundamental data. The Bridge: I will provide a Python-based bridge or a Power Query setup. This will allow you to simply update a "Ticker List" in Excel and hit refresh to pull the latest data. Consistent Mapping: I will map the API outputs to match your existing column headers exactly, ensuring your current formulas and Greeks-based models don't break. Options & Greeks: I will ensure the option chain extraction includes the Greeks (Delta, Gamma, Theta, Vega) and implied volatility where available. Deliverables: A lightweight, well-commented script or Excel-integrated tool. A simple "Setup & Refresh" guide. A clean CSV/Excel output structured for immediate drop-in. I have worked with market data structures before and understand the importance of handling "NaN" values and date-formatting consistently to keep models stable. Are you looking to pull data for a specific list of 10–20 tickers, or do you need a tool that can handle larger batch requests? Best regards,
₹800 INR in 40 days
0.6
0.6

As an accomplished Data Analyst with a specialization in Excel, I believe I possess the necessary skills to effectively handle your project on integrating equity and option-chain data into Excel. Throughout my career, I've consistently delivered high-quality, accurate, and well-structured reports and dashboards using various data sources and automation tools - a skill that is directly applicable to your project needs. I also have considerable experience working with APIs and automating data fetch from disparate sources. My deep knowledge of scripting languages like Python and VBA combined with my understanding of Power Query will ensure that I can create an efficient workflow affording you a seamless experience in maintaining market data within the Excel model. Additionally, my knack for clean, understandable code and thorough commenting will enable you to easily comprehend the mapping logic used to ensure column name consistency and data type integrity. Rest assured, I fully grasp your need for timely and easily-refreshable market data in the format you require. I am confident in my ability to meet not only the core objectives of your project but also exceed your expectations by delivering on points you might not have even thought of. My strong work ethic combined with comprehensive documentation (another forte of mine) will ensure a positive, uncomplicated experience for you while benefiting from precise and current stock data integrated seamlessly into your Excel model.
₹1,000 INR in 40 days
0.0
0.0

Hello , I checked your project, and it looks interesting. This is something we already work on, so the requirements are clear from the start. We mainly work on Visual Basic, Excel, Excel VBA, Data Analysis, API Integration, Financial APIs We focus on making things simple, reliable, and actually useful in real life not overcomplicated stuff. Let’s connect in chat and see if we’re a good fit for this. Best Regards, Ali nawaz
₹1,000 INR in 40 days
0.0
0.0

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Visual Basic, Excel, Excel VBA, Data Analysis, API Integration, Financial APIs Please come over chat and discuss your requirement in a detailed way. Regards
₹1,000 INR in 40 days
0.0
0.0

Hi there, I can build you a robust, one-click solution to pull equity and option-chain data directly into Excel. I specialize in bridging Python data automation with Excel for financial modeling and have extensive experience working with market APIs like Yahoo Finance (yfinance) and Alpha Vantage. My Proposed Solution: - Python Backend: A lightweight, well-commented script using the yfinance library to fetch OHLC prices, market stats (market cap, short interest), and full option chains with Greeks. - Excel Integration: The script will output a clean, formatted CSV that your Excel model can automatically refresh via Power Query—ensuring zero manual copy-pasting. - User-Friendly Config: A simple config file (or Excel sheet) where you can just type tickers and date ranges to update the feed. - Data Mapping: I will ensure all column headers and data types match your existing model requirements. Why Me? I am a Data Operations Analyst with deep expertise in Python, Excel VBA, and API integrations. I build tools like this daily to automate complex financial reporting pipelines. I can deliver this script and a short video guide on how to use it within one week. Best regards, Malmayad
₹1,250 INR in 40 days
0.0
0.0

Hello, I am a reliable and detail-oriented Data Entry Specialist with strong expertise in Microsoft Excel and Google Sheets. I understand that accurate data entry is not just about typing fast—it’s about maintaining consistency, eliminating errors, and organizing data in a way that actually helps your business. I can assist you with: • Data entry from PDF, scanned files, or websites • Excel formatting, cleaning, and structuring • Copy-paste and manual data input • Sorting, filtering, and basic formulas • Converting files (PDF to Excel, Word to Excel, etc.) I work with a systematic approach: first understanding your exact requirements, then creating a clear workflow to ensure speed and accuracy. I double-check my work before submission so you don’t waste time fixing mistakes. You will get: ✔ 100% accuracy focus ✔ Fast turnaround time ✔ Clear communication ✔ On-time delivery I am ready to start immediately and can handle both short-term and long-term projects. If you share a sample file or task details, I can begin right away. Let’s get your data organized and reliable. Thank you.
₹999 INR in 40 days
0.0
0.0

Dear Client I saw your requirements regarding to develop a Excel Solution for integration of Stock Data (Historical, Option Chain and other data) via API or Any Relaible Sources. I can develop this solution ASAP based on your requirements. I developed many application is similar to your requirements. Let share further details. Thanks and Regards Kannadasan K
₹750 INR in 1 day
0.0
0.0

I'm a ca inter student just given an exam in January 2026 and finding the work in same field till the exams results are out
₹1,000 INR in 40 days
0.0
0.0

Hello, I’ve carefully reviewed your requirement, and this is a problem I’ve worked on before, building refreshable market-data pipelines that feed directly into Excel or CSV files without manual cleanup. In my previous projects, I’ve used Python-based API workflows to fetch Shopify and QuickBooks data, normalise fields across endpoints, and deliver them into Excel-ready tables or clean CSVs. I focus on stable column names, correct data types, and minimal downstream maintenance. I’ve also built these pipelines so tickers and date ranges can be changed easily without touching core logic. For this project, I propose a Python workflow (with CSV or direct Excel output) that handles authentication, pulls OHLC, market stats, and options chains, and consolidates everything into a consistent schema. The script will be well commented, configurable for tickers and date ranges, and designed so it can be refreshed on demand or scheduled later if needed. I’ll include brief documentation explaining how to refresh, extend fields, or swap data sources if required. Estimated delivery: 1–2 business days for a clean, working pipeline with documentation. One quick question to confirm scope: do you prefer a free source like Yahoo Finance, where available, or are you open to a paid API? Best regards, Suhel
₹900 INR in 40 days
0.0
0.0

Hello, I can build a clean and reliable workflow to fetch historical prices, market stats, and full options chains (with greeks) from Yahoo Finance / Massive or another stable market-data API, and deliver it directly into Excel-ready format (CSV or auto-refreshable sheet). Approach • Python script using yfinance / requests / pandas to authenticate and pull OHLC, volume, fundamentals, and options chains • Clean column mapping to keep names and data types consistent with your existing Excel model • Parameterized inputs so you can easily change tickers and date ranges • Output as structured CSV or Excel-refreshable format (Power Query friendly) • Well-commented, low-maintenance code + short documentation for refresh and extension I have strong experience with API integration, data processing, and automation, and I can deliver a simple, robust solution quickly. If you share your preferred Excel structure, I can align the output exactly. Ready to start immediately. Yash Raj Sharma
₹1,000 INR in 40 days
0.0
0.0

Coimbatore, India
Member since Jan 31, 2026
$15-25 USD / hour
₹100-101 INR / hour
$10-30 USD
$1500-3000 AUD
$8-15 AUD / hour
$30-250 USD
$30-250 USD
₹600-1500 INR
€8-30 EUR
₹12500-37500 INR
$15-25 USD / hour
$10-30 USD
$10-30 USD
€30-250 EUR
₹400-750 INR / hour
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / hour
$250-750 USD
₹750-1250 INR / hour