Automate Stock Options Data Export
Budget: ₹1,500 – ₹12,500 INR
I need a repeat-able Power Automate flow that fetches live stock-option-chain information—option prices and open interest—and lands it directly into an Excel spreadsheet. The workbook already exists; each refresh should overwrite or append rows in a clean table so the data stays analysis-ready without manual intervention.
Scope of work
• Connect to a reliable option-chain data source (an API you recommend or have worked with before) and retrieve all strikes for the selected symbols and expirations.
• Parse the response, keeping fields such as symbol, expiration, strike, call/put flag, last price, bid, ask, volume, open interest, and timestamp.
• Write the cleaned data into my Excel file (stored in OneDrive or SharePoint), updating on a schedule I can adjust later.
• Include basic error handling and a quick note in the flow comments so I can maintain it.
Deliverables
1. Exported Power Automate package (.zip) ready for import.
2. Short setup guide explaining any connectors, API keys, or table names required.
If you have previous experience pulling market data into Excel via Power Automate, especially through REST APIs, that will help us hit the ground running.
Scope of work
• Connect to a reliable option-chain data source (an API you recommend or have worked with before) and retrieve all strikes for the selected symbols and expirations.
• Parse the response, keeping fields such as symbol, expiration, strike, call/put flag, last price, bid, ask, volume, open interest, and timestamp.
• Write the cleaned data into my Excel file (stored in OneDrive or SharePoint), updating on a schedule I can adjust later.
• Include basic error handling and a quick note in the flow comments so I can maintain it.
Deliverables
1. Exported Power Automate package (.zip) ready for import.
2. Short setup guide explaining any connectors, API keys, or table names required.
If you have previous experience pulling market data into Excel via Power Automate, especially through REST APIs, that will help us hit the ground running.