Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Alphavantage script not updating all symbols
Hi,
I've had a problem with Alphavantage for the past few weeks. When I run the script (unedited v2.4.05) some of the symbols update and others don't.
As examples from the log:
The entries in the psConfig.txt file are (and these are the first two in the Alphavantage section):
RRS.L,2018-05-10,,Y,N,0.01,0.01,0.01
FTEK.L,2018-03-01,,Y,N,,,
If I clear everything out of the psConfig.txt file and only run it with these two symbols, then FTEK.L updates fine
For info, I've attached the full psConfig.txt file (excluding my API key)
Thank you very much in advance for any help
James
I've had a problem with Alphavantage for the past few weeks. When I run the script (unedited v2.4.05) some of the symbols update and others don't.
As examples from the log:
- RRS.L works fine and updates the latest quote
Symbol: RRS.L. Next date: 2018-08-08. Quote file: C:\PortfolioSlicer\Quotes\_RRS.L_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=RRS.L&apikey=XXXXXXXXXXXXX&datatype=csv&outputsize=compact
Done: RRS.L (from: 2018-08-08). Record count: 1. Last quote: 2018-08-08
- FTEK.L does not update any new quotes past 20th July
Symbol: FTEK.L. Next date: 2018-07-21. Quote file: C:\PortfolioSlicer\Quotes\_FTEK.L_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=FTEK.L&apikey=XXXXXXXXXXXXX&datatype=csv&outputsize=compact
Done: FTEK.L. No new quotes found.
The entries in the psConfig.txt file are (and these are the first two in the Alphavantage section):
RRS.L,2018-05-10,,Y,N,0.01,0.01,0.01
FTEK.L,2018-03-01,,Y,N,,,
If I clear everything out of the psConfig.txt file and only run it with these two symbols, then FTEK.L updates fine
For info, I've attached the full psConfig.txt file (excluding my API key)
Thank you very much in advance for any help
James
Comments
I am not able to reproduce this issue. I tried with getting data for FETK.L and it works as expected. I deleted some lines from the Quotes\_FTEK.L_.txt file and next reload worked without problems - quotes were appended up to today.
Can you send me your Quotes\_FTEK.L_.txt file? My email is posted here:
http://www.portfolioslicer.com/contact.html
Thank you for looking at my issue. I'll send you the files via email
Thanks
J
Thanks for reporting this and for pointing out that issue appears just after you requested more than 10 quotes.
I can see in AlphaVantage community forums that other people started to encounter similar problems starting about 2 weeks ago:
https://www.alpha-vantage.community/post/problems-with-api-call-frequency-9773234
Based on the above information, I would have to add a 90second delay after every 5 requests. This will increase script run time, but should solve the issue. I'll let you know when the updated script is ready.
I releases scripts that you already tested - they are now available from download page. As I said, I added wait for 90 second after each 4 requests. As you noticed, that substantially increased query time.
My suggestion would be - avoid using AlphaVantage unless is absolutely necessary. Try to use quotes from other sources - like Yahoo or Stooq.