Advanced Stock Data Scraper
Budget: $10 – $1,000 USD
Automatically pull fresh market data from NYSE, NASDAQ, S&P 500 and the Dow Jones, and drop everything into neatly structured Excel workbooks with multiple tabs using the MMM-DD-YYYY date format that refreshes upon open.
Deliverables (2 workbooks, one for dividend paying stocks and one for non-dividend stocks).
• Current Price with % price increase/decrease changes
• Historical Daily Prices
• Trading Volume
• Ticker Symbol
• Company Name
• Sector
• Daily Closing Price
• Full Closing-Price History
• Market Cap
• 52-Week Low & High
• EPS
• P/E Ratio
• Record / Ex-Dates
• Dividend Amount
• Dividend Date
• Complete Dividend History
• Dividend Calendar
Please output to .xlsx with formulas preserved where relevant.
The workbooks should refresh cleanly when the script is rerun, overwriting old data without manual cleanup.
When replying, drop in a short code or screen sample from a similar financial scrape you’ve done, note any rate-limit work-arounds you typically employ, and give me a realistic turnaround time. I’ll review samples, confirm the fields, and green-light the build immediately after. Solid work may lead to a variety of other creative personal-use projects.
Deliverables (2 workbooks, one for dividend paying stocks and one for non-dividend stocks).
• Current Price with % price increase/decrease changes
• Historical Daily Prices
• Trading Volume
• Ticker Symbol
• Company Name
• Sector
• Daily Closing Price
• Full Closing-Price History
• Market Cap
• 52-Week Low & High
• EPS
• P/E Ratio
• Record / Ex-Dates
• Dividend Amount
• Dividend Date
• Complete Dividend History
• Dividend Calendar
Please output to .xlsx with formulas preserved where relevant.
The workbooks should refresh cleanly when the script is rerun, overwriting old data without manual cleanup.
When replying, drop in a short code or screen sample from a similar financial scrape you’ve done, note any rate-limit work-arounds you typically employ, and give me a realistic turnaround time. I’ll review samples, confirm the fields, and green-light the build immediately after. Solid work may lead to a variety of other creative personal-use projects.