Alphavantage Issues
I have just installed the new Quotes and Exchange Rate extension. I am a UK user, with the latest version of MD. I have several issues, and will address them one at a time. Some of the share price data is inaccurate, particularly the historical data for some of the investment trusts. The current price data seems to be OK, over a whole range of stocks. I spent some time correcting the historical stuff, but when I next downloaded the security quotes, it reverted to the original (grossly inaccurate) data. In other words, all the data I put in was overwritten!
So, a simple question: Is it possible to update current share prices without the historical ones (which overwrite existing values!)?
Thanks in advance for any thoughts!
Neil
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 derekkent23 on 03 Jan, 2018 10:48 PM
I am not support staff, just a user
I am a UK investor and have found that Alpha Vantage provide very poor support for UK/Irish/Luxenberg etc, domiciled funds. For these Securities the data often seems to be inaccurate and switch between Pounds and Pence then back again. So, I have stopped using the extension.
I am currently testing a stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The developer is in the beta stages of adapting it to work with Moneydance. When I say beta, this build as far as I can see is very stable and the quotes very consistent. No strange prices or for UK funds switching back and forward between Pence and Pounds. It has a lot of useful features. These include, obtaining prices from many stocks and fund quoted on different exchanges. The ability to convert quotes from one currency to another. Convert prices in Pence to Pounds, if required, for UK stocks and funds. Provide a means for importing all this data into Moneydance. Importing exchange rates. It only updates the current and dated prices for the last trading day. It does not include history. You can also see the quotes before you import them into Moneydance.
It simple to use. See the PDF and link to the developer web site in this thread http://help.infinitekind.com/discussions/investments/3036-third-par...
Please try the program and post your findings in that thread.
Hope this helps
2 Posted by Neil Barrett on 04 Jan, 2018 01:52 PM
Many thanks. I have tried the software you mention, using several "dummy" stocks. It seems to work fine, but when I try to load the .QIF file into MD, nothing happens. No confirmation, no error messages and no data uploaded. Any thoughts?
By the way, do you know how I might get a response to my query about overwriting historical share prices from IK? With the old Extension, you could turn off the historical prices and just download the current price.
Thanks again
3 Posted by derekkent23 on 04 Jan, 2018 02:26 PM
I am not support staff, just a user.
Interesting, I have imported QIF data many times during testing.
Which import method did you use drag and drop or FILE – IMPORT select the QIF file then OPEN.
Which operating system is your computer using?
Were the dummy stocks set up in Moneydance including their symbols. Where the dummy stock then added to an investment account and then shares purchased for the dummy stocks?
Hope this helps.
4 Posted by Neil Barrett on 04 Jan, 2018 06:03 PM
Thanks again. I used the QIF file import method, and the dummy values did in fact relate to some of the stocks I own, with the correct ticker codes. I think that I might have an issue because I did not tick the appropriate boxes relating to file associations when I updated MD. Do you know how I can set up the correct file association?
Thanks in advance.
5 Posted by derekkent23 on 04 Jan, 2018 06:26 PM
I am not support staff, just a user.
I am not clear on what you are saying?
Were you updating the prices for securities you already own?
Or did you add a set of test securities and a test investment account to Moneydance to put them in?
If it’s the first case you don’t need to add any securities or test investment account. In the Moneydance import window just select an investment account. It doesn’t even have to be the one the securities are in. If the PDF is not clear on this point, let me know. Appreciate your feedback.
When you talk about file association are you talking about the list of files with tick boxes you can untick, listed during Moneydance installation. If yes and you want to make sure all the boxes were ticked just install Moneydance again.
Did the process of obtaining the quote using the stand-alone program work? Any observations. I am trying to get a picture to how easy the program is to use and how accurate the results are?
6 Posted by Neil Barrett on 04 Jan, 2018 10:22 PM
Thanks - and sorry for any ambiguity. My test securities were the ones I have in MD, and I did not set up another account. I reinstalled MD, and ticked all the "association" boxes. I suspect that this did not really help, all it did was to fire up MD when you double click the QIF file.
I think the real cause of my problem was that the ticker codes did not match. In MD, I had not used the .L extension to indicate the London exchange. Once I had edited these to match those of the downloading programme, things went smoothly. Most of the shares (30) I downloaded went into the box, which I then converted to the QIF and imported into MD (by double clicking the QIF file icon!).
Three shares did not seem to download into the standalone software - see attached file. However, one I removed the .L extension, there was no problem! So I guess that I will need to remove them in MD as well.
I need to do quite a bit more testing, and will take a look at my UK OEICS in the next couple of days. Hitherto, it has been an absolute impossibility to get them to update in MD!
Thanks again for your patience.
Your pdf is quite clear by the way.
7 Posted by hleofxquotes on 04 Jan, 2018 11:25 PM
Neil,
Re: the 3 with no prices initially (for example PETS.L). If you really want to keep it as PETS.L on MD side, you can do the following
* Specify it as
PETS.L/PETS/GBX/GBP
PETS (is the quote source symbol) which will be used to ask for the price
PETS.L (is the app symbol) which will be used to write to the QIF file
When you export to the QIF file, you should see something like this
!Type:Prices
"PETS.L",1.6410,"1/4'2018",,,
Best,
8 Posted by derekkent23 on 05 Jan, 2018 11:40 AM
I am not support staff, just a user.
I am not sure when a symbol need or does not need an stock exchange symbol on the end.
In the list visible in your screen shot only “BT” requires an stock exchange symbol “.L”, the rest don’t need “.L” to return a price. However, if you check on the FT web site the BT correct symbol seems to be BT.A:LSE. But both BT.A:LSE and BT.L in the program returns the same price. I am not clear on what the rule are. If I have problems with a symbol that does not return a price I use “Search Security” feature on the FT site.
What is important is the symbol you use to get the quote in the program and then the symbol used in the exported file is the one used in Moneydance. Normally this is done by using the same symbol.
However, Hleofxquotes tip for converting symbols is a great one. I will include it in the PDF the next time I update it.
Can I encourage you to add your impressions and any other finding when you do further testing into the thread at http://help.infinitekind.com/discussions/investments/3036-third-par...
So as to keep that thread current.
Thanks for the feedback.
9 Posted by Neil Barrett on 05 Jan, 2018 05:49 PM
Thanks hleofxquotes for the useful comments about the .L extension. I have already removed it in MD and hleofxquotes for the three stocks, and everything is now fine.
Thanks also Derek for your comments. I have posted my impressions on the other thread as requested.
Best regards,
Neil
System closed this discussion on 06 Apr, 2018 05:50 PM.