Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to ouzo,Fluke,PeterGray,Instep,6Tricia, for Donating to support the site

Simple Price Scrape updated to v2.5

Discussions regarding financial software
kiloran
Lemon Quarter
Posts: 4315
Joined: November 4th, 2016, 9:24 am
Has thanked: 3599 times
Been thanked: 3106 times

Simple Price Scrape updated to v2.5

#701187

Postby kiloran » December 18th, 2024, 2:50 pm

The Simple Price Scrape started out as a simple dump of data from Yahoo. This was great, many shares could be downloaded with one web query, it covered all the major global exchanges, and reported indices and exchange rates. Some funds were available, though not all.
Over the years, Yahoo has thrown a few tantrums, and though it still covers the same breadth of data, it now requires one web query per share... not a major disaster, but it is a bit slower. Last week it was reported that some/all fund prices were incorrectly reported in pounds instead of pence, so reliability is still questionable.

We then added the Shareprices web site as an alternative source of data. This is OK for many people, but it only covers UK shares and ETFs.

Another added option was for Fund prices, using the Financial Times as a source. Although it was intended for Funds, in practice it also provided data for shares from most global markets, ETFs, indices, bonds and exchange rates, although in a few cases there were some errors extracting the data.
Version 2.5 has cleaned this up, and the "FT Funds" sheet has been replaced by the "FT" sheet. It now extracts the share name and provides a link to the relevant FT page. If Yahoo has more problems in the future, it looks like the FT will be a credible and reliable alternative source of data.

Version 2-5 for Excel and LibreOffice is available at: https://lemonfoolfinancialsoftware.weeb ... crape.html

Image

--kiloran

Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest