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: "USD:alphavantage/price:TSLA:USD"


On 11.11.2023 11:38, Sagar Shankar wrote:
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 some Indian securities, it uses the format, 0P0000XVUH.BO, which bean count doesn't accept since it starts with a zero. Using the Yahoo Finance website and the ISIN, INF846K01EH3 works. But that doesn't work for bean-price and it returns an error with the ISIN.

So I'm a bit stumped on what to do. Appreciate any suggestions!

Thanks,
Sagar

On Saturday, November 11, 2023 at 5:23:00 PM UTC+8 Sagar Shankar wrote:

    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
    won't work, if I understood the part of price fetching correctly

    Thanks
    Sagar

    On Sunday, October 29, 2023 at 11:44:47 AM UTC+8 [email protected]
    wrote:

        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 11:34 PM Sagar Shankar
        <[email protected]> wrote:

            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
            ADIT_BSL_FRON_YK3Z7Z {10 USD}
            Assets:Broker:ADIT_BSL_NIFT_136TO8I
             100 ADIT_BSL_NIFT_136TO8I {9 USD}
            and so and so forth.

            This threw up a "Invalid Token" error. So I thought, maybe
            Beancount has some restrictions on account names. So then
            I moved to the following format:
            Assets:Broker  100 ADIT_BSL_FRON_YK3Z7Z {10 USD}
            Assets:Broker  100 ADIT_BSL_NIFT_136TO8I {9 USD}
            and I'm now getting an "Invalid Currency" error.

            I'm following the examples from this page -
            https://beancount.github.io/docs/how_inventories_work.html,
            as what I want to achieve is:
            1. Track per security inventory
            2. Track cost basis and networth, the latter by pulling
            the latest market price from Google Finance.

            Appreciate any advice on how to get this working

            Thanks
            Sagar

-- 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 [email protected].
            To view this discussion on the web visit
            
https://groups.google.com/d/msgid/beancount/CAAP45exGz6rcYUAj5AgCgzQFn16DRKxprbse74R3bUJR2UuTTw%40mail.gmail.com
            
<https://groups.google.com/d/msgid/beancount/CAAP45exGz6rcYUAj5AgCgzQFn16DRKxprbse74R3bUJR2UuTTw%40mail.gmail.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/bf0a528b-a952-4aa4-9b75-f2d070fff3b9n%40googlegroups.com <https://groups.google.com/d/msgid/beancount/bf0a528b-a952-4aa4-9b75-f2d070fff3b9n%40googlegroups.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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/a6f1cd1b-737c-41dc-85a4-90e75596beb5%40tario.org.

Reply via email to