Download spreadsheet data from finance.yahoo.com and upload into database - repost
£10-20 GBP
Completed
Posted almost 11 years ago
£10-20 GBP
Paid on delivery
Full step by step instructions given. Operation to be repeated 700 times, So once you have done it once according to the instructions, it is simple. Each operation takes about 1 minute.
Instructions are as follows:
spreadsheet
1. select epic code from list
2. make a note of the epic code on paper for later
3. lookup epic code on [login to view URL]
4. if epic not found then go to next epic in list
5. click on historic prices on left hand side of [login to view URL] page
6. scroll to bottom of page
7. click on download to spreadsheet
8. note on paper of the filename of the file that has been created
database (if this is the second or more time you are going through these steps, then go straight to step 10)
1. go to [login to view URL]
2. click on 'sign in' at the top right
3. click 'sign in to my services' (data centre should be US Commercial – Austin)
4. type username 'xxxxx'
5. type password 'xxxxxx'
6. type identity domain 'xxxxxx'
7. middle right on the page where it says 'actions' click on the third button
8. click on 'sql workshop'
9. click on 'utilities'
10. click on 'data workshop'
11. under 'load data' heading, click on 'spreadsheet data'
12. Check box: Load to: New table
13. Check box: Load from: upload file (comma separated or tab delimited)
14. Click 'Next'
15. Click 'Choose file' and navigate to the spreadsheet data that you downloaded earlier from [login to view URL]
16. Click the 'Next' button
17. In the box labelled 'table name' put the epic code that you searched for on [login to view URL] to start with
18. In the first box to the right of 'column names', you should see the word 'date'. Change that to 'day'
19. click 'Next'
20. click 'load data'
21. check that 'succeeded' has a number under it and 'failed' has a zero under it
22. The job is now done.
23. click on Utilities
24. Go back to [login to view URL] and begin with the next epic on the list.
I could automate the first part of it; downloading details from Yahoo. If this is a regular task, I could automate the second task too. (Bid only for first part)
Respected Sir,
I have a well experienced in this field. I do care for concept , typo, Fonts , color culture. Please give me a change to do your work. I will complete this work before deadline. We can discuss about the projects and start as soon as possible after your reply.
Thanks!