
Combine data from a PDF and a website into one Google spreadsheet
- or -
Post a project like this3073
$$
- Posted:
- Proposals: 18
- Remote
- #1354788
- Awarded
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer

WordPress Data Entry, Data Scraping, Website research, PDF to Excel/Word, Micfosoft Office, Contact synchronization in Excel, Photoshop, InDesign

Data Entry, Web Design, VA, Web Developer, Admin Support, Virtual Assistance, WordPress, Magento, eBay

36844710096817866835715261254564895951408967121146114311501196463715225212654





Description
Experience Level: Intermediate
Hi there!
I have this PDF with less than 1000 entries:
https://www.degiro.ie/data/pdf/ie/commission-free-etfs-list.pdf
(I will send you a link to the online Google Docs Spreadsheet, which will also contain some examples.)
If you are good with text search/replace, you could copy&paste everything from PDF into spreadsheet in a few steps.
Then, by searching this website https://www.justetf.com/uk/find-etf.html using the "ISIN" number from the above PDF, I need to add a few more columns/values:
Fund Size (in m £)
TER in % p.a.
Inception date
Distribution policy
Fund domicile
Replication method
So in total, the spreadsheet with data form the PDF and the website combined, must have following columns with values:
ISIN (PDF)
Name (PDF)
Currency (PDF)
Exchange (PDF) (...you can ignore this one if it makes it easier for you)
Fund Size (in m £) (justetf.com)
TER in % p.a. (justetf.com)
Inception date (justetf.com)
Distribution policy (justetf.com)
Fund domicile (justetf.com)
Replication method (justetf.com)
Note: not all ISINs from the PDF can be found on the website. I trust you will still check each of them.
You can try to find them elsewhere online, but this is voluntary ;)
Please let me know how much you would charge for this work.
P.S.: the result will be some interesting investment data. If you are interested, I can explain at the end why.
I have this PDF with less than 1000 entries:
https://www.degiro.ie/data/pdf/ie/commission-free-etfs-list.pdf
(I will send you a link to the online Google Docs Spreadsheet, which will also contain some examples.)
If you are good with text search/replace, you could copy&paste everything from PDF into spreadsheet in a few steps.
Then, by searching this website https://www.justetf.com/uk/find-etf.html using the "ISIN" number from the above PDF, I need to add a few more columns/values:
Fund Size (in m £)
TER in % p.a.
Inception date
Distribution policy
Fund domicile
Replication method
So in total, the spreadsheet with data form the PDF and the website combined, must have following columns with values:
ISIN (PDF)
Name (PDF)
Currency (PDF)
Exchange (PDF) (...you can ignore this one if it makes it easier for you)
Fund Size (in m £) (justetf.com)
TER in % p.a. (justetf.com)
Inception date (justetf.com)
Distribution policy (justetf.com)
Fund domicile (justetf.com)
Replication method (justetf.com)
Note: not all ISINs from the PDF can be found on the website. I trust you will still check each of them.
You can try to find them elsewhere online, but this is voluntary ;)
Please let me know how much you would charge for this work.
P.S.: the result will be some interesting investment data. If you are interested, I can explain at the end why.

Waldemar P.
96% (10)Projects Completed
20
Freelancers worked with
18
Projects awarded
18%
Last project
28 Aug 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Waldemar P,
I am interested. Can you reply.
224292
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies