Quotes extensions error

Darrel's Avatar

Darrel

07 Jun, 2017 12:15 PM

The quotes extension (v1001) seems to work OK for me except when it tries to download the current price of one specific stock.
The ticker is LON:BT.A https://www.google.co.uk/finance?q=LON%3ABT.A and it seems to be the "." which is causing the problem as none of my other stocks have this and they all work. The error message is "no data found".

  1. Support Staff 1 Posted by Henry on 07 Jun, 2017 02:58 PM

    Henry's Avatar

    Hi Darrel,

    Thank you for contacting us.
    We've been looking into this issue and it seems all customers are encountering 400 and 500 errors - 404, 502 or 504.
    A Yahoo support representative has confirmed that Yahoo Finance API has been discontinued.
    From the changes that have been made, it seems like Yahoo is trying to prevent people from automated downloading like Moneydance (and so many others) are doing.

    Our lead developer has mentioned that we may be able to make a change, that means the Moneydance connection will pose as a browser, rather than a program. This may allow the connection. However, it seems very likely that this will turn into a 'cat-and-mouse' game.

    The current workaround is to download the quotes in a cvs file and import them by navigating to Tools > Securities > Edit then Import.

    We are looking into other services we can use instead to resume the automatic downloads.

    Henry
    Infinite Kind Support

  2. 2 Posted by D L Thornton on 07 Jun, 2017 03:08 PM

    D L Thornton's Avatar

    Hello

    Thanks for getting back to me.

    I've been following that issue but it does not seem to be the same as mine.

    Historical prices are not an issue as I use the Google server for those
    and these are still working well (with a couple of exceptions but I'm
    not really interested in historical data anyway).

    My problem only affects one *current* price, that of ticker LON:BT.A

    I have about 40 stocks and all *current* prices work fine for them using
    the Yahoo USA server, except this one which is the only one to have a
    "." in its name. This is why I suspect that the problem is to do with
    parsing the "." in the URL that requests the data.

    Thanks.

  3. Support Staff 3 Posted by Henry on 07 Jun, 2017 04:08 PM

    Henry's Avatar

    Hi Darrel,

    I've checked the direct ticker and I am wondering if it works when you change the ticker to BT.A
    You can do this by navigating to Tools then Securities double-click on the security and select edit.

    Please let me know if this helps with the issue.

    Henry
    Infinite Kind Support

  4. 4 Posted by D L Thornton on 07 Jun, 2017 05:48 PM

    D L Thornton's Avatar

    Hello Henry

    Sorry, I wasnt very clear. The ticker as used by Google is LON:BT.A but
    in Moneydance I use just BT.A

    As I mentioned, the only difference between this stock and all my others
    (which all work perfectly) is that this one contains a "."

    Thanks.

    Darrel

  5. 5 Posted by dbaizenman on 11 Jun, 2017 09:06 PM

    dbaizenman's Avatar

    This comment was split into a new private discussion: Quotes extensions error

    I'm using the text format importer and its all appearing double. any advice?

  6. Support Staff 6 Posted by Henry on 12 Jun, 2017 11:55 AM

    Henry's Avatar

    Hi Darrel,

    Please accept my sincere apologies for the delay getting back to you.
    While testing different configurations, I found that Editing the Security in the Quotes and Exchange Rate extension forced the download.
    Can you navigate to 'Extensions' then select 'Quotes and Exchange Rate' that will open the 'Quotes and Exchange Rate' window there please make sure that the Security is checked and that the ticker symbol listed there is BT.A, if not you can double-click on that section of the window and edit it, the Stock exchange column should be set to default. Once that is all set that way and Historical Security prices are set to Google Finance, you can click on 'update now'.

    Please let me know how it goes.

    Henry
    Infinite Kind Support

  7. 7 Posted by Darrel on 12 Jun, 2017 03:42 PM

    Darrel's Avatar

    Hello Henry

    Thanks for getting back to me.

    BT.A is correctly set as the ticker. However "default" for the exchange
    returns prices in USD which is incorrect. I have to set the exchange as
    "London - pence" for all my UK stocks to get the correct prices.

    Thanks.

    Darrel

  8. Support Staff 8 Posted by Henry on 12 Jun, 2017 03:51 PM

    Henry's Avatar

    Hi Darrel,

    Thank you for reporting back and explaining how you got the right prices.
    I'll close this discussion for now.

    Have a great day!

    Henry
    Infinite Kind Support

  9. Henry closed this discussion on 12 Jun, 2017 03:51 PM.

  10. Darrel re-opened this discussion on 12 Jun, 2017 03:56 PM

  11. 9 Posted by Darrel on 12 Jun, 2017 03:56 PM

    Darrel's Avatar

    Hello Henry

    Sorry, I wasn't clear. The problem is not solved. Nothing has changed.

    Everything works well except this one stock: BT.A It is the only
    stock to have a "." in the ticker.

    I have to select "London - pence" as the exchange for all my UK stocks
    or the prices returned are wrong. If I set default as the exchange for
    BT.A I do get a price, but it is the wrong price and is in USD not GBP.
    Therefore I cannot do this. Selecting "London - pence" for BT.A just
    results in an error with no current price being downloaded at all.

    Thanks.

    Darrel

  12. Support Staff 10 Posted by Henry on 14 Jun, 2017 12:35 PM

    Henry's Avatar

    Hi Darrel,

    I can confirm, that I'm seeing the same on my end after several attempts and comparing the price.
    As the lead developer is working on a complete solution for the automatic downloads through the Quotes and Exchange Rate extension, I have no direct workaround for this issue besides entering the current price using the Security Price Entry extension form the Extension menu for that specific Security.

    Henry
    Infinite Kind Support

  13. 11 Posted by dbaizenman on 14 Jun, 2017 08:13 PM

    dbaizenman's Avatar

    Running into a problem with my cash. If I categorize it as "ATM withdrawal: cash" it presents as a negative amount under expenses. Then im not sure how to make it spent.
    I would prefer to just consider an expense.

    Sent from my iPhone

    On Jun 14, 2017, at 8:35 AM, Henry <[email blocked]<mailto:[email blocked]>> wrote:

  14. Support Staff 12 Posted by Ethan on 14 Jun, 2017 08:49 PM

    Ethan's Avatar

    Hello,

    In what account are you making this categorization? For example, you are saying you enter in a transaction withdrawing $100 from your bank account, and this is not showing up correctly as an expense?

    Ethan
    Moneydance Support

  15. 13 Posted by dbaizenman on 14 Jun, 2017 08:51 PM

    dbaizenman's Avatar

    Yes from a checking account

    Sent from my iPhone

    On Jun 14, 2017, at 4:49 PM, Ethan <[email blocked]<mailto:[email blocked]>> wrote:

  16. 14 Posted by dbaizenman on 14 Jun, 2017 09:31 PM

    dbaizenman's Avatar

    When I create an income expense report (detailed) i receive the ATM withdrawal as a negative expense. And then under the title cash the same amount of the withdrawal appears as an expense.

    For some odd reason, it doesn't seem that is throwing my balances out of wack. It seems that I'm missing something fundamental.

    Please advice,
    Dov

    Sent from my iPhone

    On Jun 14, 2017, at 4:49 PM, Ethan <[email blocked]<mailto:[email blocked]>> wrote:

  17. 15 Posted by dbaizenman on 14 Jun, 2017 11:36 PM

    dbaizenman's Avatar

    What I discovered if I try to delete the negative expense it will automatically delete the expense. Please advise.

    Sent from my iPhone

    On Jun 14, 2017, at 4:49 PM, Ethan <[email blocked]<mailto:[email blocked]>> wrote:

  18. 16 Posted by Darrel on 15 Jun, 2017 08:48 AM

    Darrel's Avatar

    Hello Henry

    Thank you for the update. I hope that your developer will take into
    consideration this small glitch.

    Darrel

  19. 17 Posted by Darrel on 07 Aug, 2017 04:00 PM

    Darrel's Avatar

    I see that version 1002 of the stock quote extension has been released. I installed it hoping that it might fix the problem with the BT.A ticker, but unfortunately it doesn't.

    I still suspect that the problem stems from a parsing error in relation to the "." in the ticker symbol.

  20. 18 Posted by Patrick on 17 Sep, 2017 12:43 AM

    Patrick's Avatar

    I am also a fan of the stock quote extension, but alas, even with the new version, it still looks like download problems. Eagerly awaiting a fix :) By the way, a quick google search for "API for stock quotes" showed up a number of free options outside of Yahoo...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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