Built python software to amend "live" excel spread sheets. The excel spreadsheets currently link to website that has external data connection to live stocks price. The python GUI must filter certain column in excel data for certain keywords, then add/amend data in excel and export as csv. This happens "while the excel is OPENED." THIS IS NOT A WEB SCRAPING PROJECT.
*Two live excel spreadsheets- "[login to view URL]" and "[login to view URL]"
* Filter for requirement, Amend data, export, saved to CSV.
* Runs at certain time intervals.
GUI interface design and requirement for building
Sample of excel screenshots.
**Advance Python level2-3 ONLY
Python xlwings and pandas library would be required.
** ONLY apply if you have experiences in building Python GUI, Advance pure python coding ONLY.
** Need responsible coder that can deliver the code and fully tested on time.
Further detail on discussion for shortlist candidates.