Quotes not updating

Rob's Avatar

Rob

04 Apr, 2017 08:05 PM

Hi

My quotes are not updating my Security/stock prices. It stopped updating a month ago and I have checked all the obvious options without success. Exchange rates update but the securities get an error message 'Error downloading...no data found'. I have run the Test but just get X History X.

Any help most welcomed

Showing page 6 out of 6. View the first page

  1. 151 Posted by yardy on 11 Nov, 2017 07:52 PM

    yardy's Avatar

    Jim, I would be interested also if you care to share.

    Ray

  2. 152 Posted by Jim Kuhn on 11 Nov, 2017 07:58 PM

    Jim Kuhn's Avatar

    I hacked this together on Nov 1st. Two scripts (since the python built
    into MD2017 had some problems with https)... one to download the prices and
    one to import. It'll get me through until the proper support is in place.
    Caveat emptor.

    *To download current and previous few days (simplified):*

    import json
    import requests
    import string

    securityList = [ "agu.to", "msft" ]

    for security in securityList:
        r = requests.get('
    https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol='
    + security + '&apikey=YOUR_API_KEY')
        data = r.json()
        ts = data["Time Series (Daily)"]
        items = sorted(list(ts.items()), reverse=True)[:19]
        for item in items:
            print(security, str(item[0]).translate(str.maketrans('', '', '-')),
    item[1]["5. adjusted close"], item[1]["6. volume"])

    *The python script in MD:*

    from com.infinitekind.moneydance.model import *

    book = moneydance.getCurrentAccountBook()
    currencies = book.getCurrencies()

    usd = currencies.getCurrencyByName("US Dollar")
    if not usd:
    print "NO USD"
    exit

    file = open("/tmp/prices.out", "r")
    lastsym = ""
    for line in file:
    vals = line.split()
    symbol = vals[0].split(".")[0]
    date = vals[1]
    if float(vals[2]) < 0.001:
    continue
    price = 1.0 / float(vals[2])
    if symbol != lastsym:
    security = currencies.getCurrencyByTickerSymbol(symbol)
    if not security:
    continue
    lastsym = symbol
    print "Set", security.getTickerSymbol(), "to", 1 / price
    if len(vals[0].split(".")) == 1:
    security.setUserRate(price, usd)
    else:
    security.setUserRate(price)
    security.syncItem()
    print date, 1 / price
    if len(vals[0].split(".")) == 1:
    snap = security.setSnapshotInt(int(date), price, usd)
    else:
    snap = security.setSnapshotInt(int(date), price)
    snap.setDailyVolume(long(vals[3]))
    snap.syncItem()

  3. 153 Posted by George on 11 Nov, 2017 08:20 PM

    George's Avatar

    I am a new user and successfully (mostly) transferred My quicken (Windows) data to Moneydance. But I am not able to update my security prices. It seems there are issues but, while I'm not a total novice, most of the discussions are beyond my understanding. I like what I see of the program but if I can't update security prices it won't be very useful. Any help would be much appreciated.

  4. 154 Posted by yardy on 11 Nov, 2017 09:45 PM

    yardy's Avatar

    George, Welcome to MD. Yahoo and Google stopped allowing MD to get stock data on Nov 1. MD says they are working to fix the extension to go to other sources for this data. I suggest you read some more of the entries in this Blog to get the flavor of the situation.

    Ray

  5. 155 Posted by JimRB on 29 Nov, 2017 07:14 PM

    JimRB's Avatar

    Hi yardy
    My stocks were all updating until 21 November. Today is the first I realised they were not working any more!

    IK support staff - why was this not included on your blog? I spent some time trying different things to get my extension to work before coming to the forum to see whether I was the only one.

  6. 156 Posted by bonniemitch on 23 Jan, 2018 06:12 AM

    bonniemitch's Avatar

    My stocks do not update anymore either. I have installed the latest MD and extension.

  7. 157 Posted by derekkent23 on 23 Jan, 2018 09:45 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Can you provide more information.

    You don’t state what build of Moneydance 2017 you are using. You can check version/build under HELP – ABOUT MONYDANCE. For example I am running 2017.7(1663). Also what version of the Q & ER are you using see under EXTENSION – MANAGE EXTENSIONS.
    Can you also proved say three security symbols and their names to test?

    Hope this helps

  8. 158 Posted by TAM on 30 Jan, 2018 03:01 PM

    TAM's Avatar

    Considering switching to MoneyDance. Downloaded the application and migrated data from Quicken yesterday HA says 2017.6 (1656) and claims to be current. I have 300 plus securities. If I update 50 at a time using the Quotes & Exchange Rates extension, things update fine. If I try to update all at the same time, only 100 quotes are obtained and then it bombs out. 167 skipped, 33 errors, 100 quotes.

  9. 159 Posted by gray256 on 20 Feb, 2018 06:15 PM

    gray256's Avatar

    TAM, I am another user - not staff. I saw your query from 1/30/18 regarding updating 100+ quotes at once. When I look at the API documentation for the Alphavantage service (used by the Quotes Updater in Moneydance), the BatchStockQuote function says: "Up to 100 stock symbols seperated by comma. For example: symbols=MSFT,FB,AAPL. If more than 100 symbols are included, the API will return quotes for the first 100 symbols." So I am guessing that the author of the app needs to take this into consideration.

  10. System closed this discussion on 22 May, 2018 06:20 PM.

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