Project Detail

Excel + Google Finance Scrape  

Excel + Google Finance Scrape is project number 351084
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: johnsinit

Budget: $30-250

Created: 11/30/2008 at 17:47 EST

Bid Count: 15

Average Bid: $ 123

12/04/2008 at 17:47 EST

Project Creator: eb1 View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (1 reviews)

Bid On This Project
 

Description

Project Summary;
To scrape market date for Canadian Toronto stock exchange listed mining companies from Google finance into Excel format.

Project Expected outcomes;
1. Have data formatted and scraped from Google finance into an excel spreadsheet xls or xlsx format
2. Have the information that was pulled from Google to be updateable, either by (any); opening the spreadsheet, a shortcut, a ctrl shift F5 command.
3. The ability to add a new stock ticker to the spreadsheet and have the spreadsheet add the code or commands need to parse data from Google automatically.
4. Have all the fields working that are currently in the example spreadsheet (6 updateable fields.)
5. Have at least 70% of the companies update- not all companies have full Google finance listings, that is acceptable.
6. Completed on budget.
7. Use no outside programs or paid for software, in order to get the data (end-user)

Only use Google finance to get data.

Examples of data and shortcuts:
http://finance.google.ca/finance?q=TSE:AGU
TSE is the senior listing

NOTE: Google can format the URL differently, such as;
http://finance.google.ca/finance?q=TSE%3AAGU

http://finance.google.ca/finance?q=CVE:EGD
This means that the “CVE” is the Toronto stock exchange venture (like a junior market like London’s AIM)
(on page 2 of excel spreadsheet included)

If it is useful some of the tickers can be put together – A column plus F column = correct Google format for URL.
If you have a better way, you can delete the A column for the final spreadsheet.

If you have further questions please contact me.



Additional files submitted:
Canadian mining companies.xls

Messages Posted: 3 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

100

3 days

11-30-2008 20:50 EST

Hello,Please refer your PMB.Thank you.

help

  View PM Post PM

150

3 days

11-30-2008 17:52 EST

Looking forward to working with you..

help

  View PM Post PM

195

2 days

12-01-2008 03:15 EST

Hi, More details are in the PM. Best regards, Yousef

help

  View PM Post PM

88

2 days

12-01-2008 06:13 EST

Dear eb1! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB.

help

  View PM Post PM

125

4 days

12-01-2008 02:05 EST

This can certainly be done using Excel VBA. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.

help

  View PM Post PM

130

5 days

12-01-2008 14:11 EST

Please see my profile.

help

  View PM Post PM

60

3 days

12-01-2008 09:17 EST

Hi there, pls refer to PM.

help

  View PM Post PM

151

7 days

12-01-2008 01:18 EST

Dear Sir/Madam , Thanks , check PMB . With Best Regards.

help

  View PM Post PM

250

5 days

12-01-2008 13:20 EST

dear sir, I can do it perfectly. thanks

help

  View PM Post PM

200

5 days

11-30-2008 20:50 EST

(No Feedback Yet)

Wiling to take up the project and will complete as per the guidelines in the time stipulated. Thank you Sharanayya S.M.

help

  View PM Post PM

60

12 days

12-01-2008 03:34 EST

(No Feedback Yet)

Hi, We have very good experience arround such task. We can do this easily. Regards, Jignesh

help

  View PM Post PM

150

7 days

12-01-2008 06:02 EST

(No Feedback Yet)

Please check PM.

help

  View PM Post PM

50

5 days

12-01-2008 08:55 EST

(No Feedback Yet)

hi i can do this job in the time you want it to be completed.

help

  View PM Post PM

35

3 days

12-01-2008 09:39 EST

(No Feedback Yet)

i complete my work in 3days with my perfection

help

  View PM Post PM

100

2 days

12-01-2008 11:37 EST

(No Feedback Yet)

Hi Please See PM

help

    Bid on this Project