tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/64001-alpha-advantage-limit-of-5-api-calls-per-minuteInfinite Kind: Discussion 2019-01-18T14:20:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-07-22T21:38:28Z2018-07-22T21:38:28ZAlpha Advantage limit of 5 API calls per minute<div><p>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.</p>
<p>It looks like that the Q&ER extension may need to be a background task that can just plod along.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-05T21:58:09Z2018-08-05T21:58:09ZAlpha Advantage limit of 5 API calls per minute<div><p>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?</p></div>thedanctag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T04:42:44Z2018-08-07T04:42:44ZAlpha Advantage limit of 5 API calls per minute<div><p>That five per minute rule is true. It took me a very long time to download 70 quotes, four at a time, MANUALLY.</p></div>thedanctag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T07:17:59Z2018-08-07T07:18:00ZAlpha Advantage limit of 5 API calls per minute<div><p>We need to have it only update the stocks and exchange rates that you want - so you can cut down the number of calls.</p>
<p>e.g. I am only interested in 1 exchange rate from £ to $. I don't need all the other calls.</p>
<p>This is almost back to the situation we had when the stock updates broke last time.</p></div>Bobtag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T14:00:36Z2018-08-07T14:00:36ZAlpha Advantage limit of 5 API calls per minute<div><p>Hi All,</p>
<p>Take a look at this post from forum member derekkent23<br>
<a href="http://help.infinitekind.com/discussions/investments/3036-third-party-quote-and-exchange-rate-program-from-hleofxquotes/page/8#comment_45780093">http://help.infinitekind.com/discussions/investments/3036-third-par...</a></p>
<p>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.</p>
<p>The hleofxquote tool works with Yahoo and FT.</p>
<p>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.</p>
<p>@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.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T21:59:00Z2018-08-08T05:06:49ZAlpha Advantage limit of 5 API calls per minute<div><p>@Kevin N - Thanks. Deleting the currencies makes a big difference.</p></div>Bobtag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T22:01:36Z2018-08-07T22:01:37ZAlpha Advantage limit of 5 API calls per minute<div><p>Hi Kevin. Thanks. Your suggestion to delete un-needed currencies helps a lot.</p></div>Bobtag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-07T23:10:11Z2018-08-07T23:10:11ZAlpha Advantage limit of 5 API calls per minute<div><p>HI Bob,</p>
<p>You're welcome. I'm glad to hear that it helped.</p>
<p>Thank you for reporting back with your results.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-23T13:59:24Z2018-08-23T13:59:26ZAlpha Advantage limit of 5 API calls per minute<div><p>I have made a few adjustments in my Deriscope AddIn to cope with this new constraint. Now Deriscope is configured by default to automatically place only 3 requests per minute so that even a large number of tickers can be accommodated. For example a list of 30 tickers would be fully updated every 10 minutes.<br>
The default configuration can be manually adjusted to match a possible user-subscription scheme so that more requests are placed per minute if needed.<br>
More details at my video <a href="https://youtu.be/loNLupE0qnQ">https://youtu.be/loNLupE0qnQ</a></p></div>alertstag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-27T22:26:32Z2018-08-27T22:26:32ZAlpha Advantage limit of 5 API calls per minute<div><p>Hi Kevin. I just wanted to post a note of thanks for the tip on the hleofxquote tool. It does look a bit daunting, especially for an app that I PAID FOR, but I was able to muddle through. This tool is AWESOME and does everything that I'd hope for. It gets the entire list of quotes quickly and if it misses some it actually says so. I then get to validate the data before it gets absorbed into MoneyDance. I'm on Ubuntu 14.04. I've given up on Alphavantage as well and was just about to give up on MD.</p></div>thedanctag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-08-27T22:37:02Z2018-08-27T22:37:04ZAlpha Advantage limit of 5 API calls per minute<div><p>Perhaps you would want to know that as of today Deriscope brings live feeds into Excel from Yahoo Finance as well. The Deriscope's advantage is that a user can suck live feeds from diverse providers into the same spreadsheet: Yahoo Finance, Alpha Vantage, TrueFX, IEX.<br>
Check out today's 5 min video on YF feeds: <a href="https://youtu.be/aHYWtdy6ONA">https://youtu.be/aHYWtdy6ONA</a></p></div>alertstag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-10-12T22:10:30Z2018-10-12T22:10:32ZAlpha Advantage limit of 5 API calls per minute<div><p>R code:</p>
<p>libary(quantmod)</p>
<h3><a name="download-data" class="anchor" href="#download-data"></a>DOWNLOAD DATA</h3>
<h3><a name="the-getsymbols-function-is-delayed-randomly-between-15-and-20-seconds-between-requests" class="anchor" href="#the-getsymbols-function-is-delayed-randomly-between-15-and-20-seconds-between-requests"></a>the getSymbols function is delayed randomly between 15 and 20 seconds between requests</h3>
<h3><a name="all-is-wrapped-in-a-fail-safe-which-will-re-start-the-function-n-times-if-error" class="anchor" href="#all-is-wrapped-in-a-fail-safe-which-will-re-start-the-function-n-times-if-error"></a>All is wrapped in a fail-safe which will re-start the function N times if error</h3>
<pre>
<code>## Fail-safe set-up
N <- 10000
r <- NULL
attempt <- 0</code>
</pre>
<p>###################### RUN #################</p>
<pre>
<code>while( is.null(r) && attempt <= N ) {
attempt <<- attempt + 1
try( r <- lapply(tail(OTC_ref$symbol,10), function (stock) {
getSymbols.av(stock)
Sys.sleep(sample(15:20, 1))})
)
Sys.sleep(61)
}</code>
</pre></div>Alextag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-10-12T22:11:35Z2018-10-12T22:11:38ZAlpha Advantage limit of 5 API calls per minute<div><p>forgot this :</p>
<p>AV_KEY <- 'xxxx'</p>
<p>setDefaults(getSymbols.av,<br>
env=.GlobalEnv, api.key = AV_KEY, return.class = "xts", periodicity = "daily", adjusted = TRUE, interval = "1min", output.size = "full", data.type = "json")</p></div>Alextag:infinitekind.tenderapp.com,2009-01-14:Comment/457505012018-10-19T14:14:27Z2018-10-19T14:14:27ZAlpha Advantage limit of 5 API calls per minute<div><p>Yes! Deleting unused currencies. Simple but effective.</p></div>stephen