Getting Fund Data Into Excel as a Datasource

Lokolo

Has anyone found an easy reliable source? Trustnet makes all the prices end in (p) in the cells so that's not useful.

I thought FundListings would be OK but I can't seem to select the price. Only the name of the fund.

Does anyone else do it?

psychic_teabag

I download prices from fundlistings, though not into excel. I scrape the html, which is a little messy.

Linton

Do you want historical or just the current prices? For current prices I set up a dummy portfolio in ft.com which can be downloaded in csv format.

plunt

find a website with the fund price then in excel create a new sheet and go to


1) data ribbon
2) "from web" button
3) input the url
4) when at the page you will see yellow boxes. select the one you want
5) press okay and should be brought into excel. now use a vlookup to find the exact data you want
6) any time you want the data to update you can go to data ribbon again and click refresh all

hope thats the kind of thing you were after and i do that for all stocks aswell

Lokolo

I know how to do it but there's no decent website to get the data without it being clunky.

For example, if you import the pages from HL, they don't have tables.
If you import from trustnet, the prices are numbers, they are text which have (p) afterwards.

However doesn't matter as Fidelity has a page layout where I can extract the data, it's not great but it works. I am hiding the data sheet as it makes my spreadsheet look rubbish.

plunt

ah alright sorry, misunderstood!

cloud_dog

Lokolo wrote: »

If you import from trustnet, the prices are numbers, they are text which have (p) afterwards.

Why not create a master template s/sheet with the below formula in and cut / paste the downloaded data with the (p). For example 155(p) becomes 1.55:

=(LEFT(A1,FIND("(",A1)-1)/100)

Lokolo

cloud_dog wrote: »

Why not create a master template s/sheet with the below formula in and cut / paste the downloaded data with the (p). For example 155(p) becomes 1.55:

=(LEFT(A1,FIND("(",A1)-1)/100)

At the time I couldn't be bothered to try and format in the hope there was somewhere you could just download it. Fidelity is OK though so going to use that.