Re: Getting commodity tracking working for individual securities

2023-11-11 Thread Sagar Shankar
Hi Patrick, that's super useful! That's got it working at the command-line! I can run bean-price -e ledger.beancount and it pulls in the data from Yahoo Finance. However, if I try to get it to update the ledger file with bean-price --update ledger.beancount, fails with TypeError: conversion

Re: Getting commodity tracking working for individual securities

2023-11-11 Thread 'Patrick Ruckstuhl' via Beancount
Hi Sagar, you don't need to use the same symbol name in beancount as you use for lookup. You can define it in the commodity metadata e.g. something like (I'm using alphavantage price source here, but yahoo should work the same way) 2010-01-01 commodity MYSUPERCOMMODITY     price:

Re: Getting commodity tracking working for individual securities

2023-11-11 Thread Sagar Shankar
Well, looks like bean-price doesn't support Google Finance. That was a bit confusing since the documentation still refers to google finance and I had to go down the issues in the mailing list and the GitHub repo for bean-price to figure that part out. The issue with Yahoo Finance is that for

Re: Getting commodity tracking working for individual securities

2023-11-11 Thread Sagar Shankar
Hi Martin, sorry for the late reply. For some reason I never got this digest in my email inbox. OK, understood about the underscores and using dashes instead. Problem is that the tickers for these funds in Google Finance use underscores - which means updating the prices on a regular basis

Re: Getting commodity tracking working for individual securities

2023-10-28 Thread Martin Blais
The problem is not your currencies, it's the account names. Account names do not support underscores. Use dashes instead. (They probably should (mabe), but I'm not going to change the syntax in stable/v2). I'm not sure what the invalid currency error is, needs more detail On Sat, Oct 28, 2023 at

Re: Getting commodity tracking working for individual securities

2023-10-28 Thread Sagar Shankar
Sorry, I forgot to mention that I'm only facing this issue for securities in this name format. Other securities, like ITC or INFY, dont have this issue. For them, I'm able to track like: Assets:Broker:ITC 100 ITC {10 USD} Assets:Broker:INFY 100 INFY {9 USD} Thanks Sagar On Sun, Oct 29, 2023

Getting commodity tracking working for individual securities

2023-10-28 Thread Sagar Shankar
Hi, I'm trying to import my mutual fund transactions into Beancount. The mutual fund security names are in the format, "ADIT_BSL_FRON_YK3Z7Z", which are the ticker names from Google Finance. Initially I had tried to create transactions like: Assets:Broker:ADIT_BSL_FRON_YK3Z7Z 100