I have a couple of Excel Spreadsheets (attached) with various stock, option, and mutual fund data in them that I would like to be able to automatically update via an external data pull from Yahoo Finance, MSN Money, or a similar free source. I've seen examples of this before but am having trouble customizing them to what I want to do (an example of how such a feed works on a website can be seen at: [url removed, login to view]) Please take a look at two spreadsheets attached for the specifics of what I want done. 401k fund [url removed, login to view] just needs to update the YTD, 1yr, 3yr, 5yr, and 10yr numbers (and Morningstar ratings if possible). Just an update on open is sufficient for this one. Stock [url removed, login to view] is meant to be a sheet I can add rows to (I am fine with additions being done via a form or even via my hacking into the datafeed query if need be). Ideally price data on this sheet would be updated every 10 minutes or so. I am putting this in as a very small business project as I *think* that someone who knows what they're doing could probably pull this off fairly quickly, but if this is more difficult than I'm estimating, please feel free to let me know and adjust your bid accordingly. Thank you, Richard Law
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
These spreadsheets need to run on Windows XP + Office XP.