Stock prices were downloaded with wrong multiplier, and overwrotedata since August! Every download seems to be different multiplier.

JimRB's Avatar


29 Dec, 2017 07:11 PM

This is just strange.
MoneyDance 2017.6 (1656)
Quotes and Exchange Rate updater v1012
Changed to Alphavantage early December - appeared to be working fine apart from one stock.

Just updated all the stocks today, to find my net worth had soared to sky-high levels. Sadly an illusion. The Q&ERU had multiplied about half my stocks by 100. Not only that, but previously updated stocks had their history changed back to August 2017.
I have gone through each one and deleted the erroneous data, then gone into the Updater tool, right clicked and yes, every single one of them had the correct 0.01 multiplier already showing. I have changed nothing, re-downloaded the prices and they are all correct. Net Worth sadly collapsed again.

This makes no sense whatsoever.

  1. 1 Posted by JimRB on 30 Dec, 2017 03:45 PM

    JimRB's Avatar


    I have just been entering prices to match statements from my broker, and find that one of the shares has suddenly multiplied itself by 0.01, having been correct before. So I deleted those erroneous figures, corrected the multiplier, and set the whole portfolio to download again.

    ALL THE OTHER SHARES have now got a 1x multiplier applied to them. Yesterday they were correct. Worse, they have all OVERWRITTEN all of the data back to August .
    So I changed that one to be pence, and redownloaded. That one was still wrong, but the others were now overwritten with the correct data.
    I changed that one back to pounds, and the multiplier shows as 0.01. Now they download correctly.

    How can I get this to work correctly ALL of the time, not just when it feels like it?

    Surely it should not overwrite previous data? This seems a VERY bad thing to be able to do.

  2. 2 Posted by derekkent23 on 31 Dec, 2017 11:32 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    You are not the only one with this problem. See this tread starting at post 9 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

  3. 3 Posted by JimRB on 31 Dec, 2017 05:21 PM

    JimRB's Avatar

    Thanks Derek. I shall try that out. I guess that means showing the Moneydance extension to update currencies, and the program for prices.

  4. 4 Posted by derekkent23 on 31 Dec, 2017 05:39 PM

    derekkent23's Avatar

    I am not support staff,just a user.

    I am about to release the next beta version from the developer. It includes among other things the ability to obtain specified exchange rates, as well as Security quotes and import them into Moneydance. I think I will start a thread in the “Investment” section so I can direct interested user to one thread. So, keep a look out.

    Hope this helps.

  5. 5 Posted by JimRB on 31 Dec, 2017 07:47 PM

    JimRB's Avatar

    It certainly does. Thanks.

  6. 6 Posted by sprimost on 31 Dec, 2017 08:50 PM

    sprimost's Avatar

    From: sprimost

    I am not support staff, just a user.

    Now...this seems interesting...something new from Alphadvantage?

    Dear Alpha Vantage Community,
    At the turn of the new year, we are proud to announce an exciting new
    API for multi-symbol stock quotes, an enrichment to our
    symbol-specific time series and technical analysis APIs.
    *Alpha Vantage Multi-Symbol Batch Stock Quotes*
    _Example (JSON)_,FB,AAPL&apikey=demo
    _Example (CSV)_,FB,AAPL&apikey=demo&datatype=csv
    Your continued feedback and support are of utmost importance to us! We
    are looking forward to growing the Alpha Vantage global community with
    you in the year 2018 and beyond.
    Warmest regards,
    Team Alpha Vantage
    Team Alpha Vantage
    Alpha Vantage Inc. , Boston, MA 02163

  7. 7 Posted by derekkent23 on 01 Jan, 2018 11:22 AM

    derekkent23's Avatar

    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.

    Hope this helps.

  8. System closed this discussion on 02 Apr, 2018 11:30 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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