Trying to get UK fund prices working
I have got Moneydance 2015 and I have downloaded the Quotes and Exchange Rates Extension.
But I can't get the prices to update.
Let me give you an example.
Here is the ticker:
GB00B80QFX11.L
or
GB00B80QFX11
(not sure if you need the .L or not - but neither seem to work).
I have checked that on Yahoo Finance UK that this fund is quoted - and I have tested that the data is there when you click on the download data button at the bottom right of the page. So all good.
In MD15 I have set it up so that historical and current prices are set to Yahoo UK.
In the table I have entered the ticker as noted above - and I have the Stock Exchange set to London Pence.
When I click on Test - I am getting the two red crosses against historic and current.
Any suggestions?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Scott Meehan on 15 Dec, 2015 01:32 PM
Hi Mark,
Unfortunately Yahoo doesn't appear to be making UK mutual fund prices (among other data) available for download for some reason, even though they're showing up on their website. There's a suggestion on Yahoo's support area for them to re-add these funds back for download, which you can vote for here:
https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/64...
Unfortunately you'll have to enter prices manually until they re-enable downloads for these accounts.
I'm sorry for the inconvenience! Please let us know if we can be of further assistance!
Scott Meehan
Infinite Kind Support
Scott Meehan closed this discussion on 15 Dec, 2015 01:32 PM.
Mark H-A re-opened this discussion on 16 Dec, 2015 06:55 AM
2 Posted by Mark H-A on 16 Dec, 2015 06:55 AM
What a pain!
If I set up a personal portfolio on Yahoo Finance with all my funds etc. I can then download the prices into an excel CVC file.
Is there a way for me to import these in one go into MD rather than individually? I was hoping I might be able to cut and paste the whole lot in one go.
The security prices extension seems only to be able to take one price at a time before applying to the MD portfolio. So it is helpful - but could be better!
3 Posted by Scott Meehan on 16 Dec, 2015 03:37 PM
Hi Mark,
Yes, you can import a CSV of prices by going to Tools -> Securities, then double clicking on the security that you want to import the prices for, then clicking the Import button on the window that opens.
Scott Meehan
Infinite Kind Support
4 Posted by Douglas on 21 Dec, 2015 08:51 PM
Hi mark
Have a look at https://bitbucket.org/mikerb/moneydance-2015/wiki/Extensions
I use mike's security price load to load csv price file from the ft Web site, would expect yahoo to work also
Douglas
5 Posted by Mark H-A on 04 Jan, 2016 11:25 AM
Douglas - many thanks - works perfectly. FT website much better (and was using before anyway so already more or less up to date) as Yahoo did not have some of my funds priced.
What is has thrown up though is that a handful of the FT quotes have the wrong extensions on the symbols - so the valuations are either 100 times too high or 100 times too low - just on a handful. Have told FT to get it fixed - whether that works or not who knows. But not a big job to correct anyway in MD in the meantime.
Thanks again.
Yours - a happy MD user again!
System closed this discussion on 04 Apr, 2016 11:30 AM.