Dividend Data Google Sheets Integration
$10-30 CAD
Posted less than 20 seconds ago
•
Ends in 6 days
$10-30 CAD
Paid on delivery
I maintain a Google Sheet with a watch-list of tickers and I need fresh dividend metrics pulled in from dividendhistory.org. IMPORTXML() fails on that domain, so I’m after a purpose-built solution that will: • Read my ticker list, visit the page or table link I will supply for each one, and capture four specific fields: Price Change %, Total Return (with dividends reinvested), Dividend Amount, and Current Yield. • Write each value into the sheet’s pre-assigned columns, overwriting the old data while leaving my layout intact. • Offer a simple in-sheet trigger—either a custom menu item or a button—so I can refresh on demand. • If a field is missing, leave the previous value in place and flag the cell (or a notes column) with a clear warning so I know something changed on the source page. Method I’m open to a pure Google Apps Script or a lightweight Python micro-service connected through the Google Sheets API; feel free to recommend whichever you believe will be more reliable given [login to view URL]’s structure. Deliverables 1. Fully commented code installed in my Sheet and ready to run. 2. Quick setup guide so I can add new tickers or move the script to another document. 3. Brief hand-off call or Loom video to demonstrate the refresh workflow and error-handling logic. Let me know which approach you’d take and the timeframe you’d need to turn this around. I’m looking forward to getting this automated.
Project ID: 40812138
About the project
Open for bidding
Remote project
Active 57 yrs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗