Alphavantage errors for UK shares
I am now using the new Aphavantage extension which appears to work but throws up some irritating errors. I have a number of UK investment trusts which are being updated by the extension. The two problems are:-
1. Some shares require the 'stock exchange' parameter to be London Exchange (GBP) and others London Exchange (pence). I can't see any obvious reason why.
2. Many of the historical values show Volume = 0 for each day and values which are slightly too high. At a guess the values could in US $ rather than UK £.
An example is the share 'Aberforth Smaller Companies' with ticker ASL.
I have had to do considerable manual editing to tidy up the data.
Please investigate these errors.
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 Dec 31, 2017 @ 11:34 AM
I am not support staff, just a user.
You are not the only one with this problem. See this tread starting at post 9 http://help.infinitekind.com/discussions/problems/40198-stock-price.... I have stopped using the Q & ER extension and am now using a standalone free program to generate quotes. It’s consistent and reliable. And has a far better coverage of UK funds.
Hope this helps
2 Posted by derekkent23 on Jan 01, 2018 @ 11:25 AM
I am not support staff, just a user.
For anyone who is interested take a look at this thread on a third-party Quote and Exchange Rate Program from hleofxquotes.
http://help.infinitekind.com/discussions/investments/3036-third-par...
Hope this helps.
3 Posted by mxpitt on Jan 03, 2018 @ 10:09 PM
Derek - thanks for update which I'll investigate if this issue is not resolved by MD staff.
Update to my previous comments.
1. I had to change all the 'Stock Exchange' parameter to London Exchange (pence). The current values are now mostly correct after re-running the extension.
2. There is still a time anomaly. On some occasions the current value is 1/100 of the correct value. Example Albion Enterprise ticker AAEV.
3. The historical values are still about 12% too high for almost all stocks.
4 Posted by derekkent23 on Jan 03, 2018 @ 10:29 PM
I am not support staff just a user.
mxpitt I would appreciate if you took a look at this third-party Quote and Exchange Rate Program from hleofxquotes. Even if you don't import the data into Moneydance I would like your opinion on its accuracy. See thread http://help.infinitekind.com/discussions/investments/3036-third-par...
5 Posted by murkee on Jan 04, 2018 @ 11:46 AM
Yeah, the pence/pounds thing drove me crazy - good news is that by tweaking it you can fix the massive enrichment/near bankruptcy scares that results as the historical data is fixed (with a short delay)
6 Posted by mxpitt on Jan 09, 2018 @ 09:29 PM
Derek
The hleofxquotes application works fine on the UK stocks that I have tried. Many thanks. As explained in the documentation it gives the present values. However, I do need the historical values as well - mainly to sort out the incorrect values generated by the Aphavantage extension.
7 Posted by derekkent23 on Jan 09, 2018 @ 10:28 PM
I am not support staff, just a user.
Hi, have you seen the new PDF in post 3 at http://help.infinitekind.com/discussions/investments/3036-third-par...
It outline setting up a default local currency. Once done all GPX/GBP quotes will be in GBP. To prevent the conversion, you now add /GBX/GBX
Can I get you to post your finding in that thread to consolidate the finding of users.
Thanks
If you post in that thread the developer of the program will read your request for price history and possible comment on the feasibility.
Hope this helps.
8 Posted by mxpitt on Jan 11, 2018 @ 08:40 PM
I have done some analysis of the errors in the historical data generated by the Aphavantage extension. It looks like it's picking up the NAV value rather than the share price. For some investment trusts the discount or premium can be 10% or so which makes the errors very obvious. I'm only looking at London based shares so I can't say if the problem applies to other exchanges.
Anyone care to comment or check if it's the case with their stocks?
IK support - please check if this explains the errors.
Matthew
9 Posted by mxpitt on Feb 11, 2018 @ 08:43 PM
Update to my previous comments-
The current values of all the shares are now being picked up correctly which is good news. However, the historical values are wrong and as I have explained before appear to be the NAV (net asset values). In each row high = low = price and volume = 0.
IK support - please look at the following.
1. Check how the NAV values are being picked up rather than the actual share values.
2. Could you include start date - end date parameters in the extension so that only the values required are picked up rather than 3 month's worth.
3. Is there some way to broadcast the present problems with this extension and the status of its further development. More and more threads are being created by frustrated users who are all 'discovering' the issues without realising that the problem is well known.
Thanks
Matthew
System closed this discussion on May 13, 2018 @ 08:50 PM.