one thing that is in the bean-price alphavantage importer is to deal with rate limit of alphavantage, if there is an issue with the request, it sleeps for 60 seconds and then tries again. Maybe you hit that one.

On 19.09.2024 03:39, 'Aaron Axvig' via Beancount wrote:
The direct URL returns a nice JSON with price data in it, instantly.

I let the bean-price command run for a while and it finished after a couple minutes.  I'll stew on it.

On Wed, 2024-09-18 at 08:17 +0200, 'Patrick Ruckstuhl' via Beancount wrote:

That sounds weird, can you try to call the following URLs


https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=IBM&apikey=demo

and

https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=AAPL&apikey=yourkey


maybe with curl?


On 18.09.2024 03:39, 'Aaron Axvig' via Beancount wrote:

Very strange, it just sits and does nothing after starting the HTTPS connection.  So that makes me wonder I have some other network problem, because I was using the Yahoo source on a different machine and that started hanging in a similar way a couple weeks ago.  I thought that was just Yahoo cutting everyone off. :)

(venv):~/beancount/venv/bin$ ./bean-price -e 'USD:alphavantage/price:AAPL:USD' -vv --cache cache.db
INFO : Using price cache at "cache.db" (with indefinite expiration)
INFO : Processing at date: 2024-09-17
INFO : Fetching: price:AAPL:USD (time: None)
DEBUG : Starting new HTTPS connection (1): www.alphavantage.co:443 <https://www.alphavantage.co:443>

The API key is set:

(venv):~/beancount/venv/bin$ printenv | grep ALPHA
ALPHAVANTAGE_API_KEY=snipped



On Tue, 2024-09-17 at 18:30 +0200, 'Patrick Ruckstuhl' via Beancount wrote:

Hi,


sure, first you have to provide the api key as an environment variable

e.g. something like

export ALPHAVANTAGE_API_KEY=demo
and then call it like

bean-price -e 'USD:alphavantage/price:AAPL:USD' -vv

Regards,
Patrick

On 17.09.2024 14:53, 'Aaron Axvig' via Beancount wrote:


Could someone provide an example of fetching a price using
Alphavantage?  It is non-obvious to me:
bean-price -e 'USD:alphavantage/AAPL' -vv
INFO    : Using price cache at "/tmp/bean-price.cache" (with indefinite
expiration)
INFO    : Processing at date: 2024-09-17
INFO    : Fetching: AAPL (time: None)
ERROR   : Error fetching AAPL: Invalid ticker. Use "price:SYMBOL:BASE"
or "fx:CCY:BASE" format.
ERROR   : Could not fetch for job: DatedPrice(base='AAPL', quote='USD',
date=None, sources=[PriceSource(module=<module
'beanprice.sources.alphavantage' from
'/home/aaron/beancount/venv/lib/python3.11/site-
packages/beanprice/sources/alphavantage.py'>, symbol='AAPL',
invert=False)])

--
You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/711adbff4fe9c9c7905faed23d0ba1cfb4144952.camel%40axvig.com <https://groups.google.com/d/msgid/beancount/711adbff4fe9c9c7905faed23d0ba1cfb4144952.camel%40axvig.com?utm_medium=email&utm_source=footer>.

--
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/b1c4d059-b8ea-4c5f-ba2e-fa9ace0c292c%40tario.org.

Reply via email to