I am having to move several funds to the Royal Liverpool URL to get a daily price (from the financial times site which I previously used). The RL URL is as follows: https://www.fundslibrary.co.uk/Clients/RoyalLondon/?id=
one example fund id is GB00BQ1MHS31
It appears that RL have stopped providing the FT site any updates for certain funds. The problem is I have been trying to figure out how to pull the “Price Date” and “Bid Price” from the RL page but have failed spectacularly. Here are the regex patterns I have used but failed with…
Date: Price date\s*|\s*(\d{2}/\d{2}/\d{4})
Price: Bid Price\s*|\s*([\d.]+p?)
Data format: HTML
Date format %d %m %y
I get unable to parse price and unable to parse date errors when attempting to do an online price update.
Any help would be gratefully received…