We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!
Morningstar withdraws portfolio manager and X-ray
Options
Comments
-
The formula =MID( copy cell, 4, 10) works with any GBX or GBP (or USD or CHF etc) values in Libre Office (and probably in all the other spreadsheets). Increase the 10 if working with bigger numbers, smaller numbers just work. For the £2.90, I just tick the 'Detect special numbers' box in the import dialogue and it comes in as 2.90 formatted as currency, so displaying £2.90.Eco Miser
Saving money for well over half a century0 -
Manually updating it copy and paste would not seem the best approach, especially if more than one data source us required.Excel has a method to automate such a data import and update when required.Anybody interested do search on goggle etc for "auto link and update excell from web page" to get overview and how to do it
0 -
You would expect by Saturday Friday's close prices would be updated. Trustnet and Interactive Investments agree exactly as far as my portfolios go, but Morningstar now do not, and are way out. They seem to be pretty useless now for latest prices, yet another "update" that ends up worse than before.0
-
I was feeling very downbeat by the MS revised Watchlist page. I know, I know it is free. Because it allowed the listing of multiple investment types (OIECs, ETFs), it was my goto source for my watchlist.
I'd also set up some google sheets referencing the scraped MS data. The ETFs still seem to function but the OIECs need to be re-jigged (fixed), but with my sadness regarding the use of GBP prices and the inconsistent ot unknown price point, I'm unsure I'll bother to fix it using MS. The reason for using MS instead of just 'googlefinance' function was that it wasn't easy / possible to get UK OIEC prices out of GF. I'll revisit that first to see if anything has changed there.
Personal Responsibility - Sad but True
Sometimes.... I am like a dog with a bone0 -
cloud_dog said:I was feeling very downbeat by the MS revised Watchlist page. I know, I know it is free. Because it allowed the listing of multiple investment types (OIECs, ETFs), it was my goto source for my watchlist.
I'd also set up some google sheets referencing the scraped MS data. The ETFs still seem to function but the OIECs need to be re-jigged (fixed), but with my sadness regarding the use of GBP prices and the inconsistent ot unknown price point, I'm unsure I'll bother to fix it using MS. The reason for using MS instead of just 'googlefinance' function was that it wasn't easy / possible to get UK OIEC prices out of GF. I'll revisit that first to see if anything has changed there.1 -
Bobziz said:cloud_dog said:I was feeling very downbeat by the MS revised Watchlist page. I know, I know it is free. Because it allowed the listing of multiple investment types (OIECs, ETFs), it was my goto source for my watchlist.
I'd also set up some google sheets referencing the scraped MS data. The ETFs still seem to function but the OIECs need to be re-jigged (fixed), but with my sadness regarding the use of GBP prices and the inconsistent ot unknown price point, I'm unsure I'll bother to fix it using MS. The reason for using MS instead of just 'googlefinance' function was that it wasn't easy / possible to get UK OIEC prices out of GF. I'll revisit that first to see if anything has changed there.Personal Responsibility - Sad but True
Sometimes.... I am like a dog with a bone0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards