Excel-Ready Stock Data API Integration
Budget: ₹750 – ₹1,250 INR
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.
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.