Excel + Google Finance Scrape

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:

[url removed, login to view]:AGU

TSE is the senior listing

NOTE: Google can format the URL differently, such as;

[url removed, login to view]

[url removed, login to view]: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.

Kemahiran: Pemasukan Data, Excel, Visual Basic

Lihat lebih lanjut: google finance excel, excel google finance, scrape google finance, scraping google finance, scrape google finance data, google finance vba, google finance scrape, google finance api excel, scrape data google finance, vba google finance, parse google finance, google finance data feed, use googlefinance excel, excel google finance commands, scrape data excel finance, google finance format, scrape stock excel, spreadsheet finance stock scrape, link google finance page excel document, google finance infoq, google finance api retrieve data excel, retrieve data excel google finance, google finance excel plugin, web scraping excel vba, google finance add excel

Tentang Majikan:
( 1 ulasan ) calgary, Canada

ID Projek: #351084

Dianugerahkan kepada:


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

$88 USD dalam 2 hari
(15 Ulasan)

15 pekerja bebas membida secara purata $123 untuk pekerjaan ini


Hello,Please refer your [url removed, login to view] you.

$100 USD dalam 3 hari
(105 Ulasan)

Looking forward to working with you..

$150 USD dalam 3 hari
(66 Ulasan)

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

$195 USD dalam 2 hari
(18 Ulasan)

Please see my profile.

$130 USD dalam 5 hari
(8 Ulasan)

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.

$125 USD dalam 4 hari
(14 Ulasan)

Hi there, pls refer to PM.

$60 USD dalam 3 hari
(8 Ulasan)

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

$151 USD dalam 7 hari
(2 Ulasan)

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

$200 USD dalam 5 hari
(0 Ulasan)

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

$60 USD dalam 12 hari
(0 Ulasan)

Please check PM.

$150 USD dalam 7 hari
(0 Ulasan)

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

$50 USD dalam 5 hari
(0 Ulasan)

i complete my work in 3days with my perfection

$35 USD dalam 3 hari
(0 Ulasan)

Hi Please See PM

$100 USD dalam 2 hari
(0 Ulasan)

dear sir, I can do it perfectly. thanks

$250 USD dalam 5 hari
(0 Ulasan)