Quotes not Updating

scott's Avatar

scott

07 Jul, 2018 04:17 PM

I have many stock and mutual funds. I update them weekly with the Quotes and Exchange Rates Extension. I see that a lot of the investments are not being updated. Looking in the log file, I see this:

getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=HYG&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=MDIJX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=BABA&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VB&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=EMB&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CMOZX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VNQ&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VTV&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=IGLIX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=GOGIX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=LBDFX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CLAZX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CBALX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FOPIX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=LSIZX&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VMBS&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=AMLP&apikey=73S7YN26J1STWSN7&datatype=csv
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=PONAX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=DXJ&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VINIX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=PCBIX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FDL&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=EFA&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FSRIX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CREFbond&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CREFequi&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=JMGRX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VONG&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FDX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VWO&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=SMVTX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=PJGQX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FTR&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=DJP&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CREFglob&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=SPY&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=QQQ&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VEVIX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=WFMIX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=VEIRX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=IVV&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=LQD&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=CRAZX&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }
getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TIP&apikey=73S7YN26J1STWSN7&datatype=csv
Import error: skipping invalid line: "Information": "Please consider optimizing your API call frequency."
Import error: skipping invalid line: }

  1. 1 Posted by derekkent23 on 07 Jul, 2018 06:37 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    You don't state the build of the Q & ER you are running.
    There is a new build perhaps you need to update.
    Start reading this thread from the post in this link. http://help.infinitekind.com/discussions/problems/45627-cannot-upda...

    Hope this helps

  2. 2 Posted by scott on 07 Jul, 2018 11:33 PM

    scott's Avatar

    That did it for me. I was running v1009. Now I'm running v1018, and it seems to update everything, though it takes forever. Not a big deal, though. I'm usually only in the program once a week, so I'm in there a while entering new transactions and such.

    Thanks.

  3. 3 Posted by scott on 04 Aug, 2018 02:40 PM

    scott's Avatar

    And it's broken again :(

  4. 4 Posted by derekkent23 on 04 Aug, 2018 03:42 PM

    derekkent23's Avatar

    I am not support staff, just a use.

    Hi Scott

    Perhaps time to try a new way of obtaining quotes and importing them into Moneydance.

    I have given up on the Q & ER extension.

    I am using a free stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The program is in java, like Moneydance and thus runs on Windows, Mac and Linux computers.

    I have taken you’re the first 8 and last 2 symbols and entered them into the stand alone-program and all 10 return prices in less than 6 seconds, see screen shot.

    Take a look at his thread and download the PDF outlining how to use the program and link to download the program. Post 236 in this thread.
    http://help.infinitekind.com/discussions/investments/3036-third-par...

    Let us know how this program performs for you and post if you have any problems setting it up and I will get you up and running.

    It’s a good idea to click on the “SUBSCRIBE TO UPDATES” button to you are cheap up to date including when new builds are available.

    Hope this helps

  5. 5 Posted by scott on 04 Aug, 2018 11:28 PM

    scott's Avatar

    I found a work-around that's annoying, but I can live with it. I go into the extension and only check a few securities at a time, click update, then wait about twenty seconds and do another set of securities. It tedious, but gets the job done eventually. I only have about 50 securities. Doing three at a time only takes about 6 minutes. I haven't yet experimented with how many I can do in one batch. Reading other posts seems to indicate it might be 5, but that didn't seem to work. I haven't tried 4 at a time yet.

  6. 6 Posted by derekkent23 on 05 Aug, 2018 07:17 AM

    derekkent23's Avatar

    I am not support staff, just a use.
    Hi Scott

    Wow, that sounds like a lot of hard work, time consuming and very hit and miss.
    I will stick with the fast and simple work-round, the stand-alone program.

  7. System closed this discussion on 04 Nov, 2018 07:20 AM.

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

Recent Discussions

04 Mar, 2024 08:05 PM
04 Mar, 2024 08:02 PM
04 Mar, 2024 03:16 PM
04 Mar, 2024 01:28 PM
04 Mar, 2024 12:58 PM