We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

The Forum is currently experiencing technical issues which the team are working to resolve. Thank you for your patience.

Downloading Trustnet.com data into Excel

L_F Posts: 1 Newbie

21 November 2022 at 11:28AM in Savings & investments

Trustnet have changed their system and downloading weekly data no longer works. I used to use a link which would download several pages of data (588 funds in all) which I could then analyse in Excel.

Now, I can't get past the first page. I've tried using Excel's Data from Web but this does not result in a table of data as it should, according to the examples. I've noticed that the robots.txt for Trustnet.com (see below) has a series of items it doesn't allow - does that include downloading data now? I can't get any assistance from Trustnet, so can anyone help me, please?

User-agent: *

Disallow: /aspnet_client/

Disallow: /bin/

Disallow: /config/

Disallow: /data/

Disallow: /install/

Disallow: /macroScripts/

Disallow: /masterpages/

Disallow: /umbraco/

Disallow: /umbraco_client/

Disallow: /usercontrols/

Disallow: /xslt/

★ ★ ★ Meet your Ambassadors

Confirm your email address to Create Threads and Reply

MSE News

MoneySaver's 'unbelievable' £675 refund from Complete Savings – how to check if you can claim too
MoneySaver Ray secured a £675 refund from Complete Savings after reading our warning about the 'cashback with a catch' site's misleading 'click to claim' ads. And Ray's not the only one, as we've been swamped with similar successes.
Origin broadband customer? You'll soon be moved to Utility Warehouse – here's what you need to know
If you're an Origin broadband and home phone customer, you'll soon be automatically transferred to Utility Warehouse – but your service will continue as before and you should keep paying your bills as normal.
Bank of England cuts base rate to 4.25% – here's what it means for your mortgage and savings
The base rate has been cut to 4.25% from 4.5% by the Bank of England. This rate is used by the central bank to charge other banks and lenders when they borrow money, so the move can impact mortgage and savings rates.
Is now a good time to fix your mortgage or should you wait? Brokers answer as rates continue to fall ahead of expected Base Rate cut
Interest rates on fixed mortgage deals have continued to be cut ahead of this week's decision by the Bank of England on whether to change the Base Rate. But will fixed rates move much further – and should you fix now or wait?
Fixed-rate mortgages continue to fall ahead of expected Base Rate cut – so do brokers think now is a good time to fix?
Interest rates on fixed mortgage deals have continued to be cut ahead of this week's decision by the Bank of England on whether to change the Base Rate. But will fixed rates move much further?
Martin Lewis: How to call your bank by dialling just three numbers
How to call your bank by dialling just three numbers… simply dial 1-5-9. Then you know it's legit. Watch MoneySavingExpert.com founder Martin Lewis' video below, which explains it. And please share – the more people know, the fewer will be scammed.
Martin Lewis: How to call your bank by dialling just three numbers – as 'anti-scam' phone number called over a million times
One million calls have been made to the '159' anti-scam phone number since its launch in 2021, new figures reveal today (Wednesday 30 April). MoneySavingExpert.com founder Martin Lewis – one of the well-known faces most used in scams – explains how to call your bank by dialling just these three numbers.
Martin Lewis: How to call your bank with just three digits – as 'anti-scam' phone number called over a million times
One million calls have been made to the '159' anti-scam phone number since its launch in 2021, new figures reveal today (Wednesday 30 April). MoneySavingExpert.com founder Martin Lewis – one of the well-known faces most used in scams – explains how to call your bank by dialling just these three numbers.
Revealed: Holland & Barrett's supposedly cheaper 'Subscribe & Save' often costs more – it's promised a review after our investigation
Holland & Barrett's 'Subscribe & Save' scheme claims to offer regular shoppers "the best value" – but it failed to do so in the majority of cases MoneySavingExpert.com checked over a five month period. The retailer has now promised to review the scheme after our research found it was often more expensive.

View All

Downloading Trustnet.com data into Excel

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free