We’d like to remind Forumites to please avoid political debate on the Forum.

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.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Downloading Trustnet.com data into Excel

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

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.6K Banking & Borrowing
  • 254.2K Reduce Debt & Boost Income
  • 455.1K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 603K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.