Alpha Advantage limit of 5 API calls per minute

vseaslcm's Avatar

vseaslcm

22 Jul, 2018 06:02 PM

Stock price updates through Alpha Advantage are now showing the following error after 5 successful API calls:

Import error: skipping invalid line: "Information": "Thank you for using Alpha Vantage! Please visit https://www.alphavantage.co/premium/ if you would like to have a higher API call volume."

It appears that the "free" API key only provides up to 5 API calls per minute. The premium link in the Alpha Advantage site costs $19.99 per month for up to 15 API calls per, and significantly more for higher call volumes (see attachment).

What is IK's response to this limitation for updating stock price history?

  1. 1 Posted by dwg on 22 Jul, 2018 09:38 PM

    dwg's Avatar

    I suspect we can now see what AlphaVantage's business model is, Get the disaffect Yahoo users in and then once settled they either pay up or get throttled right back to make it painful.

    It looks like that the Q&ER extension may need to be a background task that can just plod along.

  2. 2 Posted by thedanc on 05 Aug, 2018 09:58 PM

    thedanc's Avatar

    FWIW, I'm ok with 5API calls per minute because I'm querying after market close and can let this run in the background while I do other work, but the Quotes and Exchange Rates tool needs to account for this. What a POS. I go and get quotes and then get a summary saying that there were 40 errors. A smarter app would keep a list of what failed and then let me retry them. A smarter app would adjust the rhythm to one request every 12 seconds so as to be license compliant. Is there any hope of improving this?

  3. 3 Posted by thedanc on 07 Aug, 2018 04:42 AM

    thedanc's Avatar

    That five per minute rule is true. It took me a very long time to download 70 quotes, four at a time, MANUALLY.

  4. 4 Posted by Bob on 07 Aug, 2018 07:17 AM

    Bob's Avatar

    We need to have it only update the stocks and exchange rates that you want - so you can cut down the number of calls.

    e.g. I am only interested in 1 exchange rate from £ to $. I don't need all the other calls.

    This is almost back to the situation we had when the stock updates broke last time.

  5. 5 Posted by -Kevin N. on 07 Aug, 2018 02:00 PM

    -Kevin N.'s Avatar

    Hi All,

    Take a look at this post from forum member derekkent23
    http://help.infinitekind.com/discussions/investments/3036-third-par...

    His attached .pdf is very thorough. It all looks a little daunting at first but it's quite simple and easy to run once it's set up.

    The hleofxquote tool works with Yahoo and FT.

    I gave up on Alpha Vantage. I've been using a combination of Mike Bray's Security Price Loader and a CSV generated from a portfolio created at yahoo.finance.

    @Bob, I think if you delete all of the extraneous currencies from Moneydance, it will only look up the one(s) that remain. You may want to try this on a copy of your data file first.

    -Kevin N. (not a member of MD support)

  6. 6 Posted by Bob on 07 Aug, 2018 09:59 PM

    Bob's Avatar

    @Kevin N - Thanks. Deleting the currencies makes a big difference.

  7. 7 Posted by Bob on 07 Aug, 2018 10:01 PM

    Bob's Avatar

    Hi Kevin. Thanks. Your suggestion to delete un-needed currencies helps a lot.

  8. 8 Posted by -Kevin N. on 07 Aug, 2018 11:10 PM

    -Kevin N.'s Avatar

    HI Bob,

    You're welcome. I'm glad to hear that it helped.

    Thank you for reporting back with your results.

    -Kevin N. (not a member of MD support)

Reply to this discussion

Internal reply

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

Attaching KB article:

»

Already uploaded files

  • Screen_Shot_2018-07-22_at_10.49.17_AM.png 68.4 KB

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