I would like a VB6 program or VBA module in MS-Access (2000, 2002/2003) that uses the Yahoo Finance website to download a CSV Stock History file for each TSX stock in a pre-populated table/list.
The list will be provided in a table or text file - whatever your preference is.
Needs to be able to run from Windows XP using basic system DLLs no third party controls. I have Internet Explorer 6 installed.
Input parameters for module:
TSX Symbol
Start Date (Month, Day, Year)
End Date (Month, Day, Year)
Output: (saves to app folder)
CSV Output File Name: <TSX_Symbol>.CSV
Example URLs:
Note - you may have to replace "." in symbol name with "-", as in example below for MRT.UN
http://ca.finance.yahoo.com/q/hp?s=MRT-UN.TO&a=00&b=1&c=2008&d=0 8&e=10&f=2010&g=d
Example of Download URL is:
http://ca.rd.yahoo.com/finance/quotes/internal/historical/download/*http://ichar t.finance.yahoo.com/table.csv?s=MRT-UN.TO&a=00&b=1&c=2008&d=08&am p;e=10&f=2010&g=d&ignore=.csv
All this project requires is the module described above.
A bonus payment will be made if you provide me with zipped file of CSVs using date range Jan 1/2008 to Aug 31/2010. There will be approximately 1000 Symbols in list.
Let me know if you have any questions.
Thanks
Requirements Interview Answers:
To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.
Untitled Page
Detailed Requirements:
This broadcast message was sent to all bidders on Friday Sep 10, 2010 1:39:41 PM:
Actually checked out how many stocks that I need the history for and it is not 1000, but 355 - in case you want to get bonus for retrieving all the data
-
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)
Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say "testing showed
the final deliverables did not
work").
So for this reason,
you should have instead followed
the above instructions and
switched it to
pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.
- Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects < $500 (before the employer's money is escrowed) is a violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
Categories:
-
The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.
-
Like everything else on this page, these categories are part of the original contract
for this project.
Microsoft Windows, Languages, Operating systems / platforms, Visual Basic, Networking and information systems, Visual Basic for Applications (VBA), Technology, Web programming, Software Development, Scripts and utilities, Database administrator
Post new project
Find workers...
Search workers
Browse by category
Move menu
Tools
Articles
FAQ
News
Help
Excellent
Sourcing Type: Outsourcing
Brief summary:
Newest
Contests / Trials 
What is this list?